public BillReview(DBConnection _DBConnection, DBConnection.Member member, bool isMonthly = false) { if (isMonthly) { Name = member.GetName(); Paid = 0; Remaining = 0; foreach (DBConnection.Bill bill in _DBConnection.MonthBills) { Remaining += bill.AmountHRK; } Remaining = Math.Round(Remaining / _DBConnection.Members.Count, 2); List <DBConnection.Payment> MemberPayments = (from item in _DBConnection.Payments where item.MemberId == member.Id select item).ToList <DBConnection.Payment>(); List <DBConnection.Bill> PaidMonthBills = (from item in _DBConnection.MonthBills where item.Paid select item).ToList <DBConnection.Bill>(); foreach (DBConnection.Bill bill in PaidMonthBills) { double amount = (from item in MemberPayments where item.BillId == bill.Id select item.AmountHRK).FirstOrDefault <double>(); Paid += amount; Remaining -= amount; } } else { Name = member.GetName(); Paid = 0; Remaining = 0; foreach (DBConnection.Bill bill in _DBConnection.Bills) { Remaining += bill.AmountHRK; } Remaining = Math.Round(Remaining / (double)_DBConnection.Members.Count, 2); List <DBConnection.Payment> MemberPayments = (from item in _DBConnection.Payments where item.MemberId == member.Id select item).ToList <DBConnection.Payment>(); foreach (DBConnection.Bill bill in _DBConnection.Bills) { double amount = (from item in MemberPayments where item.BillId == bill.Id select item.AmountHRK).FirstOrDefault <double>(); Paid += amount; Remaining -= amount; } } }
public MemberPayment(DBConnection _DBConnection, DBConnection.Bill Bill, DBConnection.Member Member) { MemberId = Member.Id; Name = Member.GetName(); PaymentAmount = 0; PaidAmount = _DBConnection.DB_GetMonthlyPaymentAmount(Member, Bill.DueDateMonth, Bill.DueDateYear); }