void loadBank(MASTERBANK bank)
{
Model.MonthEndClosed mec = new Model.MonthEndClosed();
mec.BankCode = bank.BANK_CODE;
mec.BankName = $"{bank.BANK_USERCODE} - {bank.BANK_NAME}";
mec.PaidA = lstPaidMember.Count(x => x.MASTERMEMBER.BANK_CODE == bank.BANK_CODE && x.MonthlySubcriptionMemberStatusId == (int)AppLib.MemberStatus.Active);
mec.PaidD = lstPaidMember.Count(x => x.MASTERMEMBER.BANK_CODE == bank.BANK_CODE && x.MonthlySubcriptionMemberStatusId == (int)AppLib.MemberStatus.Defaulter);
mec.Paid = mec.PaidA + mec.PaidD;
mec.UnpaidA = lstMasterMember.Count(x => x.BANK_CODE == bank.BANK_CODE && x.STATUS_CODE == (decimal)AppLib.MemberStatus.Active) - mec.PaidA;
mec.UnpaidD = lstMasterMember.Count(x => x.BANK_CODE == bank.BANK_CODE && x.STATUS_CODE == (decimal)AppLib.MemberStatus.Defaulter) - mec.PaidD;
mec.Unpaid = mec.UnpaidA + mec.UnpaidD;
mec.Total = lstMasterMember.Count(x => x.BANK_CODE == bank.BANK_CODE);
if (mec.Total != 0)
{
lstMonthEndClosed.Add(mec);
System.Windows.Forms.Application.DoEvents();
}
}
void updateBankTotal()
{
var mec = lstMonthEndClosed.FirstOrDefault(x => x.BankName == "Total");
if (mec == null)
{
mec = new Model.MonthEndClosed();
mec.BankName = "Total";
mec.PaidA = lstMonthEndClosed.Where(x => x.BankName != "Total").Sum(x => x.PaidA);
mec.PaidD = lstMonthEndClosed.Where(x => x.BankName != "Total").Sum(x => x.PaidD);
mec.Paid = lstMonthEndClosed.Where(x => x.BankName != "Total").Sum(x => x.Paid);
mec.UnpaidA = lstMonthEndClosed.Where(x => x.BankName != "Total").Sum(x => x.UnpaidA);
mec.UnpaidD = lstMonthEndClosed.Where(x => x.BankName != "Total").Sum(x => x.UnpaidD);
mec.Unpaid = lstMonthEndClosed.Where(x => x.BankName != "Total").Sum(x => x.Unpaid);
mec.Total = lstMonthEndClosed.Where(x => x.BankName != "Total").Sum(x => x.Total);
lstMonthEndClosed.Add(mec);
}
mec.Closed = lstMonthEndClosed.Where(x => x.BankName != "Total").Sum(x => x.Closed);
}
