// POST: BorrowsManage/End/5
public ActionResult End(int?BorrowId, string Status)
{
if (!isStaff())
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (ModelState.IsValid)
{
//check param
if (BorrowId == null || Status == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblBorrow tblBorrow = db.tblBorrows.Find(BorrowId);
if (tblBorrow == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//End borrow
tblBookDetail tblBookDetail = tblBorrow.tblBookDetail;
tblBookDetail.Status = Status;
tblBorrow.IsEnd = true;
db.Entry(tblBorrow).State = EntityState.Modified;
db.Entry(tblBookDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Create(string BookID, string SubID)
{
if (!isStaff())
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (ModelState.IsValid)
{
//check param
if (BookID == null || SubID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblBook tblBook = db.tblBooks.Find(BookID);
if (tblBook == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ViewBag.BookName = tblBook.Name;
//Check Instance ID already exist
string ID = BookID + SubID;
tblBookDetail tblBookDetail = db.tblBookDetails.Find(ID);
if (tblBookDetail != null)
{
ViewBag.CreateMessage = "This ID Instance already exist!";
return(View());
}
//Success Add ! Return to Add New
tblBookDetail = new tblBookDetail();
tblBookDetail.BookID = BookID;
tblBookDetail.SubID = ID;
tblBookDetail.Status = "Free"; //Default is Free
db.tblBookDetails.Add(tblBookDetail);
db.SaveChanges();
ViewBag.CreateMessage = "Successfully!";
return(View());
}
return(View());
}
// POST: BorrowsManage/Create
// Create new transaction for Borrowing
public ActionResult Create(string BookID, string SubID, string Email)
{
if (!isStaff())
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (ModelState.IsValid)
{
//check param
if (BookID == null || SubID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblBook tblBook = db.tblBooks.Find(BookID);
if (tblBook == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ViewBag.BookName = tblBook.Name;
//neu book khong available thi return va bao loi
if (!tblBook.Status.Equals("Available"))
{
ViewBag.BookID = BookID;
ViewBag.CreateMessage = "This Book is not available to borrow!";
return(View());
}
//neu Book Instance ID khong ton tai thi return ve View va bao loi
// Book InstanceID = BookID + SubID
string InstanceID = BookID + SubID;
tblBookDetail tblBookDetail = db.tblBookDetails.Find(InstanceID);
if (tblBookDetail == null)
{
ViewBag.BookID = BookID;
ViewBag.CreateMessage = "This Instance ID does not exist!";
return(View());
}
//BookInstance is Lost or Borrowed
if (tblBookDetail.Status != "Free")
{
ViewBag.BookID = BookID;
ViewBag.CreateMessage = "This Book Instance does not available!";
return(View());
}
//neu Email khong ton tai thi return View va bao loi
tblAccount tblAccount = db.tblAccounts.Find(Email);
if (tblAccount == null)
{
ViewBag.BookID = BookID;
ViewBag.CreateMessage = "This Email does not exist";
return(View());
}
//end validate
//Add
tblBookDetail.Status = "Borrowed";
db.Entry(tblBookDetail).State = EntityState.Modified;
tblBorrow tblBorrow = new tblBorrow();
tblBorrow.BorrowerEmail = Email;
tblBorrow.BookSubID = InstanceID;
tblBorrow.ExtendNumber = 3;
tblBorrow.CreateDate = DateTime.Now;
tblBorrow.ReturnDate = DateTime.Now.AddDays(10);
tblBorrow.IsEnd = false;
db.tblBorrows.Add(tblBorrow);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
