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