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 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 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);
}
public Rating[] GetAll()
{
using var context = new ConsultantContext();
return(context.Ratings.ToArray());
}
public Book[] GetAll()
{
using var context = new ConsultantContext();
return(context.Books.ToArray());
}
public Genre[] GetAll()
{
using var context = new ConsultantContext();
return(context.Genres.ToArray());
}
