public static Quiz_TrueFalse GetQuiz_SubjectBySubjectID(int SubjectID)
{
Quiz_TrueFalse quiz_TrueFalse = new Quiz_TrueFalse();
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
quiz_TrueFalse = sqlQuiz_TrueFalseProvider.GetQuiz_TrueFalseBySubjectID(SubjectID);
return quiz_TrueFalse;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
string userID = Profile.card_id;
Quiz_TrueFalse quiz_TrueFalse = new Quiz_TrueFalse();
quiz_TrueFalse.TrueFalseID = int.Parse(Request.QueryString["ID"].ToString());
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;
bool resutl = Quiz_TrueFalseManager.UpdateQuiz_TrueFalse(quiz_TrueFalse);
//if (quiz_TrueFalse.IsDrCr)
// Response.Redirect("AdminDisplayQuiz_DrCr.aspx");
//else
// Response.Redirect("AdminDisplayQuiz_TrueFalse.aspx");
Response.Redirect("ExamOrSetBuilder.aspx");
}
catch (Exception ex)
{
}
}
public static Quiz_TrueFalse GetQuiz_CourseByCourseID(int CourseID)
{
Quiz_TrueFalse quiz_TrueFalse = new Quiz_TrueFalse();
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
quiz_TrueFalse = sqlQuiz_TrueFalseProvider.GetQuiz_TrueFalseByCourseID(CourseID);
return quiz_TrueFalse;
}
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)
{
}
}
private void showQuiz_TrueFalseData()
{
try
{
Quiz_TrueFalse quiz_TrueFalse = new Quiz_TrueFalse();
quiz_TrueFalse = Quiz_TrueFalseManager.GetQuiz_TrueFalseByTrueFalseID(Int32.Parse(Request.QueryString["ID"]));
ddlCourseID.SelectedValue = quiz_TrueFalse.CourseID.ToString();
_loadSubject(quiz_TrueFalse.CourseID);
ddlSubjectID.SelectedValue = quiz_TrueFalse.SubjectID.ToString();
ChapterIDLoad(quiz_TrueFalse.CourseID, quiz_TrueFalse.SubjectID);
ddlChapterID.SelectedValue = quiz_TrueFalse.ChapterID.ToString();
fckDesc.Value = quiz_TrueFalse.QuestionTitle.ToString();
radIsDrCr.SelectedValue = quiz_TrueFalse.IsDrCr.ToString();
radIsTrue.SelectedValue = quiz_TrueFalse.IsTrue.ToString();
ddlExamID.Enabled = false;
}
catch (Exception ex)
{
}
}
protected void btnTrueFalseAddMore_Click(object sender, EventArgs e)
{
try
{
if (Session["listTrueFalse"] == null)
{
List<Quiz_TrueFalse> listTrueFalse = new List<Quiz_TrueFalse>();
Quiz_TrueFalse truefalse = new Quiz_TrueFalse();
truefalse.QuestionTitle = txtTrueFalseQuestionTitle.Text;
truefalse.IsTrue = radTrueFalse.SelectedValue == "True" ? true : false;
truefalse.IsDrCr = false;
// before that we have to generate the comprehention id
truefalse.ComprehensionID = 1;
listTrueFalse.Add(truefalse);
Session["listTrueFalse"] = listTrueFalse;
gvQuiz_TrueFalse.DataSource = Session["listTrueFalse"];
gvQuiz_TrueFalse.DataBind();
txtTrueFalseQuestionTitle.Text = string.Empty;
radTrueFalse.SelectedIndex = -1;
}
else
{
Quiz_TrueFalse truefalse = new Quiz_TrueFalse();
truefalse.QuestionTitle = txtTrueFalseQuestionTitle.Text;
truefalse.IsTrue = radTrueFalse.SelectedValue == "True" ? true : false;
truefalse.IsDrCr = false;
// before that we have to generate the comprehention id
truefalse.ComprehensionID = 1;
((List<Quiz_TrueFalse>)Session["listTrueFalse"]).Add(truefalse);
gvQuiz_TrueFalse.DataSource = Session["listTrueFalse"];
gvQuiz_TrueFalse.DataBind();
txtTrueFalseQuestionTitle.Text = string.Empty;
radTrueFalse.SelectedIndex = -1;
}
}
catch (Exception ex)
{
}
}
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 btnDrCrAddMore_Click(object sender, EventArgs e)
{
try
{
if (Session["listDrCr"] == null)
{
List<Quiz_TrueFalse> listDrCr = new List<Quiz_TrueFalse>();
Quiz_TrueFalse drcr = new Quiz_TrueFalse();
drcr.QuestionTitle = txtDrCrQuestion.Text;
drcr.IsTrue = radDrCr.SelectedValue == "True" ? true : false;
drcr.IsDrCr = true;
// before that we have to generate the comprehention id
drcr.ComprehensionID = 1;
listDrCr.Add(drcr);
Session["listDrCr"] = listDrCr;
gvQuiz_gvDrCr.DataSource = Session["listDrCr"];
gvQuiz_gvDrCr.DataBind();
txtTrueFalseQuestionTitle.Text = string.Empty;
radDrCr.SelectedIndex = -1;
}
else
{
Quiz_TrueFalse drcr = new Quiz_TrueFalse();
drcr.QuestionTitle = txtDrCrQuestion.Text;
drcr.IsTrue = radDrCr.SelectedValue == "True" ? true : false;
drcr.IsDrCr = true;
// before that we have to generate the comprehention id
drcr.ComprehensionID = 1;
((List<Quiz_TrueFalse>)Session["listDrCr"]).Add(drcr);
gvQuiz_gvDrCr.DataSource = Session["listDrCr"];
gvQuiz_gvDrCr.DataBind();
txtTrueFalseQuestionTitle.Text = string.Empty;
radDrCr.SelectedIndex = -1;
}
}
catch (Exception ex)
{
}
}
private void showQuiz_ComprehensionData()
{
try
{
List<Quiz_TrueFalse> listTrueFalse = new List<Quiz_TrueFalse>();
int comprehensionID = Convert.ToInt32(Request.QueryString["ID"].ToString());
Quiz_Comprehension quiz_Comprehension = new Quiz_Comprehension();
quiz_Comprehension = Quiz_ComprehensionManager.GetQuiz_ComprehensionByComprehensionID(comprehensionID);
ddlCourseID.SelectedValue = quiz_Comprehension.CourseID.ToString();
_loadSubject(quiz_Comprehension.CourseID);
ddlSubjectID.SelectedValue = quiz_Comprehension.SubjectID.ToString();
ChapterIDLoad(quiz_Comprehension.CourseID, quiz_Comprehension.SubjectID);
ddlChapterID.SelectedValue = quiz_Comprehension.ChapterID.ToString();
fckDesc.Value= quiz_Comprehension.Comprehension.ToString();
#region Display TrueFalse Questions
DataSet ds = Quiz_TrueFalseManager.GetQuiz_TrueFalseByComprehensionID(comprehensionID);
listTrueFalse.Clear();
foreach (DataRow dr in ds.Tables[0].Rows)
{
Quiz_TrueFalse trueFalse = new Quiz_TrueFalse();
trueFalse.TrueFalseID = Convert.ToInt32(dr["TrueFalseID"].ToString());
trueFalse.ComprehensionID = Convert.ToInt32(dr["ComprehensionID"].ToString());
trueFalse.CourseID = Convert.ToInt32(dr["CourseID"].ToString());
trueFalse.SubjectID = Convert.ToInt32(dr["SubjectID"].ToString());
trueFalse.ChapterID = Convert.ToInt32(dr["ChapterID"].ToString());
trueFalse.QuestionTitle = dr["QuestionTitle"].ToString();
trueFalse.IsDrCr = Convert.ToBoolean(dr["IsDrCr"].ToString());
trueFalse.IsTrue = Convert.ToBoolean(dr["IsTrue"].ToString());
trueFalse.AddedBy = dr["AddedBy"].ToString();
trueFalse.AddedDate = Convert.ToDateTime(dr["AddedDate"].ToString());
trueFalse.ModifiedBy = dr["ModifiedBy"].ToString();
trueFalse.ModifiedDate = Convert.ToDateTime(dr["ModifiedDate"].ToString());
listTrueFalse.Add(trueFalse);
}
Session["listTrueFalse"] = listTrueFalse;
gvQuiz_TrueFalse.DataSource = Session["listTrueFalse"];
gvQuiz_TrueFalse.DataBind();
#endregion
#region Display DrCr Questions
List<Quiz_TrueFalse> listDrCr = new List<Quiz_TrueFalse>();
ds = new DataSet();
ds = Quiz_TrueFalseManager.GetQuiz_DrCrByComprehensionID(comprehensionID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Quiz_TrueFalse drcr = new Quiz_TrueFalse();
drcr.TrueFalseID = Convert.ToInt32(dr["TrueFalseID"].ToString());
drcr.ComprehensionID = Convert.ToInt32(dr["ComprehensionID"].ToString());
drcr.CourseID = Convert.ToInt32(dr["CourseID"].ToString());
drcr.SubjectID = Convert.ToInt32(dr["SubjectID"].ToString());
drcr.ChapterID = Convert.ToInt32(dr["ChapterID"].ToString());
drcr.QuestionTitle = dr["QuestionTitle"].ToString();
drcr.IsDrCr = Convert.ToBoolean(dr["IsDrCr"].ToString());
drcr.IsTrue = Convert.ToBoolean(dr["IsTrue"].ToString());
drcr.AddedBy = dr["AddedBy"].ToString();
drcr.AddedDate = Convert.ToDateTime(dr["AddedDate"].ToString());
drcr.ModifiedBy = dr["ModifiedBy"].ToString();
drcr.ModifiedDate = Convert.ToDateTime(dr["ModifiedDate"].ToString());
listDrCr.Add(drcr);
}
Session["listDrCr"] = listDrCr;
gvQuiz_gvDrCr.DataSource = Session["listDrCr"];
gvQuiz_gvDrCr.DataBind();
#endregion
#region Display Fill in The BlankQuestions
List<Quiz_FillInTheBlanks> fillInTheBlanks = new List<Quiz_FillInTheBlanks>();
DataSet dsFillInTheBlanks = Quiz_FillInTheBlanksManager.GetQuiz_FillInTheBlanksByComprehensionID(comprehensionID);
foreach (DataRow dr in dsFillInTheBlanks.Tables[0].Rows)
{
Quiz_FillInTheBlanks fillInTheBlank = new Quiz_FillInTheBlanks();
fillInTheBlank.FillInTheBlanksID = Convert.ToInt32(dr["FillInTheBlanksID"].ToString());
fillInTheBlank.ComprehensionID = Convert.ToInt32(dr["ComprehensionID"].ToString());
fillInTheBlank.Question = dr["Question"].ToString();
fillInTheBlank.CourseID = Convert.ToInt32(dr["CourseID"].ToString());
fillInTheBlank.SubjectID = Convert.ToInt32(dr["SubjectID"].ToString());
fillInTheBlank.ChapterID = Convert.ToInt32(dr["ChapterID"].ToString());
fillInTheBlank.AddedBy=dr["AddedBy"].ToString();
fillInTheBlank.AddedDate = Convert.ToDateTime(dr["AddedDate"].ToString());
fillInTheBlank.ModifiedBy = dr["ModifiedBy"].ToString();
fillInTheBlank.ModifiedDate = Convert.ToDateTime(dr["ModifiedDate"].ToString());
fillInTheBlanks.Add(fillInTheBlank);
}
Session["fillInTheBlanks"] = fillInTheBlanks;
gvQuiz_FillInTheBlanks.DataSource = Session["fillInTheBlanks"];
gvQuiz_FillInTheBlanks.DataBind();
#endregion
#region Display Multiple Choice Questions
List<Quiz_MultipleQuestion> multipleQuestions = new List<Quiz_MultipleQuestion>();
DataSet dsMultipleQuestions = Quiz_MultipleQuestionManager.GetQuiz_MultipleQuestionByComprehensionID(comprehensionID);
foreach (DataRow dr in dsMultipleQuestions.Tables[0].Rows)
{
Quiz_MultipleQuestion multipleQuestion = new Quiz_MultipleQuestion();
multipleQuestion.MultipleQustionID = Convert.ToInt32(dr["MultipleQustionID"].ToString());
multipleQuestion.ComprehensionID = Convert.ToInt32(dr["ComprehensionID"].ToString());
multipleQuestion.CourseID = Convert.ToInt32(dr["CourseID"].ToString());
multipleQuestion.SubjectID = Convert.ToInt32(dr["SubjectID"].ToString());
multipleQuestion.ChapterID = Convert.ToInt32(dr["ChapterID"].ToString());
multipleQuestion.MultipleQuestionName = dr["MultipleQuestionName"].ToString();
multipleQuestion.AddedBy = dr["AddedBy"].ToString();
multipleQuestion.AddedDate = Convert.ToDateTime(dr["AddedDate"].ToString());
multipleQuestion.ModifiedBy = dr["ModifiedBy"].ToString();
multipleQuestion.ModifiedDate = Convert.ToDateTime(dr["ModifiedDate"].ToString());
multipleQuestions.Add(multipleQuestion);
}
Session["multipleQuestions"] = multipleQuestions;
gvQuiz_MultipleQuestion.DataSource = Session["multipleQuestions"];
gvQuiz_MultipleQuestion.DataBind();
#endregion
}
catch (Exception ex)
{
}
}
public static bool UpdateQuiz_TrueFalse(Quiz_TrueFalse quiz_TrueFalse)
{
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
return sqlQuiz_TrueFalseProvider.UpdateQuiz_TrueFalse(quiz_TrueFalse);
}
public static int InsertQuiz_TrueFalse(Quiz_TrueFalse quiz_TrueFalse)
{
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
return sqlQuiz_TrueFalseProvider.InsertQuiz_TrueFalse(quiz_TrueFalse);
}
