Ejemplo n.º 1
0
        /// <summary>
        /// Assembles a response consisting of maturity settings for the assessment
        /// as well as the question set in its hierarchy of domains, practices, etc.
        /// </summary>
        /// <param name="assessmentId"></param>
        public MaturityResponse GetMaturityQuestions(int assessmentId, bool isAcetInstallation, bool fill)
        {
            var response = new MaturityResponse();

            using (var db = new CSET_Context())
            {
                if (fill)
                {
                    db.FillEmptyMaturityQuestionsForAnalysis(assessmentId);
                }

                var myModel = ProcessModelDefaults(db, assessmentId, isAcetInstallation);


                var myModelDefinition = db.MATURITY_MODELS.Where(x => x.Maturity_Model_Id == myModel.model_id).FirstOrDefault();

                if (myModelDefinition == null)
                {
                    return(response);
                }


                response.ModelName = myModelDefinition.Model_Name;

                response.QuestionsAlias = myModelDefinition.Questions_Alias ?? "Questions";


                if (myModelDefinition.Answer_Options != null)
                {
                    response.AnswerOptions = myModelDefinition.Answer_Options.Split(',').ToList();
                    response.AnswerOptions.ForEach(x => x = x.Trim());
                }


                response.MaturityTargetLevel = this.GetMaturityTargetLevel(assessmentId, db);

                if (response.ModelName == "ACET")
                {
                    response.OverallIRP          = new ACETDashboardManager().GetOverallIrpNumber(assessmentId);
                    response.MaturityTargetLevel = response.OverallIRP;
                }


                // get the levels and their display names for this model
                response.Levels = this.GetMaturityLevelsForModel(myModel.model_id, response.MaturityTargetLevel, db);



                // Get all maturity questions for the model regardless of level.
                // The user may choose to see questions above the target level via filtering.
                var questions = db.MATURITY_QUESTIONS
                                .Include(x => x.Maturity_LevelNavigation)
                                .Where(q =>
                                       myModel.model_id == q.Maturity_Model_Id).ToList();


                // Get all MATURITY answers for the assessment
                var answers = from a in db.ANSWER.Where(x => x.Assessment_Id == assessmentId && x.Question_Type == "Maturity")
                              from b in db.VIEW_QUESTIONS_STATUS.Where(x => x.Answer_Id == a.Answer_Id).DefaultIfEmpty()
                              select new FullAnswer()
                {
                    a = a, b = b
                };


                // Get all subgroupings for this maturity model
                var allGroupings = db.MATURITY_GROUPINGS
                                   .Include(x => x.Type)
                                   .Where(x => x.Maturity_Model_Id == myModel.model_id).ToList();


                // Recursively build the grouping/question hierarchy
                var tempModel = new MaturityGrouping();
                BuildSubGroupings(tempModel, null, allGroupings, questions, answers.ToList());

                //GRAB all the domain remarks and assign them if necessary
                Dictionary <int, MATURITY_DOMAIN_REMARKS> domainRemarks =
                    db.MATURITY_DOMAIN_REMARKS.Where(x => x.Assessment_Id == assessmentId)
                    .ToDictionary(x => x.Grouping_ID, x => x);
                foreach (MaturityGrouping g in tempModel.SubGroupings)
                {
                    MATURITY_DOMAIN_REMARKS dm;
                    if (domainRemarks.TryGetValue(g.GroupingID, out dm))
                    {
                        g.DomainRemark = dm.DomainRemarks;
                    }
                }

                response.Groupings = tempModel.SubGroupings;


                // Add any glossary terms
                response.Glossary = this.GetGlossaryEntries(myModel.model_id);
            }

            return(response);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Recursive method that builds subgroupings for the specified group.
        /// It also attaches any questions pertinent to this group.
        /// </summary>
        private void BuildSubGroupings(MaturityGrouping g, int?parentID,
                                       List <MATURITY_GROUPINGS> allGroupings,
                                       List <MATURITY_QUESTIONS> questions,
                                       List <FullAnswer> answers)
        {
            var mySubgroups = allGroupings.Where(x => x.Parent_Id == parentID).OrderBy(x => x.Sequence).ToList();

            if (mySubgroups.Count == 0)
            {
                return;
            }

            foreach (var sg in mySubgroups)
            {
                var newGrouping = new MaturityGrouping()
                {
                    GroupingID   = sg.Grouping_Id,
                    GroupingType = sg.Type.Grouping_Type_Name,
                    Title        = sg.Title,
                    Description  = sg.Description,
                    Abbreviation = sg.Abbreviation
                };


                g.SubGroupings.Add(newGrouping);


                // are there any questions that belong to this grouping?
                var myQuestions = questions.Where(x => x.Grouping_Id == newGrouping.GroupingID).ToList();

                var parentQuestionIDs = myQuestions.Select(x => x.Parent_Question_Id).Distinct().ToList();

                foreach (var myQ in myQuestions)
                {
                    FullAnswer answer = answers.Where(x => x.a.Question_Or_Requirement_Id == myQ.Mat_Question_Id).FirstOrDefault();

                    var qa = new QuestionAnswer()
                    {
                        DisplayNumber     = myQ.Question_Title,
                        QuestionId        = myQ.Mat_Question_Id,
                        ParentQuestionId  = myQ.Parent_Question_Id,
                        Sequence          = myQ.Sequence,
                        QuestionType      = "Maturity",
                        QuestionText      = myQ.Question_Text.Replace("\r\n", "<br/>").Replace("\n", "<br/>").Replace("\r", "<br/>"),
                        Answer            = answer?.a.Answer_Text,
                        AltAnswerText     = answer?.a.Alternate_Justification,
                        Comment           = answer?.a.Comment,
                        Feedback          = answer?.a.Feedback,
                        MarkForReview     = answer?.a.Mark_For_Review ?? false,
                        Reviewed          = answer?.a.Reviewed ?? false,
                        Is_Maturity       = true,
                        MaturityLevel     = myQ.Maturity_LevelNavigation.Level,
                        MaturityLevelName = myQ.Maturity_LevelNavigation.Level_Name,
                        IsParentQuestion  = parentQuestionIDs.Contains(myQ.Mat_Question_Id),
                        SetName           = string.Empty
                    };

                    if (answer != null)
                    {
                        TinyMapper.Bind <VIEW_QUESTIONS_STATUS, QuestionAnswer>();
                        TinyMapper.Map(answer.b, qa);
                    }

                    newGrouping.Questions.Add(qa);
                }

                newGrouping.Questions.Sort((a, b) => a.Sequence.CompareTo(b.Sequence));

                // Recurse down to build subgroupings
                BuildSubGroupings(newGrouping, newGrouping.GroupingID, allGroupings, questions, answers);
            }
        }
Ejemplo n.º 3
0
        public List <MatAnsweredQuestionDomain> getAnsweredQuestionList(int assessmentId)
        {
            List <BasicReportData.RequirementControl> controls = new List <BasicReportData.RequirementControl>();

            //select* from ANSWER a
            //join MATURITY_QUESTIONS q on a.Question_Or_Requirement_Id = q.Mat_Question_Id
            //where a.Assessment_Id = 2357 and a.question_type = 'Maturity' and a.Answer_Text = 'N'
            using (var db = new CSET_Context())
            {
                var myModel = db.AVAILABLE_MATURITY_MODELS
                              .Include(x => x.model_)
                              .Where(x => x.Assessment_Id == assessmentId).FirstOrDefault();

                var questions = db.MATURITY_QUESTIONS.Where(q =>
                                                            myModel.model_id == q.Maturity_Model_Id).ToList();


                // Get all MATURITY answers for the assessment
                var answers = from a in db.ANSWER.Where(x => x.Assessment_Id == assessmentId && x.Question_Type == "Maturity")
                              from b in db.VIEW_QUESTIONS_STATUS.Where(x => x.Answer_Id == a.Answer_Id).DefaultIfEmpty()
                              select new FullAnswer()
                {
                    a = a, b = b
                };


                // Get all subgroupings for this maturity model
                var allGroupings = db.MATURITY_GROUPINGS
                                   .Include(x => x.Type)
                                   .Where(x => x.Maturity_Model_Id == myModel.model_id).ToList();


                // Recursively build the grouping/question hierarchy
                var questionGrouping = new MaturityGrouping();
                BuildSubGroupings(questionGrouping, null, allGroupings, questions, answers.ToList());

                var maturityDomains = new List <MatAnsweredQuestionDomain>();

                // ToDo: Refactor the following stucture of loops
                foreach (var domain in questionGrouping.SubGroupings)
                {
                    var newDomain = new MatAnsweredQuestionDomain()
                    {
                        Title             = domain.Title,
                        AssessmentFactors = new List <MaturityAnsweredQuestionsAssesment>()
                    };
                    foreach (var assesmentFactor in domain.SubGroupings)
                    {
                        var newAssesmentFactor = new MaturityAnsweredQuestionsAssesment()
                        {
                            Title      = assesmentFactor.Title,
                            Components = new List <MaturityAnsweredQuestionsComponent>()
                        };

                        foreach (var componenet in assesmentFactor.SubGroupings)
                        {
                            var newComponent = new MaturityAnsweredQuestionsComponent()
                            {
                                Title     = componenet.Title,
                                Questions = new List <MaturityAnsweredQuestions>()
                            };

                            foreach (var question in componenet.Questions)
                            {
                                if (question.Answer != null)
                                {
                                    var newQuestion = new MaturityAnsweredQuestions()
                                    {
                                        Title        = question.DisplayNumber,
                                        QuestionText = question.QuestionText,
                                        AnswerText   = question.Answer,
                                    };

                                    if (question.Comment != null)
                                    {
                                        newQuestion.Comments = "Yes";
                                    }
                                    else
                                    {
                                        newQuestion.Comments = "No";
                                    }


                                    if (question.MaturityLevel == 6)
                                    {
                                        newQuestion.MaturityLevel = "ADV";
                                    }
                                    else if (question.MaturityLevel == 7)
                                    {
                                        newQuestion.MaturityLevel = "B";
                                    }
                                    else if (question.MaturityLevel == 8)
                                    {
                                        newQuestion.MaturityLevel = "E";
                                    }
                                    else if (question.MaturityLevel == 9)
                                    {
                                        newQuestion.MaturityLevel = "INN";
                                    }
                                    else if (question.MaturityLevel == 10)
                                    {
                                        newQuestion.MaturityLevel = "INT";
                                    }
                                    else
                                    {
                                        newQuestion.MaturityLevel = "";
                                    }
                                    newComponent.Questions.Add(newQuestion);
                                }
                            }
                            if (newComponent.Questions.Count > 0)
                            {
                                newAssesmentFactor.Components.Add(newComponent);
                            }
                        }
                        if (newAssesmentFactor.Components.Count > 0)
                        {
                            newDomain.AssessmentFactors.Add(newAssesmentFactor);
                        }
                    }
                    if (newDomain.AssessmentFactors.Count > 0)
                    {
                        maturityDomains.Add(newDomain);
                    }
                }

                return(maturityDomains);
            }
        }