public void GetDataForUtility(string utilityName) { using (var context = new TownUtilityBillSystemV2Entities()) { var utilityDB = context.UTILITYs.Where(u => u.NAME == utilityName).FirstOrDefault(); var unitDB = context.UNITs.Find(utilityDB.UNIT_ID); var utilitiesDB = context.UTILITYs.ToList(); Unit.Id = unitDB.ID; Unit.Name = unitDB.NAME; Utility.Id = utilityDB.ID; Utility.Name = utilityDB.NAME; Utility.Price = utilityDB.PRICE; Utility.ResourceName = GetResourceNameForUtility(utilityDB.NAME); Utility.ImagePath = HelperMethod.GetUtilityImage(utilityDB.ID); if (utilityDB.USAGEFORSTANDARTPRICE != null) { Utility.UsageForStandartPrice = (decimal)utilityDB.USAGEFORSTANDARTPRICE; } if (utilityDB.BIGUSAGEPRICE != null) { Utility.BigUsagePrice = (decimal)utilityDB.BIGUSAGEPRICE; } Utility.Unit = Unit; foreach (var u in utilitiesDB) { if (u.NAME != Utility.Name) { Utilities.Add(new Utility() { Name = u.NAME, ResourceName = GetResourceNameForUtility(u.NAME) }); } } var meterTypesDB = context.METER_TYPEs.Where(mt => mt.UTILITY_ID == Utility.Id).ToList(); var metersDB = context.METERs.ToList(); HashSet <int> meterTypesIds = new HashSet <int>(); foreach (var m in meterTypesDB) { meterTypesIds.Add(m.ID); } foreach (var m in metersDB) { if (meterTypesIds.Contains(m.METER_TYPE_ID)) { MeterQty += 1; } } } }
public static Utility GetUtilityWithOutBigUsagePrice(UTILITY utility) { return(new Utility { Id = utility.ID, ResourceName = UtilityModel.GetResourceNameForUtility(utility.NAME), Name = utility.NAME, Price = utility.PRICE, ImagePath = HelperMethod.GetUtilityImage(utility.ID), Unit = Unit.Get(utility.UNIT) }); }
public static Utility GetUtilityWithBigUsagePrice(UTILITY utility) { return(new Utility { Id = utility.ID, ResourceName = UtilityModel.GetResourceNameForUtility(utility.NAME), Name = utility.NAME, Price = utility.PRICE, BigUsagePrice = (decimal)utility.BIGUSAGEPRICE, UsageForStandartPrice = Math.Round((decimal)utility.USAGEFORSTANDARTPRICE, 0), ImagePath = HelperMethod.GetUtilityImage(utility.ID), Unit = Unit.Get(utility.UNIT) }); }
public void GetAllUtilitiesPrices() { using (var context = new TownUtilityBillSystemV2Entities()) { var utilitiesDB = context.UTILITYs.ToList(); foreach (var item in utilitiesDB) { var unitDB = context.UNITs.Where(u => u.ID == item.UNIT_ID).FirstOrDefault(); var unit = new Unit() { Id = unitDB.ID, Name = unitDB.NAME }; if (item.USAGEFORSTANDARTPRICE != null && item.BIGUSAGEPRICE != null) { Utilities.Add(new Utility { Id = item.ID, Name = item.NAME, Price = item.PRICE, BigUsagePrice = (decimal)item.BIGUSAGEPRICE, UsageForStandartPrice = Math.Round((decimal)item.USAGEFORSTANDARTPRICE, 0), ImagePath = HelperMethod.GetUtilityImage(item.ID), Unit = unit, ResourceName = GetResourceNameForUtility(item.NAME) }); } else { Utilities.Add(new Utility { Id = item.ID, Name = item.NAME, Price = item.PRICE, ImagePath = HelperMethod.GetUtilityImage(item.ID), Unit = unit, ResourceName = GetResourceNameForUtility(item.NAME) }); } } } }
public void GetAllMeterTypes() { using (var context = new TownUtilityBillSystemV2Entities()) { var meterTypesDB = context.METER_TYPEs.ToList(); foreach (var mt in meterTypesDB) { var utilityDB = context.UTILITYs.Where(u => u.ID == mt.UTILITY_ID).FirstOrDefault(); var utility = new Utility() { Id = utilityDB.ID, Name = utilityDB.NAME, ResourceName = UtilityModel.GetResourceNameForUtility(utilityDB.NAME), ImagePath = HelperMethod.GetUtilityImage(utilityDB.ID) }; MeterTypes.Add(new MeterType() { Id = mt.ID, Name = mt.NAME, VarificationPeriod = mt.VARIFICATION_PERIOD_YEARS, Utility = utility }); } } }