public void Add()
{
//this.test.Add(new test() { name = "sample", age = 23 });
//this.test.Add(new test() { name = "sample2", age = 32 });
UnitSummary summ = new UnitSummary();
summ.unitid = "td001";
this.unit_summary.Add(summ);
this.SaveChanges();
}
private Bill GenerateBillForUnit(BillGroupDetailVM bgDetail, UnitSummary unit, string monthYear)
{
var missingDays = 0;
double extra = 0;
double arrear = 0;
var tmissingDays = (from oldBill in Bills
where oldBill.UnitId == unit.id &&
oldBill.AddedAt < bgDetail.BillDate
orderby oldBill.AddedAt descending
select oldBill).FirstOrDefault();
missingDays = tmissingDays == null ? 0 : tmissingDays.MissingDays;
if (tmissingDays != null)
{
var payprocess = (from pp in PaymentProcess
where pp.BillNo == tmissingDays.Id
select pp).FirstOrDefault();
extra = payprocess == null ? 0 : payprocess.Balance > 0 ? payprocess.Balance: 0;
arrear = payprocess == null ? 0 : payprocess.Balance < 0 ? Math.Abs(payprocess.Balance) : 0;
}
var billPeriodData = from uc in UnitConsumptionDetails
where uc.unitid == unit.id &&
uc.daterecorded >= bgDetail.StartDate.AddDays(-missingDays) &&
uc.daterecorded <= bgDetail.EndDate
orderby uc.daterecorded
select uc;
var firstDay = billPeriodData.FirstOrDefault();
var lastDay = billPeriodData.LastOrDefault();
var consumption = firstDay == null?0: lastDay.consumptioninmcube - firstDay.consumptioninmcube;
var bill = new Bill
{
MonthYear = monthYear,
UnitId = unit.id,
BillDate = bgDetail.BillDate,
DueDate = bgDetail.DueDate,
FirstReading = firstDay == null?0: firstDay.consumptioninmcube,
LastReading = lastDay == null?0:lastDay.consumptioninmcube,
Consumption = consumption,
FirstDate = firstDay == null?bgDetail.StartDate: firstDay.daterecorded,
LastDate = lastDay == null?bgDetail.EndDate: lastDay.daterecorded,
MissingDays = lastDay == null?0: lastDay.daterecorded == DateTime.MinValue ? 0 : (lastDay.daterecorded - firstDay.daterecorded).Days,
Arrears = arrear,
ExtraPaid = extra,
AddedAt = DateTime.Now
};
bill = CalculateTariff(unit.unitid, consumption, unit.meterbillingtype, bill, bgDetail.BillYear, bgDetail.DivisionId);
return(bill);
}
public bool UpdateUnit(UnitSummary unitSummary)
{
bool flag = true;
if (unitSummary.id == 0)
{
this.unit_summary.Add(unitSummary);
}
else
{
this.unit_summary.Update(unitSummary);
}
this.SaveChanges();
return(flag);
}
public bool UpdateUnit(UnitSummary unitSummary)
{
return(Repository.UpdateUnit(Mapper.Map <DataModels.UnitSummary.UnitSummary>(unitSummary)));
}
