Windows application

_loanAmount = decimal.Parse(txtLoanamt.Text);

_intrestRate = double.Parse(txtIntrestrate.Text);

_year = int.Parse(txtYear.Text);

_months = _year * 12;

if (_intrestRate > 1)

{

_intrestRate = _intrestRate / 12;

}

R = (_intrestRate / 100);

F = Math.Pow(1 + R, _months);

// decimal s = (_loanAmount * (Decimal)R);

decimal val = (Decimal)(F - 1);

decimal EMI = (_loanAmount * (Decimal)R) * (decimal)F / val;

// decimal val = (_loanAmount * (Decimal)((R * F / (-1 + F))));

_monthlyPayment = Math.Round(EMI, 2);

decimal tot = _monthlyPayment * _months;

_totalPayment = Math.Round(tot, 2);

monthlypmt = Convert.ToDecimal(_monthlyPayment);

totalpmt = Convert.ToDecimal(_totalPayment);

txtMontlypayment.Text = Convert.ToString(monthlypmt);

txtTotalPayment.Text = Convert.ToString(totalpmt);

_loan.LoanAmount = _loanAmount;

//_loan.Intrest = Convert.ToDecimal(_intrestRate) / 100;

_loan.Intrest = Convert.ToDecimal(txtIntrestrate.Text);

_loan.Loanperiod = Convert.ToString(_year);

_loan.MonthlyPayment = Convert.ToDecimal(_monthlyPayment);

_loan.TotalPayment = Convert.ToDecimal(_totalPayment);

_loan.AccountNo = txtAccno.Text;

_loan.Name = txtName.Text;

_loan.LoanStatus = "Pending";

_loan.Date = DateTime.UtcNow.ToString();

_loan.TypeOfLoan = combboxLoantypes.Text;

_loan.RemaningMonths = _months;

_dbEntity.LoanDetailTables.Add(_loan);

try

{

_dbEntity.SaveChanges();

string temp = txtAccno.Text;

var iteam = (from user in _dbEntity.UserAccountDetails

where user.Account_No == temp

select user).FirstOrDefault();

_loan.TotalBalance = iteam.Balance;

_loan.Email = iteam.Email;

SetValueForText1 = iteam.Account_No;

_dbEntity.SaveChanges();

}

catch

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

S J6y ago
_loanAmount = decimal.Parse(txtLoanamt.Text);
_intrestRate = double.Parse(txtIntrestrate.Text);
_year = int.Parse(txtYear.Text);
_months = _year * 12;
if (_intrestRate > 1)
{
_intrestRate = _intrestRate / 12;
}
R = (_intrestRate / 100);
F = Math.Pow(1 + R, _months);
// decimal s = (_loanAmount * (Decimal)R);
decimal val = (Decimal)(F - 1);
decimal EMI = (_loanAmount * (Decimal)R) * (decimal)F / val;
// decimal val = (_loanAmount * (Decimal)((R * F / (-1 + F))));
_monthlyPayment = Math.Round(EMI, 2);
decimal tot = _monthlyPayment * _months;
_totalPayment = Math.Round(tot, 2);
monthlypmt = Convert.ToDecimal(_monthlyPayment);
totalpmt = Convert.ToDecimal(_totalPayment);
txtMontlypayment.Text = Convert.ToString(monthlypmt);
txtTotalPayment.Text = Convert.ToString(totalpmt);
_loan.LoanAmount = _loanAmount;
//_loan.Intrest = Convert.ToDecimal(_intrestRate) / 100;
_loan.Intrest = Convert.ToDecimal(txtIntrestrate.Text);
_loan.Loanperiod = Convert.ToString(_year);
_loan.MonthlyPayment = Convert.ToDecimal(_monthlyPayment);
_loan.TotalPayment = Convert.ToDecimal(_totalPayment);
_loan.AccountNo = txtAccno.Text;
_loan.Name = txtName.Text;
_loan.LoanStatus = "Pending";
_loan.Date = DateTime.UtcNow.ToString();
_loan.TypeOfLoan = combboxLoantypes.Text;
_loan.RemaningMonths = _months;
_dbEntity.LoanDetailTables.Add(_loan);
try
{
_dbEntity.SaveChanges();
string temp = txtAccno.Text;
var iteam = (from user in _dbEntity.UserAccountDetails
where user.Account_No == temp
select user).FirstOrDefault();
_loan.TotalBalance = iteam.Balance;
_loan.Email = iteam.Email;
SetValueForText1 = iteam.Account_No;
_dbEntity.SaveChanges();
}
catch
Amit Gupta6y ago
If you have implemented the correct formula then it will work accordingly, Do re-recheck the implemented formula.

Here is a website for formula and calculations
https://emicalculator.net/
Laxmidhar Sahoo6y ago
hi
plsease display details