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()); }