private async void LoadLoan()
{
LoanModel l = await loans.GetSingle(loanId);
BorrowerModel b = await borrowers.GetSingle(l.BorrowerId);
txtId.Text = b.BorrowerID;
txtName.Text = b.FirstName + " " + b.MiddleName[0] + ". " + b.LastName;
txtLoanId.Text = l.LoanId;
txtDuration.Text = l.Duration.ToString();
txtEffectiveDate.Text = ConvertDate(l.EffectiveDate);
txtInterest.Text = l.Interest.ToString();
txtMaturityDate.Text = ConvertDate(l.MaturityDate);
txtPerRemittance.Text = l.PerRemittance.ToString();
txtPrincipal.Text = l.PrincipalLoan.ToString();
txtMaturityValue.Text = l.MaturityValue.ToString();
txtTotalBalance.Text = l.TotalBalance.ToString();
cboPaymentTerm.SelectedValue = l.InterestId;
txtCollector.Text = users.GetSingle(" ", l.CollectorId).Name;
gName.Text = l.Guarantor.Name;
gAddress.Text = l.Guarantor.Address;
gContacts.Text = l.Guarantor.ContactNumber;
gRelation.Text = l.Guarantor.Relationship;
cValue.Text = l.Collateral.Value.ToString();
cItem.Text = l.Collateral.Item;
cDescription.Text = l.Collateral.Description;
btnPrint.Visible = true;
int _id = int.Parse(cboPaymentTerm.SelectedValue.ToString());
double interest = interests.getInterest(_id);
txtInterestRate.Text = $"{interest: ##.##}%";
Generate();
}
private void cboPaymentTerm_SelectedIndexChanged(object sender, EventArgs e)
{
if (isLoad)
{
double rate = interests.getInterest(int.Parse(cboPaymentTerm.SelectedValue.ToString()));
txtInterest.Text = rate.ToString();
}
}
