public static VMSection SectionGet()
{
using (PHDB db = new PHDB())
{
VMSection s = new VMSection();
s.Section1 = db.Section1.Select(p => p.section1).ToList();
s.Section2 = db.Section2.Select(p => p.section2).ToList();
s.Section3 = db.Section3.Select(p => p.section3).ToList();
s.Section4 = db.Section4.Select(p => p.section4).ToList();
s.Section5 = db.Section5.Select(p => p.section5).ToList();
s.Section6 = db.Section6.Select(p => p.section6).ToList();
s.Section7 = db.Section7.Select(p => p.section7).ToList();
s.Section8 = db.Section8.Select(p => p.section8).ToList();
s.Section9 = db.Section9.Select(p => p.section9).ToList();
s.Section10 = db.Section10.Select(p => p.section10).ToList();
s.Section11 = db.Section11.Select(p => p.section11).ToList();
s.Section12 = db.Section12.Select(p => p.section12).ToList();
s.Section13 = db.Section13.Select(p => p.section13).ToList();
s.Section14 = db.Section14.Select(p => p.section14).ToList();
s.Section15 = db.Section15.Select(p => p.section15).ToList();
return(s);
}
}
public VMTestPage GetQuizData(string language = "en", string attemptId = "")
{
bool isHindi = false;
if ("hi".Equals(language, StringComparison.OrdinalIgnoreCase))
{
isHindi = true;
}
var testData = _db.GetAllQuestions(_questionDbFileName);
VMTestPage data = new VMTestPage();
data.AttemptId = attemptId;
data.QuizId = quiz.ID;
data.Sections = new List <VMSection>();
var sections = testData.Select(P => { P.SECTION_NAME = P.SECTION_NAME.ToUpper(); return(P); }).GroupBy(P => P.SECTION_NAME).Select(P => P).ToList();
int sectionSeq = 0;
foreach (var item in sections)
{
VMSection section = new VMSection();
section.Id = Guid.NewGuid().ToString();
section.Name = item.Key;
section.SeqNo = sectionSeq;
section.QuestionCount = item.Count();
section.Questions = new List <VMQuestion>();
int questionSeq = 0;
foreach (var item1 in item.Cast <McqQuestion>().ToList())
{
VMQuestion question = new VMQuestion();
question.HasMultipleCorrectAnswer = false;
question.HasParagraph = false;
question.Id = item1.QUESTION_ID;
question.Paragraph = null;
question.ParagraphId = Guid.Empty.ToString();
question.SeqNo = questionSeq;
if (isHindi)
{
question.Text = item1.QUESTION_TEXT_HI;
question.Options = new List <VMOption>();
question.Options.Add(new VMOption()
{
Id = item1.OPTION_A_ID, IsCorrect = false, SeqNo = 0, Text = item1.OPTION_A_HI
});
question.Options.Add(new VMOption()
{
Id = item1.OPTION_B_ID, IsCorrect = false, SeqNo = 1, Text = item1.OPTION_B_HI
});
question.Options.Add(new VMOption()
{
Id = item1.OPTION_C_ID, IsCorrect = false, SeqNo = 2, Text = item1.OPTION_C_HI
});
question.Options.Add(new VMOption()
{
Id = item1.OPTION_D_ID, IsCorrect = false, SeqNo = 3, Text = item1.OPTION_D_HI
});
question.Options.Add(new VMOption()
{
Id = item1.OPTION_E_ID, IsCorrect = false, SeqNo = 4, Text = item1.OPTION_E_HI
});
}
else
{
question.Text = item1.QUESTION_TEXT_EN;
question.Options = new List <VMOption>();
question.Options.Add(new VMOption()
{
Id = item1.OPTION_A_ID, IsCorrect = false, SeqNo = 0, Text = item1.OPTION_A_EN
});
question.Options.Add(new VMOption()
{
Id = item1.OPTION_B_ID, IsCorrect = false, SeqNo = 1, Text = item1.OPTION_B_EN
});
question.Options.Add(new VMOption()
{
Id = item1.OPTION_C_ID, IsCorrect = false, SeqNo = 2, Text = item1.OPTION_C_EN
});
question.Options.Add(new VMOption()
{
Id = item1.OPTION_D_ID, IsCorrect = false, SeqNo = 3, Text = item1.OPTION_D_EN
});
question.Options.Add(new VMOption()
{
Id = item1.OPTION_E_ID, IsCorrect = false, SeqNo = 4, Text = item1.OPTION_E_EN
});
}
if (quiz.ShuffleOptions)
{
question.Options = question.Options.OrderBy(P => Guid.NewGuid()).ToList();
}
section.Questions.Add(question);
questionSeq++;
}
if (quiz.ShuffleQuestions)
{
section.Questions = section.Questions.OrderBy(P => Guid.NewGuid()).ToList();
}
data.Sections.Add(section);
sectionSeq++;
}
return(data);
}
