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