internal static void Edit(long facebookID, string firstName, string lastName) { PolarTicTacToeDataContext dataContext = new PolarTicTacToeDataContext(); var curPlayer = (from p in dataContext.Players where p.FacebookID == facebookID select p).FirstOrDefault(); curPlayer.FirstName = firstName; curPlayer.LastName = lastName; dataContext.SubmitChanges(); }
internal static Player Create(long facebookID) { PolarTicTacToeDataContext dataContext = new PolarTicTacToeDataContext(); Player newPlayer = new Player(); newPlayer.FacebookID = facebookID; dataContext.Players.InsertOnSubmit(newPlayer); dataContext.SubmitChanges(); return newPlayer; }
internal static Player Create(long facebookID, string firstName, string lastName) { PolarTicTacToeDataContext dataContext = new PolarTicTacToeDataContext(); Player newPlayer = new Player(); newPlayer.FacebookID = facebookID; newPlayer.FirstName = firstName; newPlayer.LastName = lastName; dataContext.Players.InsertOnSubmit(newPlayer); dataContext.SubmitChanges(); return newPlayer; }
public static Game Create(int ChallengerID, int OpponentID) { PolarTicTacToeDataContext dataContext = new PolarTicTacToeDataContext(); Game newGame = new Game(); newGame.ChallengerID = ChallengerID; newGame.OpponentID = OpponentID; newGame.StartDate = DateTime.Now; newGame.GameState = Utils.GameState.Active.ToString(); dataContext.Games.InsertOnSubmit(newGame); dataContext.SubmitChanges(); return newGame; }
internal static bool PlayMove(int id, int player, Tuple<int, int> spot, out int? winner, out string message) { PolarTicTacToeDataContext dataContext = new PolarTicTacToeDataContext(); var game = (from p in dataContext.Games where p.ID == id select p).FirstOrDefault(); var gameRules = new GameRules(); if (gameRules.HasPlayed(game, spot)) { message = "Spot already played"; winner = null; return false; } else { string move = spot.Item1 + ";" + spot.Item2 + ";" + String.Format("{0:g}", DateTime.Now) + ";false,"; game.Moves = game.Moves ?? ""; game.Moves += move; if (gameRules.IsFinished(game, out winner)) { winner = player; game.WinnerID = winner; game.GameState = Utils.GameState.Finished.ToString(); } dataContext.SubmitChanges(); message = ""; return true; } }
internal static List<Game> GetActive(int id) { PolarTicTacToeDataContext dataContext = new PolarTicTacToeDataContext(); return (from p in dataContext.Games where p.GameState.Equals(Utils.GameState.Active.ToString()) && (p.OpponentID == id || p.ChallengerID == id) select p).ToList(); }
internal static Game GetActive(int ID1, int ID2) { PolarTicTacToeDataContext dataContext = new PolarTicTacToeDataContext(); return (from p in dataContext.Games where p.GameState.Equals(Utils.GameState.Active.ToString()) && ((p.OpponentID == ID1 && p.ChallengerID == ID2) || (p.ChallengerID == ID1 && p.OpponentID == ID2)) select p).FirstOrDefault(); }
internal static Game Get(int id) { PolarTicTacToeDataContext dataContext = new PolarTicTacToeDataContext(); return (from p in dataContext.Games where p.ID == id select p).FirstOrDefault(); }
public void setAppRequest(long appRequest) { PolarTicTacToeDataContext dataContext = new PolarTicTacToeDataContext(); var curGame = (from p in dataContext.Games where p.ID == this.ID select p).FirstOrDefault(); curGame.CurAppRequest = appRequest; dataContext.SubmitChanges(); }
internal static Player GetByID(long ID) { PolarTicTacToeDataContext dataContext = new PolarTicTacToeDataContext(); return (from p in dataContext.Players where p.ID == ID select p).FirstOrDefault(); }