public List <VideoGame> getAll()
{
using (var db = new VideoGameContext())
{
return(db.VideoGames.ToList());
}
}
private static void FillAllTables()
{
using (var context = new VideoGameContext())
{
context.Games.Add(firstGame);
context.Games.Add(secondGame);
context.Games.Add(thirdGame);
context.Games.Add(fourthGame);
context.Games.Add(fifthGame);
context.Games.Add(sixthGame);
context.Games.Add(seventhGame);
context.Users.Add(firstUser);
context.Users.Add(secondUser);
context.Ratings.Add(firstRating);
context.Ratings.Add(secondRating);
context.Ratings.Add(thirdRating);
context.Ratings.Add(fourthRating);
context.Ratings.Add(fifthRating);
context.Ratings.Add(sixthRating);
context.Ratings.Add(seventhRating);
context.SaveChanges();
}
}
/// <exception cref="DbUpdateException"> An error is encountered while saving to the database. </exception>
/// <exception cref="DbUpdateConcurrencyException">
/// A concurrency violation is encountered while saving to the database.
/// A concurrency violation occurs when an unexpected number of rows are affected during save.
/// This is usually because the data in the database has been modified since it was loaded into memory.
/// </exception>
public static async void InjectAsync(VideoGameContext context)
{
await InitializePlatforms(context);
await InitalizeGames(context);
await InitailizeGamePlatforms(context);
await context.SaveChangesAsync();
}
public bool updateVideoGame(VideoGame videoGame)
{
using (var db = new VideoGameContext())
{
var videoGameTarget = db.VideoGames.Where(vg => vg.VideoGameId == videoGame.VideoGameId).FirstOrDefault();
try
{
db.Entry(videoGameTarget).CurrentValues.SetValues(videoGame);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public PublisherController(VideoGameContext context)
{
_context = context;
}
public GameRepository(VideoGameContext videoGameContext,
IFileManager fileManager)
{
_videoGameContext = videoGameContext;
_fileManager = fileManager;
}
public static void ShowAllGames()
{
using (var context = new VideoGameContext())
{
var allGames = context.Games.ToList();
var allRatings = context.Ratings.ToList();
if (allGames.Count % QUANTITY_IN_PAGE == 0)
{
int j = 1;
for (int i = 0; i < allGames.Count / QUANTITY_IN_PAGE; i++)
{
var gamesTemp = allGames.OrderBy(i => i.Name).Skip(i * QUANTITY_IN_PAGE).Take(QUANTITY_IN_PAGE).ToList();
Console.WriteLine($"\t- page {i + 1} -\n");
foreach (var game in gamesTemp)
{
var rating = allRatings.Where(g => g.Game.Equals(game)).ToList();
Console.WriteLine($"Название: {game.Name}");
if (rating.Count > 0)
{
Console.WriteLine($"Рейтинг: {rating.Sum(r => r.Grade) / rating.Count}/5");
}
else
{
Console.WriteLine($"Рейтинг: -/5");
}
Console.WriteLine($"Разработчик: {game.Developer}");
Console.WriteLine($"Описание: {game.Description}");
Console.WriteLine("\n");
j++;
}
Console.WriteLine();
}
}
else
{
int j = 1;
for (int i = 0; i < allGames.Count / QUANTITY_IN_PAGE + 1; i++)
{
var gamesTemp = allGames.OrderBy(i => i.Name).Skip(i * QUANTITY_IN_PAGE).Take(QUANTITY_IN_PAGE).ToList();
Console.WriteLine($"\t- page {i + 1} -\n");
foreach (var game in gamesTemp)
{
var rating = allRatings.Where(g => g.Game.Equals(game)).ToList();
Console.WriteLine($"Название: {game.Name}");
if (rating.Count > 0)
{
Console.WriteLine($"Рейтинг: {rating.Sum(r => r.Grade) / rating.Count}/5");
}
else
{
Console.WriteLine($"Рейтинг: -/5");
}
Console.WriteLine($"Разработчик: {game.Developer}");
Console.WriteLine($"Описание: {game.Description}");
Console.WriteLine("\n");
j++;
}
Console.WriteLine();
}
}
}
}
public VideoGameListingsController(VideoGameContext context)
{
_context = context;
}
public GenreController(VideoGameContext context)
{
_context = context;
}
/// <exception cref="AggregateException">At least one of the <see cref="T:System.Threading.Tasks.Task"></see> instances was canceled. If a task was canceled, the <see cref="T:System.AggregateException"></see> exception contains an <see cref="T:System.OperationCanceledException"></see> exception in its <see cref="P:System.AggregateException.InnerExceptions"></see> collection. -or- An exception was thrown during the execution of at least one of the <see cref="T:System.Threading.Tasks.Task"></see> instances.</exception>
/// <exception cref="DbUpdateException">An error is encountered while saving to the database. </exception>
/// <exception cref="DbUpdateConcurrencyException">
/// A concurrency violation is encountered while saving to the database.
/// A concurrency violation occurs when an unexpected number of rows are affected during save.
/// This is usually because the data in the database has been modified since it was loaded into memory.
/// </exception>
/// <exception cref="ObjectDisposedException">One or more of the <see cref="T:System.Threading.Tasks.Task"></see> objects in <paramref name="tasks">tasks</paramref> has been disposed.</exception>
/// <exception cref="ArgumentNullException">The <paramref name="tasks">tasks</paramref> argument is null.</exception>
/// <exception cref="ArgumentException">The <paramref name="tasks">tasks</paramref> argument contains a null element. -or- The <paramref name="tasks">tasks</paramref> argument is an empty array.</exception>
public static void Inject(VideoGameContext context)
{
Task.WaitAll(InitializePlatforms(context), InitalizeGames(context), InitailizeGamePlatforms(context));
context.SaveChanges();
}
public ConstructorTests()
{
dbContextOptions = new DbContextOptions <VideoGameContext>();
context = new VideoGameContext(dbContextOptions);
}
public ConsoleController(VideoGameContext context)
{
_context = context;
}
