public bool DashboardUpdateDirtyRooms(DataSet dsDirtyRooms)
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
DbCommand commandUpdate = db.GetStoredProcCommand("usp_Dashboard_RoomDirtyUpdate");
db.AddInParameter(commandUpdate, "@RoomId", DbType.Int32, "RoomId", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@UpdatedUser", DbType.Int32, "UpdatedUser", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@IsDirty", DbType.Boolean, "IsDirty", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@CleaningNote", DbType.String, "CleaningNote", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@CleanedBy", DbType.Int32, "CleanedBy", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@CleanedDate", DbType.DateTime, "CleanedDate", DataRowVersion.Current);
db.UpdateDataSet(dsDirtyRooms, dsDirtyRooms.Tables[0].TableName, null, commandUpdate, null, UpdateBehavior.Transactional);
return true;
}