private MeterMonthWiseConsumptionModel GetMeterMonthWiseConsumption(IQueryable <MonthlyConsumptionDetails> monthlyConsumptionDetails)
{
MeterMonthWiseConsumptionModel meterMonthWiseConsumption = new MeterMonthWiseConsumptionModel();
foreach (var monthlyConsumptionDetail in monthlyConsumptionDetails)
{
switch (monthlyConsumptionDetail.Month.ToLower())
{
case "jan":
meterMonthWiseConsumption.MonthWiseConsumption.Jan = meterMonthWiseConsumption.MonthWiseConsumption.Jan + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "feb":
meterMonthWiseConsumption.MonthWiseConsumption.Feb = meterMonthWiseConsumption.MonthWiseConsumption.Feb + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "mar":
meterMonthWiseConsumption.MonthWiseConsumption.Mar = meterMonthWiseConsumption.MonthWiseConsumption.Mar + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "apr":
meterMonthWiseConsumption.MonthWiseConsumption.Apr = meterMonthWiseConsumption.MonthWiseConsumption.Apr + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "may":
meterMonthWiseConsumption.MonthWiseConsumption.May = meterMonthWiseConsumption.MonthWiseConsumption.May + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "jun":
meterMonthWiseConsumption.MonthWiseConsumption.Jun = meterMonthWiseConsumption.MonthWiseConsumption.Jun + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "jul":
meterMonthWiseConsumption.MonthWiseConsumption.Jul = meterMonthWiseConsumption.MonthWiseConsumption.Jul + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "aug":
meterMonthWiseConsumption.MonthWiseConsumption.Aug = meterMonthWiseConsumption.MonthWiseConsumption.Aug + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "sep":
meterMonthWiseConsumption.MonthWiseConsumption.Sep = meterMonthWiseConsumption.MonthWiseConsumption.Sep + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "oct":
meterMonthWiseConsumption.MonthWiseConsumption.Oct = meterMonthWiseConsumption.MonthWiseConsumption.Oct + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "nov":
meterMonthWiseConsumption.MonthWiseConsumption.Nov = meterMonthWiseConsumption.MonthWiseConsumption.Nov + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
case "dec":
meterMonthWiseConsumption.MonthWiseConsumption.Dec = meterMonthWiseConsumption.MonthWiseConsumption.Dec + monthlyConsumptionDetail.Monthly_KWH_System ?? default(double);
break;
}
}
return(meterMonthWiseConsumption);
}
List <MeterMonthWiseConsumptionModel> IMeterService.GetMonthWiseConsumption(int buildingId, int year)
{
var meterDetails = this.GetMeterDetails(buildingId);
List <MeterMonthWiseConsumptionModel> meterDataList = new List <MeterMonthWiseConsumptionModel>();
foreach (var meterDetail in meterDetails)
{
var monthlyConsumptionDetails = this.dbContext.MonthlyConsumptionDetails.Where(m => m.PowerScout.Equals(meterDetail.PowerScout, StringComparison.InvariantCultureIgnoreCase) && m.Year.Equals(year.ToString()));
MeterMonthWiseConsumptionModel meterMonthWiseConsumption = this.GetMeterMonthWiseConsumption(monthlyConsumptionDetails);
if (meterMonthWiseConsumption != null)
{
meterMonthWiseConsumption.PowerScout = meterDetail.PowerScout;
meterMonthWiseConsumption.Name = meterDetail.Breaker_details;
meterDataList.Add(meterMonthWiseConsumption);
}
else
{
meterDataList.Add(new MeterMonthWiseConsumptionModel {
PowerScout = meterDetail.PowerScout, Name = meterDetail.Breaker_details
});
}
}
return(meterDataList);
}
