public List<TrueFalseQuestionModel> GetAllTrueQuestionsByQuizMakerID(long quizMakerID)
{
List<TrueFalseQuestionModel> trueFalseQuestionModels = new List<TrueFalseQuestionModel>();
DataTable dataTable = new DataTable();
try
{
SqlConnection conn = new SqlConnection(DbHelper.ConnectionString);
SqlCommand command = new SqlCommand(@"dbo.uspGetAllTrueFalseQuestionsByQuizMakerID", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@QuizMakerID", quizMakerID);
SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
dataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
TrueFalseQuestionModel trueFalseQuestionModel = new TrueFalseQuestionModel();
trueFalseQuestionModel.QuestionID = row["QuestionID"] != DBNull.Value ? Convert.ToInt64(row["QuestionID"].ToString()) : 0;
trueFalseQuestionModel.QuizMakerID = row["QuizMakerID"] != DBNull.Value ? Convert.ToInt64(row["QuizMakerID"].ToString()) : 0;
trueFalseQuestionModel.TrueText = row["TrueText"] != DBNull.Value ? Convert.ToString(row["TrueText"]) : string.Empty;
trueFalseQuestionModel.FalseText = row["FalseText"] != DBNull.Value ? Convert.ToString(row["FalseText"]) : string.Empty;
trueFalseQuestionModels.Add(trueFalseQuestionModel);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataTable.Clear();
dataTable = null;
}
return trueFalseQuestionModels;
}
private void btnAddTrueFalseQuestion_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtTrue.Text))
{
MessageBox.Show("True statement can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (string.IsNullOrEmpty(txtFlase.Text))
{
MessageBox.Show("False statement can't be blank!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (_quizMakeID == 0)
{
TrueFalseQuestionModel trueFalseQuestionModel = new TrueFalseQuestionModel();
trueFalseQuestionModel.TrueText = txtTrue.Text;
trueFalseQuestionModel.FalseText = txtFlase.Text;
trueFalseQuestionModel.QuizMakerID = 0;
trueFalseQuestionModel.MainTopicID = 0;
trueFalseQuestionModel.SubTopicID = 0;
trueFalseQuestionModel.CreatedOn = DateTime.Now;
trueFalseQuestionModel.CreatedBy = 1;
trueFalseQuestionModel.ModifiedOn = DateTime.Now;
trueFalseQuestionModel.ModifiedBy = 1;
if (QuizMaker.trueFalseQuestionModelsGlobal != null && QuizMaker.trueFalseQuestionModelsGlobal.Count > 0)
{
trueFalseQuestionModel.QuestionCounter = QuizMaker.trueFalseQuestionModelsGlobal.Max(x => x.QuestionCounter) + 1;
}
else
{
trueFalseQuestionModel.QuestionCounter = 1;
}
QuizMaker.trueFalseQuestionModelsGlobal.Add(trueFalseQuestionModel);
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
{
TrueFalseQuestionModel trueFalseQuestionModel = new TrueFalseQuestionModel();
trueFalseQuestionModel.TrueText = txtTrue.Text;
trueFalseQuestionModel.FalseText = txtFlase.Text;
trueFalseQuestionModel.QuizMakerID = _quizMakeID;
trueFalseQuestionModel.MainTopicID = 0;
trueFalseQuestionModel.SubTopicID = 0;
trueFalseQuestionModel.CreatedOn = DateTime.Now;
trueFalseQuestionModel.CreatedBy = 1;
trueFalseQuestionModel.ModifiedOn = DateTime.Now;
trueFalseQuestionModel.ModifiedBy = 1;
if (AddMoreQuestions.addMoreTrueFalseQuestionModelsGlobal != null && AddMoreQuestions.addMoreTrueFalseQuestionModelsGlobal.Count > 0)
{
trueFalseQuestionModel.QuestionCounter = AddMoreQuestions.addMoreTrueFalseQuestionModelsGlobal.Max(x => x.QuestionCounter) + 1;
}
else
{
trueFalseQuestionModel.QuestionCounter = 1;
}
AddMoreQuestions.addMoreTrueFalseQuestionModelsGlobal.Add(trueFalseQuestionModel);
}
this.Close();
}
