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