Пример #1
0
        public void SaveXlsToTxtTest()
        {
            var files = new[]
            {
                @"\..\..\..\..\..\Results\ResultsDuma\ОИК №1\Адыгейская\СИЗКСРФ\Адыгейская 2016",
                @"\..\..\..\..\..\Results\ResultsDuma\ОИК №1\Гиагинская\СИЗКСРФ\Гиагинская 2016",
                @"\..\..\..\..\..\Results\ResultsDuma\ОИК №1\Кошехабльская\СИЗКСРФ\Кошехабльская 2016",
            };

            using (var excellExtracter = new ExcellExtracter())
            {
                var dir = Path.GetDirectoryName(this.GetType().Assembly.Location);

                foreach (var file in files)
                {
                    var path = dir + file;
                    var txt  = path + ".txt";
                    var xls  = path + ".xls";

                    File.Delete(txt);
                    excellExtracter.SaveXlsToTxt(new FileInfo(xls));

                    Assert.IsTrue(File.Exists(txt));
                }
            }
        }
Пример #2
0
        private static void Main(string[] args)
        {
            switch (args[0])
            {
            case "1":
                new Download().GetHtmlFiles(args[1]);     //1 2018
                break;

            case "2":
                new Download().GetXlsFiles(args[1]);     //2 2016
                break;

            case "3":     //3 2016
                using (var excellExtracter = new ExcellExtracter())
                    excellExtracter.ExportXls(args[1]);
                break;

            case "4":
                new FinalXmlCreator().Start(args[1]);     //4 2016
                break;

            case "5":
                new BarChartPreparer(false).PrepareDrawAllDiagrams(Data.Core.Consts.Duma
                                                                   .Union(Data.Core.Consts.President).ToArray());
                break;

            case "6":
            {
                var sortByDelta = new SortByDelta();
                sortByDelta.StartDominantForIks(new[]
                    {
                        Consts.ElectionYear2018,
                        Consts.ElectionYear2016,
                        Consts.ElectionYear2012,
                        Consts.ElectionYear2011,
                        Consts.ElectionYear2008,
                        Consts.ElectionYear2007,
                        Consts.ElectionYear2004,
                        Consts.ElectionYear2003
                    });
                sortByDelta.StartDominantForRegions(new[]
                    {
                        Consts.ElectionYear2018,
                        Consts.ElectionYear2016,
                        Consts.ElectionYear2012,
                        Consts.ElectionYear2011,
                        Consts.ElectionYear2008,
                        Consts.ElectionYear2007,
                        Consts.ElectionYear2004,
                        Consts.ElectionYear2003
                    });
                break;
            }

            case "7":
            {
                var sbMain     = Html.GenerateHtmlMainTop();
                var sbGraphics = new StringBuilder();

                bool needOutput = true;

                Pair <string, string> res = null;

                var stopwatch = new Stopwatch();
                stopwatch.Start();

                var so = new SortByDelta();

                //2018
                res = so.Start(needOutput,
                               new[]
                    {
                        Consts.ElectionYear2004, Consts.ElectionYear2008, Consts.ElectionYear2012,
                        Consts.ElectionYear2018
                    },
                               Consts.ElectionYear2012, true);
                //res = new SortByDelta().Start(needOutput, new[] { Consts.ElectionYear2018 },null, true);
                sbMain.Append(res.First);
                sbGraphics.Append(res.Second);

                //2016
                res = so.Start(needOutput,
                               new[]
                    {
                        Consts.ElectionYear2003, Consts.ElectionYear2007, Consts.ElectionYear2011,
                        Consts.ElectionYear2016
                    },
                               Consts.ElectionYear2011, true);
                //res = new SortByDelta().Start(needOutput, new[] { Consts.ElectionYear2016 },null, true);
                sbMain.Append(res.First);
                sbGraphics.Append(res.Second);

                //2012
                res = so.Start(needOutput,
                               new[] { Consts.ElectionYear2004, Consts.ElectionYear2008, Consts.ElectionYear2012 },
                               Consts.ElectionYear2004, true);
                sbMain.Append(res.First);
                sbGraphics.Append(res.Second);

                //2011
                res = so.Start(needOutput, new[] { Consts.ElectionYear2007, Consts.ElectionYear2011 },
                               Consts.ElectionYear2007, true);
                sbMain.Append(res.First);
                sbGraphics.Append(res.Second);

                //2008
                res = so.Start(needOutput, new[] { Consts.ElectionYear2004, Consts.ElectionYear2008 }, null, false);
                sbMain.Append(res.First);
                sbGraphics.Append(res.Second);

                //2007
                res = so.Start(needOutput, new[] { Consts.ElectionYear2007 }, null, false);
                sbMain.Append(res.First);
                sbGraphics.Append(res.Second);

                //2004
                res = so.Start(needOutput, new[] { Consts.ElectionYear2004 }, null, false);
                sbMain.Append(res.First);
                sbGraphics.Append(res.Second);

                //2003
                res = so.Start(needOutput, new[] { Consts.ElectionYear2003 }, null, false);
                sbMain.Append(res.First);
                sbGraphics.Append(res.Second);

                Html.GenerateResult(Consts.UpdatePath, sbMain, sbGraphics);

                stopwatch.Stop();
                Trace.WriteLine(String.Format("Generated HTML-s {0}", stopwatch.Elapsed));
            }
            break;
            }
        }