public int AddGamePlayer(GamePlayerModel player) // returns -1 if the username already exists//-2 if there is no game // 1 success { var cont = new SeniorLinqDataContext(); var query2 = (from gps in cont.Users where gps.Username == player.UserName select gps).SingleOrDefault(); if (query2 == null) { return(-1); } var query1 = (from gameplayers in cont.Gameplayers where gameplayers.Username == player.UserName && gameplayers.GID == player.GID select gameplayers).SingleOrDefault();//make sure that the game doesn't exists if (query1 == null) { var gamechecker = (from game in cont.Games where game.GID == player.GID select game).SingleOrDefault(); if (gamechecker == null) { return(-2); } Gameplayer temp = new Gameplayer(); temp.GID = player.GID; temp.Username = player.UserName; cont.Gameplayers.InsertOnSubmit(temp); cont.SubmitChanges(); return(1); } return(-1); }
public List <GamePlayerModel> RetreiveAllGamePlayersByPlayer(string usrname) { var cont = new SeniorLinqDataContext(); List <GamePlayerModel> gameplayers = new List <GamePlayerModel>(); var query = (from gp in cont.Gameplayers where gp.Username == usrname select gp).ToList(); for (int i = 0; i < query.Count; i++) { GamePlayerModel gpm = new GamePlayerModel(); gpm.GID = query[i].GID; gpm.UserName = query[i].Username; gameplayers.Add(gpm); } return(gameplayers); }
//public int DeleteGamePlayer(String uname) //{ // var cont = new SeniorLinqDataContext(); // var query = (from gp in cont.Gameplayers where gp.Username == uname select gp).SingleOrDefault(); // cont.Gameplayers.DeleteOnSubmit(query); // cont.SubmitChanges(); // var q = (from palyer in cont.Gameplayers where palyer.Username == uname select palyer).SingleOrDefault(); // if (q == null) // return 1; // else return -1; //} public List <GamePlayerModel> RetreiveGamePlayers(int gid)//retruns all found GPs if found // null List otherwise//checked { var cont = new SeniorLinqDataContext(); var query = (from gp in cont.Gameplayers where gp.GID == gid select gp).ToList(); if (query != null)//found associated players { List <GamePlayerModel> gpm = new List <GamePlayerModel>(); for (int i = 0; i < query.Count; i++) { GamePlayerModel g = new GamePlayerModel(); g.GID = query[i].GID; g.UserName = query[i].Username; gpm.Add(g); cont.SubmitChanges(); } return(gpm); } return(null); }