private void Init()
{
Name = string.Empty;
QuestionType = string.Empty;
Year = "2017";
AnswerYesNo = string.Empty;
AnswerFreeForm = string.Empty;
QuestionChildrenList = new List <QuestionChildModel>();
SectionsListModel = new QuestionSectionsListModel();
}
public void Get(System.Web.HttpContext pContext)
{
const string YES = "Yes";
var lCookieData = CookieManagement.GetCookie(pContext);
/* BUG found by Negmat. If user changes book this isn't getting updated.
* Added ResetDynamicValues method to reset AvgVerifiedCircPercent and Genre values in case the user was
* previously working with another book in the same session. */
ResetDynamicValues();
using (Loreal_DEVEntities3 db = new Loreal_DEVEntities3())
{
var questionsList = new List <QuestionModel>();
var IsDynamic = false;
// Get the Questions from the database.
var lQuestions = db.GetAnswers(lCookieData.Year, lCookieData.BookID, lCookieData.VersionID)
.OrderBy(q => q.SectionOrder)
.ThenBy(q => q.SubSectionOrder)
.ThenBy(q => q.SubSectionToQuestionOrder)
.ToList();
var IsParent = false;
var newSectionList = new QuestionSectionsListModel();
var newSection = new QuestionSectionModel();
var newSubSection = new QuestionSubSectionModel();
var newQuestion = new QuestionModel();
var newChildQuestion = new QuestionChildModel();
var QuestName = string.Empty;
var SubSecName = string.Empty;
var SecName = string.Empty;
var recordCount = 0;
var recordTotal = lQuestions.Count;
/* Data is ordered so that the first item in the collection should be a Question (as opposed to a child question.
* This means the first record will contain:
* 1. A new Section
* 2. A new SubSection
* 3. A new Question
* All subsequent records may either be contained within an existing Question, SubSection and/or Section.
* Thus the way this is structured below. */
foreach (var question in lQuestions)
{
recordCount++;
// We work our way out from Child Question to Section.
IsParent = question.IsTopLevel == YES ? true : false;
/* If the current Question is a Parent and there is a previous Question we now add it to the Question List.
* (Otherwise, the current question is a Child question and we will continue to add Children to the question
* until the next Parent question. */
if ((IsParent && newQuestion.ID > 0) || (!IsParent && SubSecName != question.SubSection))
{
newSubSection.QuestionList.Add(newQuestion);
}
// If the Section is new the SubSection and Question are, by default, new as well.
if (String.IsNullOrEmpty(SecName) || (SecName != question.Section))
{
if (!String.IsNullOrEmpty(SecName))
{
// First add the existing SubSection to the existing Section
newSection.SubSectionList.Add(newSubSection);
// Add the existing Section to the SectionList prior to creating the new Section.
newSectionList.SectionList.Add(newSection);
}
newSection = new QuestionSectionModel
{
ID = question.SectionID,
Name = question.Section,
Order = question.SectionOrder
};
SecName = question.Section;
newSubSection = new QuestionSubSectionModel
{
ID = question.SubSectionID,
Name = question.SubSection,
Order = question.SubSectionOrder
};
SubSecName = question.SubSection;
}
else if (SecName == question.Section && (SubSecName != question.SubSection))
{
// First, add the existing SubSection to the Section.
newSection.SubSectionList.Add(newSubSection);
newSubSection = new QuestionSubSectionModel
{
ID = question.SubSectionID,
Name = question.SubSection,
Order = question.SubSectionOrder
};
SubSecName = question.SubSection;
}
// Question/Child question
if (!IsParent)
{
IsDynamic = (question.QuestionType == DYNSTATEMENT || question.QuestionType == DYNYESNO);
// Resolve Dynamic Questions
if (IsDynamic)
{
// Temp for testing
var lBookID = lCookieData.BookID == null ? 8 : lCookieData.BookID;
if (String.IsNullOrEmpty(Dynamic.AvgVerifiedCircPercent))
{
GetDynamicValues(lBookID, lCookieData.Year);
}
QuestName = DynamicQuestion(question.Question);
}
else
{
QuestName = question.Question;
}
newChildQuestion = new QuestionChildModel
{
ID = question.QuestionID,
ParentID = question.ParentQuestionID,
Name = QuestName,
QuestionType = question.QuestionType,
AnswerType = question.AnswerType,
AnswerYesNo = question.AnswerYesNo,
AnswerFreeForm = question.AnswerFreeForm
};
newQuestion.QuestionChildrenList.Add(newChildQuestion);
}
else
{
IsDynamic = (question.QuestionType == DYNSTATEMENT || question.QuestionType == DYNYESNO);
// Resolve Dynamic Questions
if (IsDynamic)
{
// Temp for testing
var lBookID = lCookieData.BookID == null ? 8 : lCookieData.BookID;
if (String.IsNullOrEmpty(Dynamic.AvgVerifiedCircPercent))
{
GetDynamicValues(lBookID, lCookieData.Year);
}
QuestName = DynamicQuestion(question.Question);
}
else
{
QuestName = question.Question;
}
newQuestion = new QuestionModel
{
ID = question.QuestionID,
Order = question.SubSectionToQuestionOrder,
Name = QuestName,
QuestionType = question.QuestionType,
AnswerYesNo = question.AnswerYesNo,
AnswerFreeForm = question.AnswerFreeForm
};
}
// Insert final question.
if (recordCount == recordTotal)
{
// Is this a child question?
if (IsParent && newQuestion.ID > 0)
{
newSubSection.QuestionList.Add(newQuestion);
}
else
{
newSubSection.QuestionList.Add(newQuestion);
}
// Add final question to SubSection and Section Lists.
newSection.SubSectionList.Add(newSubSection);
newSectionList.SectionList.Add(newSection);
SectionsListModel = newSectionList;
}
}
}
}
