public static ReportDataSource GetInstallment(ITInstallmentRepository installmentRepository, string loanAcc, int installmentNo)
{
IEnumerable <TInstallment> installments = installmentRepository.GetInstallment(loanAcc, installmentNo);
var list = from ins in installments
select new
{
ins.Id,
ins.LoanId.LoanCode,
CustomerName = ins.LoanId.PersonId.PersonName,
ins.InstallmentMaturityDate,
ins.InstallmentTotal,
ins.InstallmentFine,
ins.InstallmentMustPaid,
ins.InstallmentReceiptNo,
CustomerAddress = ins.LoanId.AddressId.AddressLine1,
ins.InstallmentNo,
ins.LoanId.LoanTenor,
ins.LoanId.LoanUnits[0].UnitName,
ins.LoanId.LoanUnits[0].UnitType
}
;
ReportDataSource reportDataSource = new ReportDataSource("InstallmentViewModel", list.ToList());
return(reportDataSource);
}
public static InstallmentPaymentFormViewModel Create(ITInstallmentRepository installmentRepository, IMEmployeeRepository mEmployeeRepository, string loanCode)
{
installmentRepository.DbContext.BeginTransaction();
InstallmentPaymentFormViewModel viewModel = new InstallmentPaymentFormViewModel();
TInstallment ins = installmentRepository.GetLastInstallment(loanCode);
if (ins == null)
{
ins = new TInstallment();
}
viewModel.installment = ins;
viewModel.installment.InstallmentPaymentDate = DateTime.Today;
installmentRepository.DbContext.RollbackTransaction();
var listEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.COL.ToString());
MEmployee employee = new MEmployee();
//mCustomer.SupplierName = "-Pilih Supplier-";
listEmployee.Insert(0, employee);
var collector = from emp in listEmployee
//where emp.DepartmentId.DepartmentName == "COLLECTOR"
select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Pilih Kolektor-" };
viewModel.CollectorList = new SelectList(collector, "Id", "Id", string.Empty);
return(viewModel);
}
public InstallmentController(ITLoanRepository loanRepository, ITInstallmentRepository installmentRepository, IMEmployeeRepository mEmployeeRepository)
{
Check.Require(loanRepository != null, "loanRepository may not be null");
Check.Require(installmentRepository != null, "installmentRepository may not be null");
Check.Require(mEmployeeRepository != null, "mEmployeeRepository may not be null");
this._loanRepository = loanRepository;
this._installmentRepository = installmentRepository;
this._mEmployeeRepository = mEmployeeRepository;
}
public ReportController(ITLoanRepository loanRepository, ITInstallmentRepository installmentRepository, ITCommissionRepository tCommissionRepository, ITRecPeriodRepository tRecPeriodRepository, IMPartnerRepository mPartnerRepository)
{
Check.Require(loanRepository != null, "loanRepository may not be null");
Check.Require(installmentRepository != null, "installmentRepository may not be null");
Check.Require(tCommissionRepository != null, "tCommissionRepository may not be null");
Check.Require(tRecPeriodRepository != null, "tRecPeriodRepository may not be null");
Check.Require(mPartnerRepository != null, "mPartnerRepository may not be null");
this._loanRepository = loanRepository;
this._installmentRepository = installmentRepository;
this._tCommissionRepository = tCommissionRepository;
this._tRecPeriodRepository = tRecPeriodRepository;
this._mPartnerRepository = mPartnerRepository;
}
public static DetailLoanViewModel Create(ITLoanRepository loanRepository, ITInstallmentRepository installmentRepository, string loanCode)
{
DetailLoanViewModel viewModel = new DetailLoanViewModel();
viewModel.Loan = loanRepository.GetLoanByLoanCode(loanCode);
var l = from t in viewModel.Loan.Installments
where
t.InstallmentStatus == EnumInstallmentStatus.Not_Paid.ToString() &&
t.InstallmentMaturityDate < DateTime.Today
select t;
viewModel.InstallmentLate = l.Count();
viewModel.InstallmentMore =
(viewModel.Loan.Installments).Where(x => x.InstallmentStatus == EnumInstallmentStatus.Paid.ToString()).
Sum(x => x.InstallmentSisa).Value;
viewModel.InstallmentMinus =
(viewModel.Loan.Installments).Where(x => x.InstallmentStatus == EnumInstallmentStatus.Paid.ToString()).
Sum(x => x.InstallmentSisa).Value;
viewModel.InstallmentFine =
(viewModel.Loan.Installments).Where(x => x.InstallmentStatus == EnumInstallmentStatus.Paid.ToString()).
Sum(x => x.InstallmentFine).Value;
string separator = "|";
string[] photos = viewModel.Loan.LoanDesc.Split(separator.ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
viewModel.Photo1 = "~/Content/Images/no_photo104_on.jpg";
viewModel.Photo2 = "~/Content/Images/no_photo104_on.jpg";
if (photos.Count() > 0)
{
viewModel.Photo1 = photos[0];
}
if (photos.Count() > 1)
{
viewModel.Photo2 = photos[1];
}
return(viewModel);
}
public ClosingController(ITLoanRepository loanRepository, ITInstallmentRepository installmentRepository, IMEmployeeRepository mEmployeeRepository, ITRecPeriodRepository tRecPeriodRepository, IMCommissionRepository mCommissionRepository, IMCommissionDetRepository mCommissionDetRepository, ITLoanSurveyRepository tLoanSurveyRepository, ITCommissionRepository tCommissionRepository, IMZoneEmployeeRepository mZoneEmployeeRepository)
{
Check.Require(loanRepository != null, "loanRepository may not be null");
Check.Require(installmentRepository != null, "installmentRepository may not be null");
Check.Require(mEmployeeRepository != null, "mEmployeeRepository may not be null");
Check.Require(tRecPeriodRepository != null, "tRecPeriodRepository may not be null");
Check.Require(mCommissionRepository != null, "mCommissionRepository may not be null");
Check.Require(mCommissionDetRepository != null, "mCommissionDetRepository may not be null");
Check.Require(tLoanSurveyRepository != null, "tLoanSurveyRepository may not be null");
Check.Require(tCommissionRepository != null, "tCommissionRepository may not be null");
Check.Require(mZoneEmployeeRepository != null, "mZoneEmployeeRepository may not be null");
this._loanRepository = loanRepository;
this._installmentRepository = installmentRepository;
this._mEmployeeRepository = mEmployeeRepository;
this._tRecPeriodRepository = tRecPeriodRepository;
this._mCommissionRepository = mCommissionRepository;
this._mCommissionDetRepository = mCommissionDetRepository;
this._tLoanSurveyRepository = tLoanSurveyRepository;
this._tCommissionRepository = tCommissionRepository;
this._mZoneEmployeeRepository = mZoneEmployeeRepository;
}
