// GET: Loan public async Task <IActionResult> Index() { List <Loan> ActiveLoans = new List <Loan>(); List <Loan> OverdueLoans = new List <Loan>(); List <Loan> Loans = await _context.Loans .OrderBy(d => d.LoanStartDate) .Include(l => l.Book) .Include(l => l.Loaner) .ToListAsync(); foreach (var loan in Loans) { // Active loan if (loan.isLoanActive() == true) { ActiveLoans.Add(loan); } // Overdue Loans if (loan.isLoanOverdue() == true) { OverdueLoans.Add(loan); } } LoanVM LoanVM = new LoanVM { ActiveLoansList = ActiveLoans, OverdueLoansList = OverdueLoans }; return(View(LoanVM)); }
public ActionResult SaveLons(LoanVM Lons) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { Lons.CmpyCode = list[0].CmpyCode; Lons.UserName = list[0].user_name; return(Json(_LonService.SaveLons(Lons), JsonRequestBehavior.AllowGet)); } }
// GET: Loans/Edit/5 public async Task <IActionResult> Edit(string id) { if (id == null) { return(NotFound()); } LoanVM loanVM = new LoanVM(); loanVM.loan = await _context.Loans.FindAsync(id); if (loanVM.loan == null) { return(NotFound()); } loanVM.PreviousUrl = Request.Headers["Referer"].ToString(); return(View(loanVM)); }
// GET: Loans/Delete/5 public async Task <IActionResult> Delete(string id) { if (id == null) { return(NotFound()); } LoanVM loanVM = new LoanVM(); loanVM.loan = await _context.Loans .FirstOrDefaultAsync(m => m.Id == id); loanVM.PreviousUrl = Request.Headers["Referer"].ToString(); if (loanVM.loan == null) { return(NotFound()); } return(View(loanVM)); }
// GET: Loans/Details/5 public async Task <IActionResult> Details(int?id) { if (id == null) { return(NotFound()); } var loan = await _loanRepo.Get(id); if (loan == null) { return(NotFound()); } LoanVM LVM = new LoanVM { Loan = loan, Payments = await _loanRepo.GetPayments(loan.Id) }; return(View(LVM)); }
public LoanTab() { InitializeComponent(); DataContext = new LoanVM(); }
public LoanVM SaveLons(LoanVM Lons) { try { if (!Lons.EditFlag) { var Drecord = new List <string>(); List <LoanNew> ObjList = new List <LoanNew>(); ObjList.AddRange(Lons.LoanNew.Select(m => new LoanNew { PRLM001_CODE = m.PRLM001_CODE, COUNTRY = m.COUNTRY, CmpyCode = m.CmpyCode, Name = m.Name, Act_code = m.Act_code, }).ToList()); int n = 0; n = ObjList.Count; while (n > 0) { int Bbs1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from PRLM001 where CmpyCode='" + Lons.CmpyCode + "' and COUNTRY ='" + ObjList[n - 1].COUNTRY + "' and PRLM001_CODE='" + ObjList[n - 1].PRLM001_CODE + "'"); if (Bbs1 == 0) { StringBuilder sb = new StringBuilder(); sb.Append("'" + Lons.CmpyCode + "',"); sb.Append("'" + ObjList[n - 1].PRLM001_CODE + "',"); sb.Append("'" + ObjList[n - 1].COUNTRY + "',"); sb.Append("'" + ObjList[n - 1].Name + "',"); sb.Append("'" + ObjList[n - 1].Act_code + "')"); _EzBusinessHelper.ExecuteNonQuery("insert into PRLM001(CmpyCode,PRLM001_CODE,COUNTRY,Name,Act_code) values(" + sb.ToString() + ""); Lons.SaveFlag = true; Lons.ErrorMessage = string.Empty; } else { Drecord.Add(ObjList[n - 1].PRLM001_CODE.ToString()); Lons.Drecord = Drecord; Lons.SaveFlag = false; Lons.ErrorMessage = "Duplicate Record"; } n = n - 1; } return(Lons); } var LonsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from PRLM001 where CmpyCode='" + Lons.CmpyCode + "' and COUNTRY ='" + Lons.COUNTRY + "' and PRLM001_CODE='" + Lons.PRLM001_CODE + "'and Flag=0"); if (LonsEdit != 0) { _EzBusinessHelper.ExecuteNonQuery("update PRLM001 set Name='" + Lons.Name + "',Act_code='" + Lons.Act_code + "' where CmpyCode='" + Lons.CmpyCode + "' and COUNTRY ='" + Lons.COUNTRY + "' and PRLM001_CODE='" + Lons.PRLM001_CODE + "'"); Lons.SaveFlag = true; Lons.ErrorMessage = string.Empty; } else { Lons.SaveFlag = false; Lons.ErrorMessage = "Record not available"; } } catch (Exception ex) { Lons.SaveFlag = false; // unit.ErrorMessage = exceptionMessage; } return(Lons); }
public LoanVM SaveLons(LoanVM Lons) { return(_LonRepo.SaveLons(Lons)); }