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