public bool UpdateRoomAsDirty(Room room)
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
DbCommand command = db.GetStoredProcCommand("usp_RoomMarkDirty");
db.AddInParameter(command, "@RoomId", DbType.Int32, room.RoomId);
db.AddInParameter(command, "@UpdatedUser", DbType.Int32, room.UpdatedUser);
db.ExecuteNonQuery(command);
return true;
}