private void cmbSubjects_SelectedIndexChanged(object sender, EventArgs e)
{
long gradeID = 0;
long subjectID = 0;
if (!string.IsNullOrEmpty(cmbGrades.Text))
{
// Get the Topic from DB and fill Topics Combo
gradeID = Convert.ToInt64(cmbGrades.SelectedValue);
subjectID = Convert.ToInt64(cmbSubjects.SelectedValue);
QuizMakerRepository quizMakerRepository = new QuizMakerRepository();
List <QuizMakerTopicNumberDetail> quizMakerTopicNumberDetails = quizMakerRepository.GetAllSubTopicDetails(gradeID, subjectID);
this.cmbTopicNo.SelectedIndexChanged -= new EventHandler(cmbTopicNo_SelectedIndexChanged);
BindingSource bs = new BindingSource();
bs.DataSource = quizMakerTopicNumberDetails;
cmbTopicNo.ValueMember = "TopicID";
cmbTopicNo.DisplayMember = "TopicNumber";
cmbTopicNo.SelectedValue = subjectID;
cmbTopicNo.DataSource = bs;
this.cmbTopicNo.SelectedIndexChanged += new EventHandler(cmbTopicNo_SelectedIndexChanged);
ChangeQuizNumberValue();
}
}
private void dataGridViewTrueFalseQuestions_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == dataGridViewTrueFalseQuestions.NewRowIndex || e.RowIndex < 0)
{
return;
}
//if (e.ColumnIndex == dataGridViewShowMultipleQuestions.Columns["Add"].Index)
//{
// AddMoreQuestions addMoreQuestions = new AddMoreQuestions(_quizMakerID);
// addMoreQuestions.Show();
//}
//else
if (e.ColumnIndex == dataGridViewTrueFalseQuestions.Columns["Delete"].Index)
{
long questionID = Convert.ToInt64(dataGridViewTrueFalseQuestions.Rows[e.RowIndex].Cells["QuestionID"].Value);
QuizMakerRepository quizMakerRepository = new QuizMakerRepository();
int rowCount = quizMakerRepository.DeleteTrueFalseQuestionByQuestionID(questionID);
if (rowCount > 0)
{
ShowStatus(true, "DELETE");
BindGridViewShowAllTrueFalseQuestionByQuizMakerID(_quizMakerID);
}
}
}
private void ChangeQuizNumberValue()
{
long topicNumber = 0;
QuizMakerRepository quizMakerRepository = new QuizMakerRepository();
if (!string.IsNullOrEmpty(cmbGrades.Text) && !string.IsNullOrEmpty(cmbSubjects.Text) && !string.IsNullOrEmpty(cmbTopicNo.Text))
{
topicNumber = quizMakerRepository.GetMaxQuixNumber(Convert.ToInt64(cmbGrades.SelectedValue), Convert.ToInt64(cmbSubjects.SelectedValue), cmbTopicNo.Text);
txtQuizNumber.Text = AddToStartOfString(Convert.ToString(topicNumber + 1));
}
}
private void dataGridViewFillBlankQuestion_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == dataGridViewFillBlankQuestion.NewRowIndex || e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex == dataGridViewFillBlankQuestion.Columns["Delete"].Index)
{
long questionID = Convert.ToInt64(dataGridViewFillBlankQuestion.Rows[e.RowIndex].Cells["QuestionID"].Value);
QuizMakerRepository quizMakerRepository = new QuizMakerRepository();
int rowCount = quizMakerRepository.DeleteFillBlankQuestionByQuestionID(questionID);
if (rowCount > 0)
{
ShowStatus(true, "DELETE");
BindGridViewShowAllFillBlankQuestionByQuizMakerID(_quizMakerID);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
DataTable dataTableMultipleQuestion = TranslateMultipleQuestionAnswerListToDataTable(addMoreMultipleQuestionModelsGlobal);
DataTable dataTableTrueFalseQuestion = TranslateTrueFalseQuestionAnswerListToDataTable(addMoreTrueFalseQuestionModelsGlobal);
DataTable dataTableFillBlankQuestion = TranslateFillBlankQuestionAnswerListToDataTable(addMoreFillBlankQuestionModelsGlobal);
QuizMakerRepository quizMakerRepository = new QuizMakerRepository();
long result = quizMakerRepository.SaveMoreQuestions(dataTableMultipleQuestion, dataTableTrueFalseQuestion, dataTableFillBlankQuestion);
if (result > 0)
{
ShowStatus(true, "ADD");
}
else
{
ShowStatus(false, string.Empty);
}
addMoreMultipleQuestionModelsGlobal = new List <MultipleQuestionModel>();
addMoreTrueFalseQuestionModelsGlobal = new List <TrueFalseQuestionModel>();
addMoreFillBlankQuestionModelsGlobal = new List <FillBlankQuestionModel>();
this.Close();
}
private void BindGridViewQuizMaker()
{
QuizMakerRepository lessonPlannerRepository = new QuizMakerRepository();
List <QuizMakerModel> quizMakerModels = new List <QuizMakerModel>();
DataTable dataTable = new DataTable();
try
{
dataTable = lessonPlannerRepository.GetAllQuizMakers();
quizMakerModels = TranslateDataTableToQuizMakersModel(dataTable);
}
catch (Exception ex)
{
MessageBox.Show("Network error...Please try again!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
dataTable.Clear();
dataTable = null;
dataGridViewQuizMaker.DataSource = quizMakerModels;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cmbGrades.Text))
{
MessageBox.Show("Grade can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (string.IsNullOrEmpty(cmbSubjects.Text))
{
MessageBox.Show("Subjec can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (string.IsNullOrEmpty(cmbTopicNo.Text))
{
MessageBox.Show("Topic number can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (string.IsNullOrEmpty(txtQuizNumber.Text))
{
MessageBox.Show("Quiz number can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (string.IsNullOrEmpty(txtTimeLimit.Text))
{
MessageBox.Show("Time limit can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//else if (string.IsNullOrEmpty(txtTotalScores.Text))
//{
// MessageBox.Show("Total scores can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
//else if (string.IsNullOrEmpty(txtTotalQuestions.Text))
//{
// MessageBox.Show("Total questions can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
else if (multipleQuestionModelsGlobal.Count == 0 && trueFalseQuestionModelsGlobal.Count == 0)
{
MessageBox.Show("Please add at least one question!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
QuizMakerModel quizMakerModel = new QuizMakerModel();
quizMakerModel.QuizMakerID = Convert.ToInt64(lblQuizMakerID.Text);
quizMakerModel.GradeID = Convert.ToInt64(cmbGrades.SelectedValue);
quizMakerModel.SubjectID = Convert.ToInt64(cmbSubjects.SelectedValue);
long topicID = 0;
string topicNumberString = Convert.ToString(cmbTopicNo.SelectedValue);
if (!string.IsNullOrEmpty(topicNumberString))
{
string topicType = topicNumberString.Substring(topicNumberString.IndexOf("-") + 1);
if (topicType.ToLower() == "mt")
{
quizMakerModel.MainTopicID = Convert.ToInt64(topicNumberString.Substring(0, topicNumberString.IndexOf("-")));
quizMakerModel.SubTopicID = 0;
}
else if (topicType.ToLower() == "st")
{
quizMakerModel.SubTopicID = Convert.ToInt64(topicNumberString.Substring(0, topicNumberString.IndexOf("-")));
quizMakerModel.MainTopicID = 0;
}
}
quizMakerModel.TopicNumber = cmbTopicNo.Text;
quizMakerModel.QuizNumber = txtQuizNumber.Text;
quizMakerModel.TimeLimit = txtTimeLimit.Text;
quizMakerModel.TotalQuestions = txtTotalQuestions.Text;
quizMakerModel.TotalScore = txtTotalScores.Text;
quizMakerModel.Instructions = txtInstructions.Text;
quizMakerModel.IsMultiple = rdbMultiple.Checked ? true : false;
quizMakerModel.IsTF = rdbTF.Checked ? true : false;
quizMakerModel.IsFillBlank = rdbFillBlank.Checked ? true : false;
quizMakerModel.CreatedOn = DateTime.Now;
quizMakerModel.CreatedBy = 1; // It will be added from users
quizMakerModel.ModifiedOn = DateTime.Now;
quizMakerModel.ModifiedBy = 1; // It will be added from users
try
{
QuizMakerRepository quizMakerRepository = new QuizMakerRepository();
DataTable dataTableQuizMaker = TranslateQuizMakerListToDataTable(quizMakerModel);
DataTable dataTableMultipleQuestion = TranslateMultipleQuestionAnswerListToDataTable(multipleQuestionModelsGlobal);
DataTable dataTableTrueFalseQuestion = TranslateTrueFalseQuestionAnswerListToDataTable(trueFalseQuestionModelsGlobal);
DataTable dataTableFillBlankQuestion = TranslateFillBlankQuestionAnswerListToDataTable(fillBlankQuestionModelsGlobal);
long result = quizMakerRepository.SaveUpdateQuizMaker(dataTableQuizMaker, dataTableMultipleQuestion, dataTableTrueFalseQuestion, dataTableFillBlankQuestion);
if (result > 0)
{
ShowStatus(true, "ADD");
}
else
{
ShowStatus(false, string.Empty);
}
QuizMaker.multipleQuestionModelsGlobal = new List <MultipleQuestionModel>();
QuizMaker.trueFalseQuestionModelsGlobal = new List <TrueFalseQuestionModel>();
QuizMaker.fillBlankQuestionModelsGlobal = new List <FillBlankQuestionModel>();
//this.Close();
//Home home = new Home();
//home.Show();
}
catch (Exception ex)
{
ShowStatus(false, string.Empty);
}
}
}
private void BindGridViewQuizMakerBySubTopicID(long subTopicID)
{
QuizMakerRepository lessonPlannerRepository = new QuizMakerRepository();
dataGridViewSubTopicQuizMaker.DataSource = lessonPlannerRepository.GetAllQuizMakersBySubTopicID(subTopicID);
}
private void BindGridViewShowAllFillBlankQuestionByQuizMakerID(long quizMakerID)
{
QuizMakerRepository quizMakerRepository = new QuizMakerRepository();
dataGridViewFillBlankQuestion.DataSource = quizMakerRepository.GetAllFillBlankQuestionsByQuizMakerID(quizMakerID);
}
private void BindGridViewShowAllTrueFalseQuestionByQuizMakerID(long quizMakerID)
{
QuizMakerRepository quizMakerRepository = new QuizMakerRepository();
dataGridViewTrueFalseQuestions.DataSource = quizMakerRepository.GetAllTrueQuestionsByQuizMakerID(quizMakerID);
}
