public static List<BaseHouse> SelectAllByHouseTypeId(int houseTypeId) { Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbCommand dbCommand = db.GetStoredProcCommand("usp_BaseHouseSelectByHouseTypeId"); List<BaseHouse> listBaseHouse = new List<BaseHouse>(); db.AddInParameter(dbCommand, "HouseTypeId", DbType.Int32, houseTypeId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { BaseHouse baseHouse = HouseFactory.Create((Enums.HouseType)houseTypeId); RHP.Utility.Generic.AssignDataReaderToEntity(dataReader, baseHouse); listBaseHouse.Add(baseHouse); } if (dataReader.NextResult()) { while (dataReader.Read()) { BaseHouseRoom baseHouseRoom = new BaseHouseRoom(); RHP.Utility.Generic.AssignDataReaderToEntity(dataReader, baseHouseRoom); if (listBaseHouse != null) { BaseHouse baseHouse2 = HouseFactory.Create((Enums.HouseType)houseTypeId); foreach (BaseHouse item in listBaseHouse) { if (item.BaseHouseId == baseHouseRoom.BaseHouseId) { if (item.HouseRooms == null) { item.HouseRooms = new List<BaseHouseRoom>(); } item.HouseRooms.Add(baseHouseRoom); } } } } } } return listBaseHouse; }
public static List <BaseHouse> SelectAllByHouseTypeId(int houseTypeId) { Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbCommand dbCommand = db.GetStoredProcCommand("usp_BaseHouseSelectByHouseTypeId"); List <BaseHouse> listBaseHouse = new List <BaseHouse>(); db.AddInParameter(dbCommand, "HouseTypeId", DbType.Int32, houseTypeId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { BaseHouse baseHouse = HouseFactory.Create((Enums.HouseType)houseTypeId); RHP.Utility.Generic.AssignDataReaderToEntity(dataReader, baseHouse); listBaseHouse.Add(baseHouse); } if (dataReader.NextResult()) { while (dataReader.Read()) { BaseHouseRoom baseHouseRoom = new BaseHouseRoom(); RHP.Utility.Generic.AssignDataReaderToEntity(dataReader, baseHouseRoom); if (listBaseHouse != null) { BaseHouse baseHouse2 = HouseFactory.Create((Enums.HouseType)houseTypeId); foreach (BaseHouse item in listBaseHouse) { if (item.BaseHouseId == baseHouseRoom.BaseHouseId) { if (item.HouseRooms == null) { item.HouseRooms = new List <BaseHouseRoom>(); } item.HouseRooms.Add(baseHouseRoom); } } } } } } return(listBaseHouse); }