Пример #1
0
        public async Task <List <Results> > GetDecisions(int id)
        {
            Player player = _GAMEContext.Player.Where(m => m.Id == id).FirstOrDefault();

            if (player != null)
            {
                GameTeamPlayerRelationship gameTeamPlayerRelationship = _GAMEContext.GameTeamPlayerRelationship.Where(m => m.PlayerId == player.Id).FirstOrDefault();
                if (gameTeamPlayerRelationship != null)
                {
                    List <Results> results = await _GAMEContext.Results.Where(m => m.GameTeamPlayerRelationshipId == gameTeamPlayerRelationship.Id).ToListAsync();

                    return(results);
                }
            }
            return(null);
        }
Пример #2
0
        public async Task <ActionResult> GetCompetitorDecisions(int id)
        {
            Dictionary <int, List <Results> > dict = new Dictionary <int, List <Results> >();

            Player        player        = _GAMEContext.Player.Where(m => m.Id == id).FirstOrDefault();
            List <Player> listOfPlayers = await _GAMEContext.Player.Where(m => m.PlayerRoleId == player.PlayerRoleId).ToListAsync();

            foreach (Player p in listOfPlayers)
            {
                GameTeamPlayerRelationship gameTeamPlayerRelationship = _GAMEContext.GameTeamPlayerRelationship.Where(m => m.PlayerId == p.Id).FirstOrDefault();
                if (gameTeamPlayerRelationship != null)
                {
                    List <Results> results = await _GAMEContext.Results.Where(m => m.GameTeamPlayerRelationshipId == gameTeamPlayerRelationship.Id).ToListAsync();

                    dict[p.Id] = results;
                }
            }

            return(new JsonResult(dict));
        }
Пример #3
0
        async Task <object> IDataProvider.GetPlayer(int id)
        {
            try
            {
                Player player = await _GAMEContext.Player.FirstOrDefaultAsync(m => m.Id == id);

                Team team = null;
                if (player.GameTeamPlayerRelationship.Count != 0)
                {
                    team = player.GameTeamPlayerRelationship.FirstOrDefault().Team;
                }

                if (await ShouldUpdateResults(teamId: team.Id))
                {
                    await UpdateResults(team.Id, team.CurrentPeriod);
                }

                var Inventory = new Object();
                if (player != null && team != null)
                {
                    GameTeamPlayerRelationship gameTeamPlayerRelationship = _GAMEContext.GameTeamPlayerRelationship.Where(m => m.PlayerId == player.Id).FirstOrDefault();
                    List <Results>             results = await _GAMEContext.Results.Where(m => m.GameTeamPlayerRelationshipId == gameTeamPlayerRelationship.Id).ToListAsync();

                    List <double?> costs = new List <double?>();
                    List <int?>    inv   = new List <int?>();
                    foreach (Results r in results)
                    {
                        costs.Add(r.TotalCost);

                        inv.Add(r.Inventory);
                    }
                    Results latestResult = results.FirstOrDefault(p => p.Period == team.CurrentPeriod - 1);
                    if (latestResult != null)
                    {
                        Inventory = new
                        {
                            latestResult.PreviousOrder,
                            CurrentPeriod    = team.CurrentPeriod - 1,
                            CurrentInventory = latestResult.Inventory,
                            latestResult.IncomingInventory,
                            latestResult.TotalCost,
                            Costs       = costs,
                            Inventories = inv
                        };
                        await _GAMEContext.SaveChangesAsync();
                    }
                    else
                    {
                        Inventory = new
                        {
                            PreviousOrder = 0,
                            CurrentPeriod = team.CurrentPeriod - 1,
                            player.Inventory.CurrentInventory,
                            IncomingInventory = 0,
                            TotalCost         = 0,
                            Costs             = costs,
                            Inventories       = inv
                        };
                        await _GAMEContext.SaveChangesAsync();
                    }
                }
                return(Inventory);
            }
            catch (Exception ex)
            {
                return(ex);
            }
        }
