private void InsertUpdateChapter(ref Chapter chapter)
{
chapter.Chapter_Name = txtChapterChapterName.Text;
chapter.Chapter_No = Convert.ToInt32(nudChapterChapterNo.Value);
chapter.Description = txtChapterDescrption.Text;
chapter.Subject_ID = ComboboxKVP.GetIDFromComboBox(combChapterSubjectName);
}
private void CombTestChapters_SelectedIndexChanged(object sender, EventArgs e)
{
CurrentChapter = combTestChapters.Text;
int chapter_ID = ComboboxKVP.GetIDFromComboBox(combTestChapters);
tests = dbContext.Logs.Where(x => x.Chapter_ID == chapter_ID).ToList();
TestGenerate();
}
private void CombChapterSubjectName_SelectedIndexChanged(object sender, EventArgs e)
{
CurrentSubject = combChapterSubjectName.Text;
gvChapter.AutoGenerateColumns = false;
int subID = ComboboxKVP.GetIDFromComboBox(combChapterSubjectName);
gvChapter.DataSource = dbContext.Chapters
.Where(x => x.Subject.ID == subID)
.OrderBy(x => x.Chapter_No).ToList();
}
private void CombSearchChapter_SelectedIndexChanged(object sender, EventArgs e)
{
CurrentChapter = combSearchChapter.Text;
if (DoThat)
{
int chapter_ID = ComboboxKVP.GetIDFromComboBox(combSearchChapter);
gvSearch.AutoGenerateColumns = false;
gvSearch.DataSource = dbContext.Logs
.Where(x => x.Chapter_ID == chapter_ID).ToList();
}
}
private void CombLibraryQuestion_SelectedIndexChanged(object sender, EventArgs e)
{
if (ckbLibraryAutoFunctionaility.Checked)
{
int ID = ComboboxKVP.GetIDFromComboBox(combLibraryQuestion);
if (ID > 0)
{
Log log = dbContext.Logs.FirstOrDefault(x => x.ID == ID);
FillLibrary(log);
}
}
}
private void InsertUpdateLog(ref Log newLog)
{
newLog.Chapter_ID = ComboboxKVP.GetIDFromComboBox(combLibraryChapters);
newLog.Answer = txtLibraryAnswer.Text;
newLog.Question = combLibraryQuestion.Text;
newLog.Hint_1 = txtLibraryHint1.Text;
newLog.Hint_2 = txtLibraryHint2.Text;
newLog.Hint_3 = txtLibraryHint3.Text;
newLog.Type_ID = ComboboxKVP.GetIDFromComboBox(combLibraryType);
newLog.Level = Convert.ToInt32(nudLibraryLevel.Value);
newLog.Description = txtLibraryDescription.Text;
}
private void FillQuestion(ComboBox chapter, ComboBox question)
{
CurrentChapter = chapter.Text;
question.Items.Clear();
int chapter_id = ComboboxKVP.GetIDFromComboBox(chapter);
ComboboxKVP[] questions = dbContext.Logs
.Where(x => x.Chapter_ID == chapter_id)
.Select(y => new ComboboxKVP()
{
ID = y.ID, Text = y.Question
}).ToArray();
if (questions.Count() > 0 && CurrentChapter != "")
{
question.Items.AddRange(questions);
question.SelectedIndex = 0;
}
}
private void TestGenerate()
{
int subject_ID = ComboboxKVP.GetIDFromComboBox(combTestSubject);
int chapter_ID = ComboboxKVP.GetIDFromComboBox(combTestChapters);
if (combTestChapters.Text == "")
{
tests = dbContext.Logs.Where(x => x.Chapter.Subject_ID == subject_ID).ToList();
}
else
{
tests = dbContext.Logs.Where(x => x.Chapter_ID == chapter_ID).ToList();
}
if (tests.Count > 0)
{
TotalQuestions = tests.Count();
LastAttempt = 0;
TestFillControl(LastAttempt);
}
}
private void FillChapters(ComboBox subject, ComboBox chapter)
{
CurrentSubject = subject.Text;
chapter.Items.Clear();
int subid = ComboboxKVP.GetIDFromComboBox(subject);
ComboboxKVP[] chapters = dbContext.Chapters
.Where(x => x.Subject_ID == subid)
.OrderBy(x => x.Chapter_No).ToList()
.Select(y => new ComboboxKVP()
{
ID = y.ID, Text = "Part " + y.Chapter_No + " " + y.Chapter_Name
}).ToArray();
chapter.Items.AddRange(chapters);
if (chapters.Count() > 0 && CurrentChapter != "")
{
chapter.Text = CurrentChapter;
}
if (chapters.Count() > 0 && chapter.SelectedIndex < 0)
{
chapter.SelectedIndex = 0;
}
}