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 FirstGridViewRow() { QueQuestion ques1 = new QueQuestion() { questionId = 112, questionStatement = "This is question One" }; QueQuestion ques2 = new QueQuestion() { questionId = 2, questionStatement = "This is question Two" }; questionList.Add(ques1); questionList.Add(ques2); Session["questionList"] = questionList; AttributeOptions.DataSource = questionList; AttributeOptions.DataBind(); }
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 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); */ }