public List <Book> GetBooksList()
{
using (BookDbExpressEntities entities = new BookDbExpressEntities())
{
return(entities.Books.ToList());
}
}
public void AddBook(string name)
{
using (BookDbExpressEntities entities = new BookDbExpressEntities())
{
Book book = new Book {
BookName = name
};
entities.Books.Add(book);
entities.SaveChanges();
}
}
public Book GetBookById(string id)
{
try
{
int bookId = Convert.ToInt32(id);
using (BookDbExpressEntities entities = new BookDbExpressEntities())
{
return(entities.Books.SingleOrDefault(book => book.Id == bookId));
}
}
catch
{
throw new FaultException("Something went wrong");
}
}
public void DeleteBook(string id)
{
try
{
int bookId = Convert.ToInt32(id);
using (BookDbExpressEntities entities = new BookDbExpressEntities())
{
Book book = entities.Books.SingleOrDefault(b => b.Id == bookId);
entities.Books.Remove(book);
entities.SaveChanges();
}
}
catch
{
throw new FaultException("Something went wrong");
}
}