public ActionResult DeleteConfirmed(int id)
{
BOOK_LOANS bOOK_LOANS = db.BOOK_LOANS.Find(id);
db.BOOK_LOANS.Remove(bOOK_LOANS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "LOAN_ID,ISBN,CARD_ID,DATE_OUT,DUE_DATE,DATE_IN")] BOOK_LOANS bOOK_LOANS)
{
if (ModelState.IsValid)
{
db.Entry(bOOK_LOANS).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ISBN = new SelectList(db.BOOKs, "ISBN", "TITLE", bOOK_LOANS.ISBN);
ViewBag.CARD_ID = new SelectList(db.BORROWERs, "CARD_ID", "SSN", bOOK_LOANS.CARD_ID);
return(View(bOOK_LOANS));
}
public ActionResult ViewFines(BOOK_LOANS book_loans)
{
//return View(db.FINES.ToList().Where(x => x.CARD_ID == Convert.ToInt32(Session["cardID"])));
//var query = (from bk in db.BOOK_LOANS
// join f in db.FINES
// on bk.LOAN_ID equals f.LOAN_ID
// where bk.CARD_ID == Convert.ToInt32(Session["cardID"])
// select f.LOAN_ID).ToList();
return(View(db.FINES.ToList().Where(x => x.BOOK_LOANS.CARD_ID == Convert.ToInt32(Session["cardID"]))));
}
// GET: BOOK_LOANS/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BOOK_LOANS bOOK_LOANS = db.BOOK_LOANS.Find(id);
if (bOOK_LOANS == null)
{
return(HttpNotFound());
}
return(View(bOOK_LOANS));
}
// GET: BOOK_LOANS/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BOOK_LOANS bOOK_LOANS = db.BOOK_LOANS.Find(id);
if (bOOK_LOANS == null)
{
return(HttpNotFound());
}
ViewBag.ISBN = new SelectList(db.BOOKs, "ISBN", "TITLE", bOOK_LOANS.ISBN);
ViewBag.CARD_ID = new SelectList(db.BORROWERs, "CARD_ID", "SSN", bOOK_LOANS.CARD_ID);
return(View(bOOK_LOANS));
}
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"));
}
public ActionResult ConfirmBookLoan()
{
BOOK_LOANS bk_loan = new BOOK_LOANS();
bk_loan.CARD_ID = Convert.ToInt32(Session["cardID"]);
/* foreach(var value in db.BOOK_LOANS)
* {
* if (value.ISBN == bk_loan.ISBN)
* return View("BookNotAvailable");
* else
* {
* }
* }*/
bk_loan.ISBN = Convert.ToInt64(Session["ISBN"]);
bk_loan.DATE_OUT = DateTime.Now;
bk_loan.DUE_DATE = DateTime.Now.AddDays(14);
bk_loan.DATE_IN = null;
db.BOOK_LOANS.Add(bk_loan);
db.SaveChanges();
//Session.Clear();
return(RedirectToAction("AddBookLoan"));
}
