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); }