private void FillMetersForModel(TownUtilityBillSystemV2Entities context, ADDRESS addressDB) { var metersDB = context.METERs.Where(m => m.ADDRESS_ID == addressDB.ID).ToList(); foreach (var m in metersDB) { var meterTypeDB = context.METER_TYPEs.Where(mt => mt.ID == m.METER_TYPE_ID).FirstOrDefault(); var utilityDB = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).FirstOrDefault(); var utility = new Utility() { Id = utilityDB.ID, Name = utilityDB.NAME }; var meterType = new MeterType() { Id = meterTypeDB.ID, Name = meterTypeDB.NAME, Utility = utility }; Meters.Add(new Meter() { Id = m.ID, SerialNumber = m.SERIAL_NUMBER, ReleaseDate = m.RELEASE_DATE, VarificationDate = m.VARIFICATION_DATE, MeterType = meterType }); } }
internal void GetMeterForEdit(int meterId) { using (var context = new TownUtilityBillSystemV2Entities()) { var meterDB = context.METERs.Find(meterId); if (meterDB != null) { var meterTypeDB = context.METER_TYPEs.Where(mt => mt.ID == meterDB.METER_TYPE_ID).FirstOrDefault(); var utility = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).Select(Utility.GetUtilityWithIdAndResourceName).FirstOrDefault(); var meterType = new MeterType() { Id = meterTypeDB.ID, Name = meterTypeDB.NAME, VarificationPeriod = meterTypeDB.VARIFICATION_PERIOD_YEARS, Utility = utility }; Id = meterDB.ID; MeterType = meterType; SerialNumber = meterDB.SERIAL_NUMBER; ReleaseDate = meterDB.RELEASE_DATE; VarificationDate = meterDB.VARIFICATION_DATE; MeterTypes = context.METER_TYPEs.Select(MeterType.Get).ToList(); } } }
internal MeterType GetMeterType(int meterTypeId) { using (var context = new TownUtilityBillSystemV2Entities()) { MeterType meterType; var meterTypeDB = context.METER_TYPEs.Find(meterTypeId); if (meterTypeDB != null) { var utilityDB = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).FirstOrDefault(); var utility = Utility.GetUtilityWithIdAndResourceName(utilityDB); meterType = MeterType.Get(meterTypeDB); meterType.Utility = utility; meterType.Utilities = context.UTILITYs.Select(Utility.GetUtilityWithIdAndResourceName).ToList(); } else { meterType = null; } return(meterType); } }
private static void CreateMeterModelFromMeterList(TownUtilityBillSystemV2Entities context, MeterModel model, List <METER> rndMetersDB) { foreach (var m in rndMetersDB) { var meterTypeDB = context.METER_TYPEs.Where(mt => mt.ID == m.METER_TYPE_ID).FirstOrDefault(); var utilityDB = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).FirstOrDefault(); var addressDB = context.ADDRESSes.Where(a => a.ID == m.ADDRESS_ID).FirstOrDefault(); var indexDB = context.INDEXes.Where(i => i.ID == addressDB.INDEX_ID).FirstOrDefault(); var townDB = context.TOWNs.Where(t => t.ID == addressDB.TOWN_ID).FirstOrDefault(); var streetDB = context.STREETs.Where(s => s.ID == addressDB.STREET_ID).FirstOrDefault(); var buildingDB = context.BUILDINGs.Where(b => b.ID == addressDB.BUILDING_ID).FirstOrDefault(); var flatPartDB = context.FLAT_PARTs.Where(fp => fp.ID == addressDB.FLAT_PART_ID).FirstOrDefault(); var utility = new Utility() { Id = utilityDB.ID, Name = utilityDB.NAME, ResourceName = UtilityModel.GetResourceNameForUtility(utilityDB.NAME) }; var meterType = new MeterType() { Id = meterTypeDB.ID, Name = meterTypeDB.NAME, Utility = utility }; var index = new Index() { Id = indexDB.ID, Value = indexDB.VALUE }; var town = new Town() { Id = townDB.ID, Name = townDB.NAME }; var street = new Street() { Id = streetDB.ID, Name = streetDB.NAME }; var building = new Building() { Id = buildingDB.ID, Number = buildingDB.NUMBER }; FlatPart flatPart = null; if (flatPartDB != null) { flatPart = FlatPart.Get(flatPartDB); } var address = new Address() { Id = addressDB.ID, Index = index, Town = town, Street = street, Building = building, FlatPart = flatPart }; model.Meters.Add(new Meter() { Id = m.ID, SerialNumber = m.SERIAL_NUMBER, ReleaseDate = m.RELEASE_DATE, VarificationDate = m.VARIFICATION_DATE, MeterType = meterType, Address = address }); } }
internal void UpdateMeterType(MeterType meterType) { using (var context = new TownUtilityBillSystemV2Entities()) { var meterTypeDB = context.METER_TYPEs.Find(meterType.Id); meterTypeDB.NAME = meterType.Name; meterTypeDB.UTILITY_ID = meterType.Utility.Id; meterTypeDB.VARIFICATION_PERIOD_YEARS = meterType.VarificationPeriod; context.SaveChanges(); } }
private void InitializeMeterProperty(int meterId, TownUtilityBillSystemV2Entities context) { var meterDB = context.METERs.Where(m => m.ID == meterId).FirstOrDefault(); var meterTypeDB = context.METER_TYPEs.Where(mt => mt.ID == meterDB.METER_TYPE_ID).FirstOrDefault(); var utilityDB = context.UTILITYs.Where(u => u.ID == meterTypeDB.UTILITY_ID).FirstOrDefault(); var addressDB = context.ADDRESSes.Where(a => a.ID == meterDB.ADDRESS_ID).FirstOrDefault(); var flatPartDB = context.FLAT_PARTs.Where(fp => fp.ID == addressDB.FLAT_PART_ID).FirstOrDefault(); var unit = context.UNITs.Where(u => u.ID == utilityDB.UNIT_ID).Select(Unit.Get).FirstOrDefault();; var utility = new Utility() { Id = utilityDB.ID, Name = utilityDB.NAME, Unit = unit, ResourceName = UtilityModel.GetResourceNameForUtility(utilityDB.NAME) }; var meterType = new MeterType() { Id = meterTypeDB.ID, Name = meterTypeDB.NAME, Utility = utility }; var index = context.INDEXes.Where(i => i.ID == addressDB.INDEX_ID).Select(Index.Get).FirstOrDefault(); var town = context.TOWNs.Where(t => t.ID == addressDB.TOWN_ID).Select(Town.Get).FirstOrDefault(); var street = context.STREETs.Where(s => s.ID == addressDB.STREET_ID).Select(Street.Get).FirstOrDefault(); var building = context.BUILDINGs.Where(b => b.ID == addressDB.BUILDING_ID).Select(Building.Get).FirstOrDefault(); FlatPart flatPart = null; if (flatPartDB != null) { flatPart = FlatPart.Get(flatPartDB); } var address = new Address() { Id = addressDB.ID, Index = index, Town = town, Street = street, Building = building, FlatPart = flatPart }; Meter = new Meter() { Id = meterDB.ID, SerialNumber = meterDB.SERIAL_NUMBER, ReleaseDate = meterDB.RELEASE_DATE, VarificationDate = meterDB.VARIFICATION_DATE, MeterType = meterType, Address = address }; }
public MeterTypeModel() { MeterType = new MeterType(); MeterTypes = new List <MeterType>(); Utility = new Utility(); }