protected void btnDeleteBooks_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = db.tblBooks.ToList().Where(x => x.code == int.Parse(txtCode.Text)).First();
db.DeleteObject(tbl);
db.SaveChanges();
populateBooks();
}
protected void btnUpdateBooks_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = db.tblBooks.ToList().Where(x => x.code == int.Parse(txtCode.Text)).First();
tbl.title = txtTitle.Text;
tbl.author = txtAuthor.Text;
tbl.publication = txtPublication.Text;
tbl.subject = txtSubject.Text;
tbl.no_of_copies = int.Parse(txtBooksQnty.Text);
db.SaveChanges();
populateBooks();
}
protected void btnInsertBooks_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = new tblBook();
tbl.title = txtTitle.Text;
tbl.author = txtAuthor.Text;
tbl.publication = txtPublication.Text;
tbl.subject = txtSubject.Text;
tbl.no_of_copies = int.Parse(txtBooksQnty.Text);
db.AddTotblBooks(tbl);
db.SaveChanges();
populateBooks();
}