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 List <Book> List()
{
var context = new HBSISContext();
var books = context.Book.OrderBy(f => f.Name).ToList();
books.ForEach(f =>
{
f.Author = context.Author.FirstOrDefault(x => x.AuthorId == f.AuthorId);
});
return(books);
}
public Author GetByName(string name)
{
var context = new HBSISContext();
return(context.Author.AsNoTracking().FirstOrDefault(f => f.Name == name));
}
private int GetMaxId()
{
var context = new HBSISContext();
return(context.Author.Max(f => f.AuthorId));
}
public List <Author> List()
{
var context = new HBSISContext();
return(context.Author.AsNoTracking().OrderBy(f => f.Name).ToList());
}
public UnitOfWork(HBSISContext context)
{
_context = context;
_disposed = false;
}
public Repository(HBSISContext context)
{
Db = context;
DbSet = Db.Set <TEntity>();
}
public ClienteRepository(HBSISContext context)
: base(context)
{
}
public List <Book> GetByName(string name)
{
var context = new HBSISContext();
return(context.Book.AsNoTracking().Where(f => f.Name.Contains(name)).OrderBy(f => f.Name).ToList());
}
