public void MyBtnHandler(Object sender, EventArgs e) { selectedQuestionPanel.Visible = true; int favQueListID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]); Button btn = (Button)sender; selectedQuestionPanel.Visible = true; selectedQuestionStatment.Text = btn.CommandName.ToString(); int quesID = Int32.Parse(btn.CommandArgument); QueDao queDaoObj = new QueDao(); List <FavListQueScore> favQueDetailList = queDaoObj.getQuestionDetailsByQuesIDAndAssessmentID(favQueListID, quesID); int sum = 0; foreach (FavListQueScore queScore in favQueDetailList) { sum += queScore.sumScoreValue; } Label4.Text = sum.ToString(); selectedQuestionDetailsView.DataSource = favQueDetailList; selectedQuestionDetailsView.DataBind(); AjaxControlToolkit.ModalPopupExtender ModalPopupExtender = this.Page.FindControl("ctl00$MainContent$MsgBoxModalPopupExtender") as AjaxControlToolkit.ModalPopupExtender; UpdatePanel UpdatePanel = this.Page.FindControl("ctl00$MainContent$UpdatePanelMsgBox") as UpdatePanel; UpdatePanel.Update(); ModalPopupExtender.Show(); }
private void LoadCLOList() { QueDao queDaoObj = new QueDao(); List <KMSABET.MyPocos.AppCLO> quesList = queDaoObj.getCLOList(); CLOListGridView.DataSource = quesList; CLOListGridView.DataBind(); }
private void LoadList(String courseID) { QueDao queDaoObj = new QueDao(); List <QueQuestion> quesList = queDaoObj.getQuestionList(courseID); attributeListTag.DataSource = quesList; attributeListTag.DataBind(); }
private void LoadSOList() { QueDao queDaoObj = new QueDao(); List <KMSABET.MyPocos.AppSO> quesList = queDaoObj.getSOList(); SO_GridView1.DataSource = quesList; SO_GridView1.DataBind(); }
private void LoadCourseTopicList() { QueDao queDaoObj = new QueDao(); List <KMSABET.MyPocos.AppCourseTopic> quesList = queDaoObj.getCourseTopicList(); courseTopicListTag.DataSource = quesList; courseTopicListTag.DataBind(); }
private void LoadAttributeOptionsList() { QueDao queDaoObj = new QueDao(); List <KMSABET.MyPocos.QueAttributeOption> quesList = queDaoObj.getAttributeOptionsList(); AttributeOptionsGridView1.DataSource = quesList; AttributeOptionsGridView1.DataBind(); }
private void LoadList() { QueDao queDaoObj = new QueDao(); String courseIdLocal = Session["CourseID"].ToString(); List <QueAttribute> attrList = queDaoObj.getAttrbuteList(courseIdLocal); attributeListTag.DataSource = attrList; attributeListTag.DataBind(); }
void display(List <QueAttribute> attr, int size, QueQuestion que, SqlConnection myConnection) { int count = 0, i = 0, j = 0, max = 1; for (i = 0; i < size; i++) { max = max * attr[i].optionsList.Count; } List <int> attr_decsn = new List <int>(); for (int l = 0; l < size; l++) { attr_decsn.Add(0); } while (max > count++) { for (int z = 0; z <= size - 1; z++) { if (attr_decsn[z] == attr[z].optionsList.Count) { attr_decsn[z] = 0; attr_decsn[z + 1]++; } que.attrOptionIds.Add(attr[z].optionsList[attr_decsn[z]].attributeOptionId); //LogUtils.myLog.Info(attr[z].optionsList[attr_decsn[z]].optionStatement); } attr_decsn[0]++; QueDao queDaoObj = new QueDao(); //LogUtils.myLog.Info("Going to print new questions"); for (int iter = 0; iter < Int32.Parse(numberQuestions.Text); iter++) { totalQuesCount++; que.questionStatement = "Dummy Question " + totalQuesCount + " " + DateTime.Now.ToString() + " System Generated."; String query = queDaoObj.insertQuestion(que); try { SqlCommand myCommand = new SqlCommand(query, myConnection); //LogUtils.myLog.Info(query); myCommand.ExecuteNonQuery(); //LogUtils.myLog.Info("After inserting into DB. Total Questions : " + totalQuesCount); } catch (Exception e) { LogUtils.myLog.Debug(e.ToString(), e); } } que.attrOptionIds = new List <int>(); } }
private void LoadList(String courseId) { QueDao queDaoObj = new QueDao(); List <KMSABET.MyPocos.QueFavQuestionList> quesList = new List <MyPocos.QueFavQuestionList>(); if (Session["InstructorID"] == null || Session["userTypeId"].ToString().Equals("1")) { quesList = queDaoObj.getFavQuestionList(courseId); } else { quesList = queDaoObj.getFavQuestionList(courseId, Session["InstructorID"].ToString()); } attributeListTag.DataSource = quesList; attributeListTag.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { int favQueListID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]); if (favQueListID != 0) { bool deleteMode = Request.QueryString["delete"] == null ? false : bool.Parse(Request.QueryString["delete"]); if (deleteMode) { DBUtils dbUtilsObj = new DBUtils(); String deleteQuery = "delete from Q_Favorite_List_has_Q_Question " + " where Q_Favorite_List_favorite_list_id =" + favQueListID; dbUtilsObj.CUDOperations(deleteQuery); deleteQuery = "DELETE FROM Q_FAVORITE_LIST_QUESTION_SCORE WHERE FAVORITE_LIST_ID = " + favQueListID; dbUtilsObj.CUDOperations(deleteQuery); String updateQuery = "delete from Q_Favorite_List " + " where favorite_list_id = " + favQueListID; dbUtilsObj.CUDOperations(updateQuery); Response.Redirect("~/KMSPages/QueFavQuestionList.aspx"); } QueDao queDaoObj = new QueDao(); MyPocos.QueFavQuestionList favList = queDaoObj.getFavQuestionListByID(favQueListID); favListName1.Text = favList.favQuestionName; questionList = queDaoObj.getQuestionListByFavID(favQueListID); questionsListSelectedTag.DataSource = questionList; questionsListSelectedTag.DataBind(); } } }
public void setEditData() { int favQueListID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]); if (favQueListID != 0) { QueDao queDaoObj = new QueDao(); MyPocos.QueFavQuestionList favList = queDaoObj.getFavQuestionListByID(favQueListID); questionList = queDaoObj.getQuestionListByFavID(favQueListID); ViewState["selectedQuestionList"] = questionList; favListName.Text = favList.favQuestionName; questionsListSelectedTag.DataSource = questionList; questionsListSelectedTag.DataBind(); favListName2.Text = favList.favQuestionName; questionsListSelectedTag2.DataSource = questionList; questionsListSelectedTag2.DataBind(); Wizard1.ActiveStepIndex = 0; } }
protected void Page_Load(object sender, EventArgs e) { QueDao queDaoObj = new QueDao(); if (Page.IsPostBack == false) { fillRelevanceScore(scoreTxtBx1, true); fillRelevanceScore(TextBox1, true); fillRelevanceScore(TextBox2, true); fillCLODropDown(Session["CourseID"].ToString()); if (DropDownList3.SelectedItem != null) { fillSODropDown(DropDownList3.SelectedItem.Value); fillCourseTopicDropDownByCloId(DropDownList3.SelectedItem.Value); } String value = ClientQueryString; String[] valueArr = value.Split('=', '&'); if (valueArr.Count() > 1) { int inputId = Int32.Parse(valueArr[1]); bool deleteMode = valueArr[7] == "true" ? true : false; bool viewMode = valueArr[3] == "true" ? true : false; bool editMode = valueArr[5] == "true" ? true : false; if (deleteMode) { deleteQuestion(inputId); } this.Title = viewMode ? "View a Question" : "Update a Question"; ViewState["viewMode"] = viewMode; ViewState["editMode"] = editMode; ViewState["deleteMode"] = deleteMode; List <int> idsList = new List <int>(); idsList.Add(inputId); List <QueQuestion> queObjectTemp = queDaoObj.questionList(idsList); if (queObjectTemp.Count > 0) { QueQuestion queObje = queObjectTemp[0]; quesStmt.Text = queObje.questionStatement; fillCourseTopicDropDownByCloId(DropDownList3.SelectedItem.Value); DropDownList5.SelectedValue = queObje.courseTopicId.ToString(); fillCLODropDown(Session["CourseID"].ToString()); DropDownList3.SelectedValue = queObje.cloId.ToString(); fillSODropDown(DropDownList3.SelectedItem.Value); DropDownList4.SelectedValue = queObje.soId.ToString(); } List <QueAttributeScore> attScoreList = queDaoObj.getQuestionScoreListByID(inputId); foreach (QueAttributeScore attSocre in attScoreList) { if (attSocre.attributeID == 1301) // CLO { TextBox1.SelectedValue = attSocre.scoreValue.ToString(); } else if (attSocre.attributeID == 1302) // SO { TextBox2.SelectedValue = attSocre.scoreValue.ToString(); } else if (attSocre.attributeID == 1303) // Course Topic { scoreTxtBx1.SelectedValue = attSocre.scoreValue.ToString(); } } DropDownList5.Enabled = !viewMode; DropDownList3.Enabled = !viewMode; DropDownList4.Enabled = !viewMode; scoreTxtBx1.Enabled = !viewMode; Button1.Visible = !viewMode; DataList12.Enabled = !viewMode; TextBox1.Enabled = !viewMode; TextBox2.Enabled = !viewMode; quesStmt.Enabled = !viewMode; cancelBtn.Text = viewMode ? "Close" : "Cancel"; Button1.Text = editMode ? "Update" : "Submit"; } else { //FirstGridViewRow(); this.Title = "Add a Question"; } } String courseIdLocal = Session["CourseID"].ToString(); List <KMSABET.MyPocos.QueAttribute> attributeList = queDaoObj.getAttrbuteList(courseIdLocal); DataList12.DataSource = attributeList; DataList12.DataBind(); //MyUtilities.LogUtils.myLog.Info("Selected drop down value is: " + DropDownList1.SelectedValue); }
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e) { int questionID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]); if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { //Get questionID here int attributeID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "attributeID")); int AttributeTypeID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "attributeTypeID")); //pass Question ID to your DB and get all available options for the question //Bind the RadiobUttonList here RadioButtonList scoreTxtBoxElm = (RadioButtonList)e.Item.FindControl("scoreTxtBx"); HiddenField attributeIDText = (HiddenField)e.Item.FindControl("attributeID"); fillRelevanceScore(scoreTxtBoxElm, false); //if (AttributeTypeID == 1001) { RadioButtonList RadioButtonList1 = (RadioButtonList)e.Item.FindControl("radlstPubs"); List <KMSABET.MyPocos.QueAttributeOption> optionsList = new List <KMSABET.MyPocos.QueAttributeOption>(); Boolean isRelevanceApplicable = false; DBUtils dbUtils = new DBUtils(); String query = "SELECT * FROM Q_Attribute_Options QAO" + " JOIN Q_Attribute ON attribute_id = Q_Attribute_attribute_id" + " WHERE Q_Attribute_attribute_id = " + attributeID.ToString() + " ORDER BY QAO.PRIORITY_OPTION"; SqlDataReader attributeListReader = dbUtils.readOperation(query); while (attributeListReader.Read()) { KMSABET.MyPocos.QueAttributeOption optionTemp = new KMSABET.MyPocos.QueAttributeOption(); isRelevanceApplicable = (Boolean)attributeListReader["IS_RELEVANCE_APPLICABLE"]; optionTemp.attributeOptionId = (int)attributeListReader["attribute_option_id"]; optionTemp.optionStatement = attributeListReader["PRIORITY_OPTION"].ToString() + " - " + attributeListReader["option_statement"].ToString(); //optionTemp.attributeId = (int)attributeListReader["Q_Attribute_attribute_id"]; optionsList.Add(optionTemp); } dbUtils.closeDBConnection(); QueAttributeOption optionIgnoreThis = new QueAttributeOption(); optionIgnoreThis.attributeOptionId = 214748364 + attributeID; optionIgnoreThis.optionStatement = "Ignore This"; optionsList.Add(optionIgnoreThis); RadioButtonList1.DataSource = optionsList; RadioButtonList1.DataTextField = "optionStatement"; RadioButtonList1.DataValueField = "attributeOptionId"; RadioButtonList1.DataBind(); attributeIDText.Value = attributeID.ToString(); if (isRelevanceApplicable == false) { Label scoreTxtBoxLabel = (Label)e.Item.FindControl("Label1"); scoreTxtBoxLabel.Visible = false; scoreTxtBoxElm.Visible = false; } Boolean goneInside = false; if (questionID != 0) { QueDao dbUtils1 = new QueDao(); List <QueAttributeOption> attOptions = dbUtils1.getOptionsListByAttributeIDQuestionID(attributeID, questionID); foreach (QueAttributeOption attOption in attOptions) { scoreTxtBoxElm.SelectedValue = attOption.score.ToString(); RadioButtonList1.SelectedValue = attOption.attributeOptionId.ToString(); goneInside = true; } } if (goneInside == false) { RadioButtonList1.SelectedValue = optionIgnoreThis.attributeOptionId.ToString(); } } /*else if (AttributeTypeID == 1002) * { * CheckBoxList CheckBoxList1 = (CheckBoxList)e.Item.FindControl("chkBxList1"); * * List<KMSABET.MyPocos.QueAttributeOptions> optionsList = new List<KMSABET.MyPocos.QueAttributeOptions>(); * * DBUtils dbUtils = new DBUtils(); * SqlDataReader attributeListReader = dbUtils.readOperation("SELECT * FROM Q_Attribute_Options" + " JOIN Q_Attribute ON attribute_id = Q_Attribute_attribute_id AND attribute_type_id = 1002" + " WHERE Q_Attribute_attribute_id = " + attributeID.ToString()); + while (attributeListReader.Read()) + { + KMSABET.MyPocos.QueAttributeOptions optionTemp = new KMSABET.MyPocos.QueAttributeOptions(); + + optionTemp.attributeOptionId = (int)attributeListReader["attribute_option_id"]; + optionTemp.optionStatement = attributeListReader["option_statement"].ToString(); + optionTemp.attributeId = (int)attributeListReader["Q_Attribute_attribute_id"]; + optionsList.Add(optionTemp); + } + dbUtils.closeDBConnection(); + + CheckBoxList1.DataSource = optionsList; + CheckBoxList1.DataTextField = "optionStatement"; + CheckBoxList1.DataValueField = "attributeOptionId"; + CheckBoxList1.DataBind(); + + if (questionID != 0) + { + QueDao dbUtils1 = new QueDao(); + List<QueAttributeOptions> attOptions = dbUtils1.getOptionsListByAttributeIDQuestionID(attributeID, questionID); + TextBox scoreTxtBoxElm = (TextBox)e.Item.FindControl("scoreTxtBx"); + foreach (QueAttributeOptions attOption in attOptions) + { + scoreTxtBoxElm.Text = attOption.scoreValue.ToString(); + CheckBoxList1.Items.FindByValue(attOption.attributeOptionId.ToString()).Selected = true; + } + } + }*/ } }
protected void GenerateQuestions(object sender, EventArgs e) { LogUtils.myLog.Info(numberQuestions.Text); String courseId = Session["CourseID"].ToString(); LogUtils.myLog.Info("Session[\"CourseID\"] : " + Session["CourseID"]); LogUtils.myLog.Info("Before courseId : " + courseId); if (courseId == null || courseId == "") { courseId = "4"; } LogUtils.myLog.Info("After courseId : " + courseId); LogUtils.myLog.Info("Button Generate Questions clicked." + DateTime.Now.ToString()); AppDao appDaoObj = new AppDao(); List <AppCourseTopic> topicList = appDaoObj.getCourseTopicList(courseId); List <AppCLO> CLOList = appDaoObj.getCLOList(courseId); QueDao queDaoObj = new QueDao(); String courseIdLocal = Session["CourseID"].ToString(); List <QueAttribute> attrList = queDaoObj.getAttrbuteList(courseIdLocal); foreach (QueAttribute attr in attrList) { attr.optionsList = queDaoObj.getAttributeOptionListByAttrID(attr.attributeID.ToString()); } foreach (AppCLO clo in CLOList) { List <AppSO> SOList = appDaoObj.getSOList(clo.cloId.ToString()); clo.soList = SOList; } foreach (AppCourseTopic courseTopic in topicList) { LogUtils.myLog.Info("Course Topic : " + courseTopic.topic); foreach (AppCLO clo in CLOList) { LogUtils.myLog.Info("CLO : " + clo.cloStatement); foreach (AppSO so in clo.soList) { LogUtils.myLog.Info("SO : " + so.statement); QueQuestion queDetails = new QueQuestion(); queDetails.cloId = clo.cloId; queDetails.soId = so.id; queDetails.courseTopicId = courseTopic.id; queDetails.courseId = Int32.Parse(courseId); queDetails.attrOptionIds = new List <int>(); try { SqlConnection myConnection = new SqlConnection(MyConstants.DBConnectionString); //LogUtils.myLog.Info(MyConstants.DBConnectionString); myConnection.Open(); display(attrList, attrList.Count, queDetails, myConnection); myConnection.Close(); } catch (Exception ex) { LogUtils.myLog.Debug(e.ToString(), ex); } LogUtils.myLog.Info("After inserting questions. Total Questions : " + totalQuesCount); } } } /*List<QueAttribute> attrList = new List<QueAttribute>(); * QueAttribute attr1 = new QueAttribute(); * attr1.attributeID = 1; * attr1.attributeStatement = "Time"; * attr1.optionsList = new List<QueAttributeOption>(); * QueAttributeOption o1 = new QueAttributeOption(); * o1.attributeId = 1; * o1.optionStatement = "5 mins"; * o1.attributeOptionId = 1; * attr1.optionsList.Add(o1); * * QueAttributeOption o2 = new QueAttributeOption(); * o2.attributeId = 1; * o2.optionStatement = "10 mins"; * o2.attributeOptionId = 2; * attr1.optionsList.Add(o2); * * QueAttributeOption o5 = new QueAttributeOption(); * o5.attributeId = 1; * o5.optionStatement = "15 mins"; * o5.attributeOptionId = 5; * attr1.optionsList.Add(o5); * * QueAttribute attr2 = new QueAttribute(); * attr2.attributeID = 1; * attr2.attributeStatement = "Type"; * attr2.optionsList = new List<QueAttributeOption>(); * QueAttributeOption o3 = new QueAttributeOption(); * o3.attributeId = 2; * o3.optionStatement = "MCQ"; * o3.attributeOptionId = 1; * attr2.optionsList.Add(o3); * * QueAttributeOption o4 = new QueAttributeOption(); * o4.attributeId = 2; * o4.optionStatement = "FB"; * o4.attributeOptionId = 2; * attr2.optionsList.Add(o4); * * attrList.Add(attr1); * attrList.Add(attr2); * display(attrList, attrList.Count); */ }