public Book?TrySave(Book book) { using var context = new ConsultantContext(); if (context.Books.Any(x => x.IsbnNumber == book.IsbnNumber)) { return(null); } context.Books.Add(book); context.SaveChanges(); return(book); }
public Rating?TrySave(Rating rating) { using var context = new ConsultantContext(); if (context.Ratings.Any(x => x.BookIsbnNumber == rating.BookIsbnNumber)) { return(null); } context.Ratings.Add(rating); context.SaveChanges(); return(rating); }
public Genre?TrySave(Genre genre) { genre.Name = genre.Name.ToLowerInvariant(); using var context = new ConsultantContext(); if (context.Genres.Any(x => x.Name == genre.Name)) { return(null); } context.Genres.Add(genre); context.SaveChanges(); return(genre); }
public Tag?TrySave(Tag tag) { tag.Name = tag.Name.ToLowerInvariant(); using var context = new ConsultantContext(); if (context.Tags.Any(x => x.Name == tag.Name)) { return(null); } context.Tags.Add(tag); context.SaveChanges(); return(tag); }
public Rating?TryRemove(string bookId) { using var context = new ConsultantContext(); var removingRating = context.Ratings.SingleOrDefault(x => x.BookIsbnNumber == bookId); if (removingRating == null) { return(null); } context.Ratings.Remove(removingRating); context.SaveChanges(); return(removingRating); }
public Rating?TryUpdate(Rating rating) { using var context = new ConsultantContext(); var dbRating = context.Ratings.SingleOrDefault(x => x.BookIsbnNumber == rating.BookIsbnNumber); if (dbRating == null) { return(null); } dbRating.Value = rating.Value; context.SaveChanges(); return(dbRating); }
public Book?TryRemove(string isbnNumber) { using var context = new ConsultantContext(); var removingBook = context.Books.SingleOrDefault(x => x.IsbnNumber == isbnNumber); if (removingBook == null) { return(null); } context.Books.Remove(removingBook); context.SaveChanges(); return(removingBook); }
public Genre?TryRemove(string name) { name = name.ToLowerInvariant(); using var context = new ConsultantContext(); var removingGenre = context.Genres.SingleOrDefault(x => x.Name == name); if (removingGenre == null) { return(null); } context.Genres.Remove(removingGenre); context.SaveChanges(); return(removingGenre); }
public Genre?TryUpdate(Genre genre) { genre.Name = genre.Name.ToLowerInvariant(); using var context = new ConsultantContext(); var dbGenre = context.Genres.SingleOrDefault(x => x.Name == genre.Name); if (dbGenre == null) { return(null); } dbGenre.BooksIsbnNumbers = genre.BooksIsbnNumbers; context.SaveChanges(); return(dbGenre); }
public Tag?TryUpdate(Tag tag) { tag.Name = tag.Name.ToLowerInvariant(); using var context = new ConsultantContext(); var dbTag = context.Tags.SingleOrDefault(x => x.Name == tag.Name); if (dbTag == null) { return(null); } dbTag.BooksIsbnNumbers = tag.BooksIsbnNumbers; context.SaveChanges(); return(dbTag); }
public Book?TryUpdate(Book book) { using var context = new ConsultantContext(); var dbBook = context.Books.SingleOrDefault(x => x.IsbnNumber == book.IsbnNumber); if (dbBook == null) { return(null); } dbBook.Name = book.Name; dbBook.WrittenYear = book.WrittenYear; dbBook.Authors = book.Authors; context.SaveChanges(); return(dbBook); }