public DataSet SelectUnmatchedRatePlansByRoomId(int RoomId)
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
DbCommand command = db.GetStoredProcCommand("usp_RoomRatePlanSelectUnmatchedByRoomId");
db.AddInParameter(command, "@RoomId", DbType.Int32, RoomId);
return db.ExecuteDataSet(command);
}