public BookModel GetBookDetails(long BookID)
{
eSankalpMVCDemoEntities db = new eSankalpMVCDemoEntities();
BookModel bookModel = new BookModel();
var bookDet = db.tbl_Book.Where(p => p.BookID == BookID).FirstOrDefault();
if (bookDet != null)
{
bookModel.BookName = bookDet.BookName;
bookModel.ISBN = bookDet.ISBN;
bookModel.Author = bookDet.Author;
bookModel.BookID = bookDet.BookID;
}
return(bookModel);
}
public string SaveBook(BookModel model)
{
string msg = "";
eSankalpMVCDemoEntities db = new eSankalpMVCDemoEntities();
var saveBook = new tbl_Book()
{
BookName = model.BookName,
ISBN = model.ISBN,
Author = model.Author,
};
db.tbl_Book.Add(saveBook);
db.SaveChanges();
msg = "Book saved successfullly";
return(msg);
}
public List <BookModel> GetBookList()
{
eSankalpMVCDemoEntities db = new eSankalpMVCDemoEntities();
List <BookModel> lstBook = new List <BookModel>();
var bookList = db.tbl_Book.ToList();
foreach (var book in bookList)
{
lstBook.Add(new BookModel
{
BookID = book.BookID,
BookName = book.BookName,
ISBN = book.ISBN,
Author = book.Author,
});
}
return(lstBook);
}
