public static Quiz_ExamQuestionDetails GetQuiz_ExamQuestionDetailsByExamQuestionDetailsID(int ExamQuestionDetailsID)
{
Quiz_ExamQuestionDetails quiz_ExamQuestionDetails = new Quiz_ExamQuestionDetails();
SqlQuiz_ExamQuestionDetailsProvider sqlQuiz_ExamQuestionDetailsProvider = new SqlQuiz_ExamQuestionDetailsProvider();
quiz_ExamQuestionDetails = sqlQuiz_ExamQuestionDetailsProvider.GetQuiz_ExamQuestionDetailsByExamQuestionDetailsID(ExamQuestionDetailsID);
return quiz_ExamQuestionDetails;
}
protected void btnAssignQuestionToExam_Click(object sender, EventArgs e)
{
if (ddlExamID.SelectedValue != "0")
{
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, int.Parse(ddlAllExam.SelectedValue), (int)Enums.QuestionTypes.MCQ,
Int32.Parse(Request.QueryString["ID"]), Profile.card_id, DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
}
public bool DeleteQuiz_ExamQuestionDetails(Quiz_ExamQuestionDetails quiz_ExamQuestionDetails)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("DeleteQuiz_ExamQuestionDetailsByExam", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ExamID", SqlDbType.Int).Value = quiz_ExamQuestionDetails.ExamID;
cmd.Parameters.Add("@QuestionNo", SqlDbType.Int).Value = quiz_ExamQuestionDetails.QuestionNo;
cmd.Parameters.Add("@QuestionType", SqlDbType.Int).Value = quiz_ExamQuestionDetails.QuestionType;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (result == 1);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
string userID = Profile.card_id ;
Quiz_TrueFalse quiz_TrueFalse = new Quiz_TrueFalse();
quiz_TrueFalse.ComprehensionID = 0;
quiz_TrueFalse.CourseID = int.Parse(ddlCourseID.SelectedValue);
quiz_TrueFalse.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
quiz_TrueFalse.ChapterID = int.Parse(ddlChapterID.SelectedValue);
quiz_TrueFalse.QuestionTitle = fckDesc.Value;
quiz_TrueFalse.IsDrCr = bool.Parse(radIsDrCr.SelectedValue);
quiz_TrueFalse.IsTrue = bool.Parse(radIsTrue.SelectedValue);
quiz_TrueFalse.AddedBy = userID;
quiz_TrueFalse.AddedDate = DateTime.Now;
quiz_TrueFalse.ModifiedBy = userID;
quiz_TrueFalse.ModifiedDate = DateTime.Now;
int trueFalseID = Quiz_TrueFalseManager.InsertQuiz_TrueFalse(quiz_TrueFalse);
if (trueFalseID > 0)
{
fckDesc.Value = "";
radIsTrue.SelectedIndex = -1;
}
if (ddlExamID.SelectedValue != "0")
{
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, int.Parse( ddlExamID.SelectedValue),(quiz_TrueFalse.IsDrCr? (int)Enums.QuestionTypes.DrCr:(int)Enums.QuestionTypes.TrueFalse),
trueFalseID, Profile.card_id, DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
}
catch (Exception ex)
{
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
List<Quiz_MultipleQuestionDetails> multipleQuestions = new List<Quiz_MultipleQuestionDetails>();
multipleQuestions = (List<Quiz_MultipleQuestionDetails>)Session["multipleQuestions"];
string userID = Profile.card_id;
Quiz_MultipleQuestion quiz_MultipleQuestion = new Quiz_MultipleQuestion();
quiz_MultipleQuestion.ComprehensionID = 0;
quiz_MultipleQuestion.CourseID = int.Parse(ddlCourseID.SelectedValue);
quiz_MultipleQuestion.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
quiz_MultipleQuestion.ChapterID = int.Parse(ddlChapterID.SelectedValue);
quiz_MultipleQuestion.MultipleQuestionName = fckDesc.Value;
quiz_MultipleQuestion.AddedBy = userID;
quiz_MultipleQuestion.AddedDate = DateTime.Now;
quiz_MultipleQuestion.ModifiedBy = userID;
quiz_MultipleQuestion.ModifiedDate = DateTime.Now;
int MultipleQustionID = Quiz_MultipleQuestionManager.InsertQuiz_MultipleQuestion(quiz_MultipleQuestion);
if (multipleQuestions != null)
{
for (int i = 0; i < multipleQuestions.Count; i++)
{
HR_EmployeeSalaryRules hR_EmployeeSalaryRules = new HR_EmployeeSalaryRules();
Label lblSerial = ((Label)gvQuiz_MultipleQuestionDetails.Rows[i].FindControl("lblSerial"));
TextBox txtGridQuestionTitle = ((TextBox)gvQuiz_MultipleQuestionDetails.Rows[i].FindControl("txtQuestionTitle"));
RadioButtonList chkAnswer = ((RadioButtonList)gvQuiz_MultipleQuestionDetails.Rows[i].FindControl("radIsAnswer"));
Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails = new Quiz_MultipleQuestionDetails();
quiz_MultipleQuestionDetails.MultipleQustionID = MultipleQustionID;
quiz_MultipleQuestionDetails.QuestionTitle = txtGridQuestionTitle.Text;
quiz_MultipleQuestionDetails.IsAnswer = chkAnswer.SelectedValue == "True" ? true : false;
quiz_MultipleQuestionDetails.AddedBy = userID;
quiz_MultipleQuestionDetails.AddedDate = DateTime.Now;
quiz_MultipleQuestionDetails.ModifiedBy = userID;
quiz_MultipleQuestionDetails.ModifiedDate = DateTime.Now;
int resutl = Quiz_MultipleQuestionDetailsManager.InsertQuiz_MultipleQuestionDetails(quiz_MultipleQuestionDetails);
}
}
if (txtQuestionTitle.Text!="")
{
Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails = new Quiz_MultipleQuestionDetails();
quiz_MultipleQuestionDetails.MultipleQustionID = MultipleQustionID;
quiz_MultipleQuestionDetails.QuestionTitle = txtQuestionTitle.Text;
quiz_MultipleQuestionDetails.IsAnswer = radIsAnswer.SelectedValue == "True" ? true : false;
quiz_MultipleQuestionDetails.AddedBy = userID;
quiz_MultipleQuestionDetails.AddedDate = DateTime.Now;
quiz_MultipleQuestionDetails.ModifiedBy = userID;
quiz_MultipleQuestionDetails.ModifiedDate = DateTime.Now;
int resutl = Quiz_MultipleQuestionDetailsManager.InsertQuiz_MultipleQuestionDetails(quiz_MultipleQuestionDetails);
}
fckDesc.Value = string.Empty;
txtQuestionTitle.Text = string.Empty;
multipleQuestions.Clear();
Session["multipleQuestions"] = null;
gvQuiz_MultipleQuestionDetails.DataSource = multipleQuestions;
gvQuiz_MultipleQuestionDetails.DataBind();
if (ddlExamID.SelectedValue != "0")
{
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, int.Parse(ddlExamID.SelectedValue), (int)Enums.QuestionTypes.MCQ,
MultipleQustionID, Profile.card_id, DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
}
catch (Exception ex)
{
}
}
public bool UpdateQuiz_ExamQuestionDetails(Quiz_ExamQuestionDetails quiz_ExamQuestionDetails)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateQuiz_ExamQuestionDetails", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ExamQuestionDetailsID", SqlDbType.Int).Value = quiz_ExamQuestionDetails.ExamQuestionDetailsID;
cmd.Parameters.Add("@ExamID", SqlDbType.Int).Value = quiz_ExamQuestionDetails.ExamID;
cmd.Parameters.Add("@QuestionType", SqlDbType.Int).Value = quiz_ExamQuestionDetails.QuestionType;
cmd.Parameters.Add("@QuestionNo", SqlDbType.Int).Value = quiz_ExamQuestionDetails.QuestionNo;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = quiz_ExamQuestionDetails.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = quiz_ExamQuestionDetails.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public Quiz_ExamQuestionDetails GetQuiz_ExamQuestionDetailsFromReader(IDataReader reader)
{
try
{
Quiz_ExamQuestionDetails quiz_ExamQuestionDetails = new Quiz_ExamQuestionDetails
(
DataAccessObject.IsNULL<int>(reader["ExamQuestionDetailsID"]),
DataAccessObject.IsNULL<int>(reader["ExamID"]),
DataAccessObject.IsNULL<int>(reader["QuestionType"]),
DataAccessObject.IsNULL<int>(reader["QuestionNo"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"]),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return quiz_ExamQuestionDetails;
}
catch(Exception ex)
{
return null;
}
}
public static int InsertQuiz_ExamQuestionDetails(Quiz_ExamQuestionDetails quiz_ExamQuestionDetails)
{
SqlQuiz_ExamQuestionDetailsProvider sqlQuiz_ExamQuestionDetailsProvider = new SqlQuiz_ExamQuestionDetailsProvider();
return sqlQuiz_ExamQuestionDetailsProvider.InsertQuiz_ExamQuestionDetails(quiz_ExamQuestionDetails);
}
public static bool DeleteQuiz_ExamQuestionDetails(Quiz_ExamQuestionDetails quiz_ExamQuestionDetails)
{
SqlQuiz_ExamQuestionDetailsProvider sqlQuiz_ExamQuestionDetailsProvider = new SqlQuiz_ExamQuestionDetailsProvider();
return sqlQuiz_ExamQuestionDetailsProvider.DeleteQuiz_ExamQuestionDetails(quiz_ExamQuestionDetails);
}
protected void lbDeleteTrueFalse_Click(object sender, EventArgs e)
{
ImageButton linkButton = new ImageButton();
linkButton = (ImageButton)sender;
int questionTypeID = Convert.ToInt32(linkButton.ToolTip); ;
int questionNo = Convert.ToInt32(linkButton.CommandArgument); ;
int examID=int.Parse(ddlExamID.SelectedValue);
Quiz_ExamQuestionDetails quiz_ExamQuestionDetails = new Quiz_ExamQuestionDetails();
quiz_ExamQuestionDetails.QuestionNo = questionNo;
quiz_ExamQuestionDetails.ExamID = examID;
quiz_ExamQuestionDetails.QuestionType = questionTypeID;
Quiz_ExamQuestionDetailsManager.DeleteQuiz_ExamQuestionDetails(quiz_ExamQuestionDetails);
GenerateQuiz(questionTypeID);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
int examID = int.Parse(ddlExamID.SelectedValue);
#region Begin Exam Details
if (examID > 0)
{
foreach (GridViewRow row in gvQuiz_nc_TrueFalse.Rows)
{
if (((CheckBox)row.FindControl("chkAdded")).Checked || chkAllUnchedQuestions.Checked)
{
int trueFalseID = Convert.ToInt32(((HiddenField)row.FindControl("hfTrueFalseID")).Value);
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, examID, (int)Enums.QuestionTypes.TrueFalse,
trueFalseID, Profile.card_id, DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
}
foreach (GridViewRow row in gvQuiz_nc_gvDrCr.Rows)
{
if (((CheckBox)row.FindControl("chkAdded")).Checked || chkAllUnchedQuestions.Checked)
{
int drCrID = Convert.ToInt32(((HiddenField)row.FindControl("hfDrCrID")).Value);
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, examID, (int)Enums.QuestionTypes.DrCr,
drCrID, Profile.card_id, DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
}
foreach (GridViewRow row in gvQuiz_nc_FillInTheBlanks.Rows)
{
if (((CheckBox)row.FindControl("chkAdded")).Checked || chkAllUnchedQuestions.Checked)
{
int fillInTheBlanksID = Convert.ToInt32(((Label)row.FindControl("lblFillInTheBlanksID")).Text);
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, examID, (int)Enums.QuestionTypes.FillInTheBlanks,
fillInTheBlanksID, Profile.card_id, DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
}
foreach (GridViewRow row in gvQuiz_nc_MultipleQuestion.Rows)
{
if (((CheckBox)row.FindControl("chkAdded")).Checked || chkAllUnchedQuestions.Checked)
{
Label lblMcqID = (Label)row.FindControl("lblMultipleQustionID");
int mcqID = Convert.ToInt32(lblMcqID.Text);
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, examID, (int)Enums.QuestionTypes.MCQ,
mcqID, Profile.card_id, DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
}
foreach (GridViewRow row in gvQuiz_Comprehension.Rows)
{
if (((CheckBox)row.FindControl("chkAdded")).Checked || chkAllUnchedQuestions.Checked)
{
int comprehensionID = Convert.ToInt32(((Label)row.FindControl("lblComprehensionID")).Text);
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, examID, (int)Enums.QuestionTypes.Comprehension,
comprehensionID, Profile.card_id, DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
}
GenerateQuiz(0);
}
#endregion End Exam Details
}
catch (Exception ex)
{
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
#region Begin Insert Exam
int examDuration = Convert.ToInt32(ddlExamHour.SelectedValue) * 60 + Convert.ToInt32(ddlExamMin.SelectedValue);
if (examDuration == 0)
examDuration = 120;
DateTime examStartTime = DateTime.Now;
bool isRetake = false;// cbIsRetake.Checked;
int courseID = Convert.ToInt32(ddlCourseID.SelectedValue);
int subjectID = Convert.ToInt32(ddlSubjectID.SelectedValue);
int chapterID = 0; // Convert.ToInt32(ddlChapterID.SelectedValue);
Quiz_Exam qe = new Quiz_Exam(0, txtExamName.Text, courseID, subjectID, chapterID, examDuration, examStartTime,
isRetake, true, "User", DateTime.Now, Profile.card_id, DateTime.Now);
int examID = Quiz_ExamManager.InsertQuiz_Exam(qe);
#endregion End Insert Exam
#region Begin Exam Details
if (examID > 0)
{
foreach (GridViewRow row in gvQuiz_nc_TrueFalse.Rows)
{
int trueFalseID = Convert.ToInt32(((HiddenField)row.FindControl("hfTrueFalseID")).Value);
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, examID, (int)Enums.QuestionTypes.TrueFalse,
trueFalseID, "User", DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
foreach (GridViewRow row in gvQuiz_nc_gvDrCr.Rows)
{
int drCrID = Convert.ToInt32(((HiddenField)row.FindControl("hfDrCrID")).Value);
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, examID, (int)Enums.QuestionTypes.DrCr,
drCrID, "User", DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
foreach (GridViewRow row in gvQuiz_nc_FillInTheBlanks.Rows)
{
int fillInTheBlanksID = Convert.ToInt32(((Label)row.FindControl("lblFillInTheBlanksID")).Text);
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, examID, (int)Enums.QuestionTypes.FillInTheBlanks,
fillInTheBlanksID, "User", DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
foreach (GridViewRow row in gvQuiz_nc_MultipleQuestion.Rows)
{
Label lblMcqID = (Label)row.FindControl("lblMultipleQustionID");
int mcqID = Convert.ToInt32(lblMcqID.Text);
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, examID, (int)Enums.QuestionTypes.MCQ,
mcqID, "User", DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
foreach (GridViewRow row in gvQuiz_Comprehension.Rows)
{
int comprehensionID = Convert.ToInt32(((Label)row.FindControl("lblComprehensionID")).Text);
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, examID, (int)Enums.QuestionTypes.Comprehension,
comprehensionID, "User", DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
}
#endregion End Exam Details
}
catch (Exception ex)
{
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
List<Quiz_FillInTheBlanksDetails> fillInTheBlanksDetails = new List<Quiz_FillInTheBlanksDetails>();
fillInTheBlanksDetails = (List<Quiz_FillInTheBlanksDetails>)Session["fillInTheBlanksDetails"];
string userID = Profile.card_id;
Quiz_FillInTheBlanks fillInTheBlanks = new Quiz_FillInTheBlanks();
fillInTheBlanks.Question = fckDesc.Value;
fillInTheBlanks.ChapterID = int.Parse(ddlChapterID.SelectedValue);
fillInTheBlanks.CourseID = int.Parse(ddlCourseID.SelectedValue);
fillInTheBlanks.ComprehensionID = 0;
fillInTheBlanks.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
fillInTheBlanks.AddedBy = userID;
fillInTheBlanks.AddedDate = DateTime.Now;
fillInTheBlanks.ModifiedBy = userID;
fillInTheBlanks.ModifiedDate = DateTime.Now;
int FillInTheBlanksID = Quiz_FillInTheBlanksManager.InsertQuiz_FillInTheBlanks(fillInTheBlanks);
if (fillInTheBlanksDetails != null)
{
for (int i = 0; i < fillInTheBlanksDetails.Count; i++)
{
Label lblSerial = ((Label)gvQuiz_FillInTheBlanksQuestionDetails.Rows[i].FindControl("lblSerial"));
TextBox txtanswer = ((TextBox)gvQuiz_FillInTheBlanksQuestionDetails.Rows[i].FindControl("txtAnswer"));
Quiz_FillInTheBlanksDetails fillInTheBlanksDtl = new Quiz_FillInTheBlanksDetails();
// quiz_MultipleQuestionDetails.MultipleQuestionDetailsID= int.Parse(ddlMultipleQuestionDetailsID.SelectedValue);
fillInTheBlanksDtl.FillInTheBlanksID = FillInTheBlanksID;
fillInTheBlanksDtl.QuestionSl = int.Parse(lblSerial.Text);
fillInTheBlanksDtl.Answer = txtanswer.Text;
fillInTheBlanksDtl.AddedBy = userID;
fillInTheBlanksDtl.AddedDate = DateTime.Now;
fillInTheBlanksDtl.ModifiedBy = userID;
fillInTheBlanksDtl.ModifiedDate = DateTime.Now;
int resutl = Quiz_FillInTheBlanksDetailsManager.InsertQuiz_FillInTheBlanksDetails(fillInTheBlanksDtl);
}
}
if (txtAnswer.Text != "")
{
Quiz_FillInTheBlanksDetails fillInTheBlanksDtl = new Quiz_FillInTheBlanksDetails();
// quiz_MultipleQuestionDetails.MultipleQuestionDetailsID= int.Parse(ddlMultipleQuestionDetailsID.SelectedValue);
fillInTheBlanksDtl.FillInTheBlanksID = FillInTheBlanksID;
fillInTheBlanksDtl.QuestionSl = 1;
fillInTheBlanksDtl.Answer = txtAnswer.Text;
fillInTheBlanksDtl.AddedBy = userID;
fillInTheBlanksDtl.AddedDate = DateTime.Now;
fillInTheBlanksDtl.ModifiedBy = userID;
fillInTheBlanksDtl.ModifiedDate = DateTime.Now;
int resutl = Quiz_FillInTheBlanksDetailsManager.InsertQuiz_FillInTheBlanksDetails(fillInTheBlanksDtl);
}
fckDesc.Value = string.Empty;
txtAnswer.Text = string.Empty;
fillInTheBlanksDetails.Clear();
Session["fillInTheBlanksDetails"] = null;
gvQuiz_FillInTheBlanksQuestionDetails.DataSource = fillInTheBlanksDetails;
gvQuiz_FillInTheBlanksQuestionDetails.DataBind();
if (ddlExamID.SelectedValue != "0")
{
Quiz_ExamQuestionDetails qe_Details = new Quiz_ExamQuestionDetails(0, int.Parse(ddlExamID.SelectedValue), (int)Enums.QuestionTypes.FillInTheBlanks,
FillInTheBlanksID, Profile.card_id, DateTime.Now, Profile.card_id, DateTime.Now);
Quiz_ExamQuestionDetailsManager.InsertQuiz_ExamQuestionDetails(qe_Details);
}
}
catch (Exception ex)
{
}
}
