private static List <QARecord> QA_OneSentence(QA_Filter_Parameters filter) { var seq = 1; using (var context = new YogiApekshitContext()) { return(context.QueOneSentences.Where(obj => (filter.Lang == "Guj" ? !string.IsNullOrEmpty(obj.Que_Guj) : !string.IsNullOrEmpty(obj.Que_Eng) ) && obj.BookId == filter.BookId && (filter.ChapterNumber == 0 || obj.ChapterNumber == filter.ChapterNumber)) .OrderBy(obj => obj.BookId).ThenBy(obj => obj.ChapterNumber).ToList() .Select(c => new QARecord { Sr = seq++, Que = filter.Lang == "Guj" ? c.Que_Guj : c.Que_Eng, Ans = filter.Lang == "Guj" ? c.Ans_Guj : c.Ans_Eng, Chapter = string.Format("{0}/{1}", filter.Lang == "Guj" ? c.Book.Code_Guj : c.Book.Code_Eng, c.ChapterNumber), Exams = c.Exams, }).ToList()); } }
private static List <QARecord> QA_WhoWhomWhen(QA_Filter_Parameters filter) { var seq = 1; using (var context = new YogiApekshitContext()) { var data = context.QueWhoWhomWhens.Where(obj => (filter.Lang == "Guj" ? !string.IsNullOrEmpty(obj.Que_Guj) : !string.IsNullOrEmpty(obj.Que_Eng) ) && obj.BookId == filter.BookId && (filter.ChapterNumber == 0 || obj.ChapterNumber == filter.ChapterNumber)) .OrderBy(obj => obj.BookId).ThenBy(obj => obj.ChapterNumber).ToList() .Select(c => new QARecord { Sr = seq++, Que = filter.Lang == "Guj" ? c.Que_Guj : c.Que_Eng, Who = filter.Lang == "Guj" ? "કોણ: " + c.Who_Guj : "Who: " + c.Who_Eng, Whom = filter.Lang == "Guj" ? "કોને: " + c.Whom_Guj : "Whom: " + c.Whom_Eng, When = filter.Lang == "Guj" ? "ક્યારે: " + c.WhenSpeaking_Guj : "When: " + c.WhenSpeaking_Eng, Chapter = string.Format("{0}/{1}", filter.Lang == "Guj" ? c.Book.Code_Guj : c.Book.Code_Eng, c.ChapterNumber), Exams = c.Exams, }).ToList(); data.ForEach(c => { c.Ans = c.Who + "<br/>" + c.Whom + "<br/>" + c.When + "<br/>"; }); return(data); } }
private static QA_VM QA_List(QA_Filter_Parameters filter) { var qa_vm = new QA_VM(); var qaRecords = new List <QARecord>(); using (var context = new YogiApekshitContext()) { if (filter.BookId > 0) { var book = context.Books.Where(c => c.Id == filter.BookId).FirstOrDefault(); qa_vm.BookTitle = book != null ? filter.Lang == "Guj" ? book.Name_Guj : book.Name_Eng : string.Empty; } if (filter.ChapterNumber > 0) { var chapter = context.BookChapters.Where(c => c.Id == filter.ChapterNumber).FirstOrDefault(); qa_vm.ChapterTitle = chapter != null ? filter.Lang == "Guj" ? chapter.Name_Guj : chapter.Name_Eng : string.Empty; } } var category = (Constants.Que_Categories)Enum.Parse(typeof(Constants.Que_Categories), filter.Category); switch (category) { case Constants.Que_Categories.One_Sentence: qa_vm.Color = "#16a085"; qaRecords = QA_OneSentence(filter); break; case Constants.Que_Categories.Correct_Option: qa_vm.Color = "#e05d6f"; qaRecords = QA_CorrectOption(filter); break; case Constants.Que_Categories.Correct_Sentence: qa_vm.Color = "#418bca"; qaRecords = QA_CorrectSentence(filter); break; case Constants.Que_Categories.Correct_Sequence: qa_vm.Color = "#56b1bf"; qaRecords = QA_CorrectSequence(filter); break; case Constants.Que_Categories.Fill_In_Blank: qa_vm.Color = "#5cb85c"; qaRecords = QA_FillInBlank(filter); break; case Constants.Que_Categories.Kirtan: qa_vm.Color = "#f0ad4e"; qaRecords = QA_Kirtan(filter); break; case Constants.Que_Categories.Reason: qa_vm.Color = "#d9534f"; qaRecords = QA_Reason(filter); break; case Constants.Que_Categories.Short_Note: qa_vm.Color = "#afae8b"; qaRecords = QA_ShortNote(filter); break; case Constants.Que_Categories.Swamini_Vaato: qa_vm.Color = "#116f7d"; qaRecords = QA_SwaminiVat(filter); break; case Constants.Que_Categories.Who_Whom_When: qa_vm.Color = "#d0aa90"; qaRecords = QA_WhoWhomWhen(filter); break; default: qaRecords = new List <QARecord>(); break; } qa_vm.QARecords = qaRecords; return(qa_vm); }