public IActionResult TestGameList()
{
using (var db = new WgsipContext())
{
try
{
var a = db.PlayedGames.Include(g => g.User).Include(g => g.Game).Where(g => g.User.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower())).ToList();
List <PlayedGameDTO> games = new List <PlayedGameDTO>();
foreach (var g in a)
{
games.Add(new PlayedGameDTO(g));
}
return(Json(new
{
test = games
}));
}
catch (Exception e)
{
return(Json(new
{
test = e.Message
}));
}
}
}
public IActionResult HasPlayed(String[][] gameList)
{
try
{
using (var db = new WgsipContext())
{
foreach (var gameA in gameList)
{
var game = gameA[0].Split(',');
Int16 rate = 3;
var query = db.PlayedGames.Include(pg => pg.User).Include(pg => pg.Game)
.First(pg =>
pg.Game.GameName.ToLower().Equals(game[0].ToLower()) &&
pg.User.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower())
);
query.PlayedGame = game[1] == "true" ? true : false;
// when a game is marked as played, set the rating to 3 as a default
if (query.Rating == null)
{
query.Rating = rate;
}
}
db.SaveChanges();
}
return(Json(new { message = "success" }));
}
catch (Exception e)
{
return(Json(new { message = e.Message }));
}
}
public IActionResult TestAllGames()
{
using (var db = new WgsipContext())
{
try
{
var a = db.Games.Include(g => g.Publisher).Include(g => g.Genre).OrderBy(g => g.GameName).ToList();
List <GameDTO> games = new List <GameDTO>();
foreach (var g in a)
{
games.Add(new GameDTO(g));
}
return(Json(new
{
test = games
}));
}
catch (Exception e)
{
return(Json(new
{
test = e.Message
}));
}
}
}
public async Task <IActionResult> DeleteAccountAsync()
{
if (!User.Identity.IsAuthenticated)
{
return(Json(new { message = "You need to be logged in to delete your account" }));
}
try
{
using (WgsipContext db = new WgsipContext())
{
Account user = db.Accounts.First(a => a.AccountEmail == User.Identity.Name);
db.Accounts.Remove(user);
db.Users.Remove(db.Users.Where(u => u.Email == user.AccountEmail).First());
await _signInManager.SignOutAsync();
db.SaveChanges();
}
return(Json(new { message = "Account Deleted", success = true }));
}
catch (Exception e)
{
return(Json(new { message = e.Message }));
}
}
public IActionResult AddGame(String gameName, String publisher, String genre, String rating, String platforms, string year)
{
try
{
DateTime Date = new DateTime(int.Parse(year), 1, 1);
using (WgsipContext db = new WgsipContext())
{
Game newGame = new Game();
Genre newGenre = db.Genres.First(g => g.GenreName.ToLower().Equals(genre.ToLower()));
newGame.EsrbRating = rating;
Publisher newPublisher;
try
{
newPublisher = db.Publishers.First(p => p.PublisherName.ToLower().Equals(publisher.ToLower()));
}
catch (Exception)
{
newPublisher = new Publisher();
newPublisher.PublisherName = publisher;
db.Publishers.Add(newPublisher);
}
newGame.Genre = newGenre;
newGame.Publisher = newPublisher;
newGame.GameName = gameName;
newGame.Platforms = platforms;
newGame.DatePublished = Date;
db.Games.Add(newGame);
PlayedGames playedGame = new PlayedGames();
playedGame.Game = newGame;
playedGame.PlayedGame = false;
playedGame.User = db.Accounts.First(a => a.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower()));
db.PlayedGames.Add(playedGame);
db.SaveChanges();
}
return(Json(new { message = "successfully added game to the Games database" }));
}
catch (Exception e)
{
return(Json(new { message = e.Message }));
}
}
public IActionResult AddGameToPlayed(String gameName)
{
try
{
using (WgsipContext db = new WgsipContext())
{
Game newGame = db.Games.Include(g => g.Publisher).Include(g => g.Genre).First(g => g.GameName.ToLower().Equals(gameName.ToLower()));
PlayedGames playedGame = new PlayedGames();
playedGame.Game = newGame;
playedGame.PlayedGame = false;
playedGame.User = db.Accounts.First(a => a.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower()));
db.PlayedGames.Add(playedGame);
db.SaveChanges();
}
return(Json(new { message = "successfully added game to played games list" }));
}
catch (Exception e)
{
return(Json(new { message = e.Message }));
}
}
public async Task <IActionResult> CreateAccount(String username, String password)
{
List <string> s = new List <string>();
if (username == null)
{
s.Add("You must enter an email");
}
if (password == null)
{
s.Add("Password cannot be empty");
}
if (password == null || username == null)
{
return(Json(new { a = s }));
}
IdentityUser user = new IdentityUser {
UserName = username, Email = username,
};
IdentityResult result = await _userManager.CreateAsync(user, password);
if (result.Succeeded)
{
await _signInManager.SignInAsync(user, isPersistent : false);
ViewBag.loggedIn = User.Identity.IsAuthenticated;
ViewBag.accountName = User.Identity.Name;
using (var db = new WgsipContext())
{
Account account = new Account();
account.AccountEmail = username;
db.Accounts.Add(account);
db.SaveChanges();
}
return(Json(new { a = true }));
}
return(Json(new { a = result.Errors.ToArray() }));
}
public IActionResult SearchGames(string searchTerm)
{
List <GameDTO> games = new List <GameDTO>();
//Not the best use of reflection, but reduces amount of typing required.
Func <Game, bool> Predicate = delegate(Game a)
{
//loops through all the properties, and sees if the search term is included.
foreach (var item in a.GetType().GetProperties())
{
if (item.Name.Contains("Id"))
{
continue; //skip over Id columns
}
if (item.GetValue(a).ToString().ToLower().Contains(searchTerm.ToLower()))
{
return(true);
}
}
return(false);
};
try
{
using (WgsipContext db = new WgsipContext())
{
List <Game> resultingGames = db.Games.Include(g => g.Genre).Include(g => g.Publisher).Where(Predicate).ToList();
foreach (Game g in resultingGames)
{
games.Add(new GameDTO(g));
}
return(Json(new { gamesList = games, success = true }));
}
}
catch (Exception e)
{
return(Json(new { message = e.Message }));
}
}
public IActionResult SoundsGood(String game)
{
if (!User.Identity.IsAuthenticated)
{
return(Json(new { message = "You need to be logged in to add a game to your game list." }));
}
try
{
using (WgsipContext db = new WgsipContext())
{
Account user = db.Accounts.First(a => a.AccountEmail == User.Identity.Name);
Game gameEntry = db.Games.First(g => g.GameName.ToLower().Equals(game.ToLower()));
PlayedGames playedGame = new PlayedGames();
playedGame.User = user;
playedGame.Game = gameEntry;
playedGame.PlayedGame = false;
if (!db.PlayedGames.Include(pg => pg.Game)
.Include(pg => pg.User)
.Any(pg => pg.Game == gameEntry &&
pg.User == user))
{
db.PlayedGames.Add(playedGame);
db.SaveChanges();
return(Json(new { message = "Game added to your games list! 😆" }));
}
else
{
return(Json(new { message = "The game is already in your games list." }));
}
}
}
catch (Exception e)
{
return(Json(new { message = e.Message }));
}
}
public IActionResult Test(String genre = null, String rating = null, String platform = null)
{
string a = "";
genre = genre ?? "";
rating = rating ?? "";
platform = platform ?? "";
//if the filters have changed, we need to make a new list
if (!genre.Equals(HttpContext.Session.GetString(genre_key)) ||
!rating.Equals(HttpContext.Session.GetString(rating_key)) ||
!platform.Equals(HttpContext.Session.GetString(platform_key)))
{
HttpContext.Session.Remove(list_key);
}
//attempt retrieve the list from session storage.
string list = HttpContext.Session.GetString(list_key);
using (var db = new WgsipContext())
{
var gameList = db.Games.Include(g => g.Genre).Include(g => g.Publisher).ToList();
//see if the user is logged in.
if (User.Identity.IsAuthenticated)
{
List <PlayedGames> userGames = db.PlayedGames.Include(g => g.User).Include(g => g.Game)
.Where(g => g.User.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower()))
.ToList();
//if the user hasn't rated any games yet or they are neutral toward all of them, return a random game.
if (!userGames.Any(g => g.Rating != 3 && g.Rating != null))
{
Random rng = new Random();
gameList = gameList.FindAll(
g => g.Genre.GenreName.ToLower().Contains(genre.ToLower()) &&
g.EsrbRating.ToLower().Contains(rating.ToLower()) &&
g.Platforms.ToLower().Contains(platform.ToLower()) &&
!userGames.Any(pg => pg.Game.GameId == g.GameId));
if (!gameList.Any())
{
return(Json(new
{
test = "No matching games found. 😢"
}));
}
return(Json(new
{
test = gameList[rng.Next(0, gameList.Count)].GameName
}));
}
//See if we already have a list generated that we can pull from, or if we have to make a new one.
if (list == null)
{
gameList = gameList.FindAll(
g => g.Genre.GenreName.ToLower().Contains(genre.ToLower()) &&
g.EsrbRating.ToLower().Contains(rating.ToLower()) &&
g.Platforms.ToLower().Contains(platform.ToLower()) &&
!userGames.Any(pg => pg.Game.GameId == g.GameId));
Stack <GameDTO> gamesStack = new Stack <GameDTO>();
foreach (Game g in gameList)
{
gamesStack.Push(new GameDTO(g, db, User));
}
if (!gamesStack.Any())
{
return(Json(new
{
test = "No matching games found. 😢"
}));
}
//we use a stack for the pop method here.
gamesStack = new Stack <GameDTO>(gamesStack.OrderBy(g => g.Score));
a = gamesStack.Pop().GameName;
//Make sure there are still games left in the list before putting it into session storage.
if (gamesStack.Any())
{
HttpContext.Session.SetString(list_key, JsonConvert.SerializeObject(gamesStack.Reverse()));
HttpContext.Session.SetString(genre_key, genre);
HttpContext.Session.SetString(platform_key, platform);
HttpContext.Session.SetString(rating_key, rating);
}
}
else
{
//retrieve the stack from session storage and take the top game from it.
Stack <GameDTO> gamesStack = JsonConvert.DeserializeObject <Stack <GameDTO> >(list);
a = gamesStack.Pop().GameName;
//if the stack is empty after taking from the top, remove the now empty stack from session storage.
if (gamesStack.Any())
{
HttpContext.Session.SetString(list_key, JsonConvert.SerializeObject(gamesStack.Reverse()));
}
else
{
HttpContext.Session.Remove(list_key);
}
}
}
else
{
//if user is not logged into an account, give them a random game.
Random rng = new Random();
gameList = gameList.FindAll(
g => g.Genre.GenreName.ToLower().Contains(genre.ToLower()) &&
g.EsrbRating.ToLower().Contains(rating.ToLower()) &&
g.Platforms.ToLower().Contains(platform.ToLower()));
if (!gameList.Any())
{
return(Json(new
{
test = "No matching games found. 😢"
}));
}
a = gameList[rng.Next(0, gameList.Count)].GameName;
}
}
return(Json(new
{
test = a
}));
}
public IActionResult Rate(String gameName, Int16 rating)
{
HttpContext.Session.Remove(list_key);
try
{
using (var db = new WgsipContext())
{
int weight = 0;
switch (rating)
{
case 1:
weight = -2;
break;
case 2:
weight = -1;
break;
case 3:
weight = 0;
break;
case 4:
weight = 1;
break;
case 5:
weight = 2;
break;
}
//get gameid
int gameid = db.Games.Where(g => g.GameName.ToLower().Equals(gameName.ToLower())).First().GameId;
//get publisherid
int publisherid = db.Games.Include(g => g.Publisher).Where(g => g.GameName.ToLower().Equals(gameName.ToLower())).First().Publisher.PublisherId;
//get genreid
int genreid = db.Games.Include(g => g.Genre).Where(g => g.GameName.ToLower().Equals(gameName.ToLower())).First().Genre.GenreId;
// create list of tags assosiated with this game
List <GameTag> tagsForGame = db.GameTags.Include(g => g.Game).Include(g => g.Tag)
.Where(g => g.Game.GameId == gameid).ToList();
var played_game = db.PlayedGames.Include(pg => pg.User).Include(pg => pg.Game)
.First(pg =>
pg.Game.GameName.ToLower().Equals(gameName.ToLower()) &&
pg.User.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower())
);
int prevWeight = 0;
switch (played_game.Rating)
{
case 1:
prevWeight = -2;
break;
case 2:
prevWeight = -1;
break;
case 3:
prevWeight = 0;
break;
case 4:
prevWeight = 1;
break;
case 5:
prevWeight = 2;
break;
}
played_game.Rating = rating;
// adjust weight of the publisher
try
{
var pub = db.PublisherWeights.Include(pg => pg.User).Include(pg => pg.Publisher)
.First(pg =>
pg.Publisher.PublisherId == publisherid &&
pg.User.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower())
);
pub.Weight += prevWeight * -1; //remove the change from the previous rating.
pub.Weight += weight;
}
catch (Exception)
{
PublisherWeights pW = new PublisherWeights();
pW.Publisher = db.Publishers.First(p => p.PublisherId == publisherid);
pW.User = db.Accounts.First(a => a.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower()));
pW.Weight = weight;
db.PublisherWeights.Add(pW);
}
//adjust weight for the genre
try
{
var gen = db.GenreWeights.Include(pg => pg.User).Include(pg => pg.Genre)
.First(pg =>
pg.Genre.GenreId == genreid &&
pg.User.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower())
);
gen.Weight += prevWeight * -1; //remove the change from the previous rating.
gen.Weight += weight;
}
catch (Exception)
{
GenreWeights gW = new GenreWeights();
gW.Genre = db.Genres.First(g => g.GenreId == genreid);
gW.User = db.Accounts.First(a => a.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower()));
gW.Weight = weight;
db.GenreWeights.Add(gW);
}
/*tag weight is assigned for each tag a game has the tag weight is assigned
* the weight dived by the number of tagsa game has*/
foreach (GameTag tag in tagsForGame)
{
//get the tagid
int tagid = tag.Tag.TagId;
//adjust weight for each tag
try
{
var t = db.TagWeights.Include(pg => pg.User).Include(pg => pg.Tag)
.First(pg =>
pg.Tag.TagId == tagid &&
pg.User.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower())
);
t.Weight += (prevWeight / tagsForGame.Count) * -1; //remove the change from the previous rating.
t.Weight += (weight / tagsForGame.Count);
}
catch (Exception)
{
TagWeights tW = new TagWeights();
tW.Tag = db.Tags.First(t => t.TagId == tagid);
tW.User = db.Accounts.First(a => a.AccountEmail.ToLower().Equals(User.Identity.Name.ToLower()));
tW.Weight = weight;
db.TagWeights.Add(tW);
}
}
db.SaveChanges();
}
return(Json(new { message = "success" }));
}
catch (Exception e)
{
return(Json(new { message = e.Message }));
}
}
