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