Exemplo n.º 1
0
        static void Main()
        {
            // QueryElement Objects
            List <QueryElement> queryElements = QueryElementList.GetList();

            // QueryResultTable Objects
            List <QueryResultTable> queryResultTables = QueryResultTableList.GetList();

            // Start Timer
            Stopwatch stopWatch = new Stopwatch();

            stopWatch.Start();

            ////////////////////////////////////
            /// Place your answer after this section
            ///////////////////////////////////

            Hashtable hashtable = new Hashtable();

            for (int i = 0; i < queryElements.Count; i++)
            {
                var element = queryElements[i];
                var getProp = typeof(QueryResultTable).GetProperty("column" + element.Index);
                hashtable.Add(element.Index, getProp);
            }
            int value;
            var group = queryResultTables.GroupBy(x => x.perfdate);

            Parallel.ForEach(group, new ParallelOptions {
                MaxDegreeOfParallelism = Convert.ToInt32(Math.Ceiling((Environment.ProcessorCount * 0.75) * 1.0))
            },
                             index =>
            {
                foreach (var item in queryElements)
                {
                    PropertyInfo colPro = (PropertyInfo)hashtable[item.Index];
                    switch (item.Aggregate)
                    {
                    case AggregateType.sum:
                        var total = index.Sum(s => int.TryParse(colPro?.GetValue(s).ToString(), out value) ? value : 0);
                        colPro.SetValue(index.First(), total.ToString());
                        break;

                    case AggregateType.avg:
                        var avg = index.Average(s => int.TryParse(colPro?.GetValue(s).ToString(), out value) ? value : 0);
                        colPro.SetValue(index.First(), avg.ToString());
                        break;

                    case AggregateType.max:
                        var max = index.Max(s => int.TryParse(colPro?.GetValue(s).ToString(), out value) ? value : 0);
                        colPro.SetValue(index.First(), max.ToString());
                        break;

                    case AggregateType.min:
                        var min = index.Min(s => int.TryParse(colPro?.GetValue(s).ToString(), out value) ? value : 0);
                        colPro.SetValue(index.First(), min.ToString());
                        break;

                    default:
                        break;
                    }
                }
            });
            ////////////////////////////////////
            /// Place your answer before this section
            ///////////////////////////////////

            // Stop Timer
            stopWatch.Stop();

            // Get the elapsed time as a TimeSpan value.
            TimeSpan ts = stopWatch.Elapsed;

            // Format and display the TimeSpan value.
            string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
                                               ts.Hours, ts.Minutes, ts.Seconds,
                                               ts.Milliseconds / 10);

            ////////////////////////////
            // Data Validation
            ////////////////////////////

            if (queryResultTables[0].column1 != "800")
            {
                Console.WriteLine("ERROR IN CALCULATION for column1!");
            }

            if (queryResultTables[0].column2 != "160")
            {
                Console.WriteLine("ERROR IN CALCULATION for column2!");
            }

            if (queryResultTables[0].column3 != "180")
            {
                Console.WriteLine("ERROR IN CALCULATION for column3!");
            }

            if (queryResultTables[0].column4 != "320")
            {
                Console.WriteLine("ERROR IN CALCULATION for column4!");
            }

            if (queryResultTables[0].column5 != "780")
            {
                Console.WriteLine("ERROR IN CALCULATION for column5!");
            }

            if (queryResultTables[0].column6 != "15")
            {
                Console.WriteLine("ERROR IN CALCULATION for column6!");
            }

            Console.WriteLine("Execution duration: " + elapsedTime);

            Thread.Sleep(10000);
        }
