private static void CreateGame(DiabloEntities context, IEnumerable<XElement> xGames, User user)
        {
            foreach (var xGame in xGames)
            {
                // Find the team by team name and country name (if exists)
                var gameName = xGame.Element("game-name").Value;
                var charName = xGame.Element("character").Attribute("name").Value;
                var cash = xGame.Element("character").Attribute("cash").Value;
                var level = xGame.Element("character").Attribute("level").Value;
                var joinedOn = xGame.Element("joined-on").Value;

                decimal parsedCash = decimal.Parse(cash);
                int parsedLvl = int.Parse(level);
                DateTime newJoinedOnDate = DateTime.ParseExact(joinedOn, "dd/mm/yyyy", System.Globalization.CultureInfo.InvariantCulture);
                var game = context.Games.FirstOrDefault(g => g.Name == gameName);

                // Create the team if it does not exists
                if (game != null)
                {
                    Console.WriteLine("Existing game: {0}",
                        game.Name);
                }
                else
                {
                    // Create a new team in the DB
                    game = new Game()
                    {
                        Name = gameName
                    };
                    var character = new Character()
                    {
                        Name = charName

                    };
                    var usersGame = new UsersGame()
                    {
                        Cash = parsedCash,
                        Level = parsedLvl,
                        JoinedOn = newJoinedOnDate
                    };

                    context.Games.Add(game);
                    context.Characters.Add(character);
                    context.UsersGames.Add(usersGame);
                    context.SaveChanges();
                    Console.WriteLine("Created game: {0}",
                        game.Name);
                }

            }
        }
        private static void CreateGame(DiabloEntities context, IEnumerable <XElement> xGames, User user)
        {
            foreach (var xGame in xGames)
            {
                // Find the team by team name and country name (if exists)
                var gameName = xGame.Element("game-name").Value;
                var charName = xGame.Element("character").Attribute("name").Value;
                var cash     = xGame.Element("character").Attribute("cash").Value;
                var level    = xGame.Element("character").Attribute("level").Value;
                var joinedOn = xGame.Element("joined-on").Value;

                decimal  parsedCash      = decimal.Parse(cash);
                int      parsedLvl       = int.Parse(level);
                DateTime newJoinedOnDate = DateTime.ParseExact(joinedOn, "dd/mm/yyyy", System.Globalization.CultureInfo.InvariantCulture);
                var      game            = context.Games.FirstOrDefault(g => g.Name == gameName);

                // Create the team if it does not exists
                if (game != null)
                {
                    Console.WriteLine("Existing game: {0}",
                                      game.Name);
                }
                else
                {
                    // Create a new team in the DB
                    game = new Game()
                    {
                        Name = gameName
                    };
                    var character = new Character()
                    {
                        Name = charName
                    };
                    var usersGame = new UsersGame()
                    {
                        Cash     = parsedCash,
                        Level    = parsedLvl,
                        JoinedOn = newJoinedOnDate
                    };

                    context.Games.Add(game);
                    context.Characters.Add(character);
                    context.UsersGames.Add(usersGame);
                    context.SaveChanges();
                    Console.WriteLine("Created game: {0}",
                                      game.Name);
                }
            }
        }
        private static User CreateUser(DiabloEntities context, XElement xUsers)
        {
            User user = null;
            var  xAttributeFirstName = xUsers.Attribute("first-name");
            var  xAttributeLastName  = xUsers.Attribute("last-name");
            var  xAttributeUsername  = xUsers.Attribute("username");
            var  xAttributeIsDeleted = xUsers.Attribute("is-deleted");
            var  xAttributeIpAddress = xUsers.Attribute("ip-address");
            var  xAttributeRegDate   = xUsers.Attribute("registration-date");

            if (xAttributeFirstName != null)
            {
                string firstName = xAttributeFirstName.Value;
                string LastName  = xAttributeLastName.Value;
                string username  = xAttributeUsername.Value;
                var    isDeleted = xAttributeIsDeleted.Value;
                string ipAddress = xAttributeIpAddress.Value;
                string regDate   = xAttributeRegDate.Value;

                user = context.Users.FirstOrDefault(u => u.Username == username);
                if (user != null)
                {
                    Console.WriteLine("User {0} already exists", username);
                    // Console.WriteLine("{0} {1} {2} {3} {4}", LastName, firstName, isDeleted, ipAddress, regDate);
                }
                else
                {
                    // Create a new league in the DB
                    DateTime newRegDate = DateTime.ParseExact(regDate, "dd/mm/yyyy", System.Globalization.CultureInfo.InvariantCulture);
                    user = new User()
                    {
                        FirstName        = firstName,
                        LastName         = LastName,
                        Username         = username,
                        IpAddress        = ipAddress,
                        RegistrationDate = newRegDate
                    };
                    context.Users.Add(user);
                    context.SaveChanges();
                    Console.WriteLine("Added user: {0}", firstName);
                }
            }
            return(user);
        }
        private static User CreateUser(DiabloEntities context, XElement xUsers)
        {
            User user = null;
            var xAttributeFirstName = xUsers.Attribute("first-name");
            var xAttributeLastName = xUsers.Attribute("last-name");
            var xAttributeUsername = xUsers.Attribute("username");
            var xAttributeIsDeleted = xUsers.Attribute("is-deleted");
            var xAttributeIpAddress = xUsers.Attribute("ip-address");
            var xAttributeRegDate = xUsers.Attribute("registration-date");

            if (xAttributeFirstName != null)
            {
                string firstName = xAttributeFirstName.Value;
                string LastName = xAttributeLastName.Value;
                string username = xAttributeUsername.Value;
                var isDeleted = xAttributeIsDeleted.Value;
                string ipAddress = xAttributeIpAddress.Value;
                string regDate = xAttributeRegDate.Value;

                user = context.Users.FirstOrDefault(u => u.Username == username);
                if (user != null)
                {
                    Console.WriteLine("User {0} already exists", username);
                   // Console.WriteLine("{0} {1} {2} {3} {4}", LastName, firstName, isDeleted, ipAddress, regDate);
                }
                else
                {
                    // Create a new league in the DB
                    DateTime newRegDate = DateTime.ParseExact(regDate, "dd/mm/yyyy", System.Globalization.CultureInfo.InvariantCulture);
                    user = new User()
                    {
                        FirstName = firstName,
                        LastName = LastName,
                        Username = username,
                        IpAddress = ipAddress,
                        RegistrationDate = newRegDate
                    };
                    context.Users.Add(user);
                    context.SaveChanges();
                    Console.WriteLine("Added user: {0}", firstName);
                }
            }
            return user;
        }