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