public List<Book> GetBooksWithAuthorId(int id) { List<Book> result; using (var context = new LibraryEntities()) { result = context.Books.Where(x => x.Author.Id == id).ToList(); } return result; }
public List<Book> GetAllBooks() { List<Book> result; using (var context = new LibraryEntities()) { result = context.Books.Include("Author").Include("Category").ToList(); } return result; }
public Book GetBookById(int id) { Book result; using (var context = new LibraryEntities()) { result = context.Books.Include("Author").Include("Category").FirstOrDefault(x => x.Id == id); } return result; }
public Author GetAuthorById(int id) { Author result; using (var context = new LibraryEntities()) { result = context.Authors.FirstOrDefault(x => x.Id == id); } return result; }
public List<Author> GetAllAuthors() { List<Author> result; using (var context = new LibraryEntities()) { result = context.Authors.ToList(); } return result; }
public List<Category> GetAllCategories() { List<Category> result; using (var context = new LibraryEntities()) { result = context.Categorys.ToList(); } return result; }
public int AddBook(Book book) { int addedBookId; using (var context = new LibraryEntities()) { context.Books.Add(book); context.SaveChanges(); addedBookId = book.Id; } return addedBookId; }
public int AddAuthor(Author author) { int addedAuthorId; using (var context = new LibraryEntities()) { context.Authors.Add(author); context.SaveChanges(); addedAuthorId = author.Id; } return addedAuthorId; }
public int AddCategory(Category cat) { int addedAuthorId; using (var context = new LibraryEntities()) { context.Categorys.Add(cat); context.SaveChanges(); addedAuthorId = cat.Id; } return addedAuthorId; }
public bool DeleteBookById(int id) { bool result = false; using (var context = new LibraryEntities()) { var bookToDelte = context.Books.FirstOrDefault(x => x.Id == id); if (bookToDelte != null) { context.Books.Remove(bookToDelte); context.SaveChanges(); result = true; } } return result; }
public void UpdateBookAuthor(int bookId, int authorId) { using (var context = new LibraryEntities()) { context.Books.FirstOrDefault(x => x.Id == bookId).AuthorId = authorId; context.SaveChanges(); } }
public void UpdateBookTitle(int bookId, string title) { using (var context = new LibraryEntities()) { context.Books.FirstOrDefault(x => x.Id == bookId).Title = title; context.SaveChanges(); } }
public void UpdateBookPrice(int bookId, int price) { using (var context = new LibraryEntities()) { context.Books.FirstOrDefault(x => x.Id == bookId).Price = price; context.SaveChanges(); } }
public void UpdateBookDescr(int bookId, string descr) { using (var context = new LibraryEntities()) { context.Books.FirstOrDefault(x => x.Id == bookId).Descriptn = descr; context.SaveChanges(); } }