public ActionResult DeleteConfirmed(int id) { BORROWER bORROWER = db.BORROWERs.Find(id); db.BORROWERs.Remove(bORROWER); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "CARD_ID,SSN,FNAME,LNAME,ADDRESS,PHONE")] BORROWER bORROWER) { if (ModelState.IsValid) { db.Entry(bORROWER).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bORROWER)); }
// GET: BORROWERs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BORROWER bORROWER = db.BORROWERs.Find(id); if (bORROWER == null) { return(HttpNotFound()); } return(View(bORROWER)); }
public ActionResult SetCardId(BORROWER borrower) { int cardId = borrower.CARD_ID; Session["cardID"] = borrower.CARD_ID; bool result = db.BORROWERs.Where(x => x.CARD_ID == cardId).Any(); if (result == false) { return(View("StudentNotFound")); } return(RedirectToAction("ReturnBookLoan")); }
public ActionResult Create([Bind(Include = "CARD_ID,SSN,FNAME,LNAME,ADDRESS,PHONE")] BORROWER bORROWER) { if (ModelState.IsValid) { foreach (var ssns in db.BORROWERs) { if (ssns.SSN == bORROWER.SSN) { return(View("UserExists")); } } db.BORROWERs.Add(bORROWER); db.SaveChanges(); return(RedirectToAction("Index")); } //Session["ssn"] = bORROWER.SSN; return(View(bORROWER)); }
public ActionResult ValidateCheckOut(BORROWER borrower) { int cardId = borrower.CARD_ID; Session["cardID"] = borrower.CARD_ID; bool result = db.BORROWERs.Where(x => x.CARD_ID == cardId).Any(); //1. First Condition--If the student is registered if (result == false) { return(View("StudentNotFound")); } //2. Second Condition--If the student has already issued three books //int count = db.BOOK_LOANS.Where(x => x.CARD_ID == cardId).Count(); int count = (from bk in db.BOOK_LOANS join b in db.BORROWERs on bk.CARD_ID equals b.CARD_ID where borrower.CARD_ID == bk.CARD_ID where bk.DATE_IN == null select bk.LOAN_ID).Count(); int overDue_count = (from bk in db.BOOK_LOANS join b in db.BORROWERs on bk.CARD_ID equals b.CARD_ID where bk.CARD_ID == borrower.CARD_ID where DateTime.Now > bk.DUE_DATE select bk.LOAN_ID).Count(); //Session["count"] = count; if (count == 3 || overDue_count > 0) { return(View("MaximumLimitReached")); } //3. If the student has unpaid Fine var query = (from bk in db.BOOK_LOANS join f in db.FINES on bk.LOAN_ID equals f.LOAN_ID where f.PAID == null select bk.CARD_ID).ToList(); foreach (int value in query) { if (value == borrower.CARD_ID) { return(View("Fine")); } } //4. If the book is overdue var query1 = (from bk in db.BOOK_LOANS where DateTime.Now > bk.DUE_DATE select bk.CARD_ID).ToList(); foreach (int value in query1) { if (value == borrower.CARD_ID) { return(View("BookOverDue")); } } //5. If Book is not Available var reqBook = (from b in db.BOOK_LOANS where b.DATE_IN == null select b.ISBN).ToList(); foreach (var value in reqBook) { if (value == Convert.ToInt64(Session["ISBN"])) { return(View("BookNotAvailable")); } } return(RedirectToAction("AddBookLoan")); }