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
});
}
}
}
