Example #1
0
        static string StatisticData(StatisticService statService)
        {
            StatisticItem[] stat    = statService.All().Select(x => x.Statictic).ToArray();
            int             id      = 0;
            string          result  = "";
            string          result1 = "INSERT INTO Statistic(id,matches,wins,map_id,hero_id)\n";
            string          result2 = "VALUES (";

            for (int i = 0; i < stat.Length; i++)
            {
                for (int j = 0; j < stat[i].Matches.Length; j++, id++)
                {
                    int matches = stat[i].Matches[j];
                    int wins    = stat[i].Wins[j];
                    int mapId   = i;
                    int heroId  = j;
                    result += result1 + result2 +
                              $"{id},{matches},{wins},{mapId},{heroId}" + ");\n";
                }
            }

            return(result);
        }