public async Task <IActionResult> PutGameGenre([FromRoute] int id, [FromBody] GameGenre gameGenre)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != gameGenre.GameGenreId)
{
return(BadRequest());
}
_context.Entry(gameGenre).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!GameGenreExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> Edit(int id, [Bind("GameGenreId,Name")] GameGenre gameGenre)
{
if (id != gameGenre.GameGenreId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(gameGenre);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!GameGenreExists(gameGenre.GameGenreId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(gameGenre));
}
public ActionResult Create([Bind(Include = "GameId,GenreId")] GameGenre gameGenre)
{
if (ModelState.IsValid)
{
GameGenre tmpGameGenre = db.GameGenres.SingleOrDefault(y => y.GameId == gameGenre.GameId && y.GenreId == gameGenre.GenreId);
//Game game = db.Games.Find(id);
if (tmpGameGenre == null)
{
gameGenre.GameGenreId = Guid.NewGuid().ToString();
gameGenre.CreateDate = DateTime.Now;
gameGenre.EditDate = gameGenre.CreateDate;
db.GameGenres.Add(gameGenre);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Duplicate Entry Found");
}
}
ViewBag.GameId = new SelectList(db.Games, "GameId", "Name", gameGenre.GameId);
ViewBag.GenreId = new SelectList(db.Genres, "GenreId", "Name", gameGenre.GenreId);
return(View(gameGenre));
}
public ActionResult Create([Bind(Include = "GameId,GenreId")] GameGenre model)
{
if (ModelState.IsValid)
{
GameGenre tmpgamegenre = db.GameGenres
.SingleOrDefault(x => x.GameId == model.GameId && x.GenreId == model.GenreId);
if (tmpgamegenre == null)
{
model.GameGenreId = Guid.NewGuid().ToString();
model.CreateDate = DateTime.Now;
model.EditDate = model.CreateDate;
db.GameGenres.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Duplicate key found!");
}
}
ViewBag.GameId = new SelectList(db.Games, "GameId", "Name", model.GameId);
ViewBag.GenreId = new SelectList(db.Genres, "GenreId", "Name", model.GenreId);
return(View(model));
}
public IActionResult AddGame(AddGameGenreViewModel model)
{
if (ModelState.IsValid)
{
int gameId = model.GameId;
int genreId = model.GenreId;
List <GameGenre> existingItems = context.GameGenres
.Where(gg => gg.GameId == gameId)
.Where(gg => gg.GenreId == genreId)
.ToList();
if (existingItems.Count == 0)
{
GameGenre gameGenre = new GameGenre
{
GameId = gameId,
GenreId = genreId
};
context.GameGenres.Add(gameGenre);
context.SaveChanges();
}
return(Redirect("/Home/Detail/" + gameId));
}
return(View(model));
}
public IActionResult AddItem(AddGenreItemViewModel addGenreItemViewModel)
{
if (ModelState.IsValid)
{
var gameID = addGenreItemViewModel.GameID;
var genreID = addGenreItemViewModel.GenreID;
IList <GameGenre> existingItems = context.GameGenres
.Where(gg => gg.GameID == gameID)
.Where(gg => gg.GenreID == genreID).ToList();
if (existingItems.Count == 0)
{
GameGenre genreItem = new GameGenre
{
//these are the values in the View Model
Game = context.Games.Single(g => g.ID == gameID),
Genre = context.Genres.Single(g => g.ID == genreID)
};
context.GameGenres.Add(genreItem);
context.SaveChanges();
}
return(Redirect(string.Format("/Genre/ViewGenre/" + addGenreItemViewModel.GenreID)));
}
return(View(addGenreItemViewModel));
}
public void GenerateGameGenres()
{
Random rand = new Random();
List <Game> games = Context.Games.ToList();
List <Genre> genres = Context.Genres.ToList();
foreach (Game game in games)
{
for (int i = 0; i < rand.Next(1, 4); ++i)
{
if (i < genres.Count)
{
GameGenre gameGenre = new GameGenre
{
GameId = game.ID,
GenreId = genres[i].ID,
};
Context.GameGenres.Add(gameGenre);
}
}
}
Context.SaveChanges();
}
public IActionResult ProcessAddGameForm(AddGameViewModel addGameViewModel, string[] selectedGenres)
{
if (ModelState.IsValid)
{
Developer developer = context.Developers.Find(addGameViewModel.DeveloperId);
Game game = new Game
{
Name = addGameViewModel.Name,
Description = addGameViewModel.Description,
Cover = addGameViewModel.Cover,
ReleaseDate = addGameViewModel.ReleaseDate,
Developer = developer
};
foreach (string genre in selectedGenres)
{
GameGenre gameGenre = new GameGenre
{
Game = game,
GameId = game.Id,
GenreId = int.Parse(genre)
};
context.GameGenres.Add(gameGenre);
}
context.Games.Add(game);
context.SaveChanges();
return(Redirect("Index"));
}
return(View("AddGame", addGameViewModel));
}
// game response handler helper method w/ http request message as parameter
private async Task <IEnumerable <Game> > GameResponseHandler(HttpRequestMessage request)
{
// create a client using _clientFactory.
var client = _clientFactory.CreateClient("igdb");
// wait for response from the client.
var response = await client.SendAsync(request);
// reads the JSON response as a string.
var gamesAsJson = await response.Content.ReadAsStringAsync();
// deserializes gamesAsJson into a List<Game>.
var deserializedGames = JsonConvert.DeserializeObject <List <Game> >(gamesAsJson);
// create an empty list of games.
List <Game> games = new List <Game>();
foreach (var game in deserializedGames)
{
// declares a new Game. properties are set from API response.
Game newGame = new Game
{
GameId = game.GameId,
Name = game.Name,
Summary = game.Summary,
first_release_date = game.first_release_date,
GenreIds = game.GenreIds,
PlatformIds = game.PlatformIds,
CoverId = game.CoverId
};
// adds new game to the list of games.
games.Add(newGame);
/*** Games have a many to many relationship with Platforms and Genres. ***/
// if the newGame GenreId and PlatformId are not null
if (newGame.GenreIds != null && newGame.PlatformIds != null)
{
// for each genreId create a new GameGenre and set the values to the id of the Game and Genre.
foreach (var genreId in newGame.GenreIds)
{
GameGenre gameGenre = new GameGenre
{
GameId = newGame.GameId,
GenreId = genreId
};
}
// for each platformId create a new GameGenre and set the values to the id of the Game and Platform.
foreach (var platformId in newGame.PlatformIds)
{
GamePlatform gamePlatform = new GamePlatform
{
GameId = newGame.GameId,
PlatformId = platformId
};
}
}
}
// return the list of games.
return(games);
}
public GameGenre Build()
{
var result = _gameGenre;
_gameGenre = new GameGenre();
return(result);
}
public void Delete(GameGenre entity)
{
if (_db.Entry(entity).State == EntityState.Detached)
{
_db.Attach(entity);
}
_db.GameGenres.Remove(entity);
}
public void Update(GameGenre entity)
{
if (_db.Entry(entity).State == EntityState.Detached)
{
_db.GameGenres.Attach(entity);
}
_db.Entry(entity).State = EntityState.Modified;
}
public ActionResult DeleteConfirmed(string id)
{
GameGenre gameGenre = db.GameGenres.Find(id);
db.GameGenres.Remove(gameGenre);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void GameGenreTestConstructorTest()
{
var gameGenre = new GameGenre();
Assert.AreEqual(gameGenre.Id, 0);
Assert.AreEqual(gameGenre.GameId, 0);
Assert.AreEqual(gameGenre.GenreId, 0);
}
public void GameGenreGenerateDeleteStatementTest()
{
var gameGenre = new GameGenre(
1,
2,
3);
Assert.AreEqual(gameGenre.GenerateDeleteStatement(), "DELETE FROM GameGenre WHERE Id = 1");
}
public void GameGenreGenerateUpdateStatementTest()
{
var gameGenre = new GameGenre(
1,
2,
3);
Assert.AreEqual(gameGenre.GenerateUpdateStatement(), "UPDATE GameGenre SET GameId = 2, GenreId = 3 WHERE Id = 1");
}
public void GameGenreGenerateExistsQueryTest()
{
var gameGenre = new GameGenre(
1,
2,
3);
Assert.AreEqual(gameGenre.GenerateExistsQuery(), "SELECT Id FROM GameGenre WHERE Id = 1");
}
public Game(string title, string description, GameGenre genre, string logo, string exe)
{
ID = this.GetHashCode().ToString();
Title = title;
Description = description;
Genre = genre;
Logo = logo;
Exe = exe;
}
public Game(string id, string title, string description, GameGenre genre, string logo, string exe)
{
ID = id;
Title = title;
Description = description;
Genre = genre;
Logo = logo;
Exe = exe;
}
public void GameGenreGenerateInsertStatementTest()
{
var gameGenre = new GameGenre(
1,
2,
3);
Assert.AreEqual(gameGenre.GenerateInsertStatement(), "INSERT INTO GameGenre (GameId, GenreId) VALUES (2, 3)");
}
public object Remove(GameGenre gameGenre)
{
try {
_repo.Remove(gameGenre);
return(NoContent());
} catch (Exception error) {
throw error;
}
}
public void Delete(int gameId, int genreID)
{
using (var db = new GameMarketContext())
{
gameGenreUpdate = db.GameGenres.Where(c => c.GameId == gameId && c.GenreId == genreID).FirstOrDefault();
db.GameGenres.Remove(gameGenreUpdate);
db.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "GameId,Name,IsMultiplayer, GenreIds")] Game game, string[] GenreIds)
{
if (ModelState.IsValid)
{
Game tmpgame = db.Games.Find(game.GameId);
if (tmpgame != null)
{
Game checkgame = db.Games.SingleOrDefault(x => x.Name == game.Name && x.IsMultiplayer == game.IsMultiplayer && x.GameId != game.GameId);
if (checkgame == null)
{
tmpgame.Name = game.Name;
tmpgame.EditDate = DateTime.Now;
tmpgame.IsMultiplayer = game.IsMultiplayer;
db.Entry(tmpgame).State = EntityState.Modified;
//items to remove
var removeItems = tmpgame.Genres.Where(x => !GenreIds.Contains(x.GenreId)).ToList();
foreach (var removeItem in removeItems)
{
db.Entry(removeItem).State = EntityState.Deleted;
}
//items to add
if (GenreIds != null)
{
var addItems = GenreIds.Where(x => !tmpgame.Genres.Select(y => y.GenreId).Contains(x));
foreach (var addItem in addItems)
{
GameGenre gameGenre = new GameGenre();
gameGenre.GameGenreId = Guid.NewGuid().ToString();
gameGenre.CreateDate = DateTime.Now;
gameGenre.EditDate = gameGenre.CreateDate;
gameGenre.GameId = tmpgame.GameId;
gameGenre.GenreId = addItem;
db.GameGenres.Add(gameGenre);
//db.Entry(addItem).State = EntityState.Added;
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Duplicate Game detected.");
}
}
}
//ViewBag.GenreId = new SelectList(db.Genres, "GenreId", "Name", game.GenreId);
ViewBag.Genres = new MultiSelectList(db.Genres.ToList(), "GenreId", "Name", GenreIds);
return(View(game));
}
public async Task <IActionResult> Create([Bind("GameGenreId,Name")] GameGenre gameGenre)
{
if (ModelState.IsValid)
{
_context.Add(gameGenre);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(gameGenre));
}
public async Task <long> AddGenre(string name)
{
var genreEntity = new GameGenre()
{
Name = name
};
var result = await _context.AddAsync <GameGenre>(genreEntity);
await _context.SaveChangesAsync();
return(result.Entity.GameGenreId);
}
public async Task <IActionResult> PostGameGenre([FromBody] GameGenre gameGenre)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.GameGenre.Add(gameGenre);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetGameGenre", new { id = gameGenre.GameGenreId }, gameGenre));
}
public ActionResult Edit([Bind(Include = "GameGenreId,CreateDate,EditDate,GameId,GenreId")] GameGenre gameGenre)
{
if (ModelState.IsValid)
{
db.Entry(gameGenre).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GameId = new SelectList(db.Games, "GameId", "Name", gameGenre.GameId);
ViewBag.GenreId = new SelectList(db.Genres, "GenreId", "Name", gameGenre.GenreId);
return(View(gameGenre));
}
public async Task <GameGenreResponse> SaveAsync(GameGenre gameGenre)
{
try{
await gameGenreRepository.AddAsync(gameGenre);
await unitOfWork.CompleteAsync();
return(new GameGenreResponse(gameGenre));
}
catch (Exception ex) {
return(new GameGenreResponse($"Error while saving game' genre. Message:{ex.Message}"));
}
}
public void Create(int gameID, int genreID)
{
GameGenre newGameGenre = new GameGenre()
{
GameId = gameID, GenreId = genreID
};
using (var db = new GameMarketContext())
{
db.GameGenres.Add(newGameGenre);
db.SaveChanges();
}
}
public IActionResult List(GameGenre genre)
{
IEnumerable <GameListItemViewModel> latest = gameAppService.GetLatest(CurrentUserId, 200, Guid.Empty, null, genre);
ViewBag.Games = latest;
ViewData["Genre"] = genre;
Dictionary <GameGenre, UiInfoAttribute> genreDict = Enum.GetValues(typeof(GameGenre)).Cast <GameGenre>().ToUiInfoDictionary();
ViewData["Genres"] = genreDict;
return(View());
}
public void GameGenreGeneratePrimaryKeyWhereClauseTest()
{
var gameGenre = new GameGenre();
Assert.AreEqual(gameGenre.GeneratePrimaryKeyWhereClause(), "");
gameGenre = new GameGenre(
1,
2,
3);
Assert.AreEqual(gameGenre.GeneratePrimaryKeyWhereClause(), "Id = 1");
}
public void GameGenreGenerateSelectQueryTest()
{
var gameGenre = new GameGenre();
Assert.AreEqual(gameGenre.GenerateSelectQuery(), "SELECT Id, GameId, GenreId FROM GameGenre");
gameGenre = new GameGenre(
1,
2,
3);
Assert.AreEqual(gameGenre.GenerateSelectQuery(), "SELECT Id, GameId, GenreId FROM GameGenre WHERE Id = 1");
}
