public DataSet SelectAllDirtyRooms(int Company)
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
DbCommand dbCommand = db.GetStoredProcCommand("usp_Dashboard_Room_DirtySelect");
db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, Company);
return db.ExecuteDataSet(dbCommand);
}