// 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));
}