Пример #4
0
        public async Task AddPlayers([FromBody] AddPlayerClass addPlayerClass)
        {
            try
            {
                List <PlayerClass> players = addPlayerClass.Players;
                var  GroupedPlayer         = players.GroupBy(u => u.Team).Select(grp => grp.ToList()).ToList();
                Game game;
                if (addPlayerClass.GameId == null)
                {
                    List <int> demandData = new List <int>();
                    for (int i = 1; i <= 40; i++)
                    {
                        int demand = (i <= 6) ? 4 : 8;
                        demandData.Add(demand);
                    }
                    game = new Game
                    {
                        Name              = addPlayerClass.GameName,
                        MaxPeriod         = 40,
                        DeliveryDelay     = 2,
                        FacilitatorId     = addPlayerClass.FacilId,
                        DemandInformation = Newtonsoft.Json.JsonConvert.SerializeObject(demandData),
                        GameUrl           = "http://winegame.edventist.com/"
                    };
                    _GAMEContext.Game.Add(game);
                    await _GAMEContext.SaveChangesAsync();
                }
                else
                {
                    game = await _GAMEContext.Game.Where(m => m.Id == (int)addPlayerClass.GameId).FirstOrDefaultAsync();
                }

                foreach (List <PlayerClass> group in GroupedPlayer)
                {
                    Player groupPlayer = await _GAMEContext.Player.Where(m => m.Id == group.FirstOrDefault().Id).FirstOrDefaultAsync();

                    await _GAMEContext.GameTeamPlayerRelationship.ToListAsync();

                    await _GAMEContext.Team.ToListAsync();

                    Team team = new Team();
                    if (groupPlayer != null)
                    {
                        team      = groupPlayer.GameTeamPlayerRelationship.FirstOrDefault().Team;
                        team.Name = group.FirstOrDefault().Team;
                    }
                    else
                    {
                        team = new Team
                        {
                            Name          = group.FirstOrDefault().Team,
                            CurrentOrder  = 4,
                            CurrentPeriod = 2
                        };
                        _GAMEContext.Team.Add(team);
                    }

                    await _GAMEContext.SaveChangesAsync();

                    foreach (PlayerClass newPlayer in group)
                    {
                        Player player = await _GAMEContext.Player.Where(m => m.Id == newPlayer.Id).FirstOrDefaultAsync();

                        if (player == null)
                        {
                            player = new Player
                            {
                                FirstName       = newPlayer.FirstName,
                                LastName        = newPlayer.LastName,
                                Email           = newPlayer.Email,
                                HasMadeDecision = false
                            };

                            InventoryInformation inventoryInformation = new InventoryInformation
                            {
                                CurrentInventory  = 50,
                                Backlogs          = 0,
                                IncomingInventory = 4,
                                TotalCost         = 0,
                                NewOrder          = 4
                            };

                            switch (newPlayer.Role)
                            {
                            case "Retailer":
                                player.PlayerRoleId = (int)Role.Retailer;
                                break;

                            case "Distributor":
                                player.PlayerRoleId = (int)Role.Distributor;
                                break;

                            case "Wholesaler":
                                player.PlayerRoleId = (int)Role.Wholesaler;
                                break;

                            case "Factory":
                                player.PlayerRoleId = (int)Role.Factory;
                                break;

                            default:
                                break;
                            }

                            var userName = "";
                            userName        = (newPlayer.FirstName.Length > 3 ? userName += newPlayer.FirstName.Substring(0, 3) : userName += newPlayer.FirstName);
                            userName        = (newPlayer.LastName.Length > 3 ? userName += newPlayer.LastName.Substring(0, 3) : userName += newPlayer.LastName);
                            player.Username = userName.ToLower();
                            player.Password = userName.ToLower();
                            _GAMEContext.InventoryInformation.Add(inventoryInformation);
                            _GAMEContext.Player.Add(player);
                            await _GAMEContext.SaveChangesAsync();

                            player.InventoryId = inventoryInformation.Id;
                            GameTeamPlayerRelationship gameTeamPlayerRelationship = new GameTeamPlayerRelationship
                            {
                                GameId   = game.Id,
                                TeamId   = team.Id,
                                PlayerId = player.Id
                            };
                            _GAMEContext.GameTeamPlayerRelationship.Add(gameTeamPlayerRelationship);
                            await _GAMEContext.SaveChangesAsync();

                            Results results = new Results
                            {
                                GameTeamPlayerRelationshipId = gameTeamPlayerRelationship.Id,
                                PreviousOrder     = 4,
                                Inventory         = player.Inventory.CurrentInventory,
                                IncomingInventory = 4,
                                TotalCost         = 0,
                                Period            = 2,
                                OrderQty          = 4,
                                SentQty           = 4
                            };

                            _GAMEContext.Results.Add(results);
                            await dataProvider.SendEmail(player);
                        }
                        else
                        {
                            player.FirstName = newPlayer.FirstName;
                            player.LastName  = newPlayer.LastName;
                            player.Email     = newPlayer.Email;
                        }
                        await _GAMEContext.SaveChangesAsync();
                    }
                }
            }
            catch (Exception ex)
            {
                Console.Write(ex.ToString());
            }
        }
