//To Add new book record
public int AddBook(TblBook book)
{
long maxId = book.BookId;
try
{
if (db.TblBook.Find(book.BookId) != null)
{
List <TblBook> bookList = db.TblBook.ToList();
foreach (TblBook aBook in bookList)
{
maxId = (maxId >= aBook.BookId) ? maxId : aBook.BookId;
}
maxId += 1;
}
book.BookId = maxId;
db.TblBook.Add(book);
db.SaveChanges();
return(1);
}
catch
{
throw;
}
}
//Get the details of a particular book
public TblBook GetBookData(long id)
{
try
{
TblBook book = db.TblBook.Find(id);
return(book);
}
catch
{
throw;
}
}
//To Delete the record of a particular book
public int DeleteBook(long id)
{
try
{
TblBook book = db.TblBook.Find(id);
db.TblBook.Remove(book);
db.SaveChanges();
return(1);
}
catch
{
throw;
}
}
//To Update the records of a particluar book
public int UpdateBook(TblBook book)
{
try
{
db.Entry(book).State = EntityState.Modified;
db.SaveChanges();
return(1);
}
catch
{
throw;
}
}
