public IEnumerable <Book> getAll()
{
using (var ctx = new BokhyllanBDBContext())
{
return(ctx.Books.AsNoTracking().ToList());
}
}
public void DeleteBook(int id)
{
using (var ctx = new BokhyllanBDBContext())
{
var result = ctx.Books.Where(b => b.Id == id).FirstOrDefault();
ctx.Books.Remove(result);
ctx.SaveChanges();
}
}
public void CreateNewBook()
{
using (var ctx = new BokhyllanBDBContext())
{
var newBook = new Book {
Title = "New Title", Author = "New Author"
};
ctx.Books.Add(newBook);
ctx.SaveChanges();
}
}
public void UpdateBook(int id, string title, string author, string description)
{
using (var ctx = new BokhyllanBDBContext())
{
var result = ctx.Books.Where(b => b.Id == id).FirstOrDefault();
result.Title = title;
result.Author = author;
result.Description = description;
ctx.SaveChanges();
}
}
