protected void btnCheckOut_Click(object sender, EventArgs e) { libraryEntities db = new libraryEntities(); lockbook objLockBook; int bookid = Convert.ToInt32(this.hfbookid.Value); objLockBook = db.lockbooks.Where <lockbook>(x => x.bookid == bookid).FirstOrDefault(); if (objLockBook == null) { objLockBook = new lockbook(); objLockBook.bookid = bookid; objLockBook.username = User.Identity.Name; db.lockbooks.AddObject(objLockBook); db.SaveChanges(); } else { lblMessage.Text = "Book not available"; return; } book objBook = db.books.Where <book>(x => x.id == bookid).FirstOrDefault(); if (objBook.status == "checkout") { lblMessage.Text = "Book not available"; } else { borrowhistory bh = new borrowhistory(); bh.bookid = bookid; bh.borrower = this.txtBorrower.Text; bh.checkin_date = Rules.AddBusinessDays(DateTime.Now, 14); bh.checkout_date = DateTime.Now; bh.nationalid = this.txtNationalID.Text; bh.mobile = this.txtMobile.Text; db.borrowhistories.AddObject(bh); objBook.status = "checkout"; lblMessage.Text = "CheckOut Successfull"; db.SaveChanges(); } db.lockbooks.DeleteObject(objLockBook); db.SaveChanges(); }
protected void btnCheckIn_Click(object sender, EventArgs e) { libraryEntities db = new libraryEntities(); int bookid = Convert.ToInt32(this.hfbookid.Value); book objBook = db.books.Where <book>(x => x.id == bookid).FirstOrDefault(); if (objBook.status == "checkout") { objBook.status = "checkin"; borrowhistory bh = new borrowhistory(); bh = db.borrowhistories.OrderByDescending(u => u.id).FirstOrDefault(); // get the last borrower from history. bh.checkin_date_return = DateTime.Now; db.SaveChanges(); lblMessage.Text = "CheckIn Successfull"; } else { lblMessage.Text = "Book CheckIn Failed"; } }