示例#1
0
        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);
        }