public void Add(Author author)
{
var context = new HBSISContext();
author.AuthorId = GetMaxId() + 1;
context.Author.Add(author);
context.SaveChanges();
}
public void Add(Book book)
{
var context = new HBSISContext();
book.BookId = GetMaxId() + 1;
context.Book.Add(book);
context.SaveChanges();
}
public void Edit(Book book)
{
var context = new HBSISContext();
var oldBook = context.Book.FirstOrDefault(f => f.BookId == book.BookId);
oldBook.Name = book.Name;
oldBook.Price = book.Price;
oldBook.Quantity = book.Quantity;
context.SaveChanges();
}
public void Remove(int id)
{
var context = new HBSISContext();
var bookId = new Book {
BookId = id
};
context.Book.Attach(bookId);
context.Entry(bookId).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
public void Commit()
{
_context.SaveChanges();
}
public int SaveChanges()
{
// Tratamento
return(Db.SaveChanges());
}
