public ActionResult DeleteConfirmed(int id)
{
BookReturnTable bookReturnTable = db.BookReturnTables.Find(id);
db.BookReturnTables.Remove(bookReturnTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult BookReturn(int?id)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"])))
{
return(RedirectToAction("Login", "Home"));
}
int userid = Convert.ToInt32(Convert.ToString(Session["UserID"]));
var book = db.IssueBookTables.Find(id);
int fine = 0;
var returndate = book.ReturnDate;
int noofdays = (DateTime.Now - returndate).Days;
if (book.Status == true && book.ReserveNoOfCopies == false)
{
if (noofdays > 0)
{
fine = 2 * noofdays;
}
var returnbook = new BookReturnTable()
{
BookID = book.BookID,
CurrentDate = DateTime.Now,
EmployeeID = book.EmployeeID,
IssueDate = book.IssueDate,
ReturnDate = book.ReturnDate,
UserID = userid
};
db.BookReturnTables.Add(returnbook);
db.SaveChanges();
}
book.Status = false;
book.ReserveNoOfCopies = false;
db.Entry(book).State = EntityState.Modified;
db.SaveChanges();
if (fine > 0)
{
var addfine = new BookFineTable()
{
BookID = book.BookID,
EmployeeID = book.EmployeeID,
FineAmount = fine,
FineDate = DateTime.Now,
NoOfDays = noofdays,
ReceiveAmount = 0,
UserID = userid
};
db.BookFineTables.Add(addfine);
db.SaveChanges();
}
return(RedirectToAction("IssueBooks"));
}
public ActionResult Edit([Bind(Include = "BookReturnID,BookID,EmployeeID,IssueDate,ReturnDate,CurrentDate,UserID")] BookReturnTable bookReturnTable)
{
if (ModelState.IsValid)
{
db.Entry(bookReturnTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BookID = new SelectList(db.BookTables, "BookID", "BookTitle", bookReturnTable.BookID);
ViewBag.EmployeeID = new SelectList(db.EmployeeTables, "EmployeeID", "FullName", bookReturnTable.EmployeeID);
ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", bookReturnTable.UserID);
return(View(bookReturnTable));
}
// GET: BookReturnTables/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BookReturnTable bookReturnTable = db.BookReturnTables.Find(id);
if (bookReturnTable == null)
{
return(HttpNotFound());
}
return(View(bookReturnTable));
}
public ActionResult Create([Bind(Include = "BookReturnID,BookID,EmployeeID,UserID,IssueDate,ReturenDate,CurentDate")] BookReturnTable bookReturnTable)
{
if (ModelState.IsValid)
{
db.BookReturnTables.Add(bookReturnTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BookID = new SelectList(db.BookTables, "BookID", "BookType", bookReturnTable.BookID);
ViewBag.EmployeeID = new SelectList(db.EmployeeTables, "EmployeeID", "FullName", bookReturnTable.EmployeeID);
ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", bookReturnTable.UserID);
return(View(bookReturnTable));
}
// GET: BookReturnTables/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BookReturnTable bookReturnTable = db.BookReturnTables.Find(id);
if (bookReturnTable == null)
{
return(HttpNotFound());
}
ViewBag.BookID = new SelectList(db.BookTables, "BookID", "BookTitle", bookReturnTable.BookID);
ViewBag.EmployeeID = new SelectList(db.EmployeeTables, "EmployeeID", "FullName", bookReturnTable.EmployeeID);
ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", bookReturnTable.UserID);
return(View(bookReturnTable));
}
