Example #1
0
        public ChartData GetOverallRankedCategories()
        {
            int       assessmentId = Auth.AssessmentForUser();
            ChartData chartData    = null;

            using (CSET_Context context = new CSET_Context())
            {
                var results = new RankedCategoriesMultiResult();
                context.LoadStoredProc("[usp_GetOverallRankedCategoriesPage]")
                .WithSqlParam("assessment_id", assessmentId)
                .ExecuteStoredProc((handler) =>
                {
                    results.Result1 = handler.ReadToList <usp_getRankedCategories>().ToList();
                });


                if (results.Count >= 1)
                {
                    List <double> data        = new List <double>();
                    ChartData     overallBars = new ChartData()
                    {
                        backgroundColor = "red",
                        borderWidth     = "1",
                        label           = "Overall Ranked Categories",
                        data            = data
                    };

                    chartData          = new ChartData();
                    chartData.DataRows = new List <DataRows>();
                    int i = 1;
                    foreach (usp_getRankedCategories c in results.Result1)
                    {
                        chartData.data.Add((double)(c.prc ?? 0));
                        chartData.Labels.Add(c.Question_Group_Heading);

                        chartData.DataRows.Add(new DataRows()
                        {
                            failed  = (c.nuCount ?? 0),
                            percent = (c.prc ?? 0),
                            total   = (c.qc ?? 0),
                            title   = c.Question_Group_Heading,
                            rank    = i++
                        });
                    }
                }
            }

            return(chartData);
        }
Example #2
0
        public ChartData GetTopCategories([FromUri] int?total)
        {
            if (total == null)
            {
                total = 10000;
            }

            int       assessmentId = Auth.AssessmentForUser();
            ChartData chartData    = null;

            using (CSET_Context context = new CSET_Context())
            {
                var results = new RankedCategoriesMultiResult();
                context.LoadStoredProc("[usp_GetRankedCategoriesPage]")
                .WithSqlParam("assessment_id", assessmentId)
                .ExecuteStoredProc((handler) =>
                {
                    results.Result1 = handler.ReadToList <usp_getRankedCategories>().ToList();
                });


                if (results.Count >= 1)
                {
                    List <double> data        = new List <double>();
                    ChartData     overallBars = new ChartData()
                    {
                        backgroundColor = "red",
                        borderWidth     = "1",
                        label           = "Overall Ranked Categories",
                        data            = data
                    };

                    chartData = new ChartData();
                    foreach (usp_getRankedCategories c in results.Result1.Take((int)total))
                    {
                        chartData.data.Add((double)c.prc);
                        chartData.Labels.Add(c.Question_Group_Heading);
                    }
                }
            }

            return(chartData);
        }