public List<FillBlankQuestionModel> GetAllFillBlankQuestionsByQuizMakerID(long quizMakerID) { List<FillBlankQuestionModel> fillBlankQuestionModels = new List<FillBlankQuestionModel>(); DataTable dataTable = new DataTable(); try { SqlConnection conn = new SqlConnection(DbHelper.ConnectionString); SqlCommand command = new SqlCommand(@"dbo.uspGetAllFillBlankQuestionsByQuizMakerID", conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@QuizMakerID", quizMakerID); SqlDataAdapter dataAdapter = new SqlDataAdapter(command); dataAdapter.Fill(dataTable); foreach (DataRow row in dataTable.Rows) { FillBlankQuestionModel fillBlankQuestionModel = new FillBlankQuestionModel(); fillBlankQuestionModel.QuestionID = row["QuestionID"] != DBNull.Value ? Convert.ToInt64(row["QuestionID"].ToString()) : 0; fillBlankQuestionModel.QuizMakerID = row["QuizMakerID"] != DBNull.Value ? Convert.ToInt64(row["QuizMakerID"].ToString()) : 0; fillBlankQuestionModel.QuestionText = row["QuestionText"] != DBNull.Value ? Convert.ToString(row["QuestionText"]) : string.Empty; fillBlankQuestionModel.AnswerText = row["AnswerText"] != DBNull.Value ? Convert.ToString(row["AnswerText"]) : string.Empty; fillBlankQuestionModels.Add(fillBlankQuestionModel); } } catch (Exception ex) { throw ex; } finally { dataTable.Clear(); dataTable = null; } return fillBlankQuestionModels; }
private void btnAddFillBlankQuestion_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtQuestion.Text)) { MessageBox.Show("Question can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (string.IsNullOrEmpty(txtAnswer.Text)) { MessageBox.Show("Answer can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (_quizMakeID == 0) { FillBlankQuestionModel fillBlankQuestionModel = new FillBlankQuestionModel(); fillBlankQuestionModel.QuestionText = txtQuestion.Text; fillBlankQuestionModel.QuizMakerID = 0; fillBlankQuestionModel.MainTopicID = 0; fillBlankQuestionModel.SubTopicID = 0; fillBlankQuestionModel.AnswerText = txtAnswer.Text; fillBlankQuestionModel.CreatedOn = DateTime.Now; fillBlankQuestionModel.CreatedBy = 1; fillBlankQuestionModel.ModifiedOn = DateTime.Now; fillBlankQuestionModel.ModifiedBy = 1; if (QuizMaker.fillBlankQuestionModelsGlobal != null && QuizMaker.fillBlankQuestionModelsGlobal.Count > 0) { fillBlankQuestionModel.QuestionCounter = QuizMaker.fillBlankQuestionModelsGlobal.Max(x => x.QuestionCounter) + 1; } else { fillBlankQuestionModel.QuestionCounter = 1; } QuizMaker.fillBlankQuestionModelsGlobal.Add(fillBlankQuestionModel); if (QuizMaker.multipleQuestionModelsGlobal != null) { QuizMaker quiz = (QuizMaker)Application.OpenForms["QuizMaker"]; if (quiz != null) { int totalQuestions = QuizMaker.multipleQuestionModelsGlobal.Count() + QuizMaker.trueFalseQuestionModelsGlobal.Count() + QuizMaker.fillBlankQuestionModelsGlobal.Count(); quiz.txtTotalQuestions.Text = totalQuestions.ToString(); } } } else { FillBlankQuestionModel fillBlankQuestionModel = new FillBlankQuestionModel(); fillBlankQuestionModel.QuestionText = txtQuestion.Text; fillBlankQuestionModel.QuizMakerID = _quizMakeID; fillBlankQuestionModel.MainTopicID = 0; fillBlankQuestionModel.SubTopicID = 0; fillBlankQuestionModel.AnswerText = txtAnswer.Text; fillBlankQuestionModel.CreatedOn = DateTime.Now; fillBlankQuestionModel.CreatedBy = 1; fillBlankQuestionModel.ModifiedOn = DateTime.Now; fillBlankQuestionModel.ModifiedBy = 1; if (AddMoreQuestions.addMoreFillBlankQuestionModelsGlobal != null && AddMoreQuestions.addMoreFillBlankQuestionModelsGlobal.Count > 0) { fillBlankQuestionModel.QuestionCounter = AddMoreQuestions.addMoreFillBlankQuestionModelsGlobal.Max(x => x.QuestionCounter) + 1; } else { fillBlankQuestionModel.QuestionCounter = 1; } AddMoreQuestions.addMoreFillBlankQuestionModelsGlobal.Add(fillBlankQuestionModel); } this.Close(); }