示例#1
0
        private void retrieveMatchData()
        {
            string        NAv511  = @"M:\Users\Maxi\Documents\Proyectos\Riot Games Contest\5.11\RANKED_SOLO\NA.json";
            string        NAv514  = @"M:\Users\Maxi\Documents\Proyectos\Riot Games Contest\5.14\RANKED_SOLO\NA.json";
            int           i       = 0;
            IList <Match> matches = new List <Match>();

            using (StreamReader reader = new StreamReader(NAv511))
            {
                var     textResponse = reader.ReadToEnd();
                dynamic dynObject    = JsonConvert.DeserializeObject(textResponse);
                foreach (var match in dynObject)
                {
                    Match m = Procedures.GetMatch(match.Value.ToString());
                    if (m != null)
                    {
                        using (var data = new Data.SqlData())
                        {
                            data.SaveMatch(m);
                            data.SaveApTimeline(m, "5.11");
                            data.SaveFinalStats(m, "5.11");
                            data.SaveRunePage(m);
                        }
                    }
                    i++;
                    Console.WriteLine("Patch 5.11: " + i);
                }
            }
            i = 0;
            using (StreamReader reader = new StreamReader(NAv514))
            {
                var     textResponse = reader.ReadToEnd();
                dynamic dynObject    = JsonConvert.DeserializeObject(textResponse);
                foreach (var match in dynObject)
                {
                    Match m = Procedures.GetMatch(match.Value.ToString());
                    if (m != null)
                    {
                        using (var data = new Data.SqlData())
                        {
                            data.SaveMatch(m);
                            data.SaveApTimeline(m, "5.14");
                            data.SaveFinalStats(m, "5.14");
                            data.SaveRunePage(m);
                        }
                    }
                    i++;
                    Console.WriteLine("Patch 5.14: " + i);
                }
            }
        }
示例#2
0
        private void SaveItemsInDB()
        {
            var items11 = Procedures.getItemsData("5.11.1");
            var items14 = Procedures.getItemsData("5.14.1");
            var champs  = Procedures.getChampionData();
            var runes   = Procedures.getRunesData();

            using (var data = new Data.SqlData())
            {
                data.SaveItems(items11, "5.11.1");
                data.SaveItems(items14, "5.14.1");
                data.SaveChampions(champs);
                data.SaveRunes(runes);
            }
            Console.ReadKey();
        }
示例#3
0
        private static void ProcessAverages()
        {
            var champs = Data.Entidades.Caches.ChampionsCache.Get();

            foreach (var champ in champs)
            {
                IList <ApTimeLine> timelines;
                using (var data = new Data.SqlData())
                {
                    timelines = data.GetTimelines(champ.Id);
                }

                var cleanTimelines = new List <ApTimeLine>();
                var matchgroups    = timelines.GroupBy(t => t.MatchId);
                int j = 0;
                foreach (var match in matchgroups)
                {
                    var participantgroups = match.OrderBy(m => m.Minute).GroupBy(m => m.PlayerId);
                    foreach (var player in participantgroups)
                    {
                        for (int i = 0; i < player.Count() - 1; i++)
                        {
                            cleanTimelines.Add(player.ElementAt(i));

                            while (player.ElementAt(i + 1).Minute > cleanTimelines.ElementAt(j).Minute + 1)
                            {
                                var newmin = new ApTimeLine(cleanTimelines.ElementAt(j));
                                newmin.Minute++;
                                cleanTimelines.Add(newmin);
                                j++;
                            }
                            j++;
                        }
                    }
                }

                var patchgroups = cleanTimelines.GroupBy(t => t.Patch);
                foreach (var patch in patchgroups)
                {
                    var rankgroups = patch.GroupBy(p => p.Rank);
                    foreach (var rank in rankgroups)
                    {
                        var rolegroups = rank.GroupBy(p => Data.Entidades.EnumHelpers.GetRealRoles(p.Role, p.Lane));
                        foreach (var role in rolegroups)
                        {
                            var minutegroups = role.OrderBy(m => m.Minute).GroupBy(t => t.Minute);
                            foreach (var minute in minutegroups)
                            {
                                var items = new List <Item>();
                                foreach (var match in minute)
                                {
                                    match.Items = Data.Entidades.Caches.ItemsCache.RemoveTrinkets(match.Items);
                                    foreach (var item in match.Items)
                                    {
                                        items.Add(item);
                                    }
                                }

                                var q = from x in items
                                        group x by x into g
                                        let count = g.Count()
                                                    orderby count descending
                                                    select new { Value = g.Key, Count = count };

                                var e = q.OrderByDescending(i => i.Count).Take(10);

                                var avgt = new AvgTimeLine();
                                avgt.Minute       = minute.Key;
                                avgt.ChampionId   = champ.Id;
                                avgt.AvgAp        = minute.Average(m => m.TotalAp);
                                avgt.AvgMr        = minute.Average(m => m.TotalMr);
                                avgt.Patch        = patch.Key;
                                avgt.AvgGoldSpent = (int)minute.Average(m => m.GoldSpent);
                                avgt.Rank         = rank.Key;
                                avgt.Role         = role.Key.ToString();
                                avgt.TotalGames   = minute.Count();
                                avgt.Items        = string.Join("|", e.Select(i => string.Format("{0}:{1}", i.Value.Id, i.Count)));
                                using (var data = new Data.SqlData())
                                {
                                    data.SaveAvgTimeLine(avgt);
                                }
                            }
                        }
                    }
                }
            }
        }
