//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() }); }