public static Quiz_FillInTheBlanks GetQuiz_CourseByCourseID(int CourseID) { Quiz_FillInTheBlanks quiz_FillInTheBlanks = new Quiz_FillInTheBlanks(); SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider(); quiz_FillInTheBlanks = sqlQuiz_FillInTheBlanksProvider.GetQuiz_FillInTheBlanksByCourseID(CourseID); return quiz_FillInTheBlanks; }
public bool UpdateQuiz_FillInTheBlanks(Quiz_FillInTheBlanks quiz_FillInTheBlanks) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateQuiz_FillInTheBlanks", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FillInTheBlanksID", SqlDbType.Int).Value = quiz_FillInTheBlanks.FillInTheBlanksID; cmd.Parameters.Add("@ComprehensionID", SqlDbType.Int).Value = quiz_FillInTheBlanks.ComprehensionID; cmd.Parameters.Add("@Question", SqlDbType.NText).Value = quiz_FillInTheBlanks.Question; cmd.Parameters.Add("@CourseID", SqlDbType.Int).Value = quiz_FillInTheBlanks.CourseID; cmd.Parameters.Add("@SubjectID", SqlDbType.Int).Value = quiz_FillInTheBlanks.SubjectID; cmd.Parameters.Add("@ChapterID", SqlDbType.Int).Value = quiz_FillInTheBlanks.ChapterID; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = quiz_FillInTheBlanks.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = quiz_FillInTheBlanks.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public Quiz_FillInTheBlanks GetQuiz_FillInTheBlanksFromReaderTable(DataRow reader) { try { Quiz_FillInTheBlanks quiz_FillInTheBlanks = new Quiz_FillInTheBlanks ( DataAccessObject.IsNULL<int>(reader["FillInTheBlanksID"]), DataAccessObject.IsNULL<int>(reader["ComprehensionID"]), DataAccessObject.IsNULL<string>(reader["Question"]), DataAccessObject.IsNULL<int>(reader["CourseID"]), DataAccessObject.IsNULL<int>(reader["SubjectID"]), DataAccessObject.IsNULL<int>(reader["ChapterID"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return quiz_FillInTheBlanks; } catch (Exception ex) { return null; } }
public static bool UpdateQuiz_FillInTheBlanks(Quiz_FillInTheBlanks quiz_FillInTheBlanks) { SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider(); return sqlQuiz_FillInTheBlanksProvider.UpdateQuiz_FillInTheBlanks(quiz_FillInTheBlanks); }
public static Quiz_FillInTheBlanks GetQuiz_SubjectBySubjectID(int SubjectID) { Quiz_FillInTheBlanks quiz_FillInTheBlanks = new Quiz_FillInTheBlanks(); SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider(); quiz_FillInTheBlanks = sqlQuiz_FillInTheBlanksProvider.GetQuiz_FillInTheBlanksBySubjectID(SubjectID); return quiz_FillInTheBlanks; }
public static int InsertQuiz_FillInTheBlanks(Quiz_FillInTheBlanks quiz_FillInTheBlanks) { SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider(); return sqlQuiz_FillInTheBlanksProvider.InsertQuiz_FillInTheBlanks(quiz_FillInTheBlanks); }
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 btnMoreFillInTheBlanksQuestion_Click(object sender, EventArgs e) { try { if (Session["fillInTheBlanks"] == null) { List<Quiz_FillInTheBlanks> fillInTheBlanks = new List<Quiz_FillInTheBlanks>(); Quiz_FillInTheBlanks quiz_FillInTheBlank = new Quiz_FillInTheBlanks(); quiz_FillInTheBlank.FillInTheBlanksID = 0; fillInTheBlanks.Add(quiz_FillInTheBlank); Session["fillInTheBlanks"] = fillInTheBlanks; gvQuiz_FillInTheBlanks.DataSource = Session["fillInTheBlanks"]; gvQuiz_FillInTheBlanks.DataBind(); } else { Quiz_FillInTheBlanks quiz_FillInTheBlank = new Quiz_FillInTheBlanks(); quiz_FillInTheBlank.FillInTheBlanksID = 0; ((List<Quiz_FillInTheBlanks>)Session["fillInTheBlanks"]).Add(quiz_FillInTheBlank); gvQuiz_FillInTheBlanks.DataSource = Session["fillInTheBlanks"]; gvQuiz_FillInTheBlanks.DataBind(); } } 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) { } }
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) { } }
private void showQuiz_FillInTheBlanksData() { try { List<Quiz_FillInTheBlanksDetails> fillInTheBlanksDetails = new List<Quiz_FillInTheBlanksDetails>(); Quiz_FillInTheBlanks quiz_FillInTheBlanks = new Quiz_FillInTheBlanks(); quiz_FillInTheBlanks = Quiz_FillInTheBlanksManager.GetQuiz_FillInTheBlanksByFillInTheBlanksID(Int32.Parse(Request.QueryString["ID"])); _loadSubject(quiz_FillInTheBlanks.CourseID); ChapterIDLoad(quiz_FillInTheBlanks.CourseID, quiz_FillInTheBlanks.SubjectID); fckDesc.Value= quiz_FillInTheBlanks.Question.ToString(); ddlCourseID.SelectedValue = quiz_FillInTheBlanks.CourseID.ToString(); ddlSubjectID.SelectedValue = quiz_FillInTheBlanks.SubjectID.ToString(); ddlSubjectID_SelectedIndexChanged(this, new EventArgs()); ddlChapterID.SelectedValue = quiz_FillInTheBlanks.ChapterID.ToString(); DataSet ds = Quiz_FillInTheBlanksDetailsManager.GetQuiz_FillInTheBlanksByFillInTheBlanksID(quiz_FillInTheBlanks.FillInTheBlanksID); foreach (DataRow dr in ds.Tables[0].Rows) { Quiz_FillInTheBlanksDetails fitbDetails = new Quiz_FillInTheBlanksDetails(); fitbDetails.FillInTheBlanksDetailsID = Convert.ToInt32(dr["FillInTheBlanksDetailsID"].ToString()); fitbDetails.FillInTheBlanksID = Convert.ToInt32(dr["FillInTheBlanksID"].ToString()); fitbDetails.QuestionSl = Convert.ToInt32(dr["QuestionSl"].ToString()); fitbDetails.Answer = dr["Answer"].ToString(); fitbDetails.AddedBy = dr["AddedBy"].ToString(); fitbDetails.AddedDate =Convert.ToDateTime(dr["AddedDate"].ToString()); fitbDetails.ModifiedBy = dr["ModifiedBy"].ToString(); fitbDetails.ModifiedDate = Convert.ToDateTime(dr["ModifiedDate"].ToString()); fillInTheBlanksDetails.Add(fitbDetails); } Session["fillInTheBlanksDetails"] = fillInTheBlanksDetails; gvQuiz_FillInTheBlanksQuestionDetails.DataSource = Session["fillInTheBlanksDetails"]; gvQuiz_FillInTheBlanksQuestionDetails.DataBind(); } catch (Exception ex) { } }