public ActionResult ConfirmPayment()
{
//var result = db.FINES.Where(x => x.LOAN_ID == x.BOOK_LOANS.LOAN_ID);
//var value = Convert.ToInt32(Session["loanID"]);
//FINE fine = new FINE();
//foreach(var items in db.FINES)
//{
// if(items.LOAN_ID == value)
// {
// fine.LOAN_ID = value;
// fine.FINE_AMT = Convert.ToDecimal(Session["fine_amt"]);
// fine.PAID = DateTime.Now;
// db.FINES.Remove(items);
// db.SaveChanges();
// db.FINES.Add(fine);
// db.SaveChanges();
// return View("Index");
// }
//}
var id = Convert.ToInt32(Session["loanID"]);
FINE fine = db.FINES.Find(id);
fine.FINE_AMT = Convert.ToDecimal(Session["fine_amt"]);
fine.PAID = DateTime.Now;
db.FINES.Add(fine);
db.SaveChanges();
return(View("Index"));
}
public ActionResult DeleteConfirmed(decimal id)
{
FINE fINE = db.FINES.Find(id);
db.FINES.Remove(fINE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "LOAN_ID,FINE_AMT,PAID")] FINE fINE)
{
if (ModelState.IsValid)
{
db.Entry(fINE).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LOAN_ID = new SelectList(db.BOOK_LOANS, "LOAN_ID", "LOAN_ID", fINE.LOAN_ID);
return(View(fINE));
}
public ActionResult Create([Bind(Include = "LOAN_ID,FINE_AMT,PAID")] FINE fINE)
{
if (ModelState.IsValid)
{
db.FINES.Add(fINE);
BOOKsController book = new BOOKsController();
//db.SaveChanges();
book.ViewFines(fINE.BOOK_LOANS);
return(RedirectToAction("Index"));
}
ViewBag.LOAN_ID = new SelectList(db.BOOK_LOANS, "LOAN_ID", "LOAN_ID", fINE.LOAN_ID);
return(View(fINE));
}
// GET: FINEs/Details/5
public ActionResult Details(decimal?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FINE fINE = db.FINES.Find(id);
if (fINE == null)
{
return(HttpNotFound());
}
return(View(fINE));
}
// GET: FINEs/Edit/5
public ActionResult Edit(decimal?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FINE fINE = db.FINES.Find(id);
if (fINE == null)
{
return(HttpNotFound());
}
ViewBag.LOAN_ID = new SelectList(db.BOOK_LOANS, "LOAN_ID", "LOAN_ID", fINE.LOAN_ID);
return(View(fINE));
}
public ActionResult CheckIn(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var fine = db.FINES.Find(id);
/*if (fine == null)
* {
* return HttpNotFound();
* }*/
var book_loan = db.BOOK_LOANS.Find(id);
//if (fine.BOOK_LOANS.DATE_IN > fine.BOOK_LOANS.DUE_DATE)
//DateTime due_date = new DateTime(fine.BOOK_LOANS.DUE_DATE);
DateTime due_date = book_loan.DUE_DATE;
if (DateTime.Now > Convert.ToDateTime(due_date))
{
FINE fines = new FINE();
DateTime default_date = new DateTime(9999, 12, 12);
var days = DateTime.Now.Subtract(due_date).TotalDays;
fines.FINE_AMT = Convert.ToDecimal(0.25 * days);
fines.LOAN_ID = book_loan.LOAN_ID;
fines.PAID = default_date;
FINEsController cont = new FINEsController();
cont.Create(fines);
db.SaveChanges();
return(View("FineAdded"));
}
else
{
BOOK_LOANS bkln = db.BOOK_LOANS.Find(id);
bkln.DATE_IN = DateTime.Now;
var isbn = bkln.ISBN;
//SearchNew book = db.SearchNews.Find(isbn);
//db.SearchNews.Add(book);
db.SaveChanges();
}
return(RedirectToAction("ReturnBookLoan"));
}
