/// <summary>
///
/// </summary>
/// <param name="categoryGroup"></param>
/// <param name="q"></param>
private void AddQuestionToStructure(MergeStructure enchilada, List <MergeCategory> categoryGroup, MergeQuestion q)
{
// if the answers agree, don't include it
if (q.SourceAnswers.Select(x => x.AnswerText).Distinct().Count() == 1)
{
return;
}
MergeCategory cat = categoryGroup.Where(x => x.Category == q.CategoryText).FirstOrDefault();
if (cat == null)
{
cat = new MergeCategory();
cat.Category = q.CategoryText;
categoryGroup.Add(cat);
}
cat.Questions.Add(q);
cat.Questions = cat.Questions.OrderBy(x => x.QuestionText).ToList();
}
/// <summary>
///
/// </summary>
public MergeStructure GetAnswers(List <int> mergeCandidates)
{
if (mergeCandidates.Count == 0)
{
return(null);
}
MergeStructure mergeResponse = new MergeStructure
{
MergeID = Guid.NewGuid()
};
Dictionary <int, MergeQuestion> QuestionDictionary = new Dictionary <int, MergeQuestion>();
using (var db = new CSET_Context())
{
// this is probably unnecessary because we just barely created the new merge ID
var previousCombinedAnswers = db.COMBINED_ANSWER.Where(x => x.Merge_ID == mergeResponse.MergeID).ToList();
db.COMBINED_ANSWER.RemoveRange(previousCombinedAnswers);
db.SaveChanges();
for (int i = 0; i < mergeCandidates.Count; i++)
{
int assessmentID = mergeCandidates[i];
var myAnswers = RelevantAnswers.GetAnswersForAssessment(assessmentID);
foreach (var a in myAnswers)
{
MergeQuestion mq = null;
if (QuestionDictionary.ContainsKey(a.Question_Or_Requirement_ID))
{
mq = QuestionDictionary[a.Question_Or_Requirement_ID];
}
else
{
var query1 = from nq in db.NEW_QUESTION
join usch in db.UNIVERSAL_SUB_CATEGORY_HEADINGS on nq.Heading_Pair_Id equals usch.Heading_Pair_Id
join qgh in db.QUESTION_GROUP_HEADING on usch.Question_Group_Heading_Id equals qgh.Question_Group_Heading_Id
where nq.Question_Id == a.Question_Or_Requirement_ID
select new { nq, qgh };
var q = query1.FirstOrDefault();
if (q == null)
{
continue;
}
mq = new MergeQuestion(mergeCandidates.Count);
mq.CategoryID = (int)q.qgh.Question_Group_Heading_Id;
mq.CategoryText = q.qgh.Question_Group_Heading1;
mq.QuestionID = q.nq.Question_Id;
mq.QuestionText = q.nq.Simple_Question;
}
mq.Is_Component = a.Is_Component;
var sourceAnswer = mq.SourceAnswers[i];
sourceAnswer.SourceAnswerID = a.Answer_ID;
sourceAnswer.AnswerText = a.Answer_Text == "U" ? "" : a.Answer_Text;
sourceAnswer.AlternateJustification = a.Alternate_Justification;
sourceAnswer.Comment = a.Comment;
QuestionDictionary[a.Question_Or_Requirement_ID] = mq;
// at this point we should probably build the COMBINED_ANSWER record, but only
// if one has not been built for this answer.
var ca = db.COMBINED_ANSWER.Where(x => x.Merge_ID == mergeResponse.MergeID && x.Question_Or_Requirement_Id == a.Question_Or_Requirement_ID).FirstOrDefault();
if (ca == null && a.Answer_Text != "U" && a.Answer_Text != "")
{
ca = new COMBINED_ANSWER()
{
Merge_ID = mergeResponse.MergeID,
Mark_For_Review = a.Mark_For_Review,
Comment = a.Comment,
Alternate_Justification = a.Alternate_Justification,
Question_Or_Requirement_Id = a.Question_Or_Requirement_ID,
Custom_Question_Guid = a.Custom_Question_Guid,
Answer_Text = a.Answer_Text,
Component_Guid = a.Component_Guid,
Is_Component = a.Is_Component
// Is_Resolved
// Type_Question
};
db.COMBINED_ANSWER.Add(ca);
db.SaveChanges();
mq.CombinedAnswerID = ca.AnswerID;
}
}
}
// sort the questions into their appropriate lists/categories
foreach (MergeQuestion q in QuestionDictionary.Values)
{
SetDefaultAnswer(q);
if (!q.Is_Component)
{
AddQuestionToStructure(mergeResponse, mergeResponse.QuestionsCategories, q);
}
else
{
if (q.SourceAnswers.Exists(x => x.ComponentGuid != Guid.Empty.ToString()))
{
AddQuestionToStructure(mergeResponse, mergeResponse.ComponentOverrideCategories, q);
}
else
{
AddQuestionToStructure(mergeResponse, mergeResponse.ComponentDefaultCategories, q);
}
}
}
mergeResponse.QuestionsCategories = mergeResponse.QuestionsCategories.OrderBy(x => x.Category).ToList();
mergeResponse.ComponentDefaultCategories = mergeResponse.ComponentDefaultCategories.OrderBy(x => x.Category).ToList();
mergeResponse.ComponentOverrideCategories = mergeResponse.ComponentOverrideCategories.OrderBy(x => x.Category).ToList();
}
// remove any empty categories
mergeResponse.QuestionsCategories.RemoveAll(x => x.Questions.Count() == 0);
mergeResponse.ComponentDefaultCategories.RemoveAll(x => x.Questions.Count() == 0);
mergeResponse.ComponentOverrideCategories.RemoveAll(x => x.Questions.Count() == 0);
return(mergeResponse);
}
