public void CalculateLoanStatisticsThrowExceptionIfNotValidDownpayment(int downpayment)
{
var loanInfoModel = new LoanInfoModel(10, 5, downpayment, 10);
var manager = new Mock <ILoanManager>();
manager.Setup(x => x.CalculateLoanStatistics(It.IsAny <ILoanInfoModel>())).Throws <InvalidDownPaymentException>();
Assert.Throws <InvalidDownPaymentException>(() => manager.Object.CalculateLoanStatistics(loanInfoModel));
}
public void CalculateLoanStatisticsThrowExceptionIfNotValidTerm(int term)
{
var loanInfoModel = new LoanInfoModel(10, 5, 5, term);
var manager = new Mock <ILoanManager>();
manager.Setup(x => x.CalculateLoanStatistics(It.IsAny <ILoanInfoModel>())).Throws <InvalidTermException>();
Assert.Throws <InvalidTermException>(() => manager.Object.CalculateLoanStatistics(loanInfoModel));
}
public void CalculateLoanStatisticsMethodReturnsResult()
{
var loanInfoModel = new LoanInfoModel(100000, 5.5m, 20000, 30);
var manager = new Mock <ILoanManager>();
manager.Object.CalculateLoanStatistics(loanInfoModel);
manager.Verify(x => x.CalculateLoanStatistics(loanInfoModel), Times.Once);
Assert.DoesNotThrow(() => manager.Object.CalculateLoanStatistics(loanInfoModel));
}
public static ILoanInfoModel FillLoanFields()
{
var amount = 0;
decimal interest = 0;
var downpayment = 0;
var term = 0;
Console.Clear();
Console.Write(LoanRes.Amount);
try
{
int.TryParse(Console.ReadLine(), out amount);
if (amount <= 0)
{
throw new Exception();
}
}
catch
{
while (amount <= 0)
{
var errorMessage = amount <= 0 ? Errors.MustBepositiveOrGreaterZero : Errors.NotValidInteger;
Log.Error(errorMessage);
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(errorMessage);
Console.ResetColor();
Console.Write(LoanRes.Amount);
int.TryParse(Console.ReadLine(), out amount);
}
}
Console.Write(LoanRes.Interest);
try
{
var interestString = Console.ReadLine(); // Reading From console
var trimmed = interestString.Trim('%').Replace(",", "."); // Trimming '%' symbols
if (!decimal.TryParse(trimmed, out interest))
{
throw new Exception(Errors.NotValidInteger);
}
if (interest <= 0 || interest > 100)
{
throw new Exception("");
}
}
catch (Exception e)
{
var notValidString = !string.IsNullOrEmpty(e.Message); // flag for error mesages
while (interest <= 0 || interest > 100)
{
string errorMessage;
if (interest <= 0)
{
errorMessage = notValidString ? e.Message : Errors.MustBepositiveOrGreaterZero;
}
else if (interest > 100)
{
errorMessage = Errors.PersentLess;
}
else
{
errorMessage = Errors.NotValidInteger;
}
Log.Error(errorMessage);
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(errorMessage);
Console.ResetColor();
Console.Write(LoanRes.Interest);
var interestString = Console.ReadLine();
var trimmed = interestString.Trim('%'); // Trimming not numerical symbols
notValidString = !decimal.TryParse(trimmed, out interest);
}
}
Console.Write(LoanRes.Downpayment);
try
{
if (!int.TryParse(Console.ReadLine(), out downpayment))
{
throw new Exception(Errors.NotValidInteger);
}
;
if (downpayment < 0)
{
throw new Exception("");
}
if (downpayment >= amount)
{
throw new Exception("");
}
}
catch (Exception e)
{
var notValidString = !string.IsNullOrEmpty(e.Message);
while (downpayment < 0 || downpayment >= amount || notValidString)
{
string errorMessage;
if (downpayment < 0)
{
errorMessage = Errors.MustBepositive;
}
else if (downpayment >= amount)
{
errorMessage = Errors.DownpaymentLessAmount;
}
else
{
errorMessage = Errors.NotValidInteger;
}
Log.Error(errorMessage);
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(errorMessage);
Console.ResetColor();
Console.Write(LoanRes.Downpayment);
notValidString = !int.TryParse(Console.ReadLine(), out downpayment);
}
}
Console.Write(LoanRes.Term);
try
{
int.TryParse(Console.ReadLine(), out term);
if (term <= 0)
{
throw new Exception();
}
}
catch
{
while (term <= 0)
{
var errorMessage = amount <= 0 ? Errors.MustBepositiveOrGreaterZero : Errors.NotValidInteger;
Log.Error(errorMessage);
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(errorMessage);
Console.ResetColor();
Console.Write(LoanRes.Term);
int.TryParse(Console.ReadLine(), out term);
}
}
Console.WriteLine();
var result = new LoanInfoModel(amount, interest, downpayment, term);
return(result);
}
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);
}