public JsonResult SavePayment(tbl_payment model)
{
try
{
db_lendingEntities db = new db_lendingEntities();
tbl_payment tbl = new tbl_payment();
tbl.reference_no = model.reference_no;
tbl.date_trans = model.date_trans;
tbl.payor_id = model.payor_id;
tbl.payor_name = model.payor_name;
tbl.total_amount = model.total_amount;
tbl.created_by = Session["UserName"].ToString();
tbl.date_created = DateTime.Now;
db.tbl_payment.Add(tbl);
db.SaveChanges();
return(Json(tbl.reference_no, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("Failed", JsonRequestBehavior.DenyGet));
throw ex;
}
}
public async Task <int> Delete(Tbl_paymentRequest tbl_paymentRequest)
{
var tbl_payment = new tbl_payment()
{
id = tbl_paymentRequest.id
};
_context.tbl_payments.Remove(tbl_payment);
return(await _context.SaveChangesAsync());
}
public async Task <int> Create(Tbl_paymentRequest tbl_paymentRequest)
{
int maxIdOrder = _context.tbl_orders.Max(u => u.id);
var tbl_payment = new tbl_payment()
{
receive = tbl_paymentRequest.receive,
refund = tbl_paymentRequest.refund,
type = tbl_paymentRequest.type,
idorder = maxIdOrder
};
_context.tbl_payments.Add(tbl_payment);
return(await _context.SaveChangesAsync());
}
public void AddPayment(ref dtoPayment t)
{
var payment = new tbl_payment()
{
referenceNumber = t.referenceNumber,
cashAmount = t.chequeAmount,
chequeNumber = t.chequeNumber,
chequeDate = t.chequeDate,
chequeBank = t.chequeBank,
dateCreated = DateTime.Now,
createdBy = t.createdBy,
supplierId = t.supplierId
};
DBContext.tbl_payment.Add(payment);
DBContext.SaveChanges();
t.paymentId = payment.paymentId;
}
//VIEWING
public ActionResult Details(int?id)
{
try
{
using (db_lendingEntities db = new db_lendingEntities())
{
tbl_payment tbl_payment = db.tbl_payment.Find(id);
if (Session["UserId"] != null)
{
return(View(tbl_payment));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
}
catch (Exception)
{
throw;
}
}
public async Task <JsonResult> Save(collectionSaveModel model)
{
try
{
tbl_payment payment = new tbl_payment();
bool success = false;
string message = "";
db = new db_lendingEntities();
var isDuplicate = await db.tbl_payment.AllAsync(u => u.reference_no == model.PaymentNo);
if (isDuplicate == false)
{
payment.reference_no = model.PaymentNo;
payment.date_trans = DateTime.Parse(model.PaymentDate);
payment.payor_id = int.Parse(model.CustomerId);
payment.payor_name = model.CustomerName;
payment.total_amount = decimal.Round(decimal.Parse(model.Payment), 2,
MidpointRounding.AwayFromZero);
payment.created_by = Session["UserName"].ToString();
payment.date_created = DateTime.Now;
db.tbl_payment.Add(payment);
await db.SaveChangesAsync();
var result = true;
success = result;
if (result)
{
decimal totalPayment = 0;
decimal amountDuePrincipal = 0;
decimal amountDueInterest = 0;
try
{
totalPayment = decimal.Round(decimal.Parse(model.Payment), 2,
MidpointRounding.AwayFromZero);
amountDuePrincipal = decimal.Round(decimal.Parse(model.AmountDuePrincipal), 2,
MidpointRounding.AwayFromZero);
amountDueInterest = decimal.Round(decimal.Parse(model.AmountDueInterest), 2,
MidpointRounding.AwayFromZero);
}
catch (Exception ex)
{
}
decimal paymentInterest = 0;
decimal paymentPrincipal = 0;
if (amountDueInterest > 0)
{
if (totalPayment >= amountDueInterest)
{
paymentInterest = decimal.Round(amountDueInterest, 2, MidpointRounding.AwayFromZero);
totalPayment = totalPayment - paymentInterest;
}
else if (totalPayment < amountDueInterest)
{
paymentInterest = totalPayment;
totalPayment = 0;
}
}
if (amountDuePrincipal > 0)
{
paymentPrincipal = totalPayment;
totalPayment = 0;
}
if (paymentPrincipal > 0)
{
tbl_payment_details paymentDetailsPrincipal = new tbl_payment_details();
paymentDetailsPrincipal.reference_no = model.PaymentNo;
paymentDetailsPrincipal.payment_type = "OR Payment";
paymentDetailsPrincipal.loan_no = model.LoanNo;
paymentDetailsPrincipal.loan_name = model.LoanName;
paymentDetailsPrincipal.due_date = DateTime.Parse(model.LoanDueDate);
paymentDetailsPrincipal.amount =
decimal.Round(paymentPrincipal, 2, MidpointRounding.AwayFromZero);
paymentDetailsPrincipal.created_by = Session["UserName"].ToString();
paymentDetailsPrincipal.date_created = DateTime.Now;
db.tbl_payment_details.Add(paymentDetailsPrincipal);
await db.SaveChangesAsync();
}
if (paymentInterest > 0)
{
tbl_payment_details paymentDetailsInterest = new tbl_payment_details();
paymentDetailsInterest.reference_no = model.PaymentNo;
paymentDetailsInterest.payment_type = "OR Payment Interest";
paymentDetailsInterest.loan_no = model.LoanNo;
paymentDetailsInterest.loan_name = model.LoanName;
paymentDetailsInterest.due_date = DateTime.Parse(model.LoanDueDate);
paymentDetailsInterest.amount =
decimal.Round(paymentInterest, 2, MidpointRounding.AwayFromZero);
paymentDetailsInterest.created_by = Session["UserName"].ToString();
paymentDetailsInterest.date_created = DateTime.Now;
db.tbl_payment_details.Add(paymentDetailsInterest);
await db.SaveChangesAsync();
}
tbl_loan_ledger loanLedger = new tbl_loan_ledger();
loanLedger.date_trans = DateTime.Parse(model.PaymentDate);
loanLedger.trans_type = "OR Payment";
loanLedger.reference_no = model.PaymentNo;
loanLedger.loan_no = model.LoanNo;
loanLedger.loan_type_name = model.LoanName;
loanLedger.customer_id = int.Parse(model.CustomerId);
loanLedger.customer_name = model.CustomerName;
loanLedger.interest_type = GetInterestType(model.LoanName);
loanLedger.interest_rate = GetInterestRate(model.LoanName);
loanLedger.interest = decimal.Round(paymentInterest, 2, MidpointRounding.AwayFromZero);
loanLedger.amount_paid =
decimal.Round(decimal.Parse(model.Payment), 2, MidpointRounding.AwayFromZero);
loanLedger.principal = decimal.Round(paymentPrincipal, 2, MidpointRounding.AwayFromZero);
loanLedger.balance = 0;
loanLedger.date_created = DateTime.Now;
loanLedger.created_by = Session["UserName"].ToString();
db.tbl_loan_ledger.Add(loanLedger);
await db.SaveChangesAsync();
message = "Successfully saved.";
}
else
{
message = "Error saving data. Duplicate entry.";
}
}
else
{
message = "Error saving data. Duplicate entry.";
}
return(Json(new { success = success, message = message }));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
return(Json(new { success = false, message = "Failed to save." }));
}
}
public dtoResult Insert(ref dtoPayment t)
{
dtoResult objResult = new dtoResult();
try
{
var objpayment = new tbl_payment
{
supplierId = t.supplierId,
referenceNumber = t.referenceNumber,
paymentDate = DateTime.Now,
cashAmount = t.cashAmount,
chequeAmount = t.chequeAmount,
chequeNumber = t.chequeNumber,
TypeOfPayment = t.TypeOfPayment,
ModeOfPayment = t.ModeOfPayment,
chequeDate = t.chequeDate,
chequeBank = t.chequeBank,
totalPayment = t.totalPayment,
dateCreated = DateTime.Now,
createdBy = t.createdBy
};
DBContext.tbl_payment.Add(objpayment);
DBContext.SaveChanges();
t.paymentId = objpayment.paymentId;
objResult.isSuccessful = true;
}
catch (Exception ex)
{
objResult.isSuccessful = false;
objResult.errorMsg = ex.Message;
}
return objResult;
}
