public DataSet SelectAll(Room room)
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
DbCommand dbCommand = db.GetStoredProcCommand("usp_RoomSelectAll");
db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, room.CompanyId);
return db.ExecuteDataSet(dbCommand);
}