示例#4
0
        private static void ProcessAverages()
        {
            var champs = Data.Entidades.Caches.ChampionsCache.Get();
            foreach (var champ in champs)
            {
                IList<ApTimeLine> timelines;
                using (var data = new Data.SqlData())
                {
                    timelines = data.GetTimelines(champ.Id);
                }

                var cleanTimelines = new List<ApTimeLine>();
                var matchgroups = timelines.GroupBy(t => t.MatchId);
                int j = 0;
                foreach (var match in matchgroups)
                {
                    var participantgroups = match.OrderBy(m => m.Minute).GroupBy(m => m.PlayerId);
                    foreach (var player in participantgroups)
                    {
                        for (int i = 0; i < player.Count() - 1; i++)
                        {

                            cleanTimelines.Add(player.ElementAt(i));

                            while (player.ElementAt(i + 1).Minute > cleanTimelines.ElementAt(j).Minute + 1)
                            {
                                var newmin = new ApTimeLine(cleanTimelines.ElementAt(j));
                                newmin.Minute++;
                                cleanTimelines.Add(newmin);
                                j++;
                            }
                            j++;
                        }
                    }
                }

                var patchgroups = cleanTimelines.GroupBy(t => t.Patch);
                foreach (var patch in patchgroups)
                {
                    var rankgroups = patch.GroupBy(p => p.Rank);
                    foreach (var rank in rankgroups)
                    {
                        var rolegroups = rank.GroupBy(p => Data.Entidades.EnumHelpers.GetRealRoles(p.Role, p.Lane));
                        foreach (var role in rolegroups)
                        {
                            var minutegroups = role.OrderBy(m => m.Minute).GroupBy(t => t.Minute);
                            foreach (var minute in minutegroups)
                            {
                                var items = new List<Item>();
                                foreach (var match in minute)
                                {
                                    match.Items = Data.Entidades.Caches.ItemsCache.RemoveTrinkets(match.Items);
                                    foreach (var item in match.Items)
                                    {
                                        items.Add(item);
                                    }
                                }

                                var q = from x in items
                                        group x by x into g
                                        let count = g.Count()
                                        orderby count descending
                                        select new { Value = g.Key, Count = count };

                                var e = q.OrderByDescending(i => i.Count).Take(10);

                                var avgt = new AvgTimeLine();
                                avgt.Minute = minute.Key;
                                avgt.ChampionId = champ.Id;
                                avgt.AvgAp = minute.Average(m => m.TotalAp);
                                avgt.AvgMr = minute.Average(m => m.TotalMr);
                                avgt.Patch = patch.Key;
                                avgt.AvgGoldSpent = (int)minute.Average(m => m.GoldSpent);
                                avgt.Rank = rank.Key;
                                avgt.Role = role.Key.ToString();
                                avgt.TotalGames = minute.Count();
                                avgt.Items = string.Join("|", e.Select(i => string.Format("{0}:{1}", i.Value.Id, i.Count)));
                                using (var data = new Data.SqlData())
                                {
                                    data.SaveAvgTimeLine(avgt);
                                }
                            }
                        }
                    }
                }
            }
        }
示例#5
0
 private void SaveItemsInDB()
 {
     var items11 = Procedures.getItemsData("5.11.1");
     var items14 = Procedures.getItemsData("5.14.1");
     var champs = Procedures.getChampionData();
     var runes = Procedures.getRunesData();
     using (var data = new Data.SqlData())
     {
         data.SaveItems(items11, "5.11.1");
         data.SaveItems(items14, "5.14.1");
         data.SaveChampions(champs);
         data.SaveRunes(runes);
     }
     Console.ReadKey();
 }
示例#6
0
 private void retrieveMatchData()
 {
     string NAv511 = @"M:\Users\Maxi\Documents\Proyectos\Riot Games Contest\5.11\RANKED_SOLO\NA.json";
     string NAv514 = @"M:\Users\Maxi\Documents\Proyectos\Riot Games Contest\5.14\RANKED_SOLO\NA.json";
     int i = 0;
     IList<Match> matches = new List<Match>();
     using (StreamReader reader = new StreamReader(NAv511))
     {
         var textResponse = reader.ReadToEnd();
         dynamic dynObject = JsonConvert.DeserializeObject(textResponse);
         foreach (var match in dynObject)
         {
             Match m = Procedures.GetMatch(match.Value.ToString());
             if (m != null)
             {
                 using (var data = new Data.SqlData())
                 {
                     data.SaveMatch(m);
                     data.SaveApTimeline(m, "5.11");
                     data.SaveFinalStats(m, "5.11");
                     data.SaveRunePage(m);
                 }
             }
             i++;
             Console.WriteLine("Patch 5.11: " + i);
         }
     }
     i = 0;
     using (StreamReader reader = new StreamReader(NAv514))
     {
         var textResponse = reader.ReadToEnd();
         dynamic dynObject = JsonConvert.DeserializeObject(textResponse);
         foreach (var match in dynObject)
         {
             Match m = Procedures.GetMatch(match.Value.ToString());
             if (m != null)
             {
                 using (var data = new Data.SqlData())
                 {
                     data.SaveMatch(m);
                     data.SaveApTimeline(m, "5.14");
                     data.SaveFinalStats(m, "5.14");
                     data.SaveRunePage(m);
                 }
             }
             i++;
             Console.WriteLine("Patch 5.14: " + i);
         }
     }
 }