public void Nameinsert(string adminName, int adminAge)
{
Nametb.Name = adminName;
Nametb.Age = adminAge;
bookdatabase.NameTables.Add(Nametb);
bookdatabase.SaveChanges();
}
public void CustReturn(int Custid)
{
using (BookLibraryEntities1 Return = new BookLibraryEntities1())
{
Cust obj_table = Return.Custs.First(x => x.CustID == Custid);
Return.Custs.Remove(obj_table);
Return.SaveChanges();
}
}
public void BookRemove(int BookID)
{
using (BookLibraryEntities1 BookRemove = new BookLibraryEntities1())
{
BookTable obj_table = BookRemove.BookTables.First(x => x.BookNo == BookID);
BookRemove.BookTables.Remove(obj_table);
BookRemove.SaveChanges();
}
}
public void BookUpdate(int BookID, string BookName, string BookAuthor, int Copies)
{
using (var BooktableObj = new BookLibraryEntities1())
{
var UPbook = BooktableObj.BookTables.SingleOrDefault(b => b.BookNo == BookID);
if (UPbook != null)
{
UPbook.BookName = BookName;
UPbook.BookAuthor = BookAuthor;
UPbook.Copies = Copies;
BooktableObj.SaveChanges();
}
}
}
