//checked #region GameFrame public int AddGameFrame(GameFrameModel gf) // returns 1 if the insertion was successful //-1 if parameters are incoherent//-2 if the GF already exists// checked// { var cont = new SeniorLinqDataContext(); GameFrame temp = new GameFrame(); if (gf.MinPlayers <= gf.MaxPlayers && gf.MinStrategies <= gf.MaxStrategies) { var query1 = (from gfs in cont.GameFrames where gfs.Title == gf.Title select gfs).SingleOrDefault(); if (query1 == null) { temp.Title = gf.Title; temp.MinPlayers = gf.MinPlayers; temp.MaxPlayers = gf.MaxPlayers; temp.MinStrategies = gf.MinStrategies; temp.MaxStrategies = gf.MaxStrategies; cont.GameFrames.InsertOnSubmit(temp); cont.SubmitChanges(); var query = (from gff in cont.GameFrames where gff.Title == temp.Title select gff.Title).SingleOrDefault(); if (query != null) { return(1); } } return(-2); } return(-1); }
public GameFrameModel RetreiveGameFrame(string title)// returns a gameframe if found , otherwise null ///checked { var cont = new SeniorLinqDataContext(); var query = (from gff in cont.GameFrames where gff.Title == title select gff).SingleOrDefault(); if (query != null) { GameFrameModel gf = new GameFrameModel(); gf.Title = query.Title; gf.MinPlayers = query.MinPlayers; gf.MaxPlayers = query.MaxPlayers; gf.MinStrategies = query.MinStrategies; gf.MaxStrategies = query.MaxStrategies; return(gf); } return(null); }
public int UpdateGameFrame(GameFrameModel edited) { if (edited.MinPlayers > edited.MaxPlayers && edited.MinStrategies > edited.MaxStrategies) { return(-1); } var cont = new SeniorLinqDataContext(); var query = (from gfs in cont.GameFrames where gfs.Title == edited.Title select gfs).SingleOrDefault(); if (query != null) { GameFrameModel temp = new GameFrameModel(); query.MaxPlayers = edited.MaxPlayers; query.MaxStrategies = edited.MaxStrategies; query.MinPlayers = edited.MinPlayers; query.MinStrategies = edited.MinStrategies; cont.SubmitChanges(); return(1); } return(-1); }
public List <GameFrameModel> RetreiveFreeGameFrame() { var cont = new SeniorLinqDataContext(); var allGFs = (from gfs in cont.GameFrames select gfs.Title).ToList(); var allGames = (from games in cont.Games select games.Title).ToList(); var result = allGFs.Except(allGames); List <GameFrameModel> result2 = new List <GameFrameModel>(); foreach (string title in result) { GameFrameModel temp = new GameFrameModel(); var x = (from gfs in cont.GameFrames where gfs.Title == title select gfs).SingleOrDefault(); temp.Title = x.Title; temp.MinStrategies = x.MinStrategies; temp.MinPlayers = x.MinPlayers; temp.MaxPlayers = x.MaxPlayers; temp.MaxStrategies = x.MaxStrategies; result2.Add(temp); } return(result2); }
public List <GameFrameModel> GameByNumPlayer(int nop) { var cont = new SeniorLinqDataContext(); List <GameFrameModel> gameframemodels = new List <GameFrameModel>(); if (nop < 4) { var query = (from gf in cont.GameFrames where gf.MinPlayers == gf.MaxPlayers && gf.MinPlayers == nop select gf).ToList();// all gameframes with nop players List <GameFrameModel> gamemodels = new List <GameFrameModel>(); for (int i = 0; i < query.Count; i++) { GameFrameModel Model1 = new GameFrameModel(); Model1.Title = query[i].Title; Model1.MaxPlayers = query[i].MaxPlayers; Model1.MaxStrategies = query[i].MaxStrategies; Model1.MinPlayers = query[i].MinPlayers; Model1.MinStrategies = query[i].MinStrategies; gameframemodels.Add(Model1); } } else { var query = (from gf in cont.GameFrames where gf.MaxPlayers > 3 select gf).ToList();//all N gameframes for (int i = 0; i < query.Count; i++) { GameFrameModel Model1 = new GameFrameModel(); Model1.Title = query[i].Title; Model1.MaxPlayers = query[i].MaxPlayers; Model1.MaxStrategies = query[i].MaxStrategies; Model1.MinPlayers = query[i].MinPlayers; Model1.MinStrategies = query[i].MinStrategies; gameframemodels.Add(Model1); } } return(gameframemodels); }