//Update
public void UpdateValues(string Name, int Lifes, int Bonus, int GameID)
{
if (dbContext.Game.Where(g => g.ID == GameID).Count() == 0)
{
throw new Exception("Er is geen game gevonden met de ID : `" + GameID.ToString() + "`");
}
if (Lifes < 1 || Lifes > 5)
{
throw new Exception("De levens moet tussen de 1 en de 5 zijn!");
}
if (Bonus < 1 || Bonus > 10)
{
throw new Exception("De bonustijd moet tussen de 1 en de 10 zijn!");
}
if (Name.Length < 3 || Name.Length > 25)
{
throw new Exception("De naam moet tussen de 3 en 25 characters bevatten!");
}
Models.DataModels.Game game = dbContext.Game.Where(g => g.ID == GameID).First();
game.name = Name;
game.lifes = Lifes;
game.bonusTime = Bonus;
dbContext.SaveChanges();
//SQL.Update("UPDATE `game` SET `name` = '" + Name + "', `lifes` = '" + Lifes.ToString() + "', `bonusTime` = '" + Bonus.ToString() + "' WHERE `ID` = '" + GameID.ToString() + "'");
}
//Update
public void UpdateValues(string Name, int Lifes, int Bonus, int GameID)
{
if (_dbContext.Game.Where(g => g.ID == GameID).Count() == 0)
{
throw new Exception("Er is geen game gevonden met de ID : `" + GameID.ToString() + "`");
}
if (Lifes < 1 || Lifes > 5)
{
throw new Exception("De levens moet tussen de 1 en de 5 zijn!");
}
if (Bonus < 1 || Bonus > 10)
{
throw new Exception("De bonustijd moet tussen de 1 en de 10 zijn!");
}
if (Name.Length < 3 || Name.Length > 25)
{
throw new Exception("De naam moet tussen de 3 en 25 characters bevatten!");
}
Models.DataModels.Game Game = _dbContext.Game.Where(g => g.ID == GameID).First();
Game.Name = Name;
Game.Lifes = Lifes;
Game.BonusTime = Bonus;
_dbContext.SaveChanges();
}
//Delete
public void DeleteGame(int GameID)
{
Game game = GetGame(GameID);
for (int i = 0; i < game.Questions.Count; i++)
{
question_Handler.DeleteQuestion(game.Questions[i].QuestionID, game.ID);
}
Models.DataModels.Game gm = dbContext.Game.Where(g => g.ID == GameID).First();
dbContext.Game.Remove(gm);
dbContext.SaveChanges();
}
//Delete
public void DeleteGame(int GameID)
{
Game Game = GetGame(GameID);
for (int i = 0; i < Game.Questions.Count; i++)
{
_questionHandler.DeleteQuestion(Game.Questions[i].QuestionID, Game.ID);
}
Models.DataModels.Game GameToDelete = _dbContext.Game.Where(g => g.ID == GameID).First();
_dbContext.Game.Remove(GameToDelete);
_dbContext.SaveChanges();
}
//Create
public void CreateGame(Game game, HttpPostedFileBase file)
{
if (game.Lifes < 1 || game.Lifes > 5)
{
throw new Exception("De levens moet tussen de 1 en de 5 zijn!");
}
if (game.BonusTime < 1 || game.BonusTime > 10)
{
throw new Exception("De bonustijd moet tussen de 1 en de 10 zijn!");
}
if (game.Name.Length < 3 || game.Name.Length > 25)
{
throw new Exception("De naam moet tussen de 3 en 25 characters bevatten!");
}
Models.DataModels.Game NewGame = new Models.DataModels.Game()
{
bonusTime = game.BonusTime,
lifes = game.Lifes,
name = game.Name,
Online = game.Online
};
string Image = "";
if (file != null)
{
Image = UploadHandler.UploadImage(file, UploadHandler.GetImageSize(PreDefImageSize.GameImage), PreDefImageLocation.GameImage).Name;
string img = UploadHandler.GetImageUrlPath(PreDefImageLocation.GameImage) + Image;
//SQL.Insert("INSERT INTO `chartgroup`(`ID`) VALUES(NULL);INSERT INTO `game` (`ID`, `name`, `lifes`, `bonusTime`,`online`, `ChartGroupID`, `img`) VALUES (NULL, '" + game.Name + "', '" + game.Lifes + "', '" + game.BonusTime + "', '1',( SELECT MAX(`chartgroup`.`ID`) FROM `chartgroup`), '" + img + "');");
NewGame.img = img;
}
dbContext.ChartGroup.Add(new Models.DataModels.ChartGroup());
dbContext.SaveChanges();
NewGame.ChartGroupID = dbContext.ChartGroup.OrderByDescending(o => o.ID).FirstOrDefault().ID;
dbContext.Game.Add(NewGame);
dbContext.SaveChanges();
}
public void UpdateOnlineStatus(int GameID, bool status)
{
if (dbContext.Game.Where(g => g.ID == GameID).Count() == 0)
{
throw new Exception("Er is geen game gevonden met het ID : `" + GameID.ToString() + "`");
}
Models.DataModels.Game game = dbContext.Game.Where(g => g.ID == GameID).First();
if (status)
{
game.Online = true;
}
else
{
game.Online = false;
}
dbContext.SaveChanges();
}
public Game GetGame(string ID)
{
int iID = Convert.ToInt32(ID);
if (dbContext.Game.Where(g => g.ID == iID).Count() == 0)
{
throw new Exception("Er is geen game gevonden met de ID : `" + ID + "`");
}
Models.DataModels.Game game = dbContext.Game.Where(g => g.ID == iID).First();
return(new Game()
{
ID = Convert.ToInt32(ID),
BonusTime = game.bonusTime,
Lifes = game.lifes,
Name = game.name,
ImageURL = game.img,
Online = game.Online,
ChartGroupID = game.ChartGroupID,
Questions = question_Handler.GetQuestions(Convert.ToInt32(ID))
});
}
//Read
public GameHighscore GetGameHighscore(int GameID)
{
if (_dbContext.Game.Where(g => g.ID == GameID).Count() == 0)
{
throw new Exception("There is no record of that Game!");
}
List <Models.DataModels.HighScore> GameHighScores = _dbContext.HighScore.Where(hs => hs.GameID == GameID).ToList();
List <int> UserIDs = GameHighScores.Select(ghs => ghs.UserID).ToList();
List <Models.DataModels.User> users = _dbContext.User.Where(u => UserIDs.Contains(u.ID)).ToList();
List <string> FirstNames = users.Select(u => u.FirstName).ToList();
List <string> MiddleNames = users.Select(u => u.MiddleName).ToList();
List <string> LastNames = users.Select(u => u.LastName).ToList();
List <string> Fullnames = new List <string>();
for (int i = 0; i < FirstNames.Count; i++)
{
if (MiddleNames[i] != "")
{
Fullnames.Add(FirstNames[i] + " " + MiddleNames[i] + " " + LastNames[i]);
}
else
{
Fullnames.Add(FirstNames[i] + " " + LastNames[i]);
}
}
Models.DataModels.Game Game = _dbContext.Game.Find(GameID);
return(new GameHighscore()
{
GameID = GameID,
GameName = Game.Name,
Name = Fullnames,
points = _dbContext.HighScore.Where(hs => hs.GameID == GameID).ToList().Select(hs => hs.Points.ToString()).ToList()
});
}
