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