public ActionResult RetrieveDLRByLMSNo(string lmsno)
{
DLRModel mdl = new DLRModel();
mdl = service.getDLR(lmsno);
return(View("DLRbyLMSNo", mdl));
}
public DLRModel getDLR(string lmscode)
{
string sql = "usp_getDLR";
object[] parms = { "@lmsno", lmscode };
var data = db.ReadDictionary(sql, 1, parms);
DLRModel mdl = new DLRModel();
foreach (var d in data)
{
mdl.LMSCode = d["code"].ToString();
mdl.DLRNo = d["bis_code"].ToString();
mdl.DLRDate = d["datetime_created"].ToString();
mdl.Branch = d["branch"].ToString();
mdl.ApplicationTypeDesc = d["ApplicationTypeDesc"].ToString();
BorrowerInfoModel brw = new BorrowerInfoModel();
brw.FullName = d["LAST_NAME"].ToString() + ", " + d["FIRST_NAME"].ToString() + " " + d["MIDDLE_NAME"].ToString();
brw.BorrowerCode = d["OWNER_CODE"].ToString();
brw.Province = d["province_name"].ToString();
brw.City = d["city_name"].ToString();
brw.StreetAddress = d["street_address"].ToString();
brw.PostalCode = d["postal_code"].ToString();
brw.LandlineNo = d["phone_number"].ToString();
brw.MobileNo = d["mobile_number"].ToString();
brw.Brgy = d["barangay_name"].ToString();
mdl.Borrower = brw;
LoanInfoModel ln = new LoanInfoModel();
ln.LoanApplicationNo = d["loan_application_code"].ToString();
ln.LoanTypeDesc = d["loan_type_desc"].ToString();
ln.LoanSetDesc = d["loan_set_desc"].ToString();
ln.LoanTermDesc = d["loan_term_desc"].ToString();
ln.DesiredMLV = Convert.ToDouble(d["LOAN_AMOUNT"]).ToString("n2");
ln.ApprovedMLV = Convert.ToDouble(d["approved_mlv"]).ToString("n2");
ln.FirstDueDate = d["first_due_date"].ToString();
ln.AddOnRate = d["add_on_rate"].ToString();
ln.NetMonthlyInstallment = Convert.ToDouble(d["net_monthly_installment"]).ToString("n2");
mdl.Loan = ln;
GIBCOModel gibco = new GIBCOModel();
gibco.GIBCOBasic1 = Convert.ToDouble(d["gibco_basic_1"]).ToString("n2");
gibco.GIBCOBasic2 = Convert.ToDouble(d["gibco_basic_2"]).ToString("n2");
gibco.GIBCOBasic3 = Convert.ToDouble(d["gibco_basic_3"]).ToString("n2");
gibco.GIBCOBasic4 = Convert.ToDouble(d["gibco_basic_4"]).ToString("n2");
gibco.GIBCOBasic5 = Convert.ToDouble(d["gibco_basic_5"]).ToString("n2");
gibco.GIBCOYear1 = Convert.ToDouble(d["gibco_first_year"]).ToString("n2");
gibco.GIBCOYear2 = Convert.ToDouble(d["gibco_second_year"]).ToString("n2");
gibco.GIBCOYear3 = Convert.ToDouble(d["gibco_third_year"]).ToString("n2");
gibco.GIBCOYear4 = Convert.ToDouble(d["gibco_fourth_year"]).ToString("n2");
gibco.GIBCOYear5 = Convert.ToDouble(d["gibco_fifth_year"]).ToString("n2");
gibco.GMMU1 = Convert.ToDouble(d["gmmu_1"]).ToString("n2");
gibco.GMMU2 = Convert.ToDouble(d["gmmu_2"]).ToString("n2");
gibco.GMMU3 = Convert.ToDouble(d["gmmu_3"]).ToString("n2");
gibco.GMMU4 = Convert.ToDouble(d["gmmu_4"]).ToString("n2");
gibco.GMMU5 = Convert.ToDouble(d["gmmu_5"]).ToString("n2");
gibco.GIBCODate1 = d["gibco_date_1"].ToString();
gibco.GIBCODate2 = d["gibco_date_2"].ToString();
gibco.GIBCODate3 = d["gibco_date_3"].ToString();
gibco.GIBCODate4 = d["gibco_date_4"].ToString();
gibco.GIBCODate5 = d["gibco_date_5"].ToString();
mdl.GIBCO = gibco;
OutrightPayments outpayment = new OutrightPayments();
outpayment.HandlingORCode = d["or_handling_id"].ToString();
if (outpayment.HandlingORCode != String.Empty)
{
outpayment.HandlingORDate = d["datetime_created"].ToString();
}
outpayment.ProcessingORCode = d["or_processing_fee_id"].ToString();
if (outpayment.ProcessingORCode != String.Empty)
{
outpayment.ProcessingORDate = d["datetime_created"].ToString();
}
outpayment.DSTORCode = d["or_dst_id"].ToString();
if (outpayment.DSTORCode != String.Empty)
{
outpayment.DSTORDate = d["datetime_created"].ToString();
}
outpayment.PIPPVAOORCode = d["or_pip_pvao_id"].ToString();
if (outpayment.PIPPVAOORCode != String.Empty)
{
outpayment.PIPPVAOORDate = d["datetime_created"].ToString();
}
outpayment.RestructuringFeeORCode = d["or_restructuring_id"].ToString();
if (outpayment.RestructuringFeeORCode != String.Empty)
{
outpayment.RestructuringFeeORDate = d["datetime_created"].ToString();
}
outpayment.HandlingORAmount = d["or_amount_handling"].ToString();
outpayment.ProcessingORAmount = d["or_amount_processing_fee"].ToString();
outpayment.DSTORAmount = d["or_amount_dst"].ToString();
outpayment.PIPPVAOORAmount = d["or_amount_pip_pvao"].ToString();
outpayment.RestructuringFeeORAmount = d["or_amount_restructuring"].ToString();
mdl.Outpayments = outpayment;
LessHandlingFeeRebatablePaymentDiscount less = new LessHandlingFeeRebatablePaymentDiscount();
less.LessHandlingFee = d["handling_fee"].ToString();
less.TotalLessHandlingFee = Convert.ToDouble(d["handling_fee_total"]).ToString("n2");
less.LessFinanceCharges = d["less_finance_charges"].ToString();
less.LessHandlingWOInsurance = d["less_handling_fee_wo_insurance"].ToString();
less.LessHandlingWOPDC = d["less_handling_fee_wo_pdc"].ToString();
less.LessRppd = d["less_rppd"].ToString();
less.TotalPpd = d["total_ppd"].ToString();
mdl.LessHandling = less;
}
return(mdl);
}