Exemplo n.º 2
0
        static void Main()
        {
            // QueryElement Objects
            List <QueryElement> queryElements = QueryElementList.GetList();

            // QueryResultTable Objects
            List <QueryResultTable> queryResultTables = QueryResultTableList.GetList();

            // Start Timer
            Stopwatch stopWatch = new Stopwatch();

            stopWatch.Start();

            ////////////////////////////////////
            /// Place your answer after this section
            ///////////////////////////////////

            var type       = typeof(QueryResultTable);
            var accessor   = TypeAccessor.Create(type);
            var properties = accessor.GetMembers();

            var propertyQueryElements = properties.Join(queryElements, property => property.Name, queryElement => $"column{queryElement.Index}", (property, queryElement) => new { property = property.Name, aggregate = queryElement.Aggregate }).ToList();

            queryResultTables.AsEnumerable().AsParallel().GroupBy(x => x.perfdate, (_, groups) =>
            {
                var first = groups.FirstOrDefault();
                foreach (var propertyQueryElement in propertyQueryElements)
                {
                    var aggregate       = propertyQueryElement.aggregate;
                    var property        = propertyQueryElement.property;
                    var sourceAsIntList = groups.Where(x => accessor[x, property] != null && !string.IsNullOrWhiteSpace(accessor[x, property].ToString())).Select(x => Convert.ToInt32(accessor[x, property]));

                    if (aggregate == Enums.AggregateType.avg)
                    {
                        accessor[first, property] = sourceAsIntList.Average().ToString();
                    }
                    if (aggregate == Enums.AggregateType.max)
                    {
                        accessor[first, property] = sourceAsIntList.Max().ToString();
                    }
                    if (aggregate == Enums.AggregateType.min)
                    {
                        accessor[first, property] = sourceAsIntList.Min().ToString();
                    }
                    if (aggregate == Enums.AggregateType.sum)
                    {
                        accessor[first, property] = sourceAsIntList.Sum().ToString();
                    }
                }
                return(first);
            }
                                                                  ).ToList();

            ////////////////////////////////////
            /// Place your answer before this section
            ///////////////////////////////////

            // Stop Timer
            stopWatch.Stop();

            // Get the elapsed time as a TimeSpan value.
            TimeSpan ts = stopWatch.Elapsed;

            // Format and display the TimeSpan value.
            string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
                                               ts.Hours, ts.Minutes, ts.Seconds,
                                               ts.Milliseconds / 10);

            ////////////////////////////
            // Data Validation
            ////////////////////////////

            if (queryResultTables[0].column1 != "800")
            {
                Console.WriteLine("ERROR IN CALCULATION for column1!");
            }

            if (queryResultTables[0].column2 != "160")
            {
                Console.WriteLine("ERROR IN CALCULATION for column2!");
            }

            if (queryResultTables[0].column3 != "180")
            {
                Console.WriteLine("ERROR IN CALCULATION for column3!");
            }

            if (queryResultTables[0].column4 != "320")
            {
                Console.WriteLine("ERROR IN CALCULATION for column4!");
            }

            if (queryResultTables[0].column5 != "780")
            {
                Console.WriteLine("ERROR IN CALCULATION for column5!");
            }

            if (queryResultTables[0].column6 != "15")
            {
                Console.WriteLine("ERROR IN CALCULATION for column6!");
            }

            Console.WriteLine("Execution duration: " + elapsedTime);

            Thread.Sleep(10000);
        }
Exemplo n.º 3
0
        static void Main()
        {
            // QueryElement Objects
            List <QueryElement> queryElements = QueryElementList.GetList();

            // QueryResultTable Objects
            List <QueryResultTable> queryResultTables = QueryResultTableList.GetList();

            // Start Timer
            Stopwatch stopWatch = new Stopwatch();

            stopWatch.Start();

            ////////////////////////////////////
            /// Place your answer after this section
            ///////////////////////////////////



            ////////////////////////////////////
            /// Place your answer before this section
            ///////////////////////////////////

            // Stop Timer
            stopWatch.Stop();

            // Get the elapsed time as a TimeSpan value.
            TimeSpan ts = stopWatch.Elapsed;

            // Format and display the TimeSpan value.
            string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
                                               ts.Hours, ts.Minutes, ts.Seconds,
                                               ts.Milliseconds / 10);

            ////////////////////////////
            // Data Validation
            ////////////////////////////

            if (queryResultTables[0].column1 != "800")
            {
                Console.WriteLine("ERROR IN CALCULATION for column1!");
            }

            if (queryResultTables[0].column2 != "160")
            {
                Console.WriteLine("ERROR IN CALCULATION for column2!");
            }

            if (queryResultTables[0].column3 != "180")
            {
                Console.WriteLine("ERROR IN CALCULATION for column3!");
            }

            if (queryResultTables[0].column4 != "320")
            {
                Console.WriteLine("ERROR IN CALCULATION for column4!");
            }

            if (queryResultTables[0].column5 != "780")
            {
                Console.WriteLine("ERROR IN CALCULATION for column5!");
            }

            if (queryResultTables[0].column6 != "15")
            {
                Console.WriteLine("ERROR IN CALCULATION for column6!");
            }

            Console.WriteLine("Execution duration: " + elapsedTime);

            Thread.Sleep(10000);
        }