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