private List <ViewModel_EmployeeLoan> GetEmployeeLoans() { List <ViewModel_EmployeeLoan> employeeLoanViewList = new List <ViewModel_EmployeeLoan>(); var employeeLoanList = _employeeLoanLogic.GetList(); //var employeeLoanPaymentList = _employeeLoanPaymentLogic.GetList(); var employeeList = employeeLoanList.Select(c => c.EmployeeId).Distinct(); var employees = _employeeLogic.GetList(); foreach (var employeeId in employeeList) { ViewModel_EmployeeLoan employeeLoanView = new ViewModel_EmployeeLoan(); employeeLoanView.EmployeeId = employeeId; var emp = employees.Where(e => e.Id == employeeId).FirstOrDefault(); employeeLoanView.EmployeeName = emp.FirstName + " " + emp.LastName; employeeLoanView.LoanAmount = employeeLoanList.Where(c => c.EmployeeId == employeeId).Sum(c => c.LoanAmount); employeeLoanView.PaidAmount = 0;// employeeLoanPaymentList.Where(c=>c.EmployeeId==employeeId).Sum(c=>c.LoanAmountPaid); employeeLoanView.DueAmount = employeeLoanView.LoanAmount - employeeLoanView.PaidAmount; employeeLoanViewList.Add(employeeLoanView); } return(employeeLoanViewList); }
private List <ViewModel_EmployeeLoan> GetEmployeeLoans() { List <ViewModel_EmployeeLoan> employeeLoanViewList = new List <ViewModel_EmployeeLoan>(); var employeeLoanList = _employeeLoanLogic.GetList(); var employeeList = _employeeLogic.GetList(); foreach (var loan in employeeLoanList) { ViewModel_EmployeeLoan employeeLoanView = new ViewModel_EmployeeLoan(); employeeLoanView.LoanId = loan.Id; employeeLoanView.EmployeeId = loan.EmployeeId; employeeLoanView.EmployeeName = employeeList.Where(c => c.Id == loan.EmployeeId).FirstOrDefault().FirstName + " " + employeeList.Where(c => c.Id == loan.EmployeeId).FirstOrDefault().LastName; employeeLoanView.LoanAmount = loan.LoanAmount; employeeLoanView.LoanTakenOn = loan.LoanTakenOn; employeeLoanView.Remarks = loan.Remarks; employeeLoanViewList.Add(employeeLoanView); } return(employeeLoanViewList); }