Пример #5
0
        public async Task MakeOrder([FromBody] OrderClass orderClass)
        {
            List <Player> players = await _GAMEContext.Player.ToListAsync();

            Player player = players.FirstOrDefault(m => m.Id == orderClass.PlayerId);

            if (player != null)
            {
                InventoryInformation inventoryInformation = player.Inventory;
            }

            int OrderMadeTo = 0;

            switch (player.PlayerRoleId)
            {
            case (int)Role.Retailer:
                OrderMadeTo = (int)_GAMEContext.GameTeamPlayerRelationship.Where(m => m.TeamId == player.GameTeamPlayerRelationship.FirstOrDefault().TeamId&& m.Player.PlayerRoleId == (int)Role.Wholesaler).FirstOrDefault().PlayerId;
                break;

            case (int)Role.Wholesaler:
                OrderMadeTo = (int)_GAMEContext.GameTeamPlayerRelationship.Where(m => m.TeamId == player.GameTeamPlayerRelationship.FirstOrDefault().TeamId&& m.Player.PlayerRoleId == (int)Role.Distributor).FirstOrDefault().PlayerId;
                break;

            case (int)Role.Distributor:
                OrderMadeTo = (int)_GAMEContext.GameTeamPlayerRelationship.Where(m => m.TeamId == player.GameTeamPlayerRelationship.FirstOrDefault().TeamId&& m.Player.PlayerRoleId == (int)Role.Factory).FirstOrDefault().PlayerId;
                break;

            case (int)Role.Factory:
                OrderMadeTo = 0;
                break;

            default:
                break;
            }

            GameTeamPlayerRelationship gameTeamPlayerRelationship = await _GAMEContext.GameTeamPlayerRelationship.FirstOrDefaultAsync(m => m.PlayerId == player.Id);

            int currentPeriod = gameTeamPlayerRelationship.Team.CurrentPeriod;
            PlayerTransactions playerTransactions = await _GAMEContext.PlayerTransactions.FirstOrDefaultAsync(m => m.OrderMadeFrom == player.Id && m.OrderMadePeriod == currentPeriod);

            if (playerTransactions == null)
            {
                playerTransactions = new PlayerTransactions();
                _GAMEContext.PlayerTransactions.Add(playerTransactions);
            }
            playerTransactions.OrderMadeFrom      = player.Id;
            playerTransactions.OrderMadeTo        = OrderMadeTo;
            playerTransactions.OrderQty           = orderClass.OrderQty;
            playerTransactions.GameId             = gameTeamPlayerRelationship.GameId;
            playerTransactions.TeamId             = gameTeamPlayerRelationship.TeamId;
            playerTransactions.OrderMadePeriod    = gameTeamPlayerRelationship.Team.CurrentPeriod;
            playerTransactions.OrderReceivePeriod = gameTeamPlayerRelationship.Team.CurrentPeriod + 2;

            player.HasMadeDecision = true;
            await _GAMEContext.SaveChangesAsync();

            if (await dataProvider.ShouldUpdateResults(gameTeamPlayerRelationship.TeamId))
            {
                await dataProvider.UpdateResults(gameTeamPlayerRelationship.TeamId, gameTeamPlayerRelationship.Team.CurrentPeriod);
            }
        }