public static void StoreGame(GameSnapshot snapshot, DateTime startTime) { using (var db = new HanksiteEntities()) { Game game = new Game { Name = snapshot.Name, StartTime = startTime, EndTime = DateTime.Now }; foreach (var player in snapshot.Players) { GameUser gameUser = new GameUser { Game = game, UserID = player.User.ID, Position = player.Position }; db.GameUsers.Add(gameUser); } db.SaveChanges(); } }
public static List <PlayedGameInfo> GetPlayedGamesForUser(long userId) { using (var db = new HanksiteEntities()) { var qUserGames = from userGame in db.GameUsers.Include("Game").Include("Game.GameUsers").Include("Game.GameUsers.User") where userGame.UserID == userId select userGame; List <PlayedGameInfo> playedGames = new List <PlayedGameInfo>(); foreach (var userGame in qUserGames) { playedGames.Add(new PlayedGameInfo { Position = (int)userGame.Position, Name = userGame.Game.Name, StartTime = userGame.Game.StartTime, Duration = userGame.Game.EndTime - userGame.Game.StartTime, Enemies = (from user in userGame.Game.GameUsers where user.UserID != userId select new PlayerCore { User = new Common.Users.User { ID = user.UserID, UserName = user.User.UserName }, Position = (int)user.Position }).ToArray() }); } return(playedGames); } }
public static User GetUserByName(string userName) { using (var db = new HanksiteEntities()) { return((from user in db.Users where user.UserName == userName select user) .SingleOrDefault()); } }
public static User GetUser(long userId) { using (var db = new HanksiteEntities()) { return((from user in db.Users where user.ID == userId select user) .Single()); } }
public static void ChangeUserPassword(long userId, string passwordSalt, string password) { using (var db = new HanksiteEntities()) { User userToChange = (from user in db.Users where user.ID == userId select user) .Single(); userToChange.PasswordSalt = passwordSalt; userToChange.Password = password; db.SaveChanges(); } }
public static long RegisterUser(string userName, string passwordSalt, string password) { using (var db = new HanksiteEntities()) { User user = new User { UserName = userName, PasswordSalt = passwordSalt, Password = password }; db.Users.Add(user); db.SaveChanges(); return(user.ID); } }