public static Quiz_MultipleQuestionDetails GetQuiz_MultipleQustionByMultipleQustionID(int MultipleQustionID)
{
Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails = new Quiz_MultipleQuestionDetails();
SqlQuiz_MultipleQuestionDetailsProvider sqlQuiz_MultipleQuestionDetailsProvider = new SqlQuiz_MultipleQuestionDetailsProvider();
quiz_MultipleQuestionDetails = sqlQuiz_MultipleQuestionDetailsProvider.GetQuiz_MultipleQuestionDetailsByMultipleQustionID(MultipleQustionID);
return quiz_MultipleQuestionDetails;
}
protected void btnAddMore_Click(object sender, EventArgs e)
{
try
{
if (Session["multipleQuestions"] == null)
{
List<Quiz_MultipleQuestionDetails> multipleQuestions = new List<Quiz_MultipleQuestionDetails>();
Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails = new Quiz_MultipleQuestionDetails();
quiz_MultipleQuestionDetails.QuestionTitle = txtQuestionTitle.Text;
quiz_MultipleQuestionDetails.IsAnswer = radIsAnswer.SelectedValue == "True" ? true : false;
quiz_MultipleQuestionDetails.MultipleQuestionDetailsID = 0;
multipleQuestions.Add(quiz_MultipleQuestionDetails);
Session["multipleQuestions"] = multipleQuestions;
txtQuestionTitle.Text = "";
radIsAnswer.SelectedIndex = -1;
gvQuiz_MultipleQuestionDetails.DataSource = Session["multipleQuestions"];
gvQuiz_MultipleQuestionDetails.DataBind();
txtQuestionTitle.Text = "";
radIsAnswer.SelectedIndex = -1;
}
else
{
Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails = new Quiz_MultipleQuestionDetails();
quiz_MultipleQuestionDetails.QuestionTitle = txtQuestionTitle.Text;
quiz_MultipleQuestionDetails.IsAnswer = radIsAnswer.SelectedValue == "True" ? true : false;
quiz_MultipleQuestionDetails.MultipleQuestionDetailsID = 0;
((List<Quiz_MultipleQuestionDetails>)Session["multipleQuestions"]).Add(quiz_MultipleQuestionDetails);
txtQuestionTitle.Text = "";
radIsAnswer.SelectedIndex = -1;
gvQuiz_MultipleQuestionDetails.DataSource = Session["multipleQuestions"];
gvQuiz_MultipleQuestionDetails.DataBind();
txtQuestionTitle.Text = "";
radIsAnswer.SelectedIndex = -1;
}
}
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)
{
}
}
private void showQuiz_MultipleQuestionData()
{
try
{
List<Quiz_MultipleQuestionDetails> multipleQuestions = new List<Quiz_MultipleQuestionDetails>();
Quiz_MultipleQuestion quiz_MultipleQuestion = new Quiz_MultipleQuestion();
quiz_MultipleQuestion = Quiz_MultipleQuestionManager.GetQuiz_MultipleQuestionByMultipleQustionID(Int32.Parse(Request.QueryString["ID"]));
ddlCourseID.SelectedValue = quiz_MultipleQuestion.CourseID.ToString();
ddlCourseID_SelectedIndexChanged(new Object(), new EventArgs());
ddlSubjectID.SelectedValue = quiz_MultipleQuestion.SubjectID.ToString();
ddlSubjectID_SelectedIndexChanged(new Object(), new EventArgs());
ddlChapterID.SelectedValue = quiz_MultipleQuestion.ChapterID.ToString();
fckDesc.Value= quiz_MultipleQuestion.MultipleQuestionName.ToString();
DataSet ds = Quiz_MultipleQuestionDetailsManager.GetAllQuiz_MultipleQuestionDetailsByMultipleQustionID(quiz_MultipleQuestion.MultipleQustionID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Quiz_MultipleQuestionDetails mcqDetail = new Quiz_MultipleQuestionDetails();
mcqDetail.MultipleQuestionDetailsID = Convert.ToInt32(dr["MultipleQuestionDetailsID"].ToString());
mcqDetail.MultipleQustionID = Convert.ToInt32(dr["MultipleQustionID"].ToString());
mcqDetail.QuestionTitle = dr["QuestionTitle"].ToString();
mcqDetail.IsAnswer = bool.Parse(dr["IsAnswer"].ToString());
mcqDetail.AddedBy = dr["AddedBy"].ToString();
mcqDetail.AddedDate = Convert.ToDateTime(dr["AddedDate"].ToString());
mcqDetail.ModifiedBy = dr["ModifiedBy"].ToString();
mcqDetail.ModifiedDate = Convert.ToDateTime(dr["ModifiedDate"].ToString());
multipleQuestions.Add(mcqDetail);
}
Session["multipleQuestions"] = multipleQuestions;
gvQuiz_MultipleQuestionDetails.DataSource = Session["multipleQuestions"];
gvQuiz_MultipleQuestionDetails.DataBind();
}
catch (Exception ex)
{
}
}
protected void btnUpdate_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 ;
int multipleQuestionID = int.Parse(Request.QueryString["ID"].ToString());
Quiz_MultipleQuestion quiz_MultipleQuestion = Quiz_MultipleQuestionManager.GetQuiz_MultipleQuestionByMultipleQustionID(multipleQuestionID);
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.ModifiedBy = userID;
quiz_MultipleQuestion.ModifiedDate = DateTime.Now;
bool result = Quiz_MultipleQuestionManager.UpdateQuiz_MultipleQuestion(quiz_MultipleQuestion);
if (result)
{
#region Fill In The BlankDetails Insert/Update
foreach (GridViewRow row in gvQuiz_MultipleQuestionDetails.Rows)
{
int mcqDtlID = Convert.ToInt32(((HiddenField)row.FindControl("hfMCQdtlID")).Value);
Label lblSerial = ((Label)row.FindControl("lblSerial"));
TextBox txtGridQuestionTitle = ((TextBox)row.FindControl("txtQuestionTitle"));
RadioButtonList radIsAnswer = ((RadioButtonList)row.FindControl("radIsAnswer"));
Quiz_MultipleQuestionDetails mcqDtl = new Quiz_MultipleQuestionDetails();
if (mcqDtlID > 0)
{
mcqDtl = multipleQuestions.Find(X => X.MultipleQuestionDetailsID == mcqDtlID);
mcqDtl.QuestionTitle = txtGridQuestionTitle.Text;
mcqDtl.IsAnswer = radIsAnswer.SelectedValue == "True" ? true : false;
mcqDtl.ModifiedBy = userID;
mcqDtl.ModifiedDate = DateTime.Now;
Quiz_MultipleQuestionDetailsManager.UpdateQuiz_MultipleQuestionDetails(mcqDtl);
}
else
{
mcqDtl.MultipleQuestionDetailsID = mcqDtlID;
mcqDtl.MultipleQustionID = multipleQuestionID;
mcqDtl.QuestionTitle = txtGridQuestionTitle.Text;
mcqDtl.IsAnswer = radIsAnswer.SelectedValue == "True" ? true : false;
mcqDtl.AddedBy = userID;
mcqDtl.AddedDate = DateTime.Now;
mcqDtl.ModifiedBy = userID;
mcqDtl.ModifiedDate = DateTime.Now;
Quiz_MultipleQuestionDetailsManager.InsertQuiz_MultipleQuestionDetails(mcqDtl);
}
}
if (txtQuestionTitle.Text != "")
{
Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails = new Quiz_MultipleQuestionDetails();
quiz_MultipleQuestionDetails.MultipleQustionID = multipleQuestionID;
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);
}
#endregion
#region Remove Deleted Answer from DB
List<int> deletedDtlID = new List<int>();
if (Session["deletedDtlID"] != null)
{
deletedDtlID = (List<int>)Session["deletedDtlID"];
foreach (int mcqDtlID in deletedDtlID)
{
Quiz_MultipleQuestionDetailsManager.DeleteQuiz_MultipleQuestionDetails(mcqDtlID);
}
}
#endregion
}
multipleQuestions.Clear();
Session["deletedDtlID"] = null;
Session["multipleQuestions"] = null;
//Response.Redirect("AdminDisplayQuiz_MultipleQuestion.aspx");
Response.Redirect("ExamOrSetBuilder.aspx");
}
catch (Exception ex)
{
}
}
public bool UpdateQuiz_MultipleQuestionDetails(Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateQuiz_MultipleQuestionDetails", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MultipleQuestionDetailsID", SqlDbType.Int).Value = quiz_MultipleQuestionDetails.MultipleQuestionDetailsID;
cmd.Parameters.Add("@MultipleQustionID", SqlDbType.Int).Value = quiz_MultipleQuestionDetails.MultipleQustionID;
cmd.Parameters.Add("@QuestionTitle", SqlDbType.NText).Value = quiz_MultipleQuestionDetails.QuestionTitle;
cmd.Parameters.Add("@IsAnswer", SqlDbType.Bit).Value = quiz_MultipleQuestionDetails.IsAnswer;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = quiz_MultipleQuestionDetails.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = quiz_MultipleQuestionDetails.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public Quiz_MultipleQuestionDetails GetQuiz_MultipleQuestionDetailsFromReader(IDataReader reader)
{
try
{
Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails = new Quiz_MultipleQuestionDetails
(
DataAccessObject.IsNULL<int>(reader["MultipleQuestionDetailsID"]),
DataAccessObject.IsNULL<int>(reader["MultipleQustionID"]),
DataAccessObject.IsNULL<string>(reader["QuestionTitle"]),
DataAccessObject.IsNULL<bool>(reader["IsAnswer"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return quiz_MultipleQuestionDetails;
}
catch(Exception ex)
{
return null;
}
}
public static int InsertQuiz_MultipleQuestionDetails(Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails)
{
SqlQuiz_MultipleQuestionDetailsProvider sqlQuiz_MultipleQuestionDetailsProvider = new SqlQuiz_MultipleQuestionDetailsProvider();
return sqlQuiz_MultipleQuestionDetailsProvider.InsertQuiz_MultipleQuestionDetails(quiz_MultipleQuestionDetails);
}
public static bool UpdateQuiz_MultipleQuestionDetails(Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails)
{
SqlQuiz_MultipleQuestionDetailsProvider sqlQuiz_MultipleQuestionDetailsProvider = new SqlQuiz_MultipleQuestionDetailsProvider();
return sqlQuiz_MultipleQuestionDetailsProvider.UpdateQuiz_MultipleQuestionDetails(quiz_MultipleQuestionDetails);
}
protected void btnSaveComprehention_Click(object sender, EventArgs e)
{
try
{
string userID = Profile.card_id ;
int comprehensionID = 0;
Quiz_Comprehension quiz_Comprehension = new Quiz_Comprehension();
#region "Save Comprehention Basic Data"
if (Request.QueryString["ID"] != null)
{
comprehensionID = Convert.ToInt32(Request.QueryString["ID"].ToString());
quiz_Comprehension = Quiz_ComprehensionManager.GetQuiz_ComprehensionByComprehensionID(comprehensionID);
quiz_Comprehension.CourseID = int.Parse(ddlCourseID.SelectedValue);
quiz_Comprehension.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
quiz_Comprehension.ChapterID = int.Parse(ddlChapterID.SelectedValue);
quiz_Comprehension.Comprehension = fckDesc.Value;
quiz_Comprehension.ModifiedBy = userID;
quiz_Comprehension.ModifiedDate = DateTime.Now;
Quiz_ComprehensionManager.UpdateQuiz_Comprehension(quiz_Comprehension);
}
else
{
quiz_Comprehension.ComprehensionID = 0;
quiz_Comprehension.CourseID = int.Parse(ddlCourseID.SelectedValue);
quiz_Comprehension.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
quiz_Comprehension.ChapterID = int.Parse(ddlChapterID.SelectedValue);
quiz_Comprehension.Comprehension = fckDesc.Value;
quiz_Comprehension.AddedBy = userID;
quiz_Comprehension.AddedDate = DateTime.Now;
quiz_Comprehension.ModifiedBy = userID;
quiz_Comprehension.ModifiedDate = DateTime.Now;
comprehensionID = Quiz_ComprehensionManager.InsertQuiz_Comprehension(quiz_Comprehension);
}
#endregion
#region "Save true and falsess"
for (int tI = 0; tI < gvQuiz_TrueFalse.Rows.Count; tI++)
{
Quiz_TrueFalse quiz_TrueFalse = new Quiz_TrueFalse();
HiddenField hfTureFalseID = (HiddenField)gvQuiz_TrueFalse.Rows[tI].FindControl("hfTureFalseID");
int trueFalseID = Convert.ToInt32(hfTureFalseID.Value);
TextBox txtQuestionTitle = (TextBox)gvQuiz_TrueFalse.Rows[tI].FindControl("txtQuestionTitle");
RadioButtonList radIsAnswer = (RadioButtonList)gvQuiz_TrueFalse.Rows[tI].FindControl("radIsAnswer");
if (txtQuestionTitle.Text != "")
{
quiz_TrueFalse.TrueFalseID = trueFalseID;
quiz_TrueFalse.ComprehensionID = comprehensionID;
quiz_TrueFalse.CourseID = int.Parse(ddlCourseID.SelectedValue);
quiz_TrueFalse.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
quiz_TrueFalse.ChapterID = int.Parse(ddlChapterID.SelectedValue);
quiz_TrueFalse.QuestionTitle = txtQuestionTitle.Text;
quiz_TrueFalse.IsDrCr = false;
quiz_TrueFalse.IsTrue = radIsAnswer.SelectedValue == "True" ? true : false;
quiz_TrueFalse.AddedBy = userID;
quiz_TrueFalse.AddedDate = DateTime.Now;
quiz_TrueFalse.ModifiedBy = userID;
quiz_TrueFalse.ModifiedDate = DateTime.Now;
if (trueFalseID > 0)
Quiz_TrueFalseManager.UpdateQuiz_TrueFalse(quiz_TrueFalse);
else
trueFalseID = Quiz_TrueFalseManager.InsertQuiz_TrueFalse(quiz_TrueFalse);
}
}
gvQuiz_TrueFalse.DataSource = string.Empty.ToList();
gvQuiz_TrueFalse.DataBind();
#endregion
#region "Save dr cr "
for (int dI = 0; dI < gvQuiz_gvDrCr.Rows.Count; dI++)
{
Quiz_TrueFalse quiz_TrueFalse = new Quiz_TrueFalse();
HiddenField hfDrCrID = (HiddenField)gvQuiz_gvDrCr.Rows[dI].FindControl("hfDrCrID");
int trueFalseID = Convert.ToInt32(hfDrCrID.Value);
TextBox txtQuestionTitle = (TextBox)gvQuiz_gvDrCr.Rows[dI].FindControl("txtQuestionTitle");
RadioButtonList radIsAnswer = (RadioButtonList)gvQuiz_gvDrCr.Rows[dI].FindControl("radIsAnswer");
if (txtQuestionTitle.Text != "")
{
quiz_TrueFalse.TrueFalseID = trueFalseID;
quiz_TrueFalse.ComprehensionID = comprehensionID;
quiz_TrueFalse.CourseID = int.Parse(ddlCourseID.SelectedValue);
quiz_TrueFalse.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
quiz_TrueFalse.ChapterID = int.Parse(ddlChapterID.SelectedValue);
quiz_TrueFalse.QuestionTitle = txtQuestionTitle.Text;
quiz_TrueFalse.IsDrCr = true;
quiz_TrueFalse.IsTrue = radIsAnswer.SelectedValue == "True" ? true : false;
quiz_TrueFalse.AddedBy = userID;
quiz_TrueFalse.AddedDate = DateTime.Now;
quiz_TrueFalse.ModifiedBy = userID;
quiz_TrueFalse.ModifiedDate = DateTime.Now;
if (trueFalseID > 0)
Quiz_TrueFalseManager.UpdateQuiz_TrueFalse(quiz_TrueFalse);
else
trueFalseID = Quiz_TrueFalseManager.InsertQuiz_TrueFalse(quiz_TrueFalse);
}
}
gvQuiz_gvDrCr.DataSource = string.Empty.ToList();
gvQuiz_gvDrCr.DataBind();
#endregion
#region Delete True/False and Dr/Cr Questions
List<int> delTrueFalseIDs = new List<int>();
if (Session["delTrueFalseIDs"] != null)
{
delTrueFalseIDs = (List<int>)Session["delTrueFalseIDs"];
foreach (int id in delTrueFalseIDs)
{
Quiz_TrueFalseManager.DeleteQuiz_TrueFalse(id);
}
}
#endregion
#region "Save fill in the blanks"
for (int i = 0; i < gvQuiz_FillInTheBlanks.Rows.Count; i++)
{
Quiz_FillInTheBlanks fillInTheBlanks = new Quiz_FillInTheBlanks();
HiddenField hfFillInTheBlankID = (HiddenField)gvQuiz_FillInTheBlanks.Rows[i].FindControl("hfFillInTheBlankID");
int fillInTheBlankID = Convert.ToInt32(hfFillInTheBlankID.Value);
TextBox txtFilInTheBlanksQuestion = (TextBox)gvQuiz_FillInTheBlanks.Rows[i].FindControl("txtFilInTheBlanksQuestion");
if (txtFilInTheBlanksQuestion.Text != "")
{
fillInTheBlanks.FillInTheBlanksID = fillInTheBlankID;
fillInTheBlanks.Question = txtFilInTheBlanksQuestion.Text;
fillInTheBlanks.ChapterID = int.Parse(ddlChapterID.SelectedValue);
fillInTheBlanks.CourseID = int.Parse(ddlCourseID.SelectedValue);
fillInTheBlanks.ComprehensionID = comprehensionID;
fillInTheBlanks.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
fillInTheBlanks.AddedBy = userID;
fillInTheBlanks.AddedDate = DateTime.Now;
fillInTheBlanks.ModifiedBy = userID;
fillInTheBlanks.ModifiedDate = DateTime.Now;
if (fillInTheBlankID > 0)
Quiz_FillInTheBlanksManager.UpdateQuiz_FillInTheBlanks(fillInTheBlanks);
else
fillInTheBlankID = Quiz_FillInTheBlanksManager.InsertQuiz_FillInTheBlanks(fillInTheBlanks);
#region Fill In The Blanks Details
if (fillInTheBlankID > 0)
{
GridView gvQuiz_FillInTheBlanksDetails = (GridView)gvQuiz_FillInTheBlanks.Rows[i].FindControl("gvQuiz_FillInTheBlanksDetails");
for (int j = 0; j < gvQuiz_FillInTheBlanksDetails.Rows.Count; j++)
{
HiddenField hfFillInTheBlankDtlID = (HiddenField)gvQuiz_FillInTheBlanksDetails.Rows[j].FindControl("hfFillInTheBlankDtlID");
int fillInTheBlanksDetailsID = Convert.ToInt32(hfFillInTheBlankDtlID.Value);
Label lblSerial = (Label)gvQuiz_FillInTheBlanksDetails.Rows[j].FindControl("lblSerial");
TextBox txtAnswer = ((TextBox)gvQuiz_FillInTheBlanksDetails.Rows[j].FindControl("txtAnswer"));
if (txtAnswer.Text != "")
{
Quiz_FillInTheBlanksDetails fillInTheBlanksDtl = new Quiz_FillInTheBlanksDetails();
fillInTheBlanksDtl.FillInTheBlanksDetailsID = fillInTheBlanksDetailsID;
fillInTheBlanksDtl.FillInTheBlanksID = fillInTheBlankID;
fillInTheBlanksDtl.QuestionSl = int.Parse(lblSerial.Text);
fillInTheBlanksDtl.Answer = txtAnswer.Text;
fillInTheBlanksDtl.AddedBy = userID;
fillInTheBlanksDtl.AddedDate = DateTime.Now;
fillInTheBlanksDtl.ModifiedBy = userID;
fillInTheBlanksDtl.ModifiedDate = DateTime.Now;
if (fillInTheBlanksDetailsID > 0)
Quiz_FillInTheBlanksDetailsManager.UpdateQuiz_FillInTheBlanksDetails(fillInTheBlanksDtl);
else
fillInTheBlanksDetailsID = Quiz_FillInTheBlanksDetailsManager.InsertQuiz_FillInTheBlanksDetails(fillInTheBlanksDtl);
}
}
gvQuiz_FillInTheBlanksDetails.DataSource = string.Empty.ToList();
gvQuiz_FillInTheBlanksDetails.DataBind();
}
}
}
gvQuiz_FillInTheBlanks.DataSource = string.Empty.ToList();
gvQuiz_FillInTheBlanks.DataBind();
#endregion
List<int> delFillInTheBlankIDs = new List<int>();
if (Session["delFillInTheBlankIDs"] != null)
{
delFillInTheBlankIDs = (List<int>)Session["delFillInTheBlankIDs"];
foreach (int id in delFillInTheBlankIDs)
{
Quiz_FillInTheBlanksManager.DeleteQuiz_FillInTheBlanks(id);
}
}
List<int> delFillInTheBlankDetailsIDs = new List<int>();
if (Session["delFillInTheBlankDetailsIDs"] != null)
{
delFillInTheBlankDetailsIDs = (List<int>)Session["delFillInTheBlankDetailsIDs"];
foreach (int id in delFillInTheBlankDetailsIDs)
{
Quiz_FillInTheBlanksDetailsManager.DeleteQuiz_FillInTheBlanksDetails(id);
}
}
#endregion
#region "Save multiple questions"
for (int mI = 0; mI < gvQuiz_MultipleQuestion.Rows.Count; mI++)
{
TextBox txtMultipleQuestionName = (TextBox)gvQuiz_MultipleQuestion.Rows[mI].FindControl("txtMultipleQuestionName");
HiddenField hfMultipleQuestionID = (HiddenField)gvQuiz_MultipleQuestion.Rows[mI].FindControl("hfMultipleQuestionID");
int multipleQuestionID = Convert.ToInt32(hfMultipleQuestionID.Value);
if (txtMultipleQuestionName.Text != "")
{
Quiz_MultipleQuestion quiz_MultipleQuestion = new Quiz_MultipleQuestion();
quiz_MultipleQuestion.MultipleQustionID = multipleQuestionID;
quiz_MultipleQuestion.ComprehensionID = comprehensionID;
quiz_MultipleQuestion.CourseID = int.Parse(ddlCourseID.SelectedValue);
quiz_MultipleQuestion.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
quiz_MultipleQuestion.ChapterID = int.Parse(ddlChapterID.SelectedValue);
quiz_MultipleQuestion.MultipleQuestionName = txtMultipleQuestionName.Text;
quiz_MultipleQuestion.AddedBy = userID;
quiz_MultipleQuestion.AddedDate = DateTime.Now;
quiz_MultipleQuestion.ModifiedBy = userID;
quiz_MultipleQuestion.ModifiedDate = DateTime.Now;
if (multipleQuestionID > 0)
Quiz_MultipleQuestionManager.UpdateQuiz_MultipleQuestion(quiz_MultipleQuestion);
else
multipleQuestionID = Quiz_MultipleQuestionManager.InsertQuiz_MultipleQuestion(quiz_MultipleQuestion);
GridView gvQuiz_MultipleQuestionDetails = (GridView)gvQuiz_MultipleQuestion.Rows[mI].FindControl("gvQuiz_MultipleQuestionDetails");
for (int mDi = 0; mDi < gvQuiz_MultipleQuestionDetails.Rows.Count; mDi++)
{
Label lblSerial = ((Label)gvQuiz_MultipleQuestionDetails.Rows[mDi].FindControl("lblSerial"));
HiddenField hfMultipleQuestionDetailsID = (HiddenField)gvQuiz_MultipleQuestionDetails.Rows[mDi].FindControl("hfMultipleQuestionDetailsID");
int multipleQuestionDetailsID = Convert.ToInt32(hfMultipleQuestionDetailsID.Value);
TextBox txtQuestionTitle = (TextBox)gvQuiz_MultipleQuestionDetails.Rows[mDi].FindControl("txtQuestionTitle");
Label lblAnswer = (Label)gvQuiz_MultipleQuestionDetails.Rows[mDi].FindControl("lblAnswer");
RadioButtonList chkAnswer = (RadioButtonList)gvQuiz_MultipleQuestionDetails.Rows[mDi].FindControl("radIsAnswer");
if (txtQuestionTitle.Text != "")
{
Quiz_MultipleQuestionDetails quiz_MultipleQuestionDetails = new Quiz_MultipleQuestionDetails();
quiz_MultipleQuestionDetails.MultipleQuestionDetailsID = multipleQuestionDetailsID;
quiz_MultipleQuestionDetails.MultipleQustionID = multipleQuestionID;
quiz_MultipleQuestionDetails.QuestionTitle = txtQuestionTitle.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;
if (multipleQuestionDetailsID > 0)
Quiz_MultipleQuestionDetailsManager.UpdateQuiz_MultipleQuestionDetails(quiz_MultipleQuestionDetails);
else
multipleQuestionDetailsID = Quiz_MultipleQuestionDetailsManager.InsertQuiz_MultipleQuestionDetails(quiz_MultipleQuestionDetails);
}
}
gvQuiz_MultipleQuestionDetails.DataSource = string.Empty.ToList();
gvQuiz_MultipleQuestionDetails.DataBind();
}
}
gvQuiz_MultipleQuestion.DataSource = string.Empty.ToList();
gvQuiz_MultipleQuestion.DataBind();
List<int> delMultipleQuestionIDs = new List<int>();
if (Session["delMultipleQuestionIDs"] != null)
{
delMultipleQuestionIDs = (List<int>)Session["delMultipleQuestionIDs"];
foreach (int id in delMultipleQuestionIDs)
{
Quiz_MultipleQuestionManager.DeleteQuiz_MultipleQuestion(id);
}
}
List<int> delMultipleQuestionDetailsIDs = new List<int>();
if (Session["delMultipleQuestionDetailsIDs"] != null)
{
delMultipleQuestionDetailsIDs = (List<int>)Session["delMultipleQuestionDetailsIDs"];
foreach (int id in delMultipleQuestionDetailsIDs)
{
Quiz_MultipleQuestionDetailsManager.DeleteQuiz_MultipleQuestionDetails(id);
}
}
#endregion
Response.Redirect("~/quiz/AdminDisplayQuiz_Comprehension.aspx", false);
}
catch (Exception ex)
{
}
}
protected void btnMoreMultipleQuestionAns_Click(object sender, EventArgs e)
{
try
{
List<Quiz_MultipleQuestionDetails> multipleQuestionDetails = new List<Quiz_MultipleQuestionDetails>();
Button btnMoreMultipleQuestionAns = (Button)sender;
GridViewRow row = (GridViewRow)btnMoreMultipleQuestionAns.NamingContainer;
GridView gvQuiz_MultipleQuestionDetails = (GridView)row.FindControl("gvQuiz_MultipleQuestionDetails");
foreach (GridViewRow dtlRow in gvQuiz_MultipleQuestionDetails.Rows)
{
TextBox txtQuestionTitle = (TextBox)dtlRow.FindControl("txtQuestionTitle");
Quiz_MultipleQuestionDetails multipleQuestionDetail = new Quiz_MultipleQuestionDetails();
multipleQuestionDetail.MultipleQustionID = 0;
multipleQuestionDetail.MultipleQuestionDetailsID = 0;
multipleQuestionDetail.QuestionTitle = txtQuestionTitle.Text;
multipleQuestionDetails.Add(multipleQuestionDetail);
}
//Session["multipleQuestionDetails"] = multipleQuestionDetails;
multipleQuestionDetails.Add(new Quiz_MultipleQuestionDetails());
gvQuiz_MultipleQuestionDetails.DataSource = multipleQuestionDetails;
gvQuiz_MultipleQuestionDetails.DataBind();
}
catch (Exception ex)
{
}
}
protected void btnDeleteMultipleQuestionDetails_Click(object sender, EventArgs e)
{
try
{
List<Quiz_MultipleQuestionDetails> multipleQuestionDetails = new List<Quiz_MultipleQuestionDetails>();
List<int> delMultipleQuestionDetailsIDs = new List<int>();
ImageButton btnDelete = new ImageButton();
btnDelete = (ImageButton)sender;
GridView gvQuiz_MultipleQuestionDetails = (GridView)((GridViewRow)btnDelete.NamingContainer).NamingContainer;
foreach (GridViewRow dtlRow in gvQuiz_MultipleQuestionDetails.Rows)
{
TextBox txtQuestionTitle = (TextBox)dtlRow.FindControl("txtQuestionTitle");
Label lblAnswer = (Label)dtlRow.FindControl("lblAnswer");
HiddenField hfMultipleQuestionDetailsID = (HiddenField)dtlRow.FindControl("hfMultipleQuestionDetailsID");
Quiz_MultipleQuestionDetails multipleQuestionDetail = new Quiz_MultipleQuestionDetails();
multipleQuestionDetail.MultipleQuestionDetailsID = Convert.ToInt32(hfMultipleQuestionDetailsID.Value);
multipleQuestionDetail.MultipleQustionID = 0;
multipleQuestionDetail.QuestionTitle = txtQuestionTitle.Text;
multipleQuestionDetail.IsAnswer = bool.Parse(lblAnswer.Text);
multipleQuestionDetails.Add(multipleQuestionDetail);
}
int index = Convert.ToInt32(btnDelete.CommandArgument);
multipleQuestionDetails.RemoveAt(index);
Session["multipleQuestionDetails"] = multipleQuestionDetails;
GridViewRow row = (GridViewRow)btnDelete.NamingContainer;
int multipleQuestionDetailsID = Convert.ToInt32(((HiddenField)row.FindControl("hfMultipleQuestionDetailsID")).Value);
if (multipleQuestionDetailsID > 0)
{
if (Session["delMultipleQuestionDetailsIDs"] == null)
{
delMultipleQuestionDetailsIDs.Add(multipleQuestionDetailsID);
Session["delMultipleQuestionDetailsIDs"] = delMultipleQuestionDetailsIDs;
}
else
((List<int>)Session["delMultipleQuestionDetailsIDs"]).Add(multipleQuestionDetailsID);
}
gvQuiz_MultipleQuestionDetails.DataSource = Session["multipleQuestionDetails"];
gvQuiz_MultipleQuestionDetails.DataBind();
//upMultipleQuestion.Update();
}
catch (Exception ex)
{
}
}
