示例#1
0
        static void Main(string[] args)
        {
            var importModel = new ImportModel();

            //var folder = await Windows.ApplicationModel.Package.Current.InstalledLocation.GetFolderAsync("Assets");
            //var file = await folder.GetFileAsync("matches.json");

            var client = new HttpClient();
            var uri    = new Uri("http://10.5.3.7/scouting/json/flat.php", UriKind.Absolute);

            using (var downloadStream = client.GetStreamAsync(uri).Result)
            //using (var fileData = await file.OpenReadAsync())
            {
                using (var stringreader = new StreamReader(downloadStream))
                {
                    using (var jsonReader = new JsonTextReader(stringreader))
                    {
                        var jsonSerializer = new JsonSerializer();
                        importModel = jsonSerializer.Deserialize <ImportModel>(jsonReader);
                    }
                }
            }

            using (var dbContext = new RawDataDbContext())
            {
                foreach (var team in importModel.Teams)
                {
                    var matches = team.Value.Matches;
                    if (matches == null)
                    {
                        continue;
                    }

                    foreach (var match in matches)
                    {
                        Console.Write("{0} {1}", team.Key, match.Key);
                        var importantMatchData = new ImportantMatchData();
                        importantMatchData.MatchNumber        = match.Key;
                        importantMatchData.AutonomousHighMade = match.Value.AutonomousHigh
                                                                + match.Value.AutonomousHighHot;
                        importantMatchData.BallsDropped       = match.Value.TeleOperatedBallsLost.GetValueOrDefault();
                        importantMatchData.Catches            = match.Value.TeleOperatedCatch;
                        importantMatchData.HighGoals          = match.Value.TeleOperatedHighGoal;
                        importantMatchData.HighGoalsAttempted = match.Value.TeleOperatedHighGoal
                                                                + match.Value.TeleOperatedHighGoalMiss;
                        importantMatchData.TeamNumber  = team.Key;
                        importantMatchData.Possessions = match.Value.TeleOperatedPossessionBack
                                                         + match.Value.TeleOperatedPossessionFront
                                                         + match.Value.TeleOperatedPossessionMiddle;
                        importantMatchData.TrussesAttempted = match.Value.TeleOperatedTruss
                                                              + match.Value.TeleOperatedTrussFail;
                        importantMatchData.TrussesMade = match.Value.TeleOperatedTruss;

                        dbContext.Matches.Add(importantMatchData);
                        dbContext.SaveChanges();
                    }
                }
            }
        }
示例#2
0
        static void Main(string[] args)
        {
            var importModel = new ImportModel();

            //var folder = await Windows.ApplicationModel.Package.Current.InstalledLocation.GetFolderAsync("Assets");
            //var file = await folder.GetFileAsync("matches.json");

            var client = new HttpClient();
            var uri = new Uri("http://10.5.3.7/scouting/json/flat.php", UriKind.Absolute);
            using (var downloadStream = client.GetStreamAsync(uri).Result)
            //using (var fileData = await file.OpenReadAsync())
            {
                using (var stringreader = new StreamReader(downloadStream))
                {
                    using (var jsonReader = new JsonTextReader(stringreader))
                    {
                        var jsonSerializer = new JsonSerializer();
                        importModel = jsonSerializer.Deserialize<ImportModel>(jsonReader);
                    }
                }
            }

            using (var dbContext = new RawDataDbContext())
            {
                foreach (var team in importModel.Teams)
                {
                    var matches = team.Value.Matches;
                    if (matches == null)
                    {
                        continue;
                    }

                    foreach (var match in matches)
                    {
                        Console.Write("{0} {1}", team.Key, match.Key);
                        var importantMatchData = new ImportantMatchData();
                        importantMatchData.MatchNumber = match.Key;
                        importantMatchData.AutonomousHighMade = match.Value.AutonomousHigh
                                                                + match.Value.AutonomousHighHot;
                        importantMatchData.BallsDropped = match.Value.TeleOperatedBallsLost.GetValueOrDefault();
                        importantMatchData.Catches = match.Value.TeleOperatedCatch;
                        importantMatchData.HighGoals = match.Value.TeleOperatedHighGoal;
                        importantMatchData.HighGoalsAttempted = match.Value.TeleOperatedHighGoal
                                                                + match.Value.TeleOperatedHighGoalMiss;
                        importantMatchData.TeamNumber = team.Key;
                        importantMatchData.Possessions = match.Value.TeleOperatedPossessionBack
                                                         + match.Value.TeleOperatedPossessionFront
                                                         + match.Value.TeleOperatedPossessionMiddle;
                        importantMatchData.TrussesAttempted = match.Value.TeleOperatedTruss
                                                              + match.Value.TeleOperatedTrussFail;
                        importantMatchData.TrussesMade = match.Value.TeleOperatedTruss;

                        dbContext.Matches.Add(importantMatchData);
                        dbContext.SaveChanges();
                    }
                }
            }
        }