public OurBank GetPersonBank(string NationalCode) { decimal Loan = dc.LoanSelectCommand().Where(x => x.PersonNationalCode == NationalCode).Sum(x => x.Amount); decimal Deposit = dc.DepositSelectCommand().Where(x => x.PersonNationalCode == NationalCode).Sum(x => x.Amount); // TODO better code here decimal PayedInstallements = 0, NonPayedInstallements = 0; foreach (var item in dc.LoanTransactions.Where(x => x.PersonNationalCode == NationalCode)) { PayedInstallements += item.Installements.Where(x => x.IsPayed == true).Sum(x => x.Amount); NonPayedInstallements += item.Installements.Where(x => x.IsPayed == false).Sum(x => x.Amount); } return(new OurBank { Loan = Loan, Deposit = Deposit, PayedInstallements = PayedInstallements, NonPayedInstallements = NonPayedInstallements }); }
public List <DepositSelectCommandResult> UnPermittedDepositTransactions(string NationalCode) { return(dc.DepositSelectCommand().Where(x => x.AdminPermission == false && x.PersonNationalCode == NationalCode).ToList()); }