public List <ImpRuleQuesAnswer> getRuleAnswerList(int ruleQuestionID = 0, int quesTypeID = 0) { List <ImpRuleQuesAnswer> quesAnsList = new List <ImpRuleQuesAnswer>(); String myQuery = "SELECT *" + " FROM I_Rule_Ques_Answer QA" + " JOIN I_Rule_Question Q ON Q.rule_question_id = QA.I_Rule_Question_rule_question_id" + " WHERE 1=1"; myQuery += ruleQuestionID != 0 ? " AND QA.I_Rule_Question_rule_question_id = " + ruleQuestionID : ""; myQuery += quesTypeID != 0 ? " AND Q.rule_question_type_id = " + quesTypeID : ""; DBUtils dbUtils = new DBUtils(); SqlDataReader listReader = dbUtils.readOperation(myQuery); while (listReader.Read()) { ImpRuleQuesAnswer obj1 = new ImpRuleQuesAnswer(); obj1.answerId = (int)listReader["answer_id"]; obj1.answerStatemet = listReader["answer_statement"].ToString(); obj1.questionId = (int)listReader["I_Rule_Question_rule_question_id"]; quesAnsList.Add(obj1); } dbUtils.closeDBConnection(); return(quesAnsList); }
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e) { int ruleID = 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 ruleQuesID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "ruleQuesId")); int questionTypeID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "ruleQuesTypeID")); HiddenField questionIDHidden = (HiddenField)e.Item.FindControl("ruleQuestionIDHidden"); HiddenField ruleQuestionTypeIDHiddenBackend = (HiddenField)e.Item.FindControl("ruleQuestionTypeIDHidden"); ruleQuestionTypeIDHiddenBackend.Value = questionTypeID.ToString(); questionIDHidden.Value = ruleQuesID.ToString(); if (questionTypeID == 1101) { RadioButtonList RadioButtonList1 = (RadioButtonList)e.Item.FindControl("radlstPubs"); Panel queryPanelOneBackend = (Panel)e.Item.FindControl("queryPanelOne"); queryPanelOneBackend.Visible = false; ImpDao impDaoObj = new ImpDao(); List <ImpRuleQuesAnswer> answerList = impDaoObj.getRuleAnswerList(ruleQuesID, questionTypeID); RadioButtonList1.DataSource = answerList; RadioButtonList1.DataTextField = "answerStatemet"; RadioButtonList1.DataValueField = "answerId"; RadioButtonList1.DataBind(); if (ruleID != 0) { ImpRuleQuesAnswer ruleAns = impDaoObj.getRuleAnswerByRuleIDQuestionID(ruleQuesID, ruleID); RadioButtonList1.SelectedValue = ruleAns.answerId.ToString(); } } else if (questionTypeID == 1102) { RadioButtonList RadioButtonList1 = (RadioButtonList)e.Item.FindControl("radlstPubs"); DBUtils dbUtils1 = new DBUtils(); SqlDataReader attributeTypeReader1 = dbUtils1.readOperation("SELECT * FROM App_CODE Where CODE_TYPE_ID=1600"); while (attributeTypeReader1.Read()) { RadioButtonList1.Items.Add(new ListItem(attributeTypeReader1["CODE_VALUE"].ToString(), attributeTypeReader1["CODE_ID"].ToString())); } dbUtils1.closeDBConnection(); if (ruleID != 0) { ImpDao impDaoObj = new ImpDao(); ImpRuleQuesAnswer ruleAns = impDaoObj.getRuleDBValueByRuleIDQuestionID(ruleQuesID, ruleID); RadioButtonList1.SelectedValue = ruleAns.comparisonTypeID.ToString(); TextBox comparisonValueTxtBox = (TextBox)e.Item.FindControl("dbQueryValue"); comparisonValueTxtBox.Text = ruleAns.comparisonValue.ToString(); } } } }
public ImpRuleQuesAnswer getRuleDBValueByRuleIDQuestionID(int ruleQuestionID, int ruleID) { ImpRuleQuesAnswer obj1 = new ImpRuleQuesAnswer(); String myQuery = "SELECT *" + " FROM I_Rule_Case RC" + " WHERE RC.I_RULE_QUESTION_ID = " + ruleQuestionID + " AND RC.I_Rule_rule_id = " + ruleID; DBUtils dbUtils = new DBUtils(); SqlDataReader listReader = dbUtils.readOperation(myQuery); while (listReader.Read()) { obj1.questionId = (int)listReader["I_RULE_QUESTION_ID"]; obj1.comparisonValue = (int)listReader["COMPARISON_VALUE"]; obj1.comparisonTypeID = (int)listReader["COMPARISON_TYPE"]; } dbUtils.closeDBConnection(); return(obj1); }
public ImpRuleQuesAnswer getRuleAnswerByRuleIDQuestionID(int ruleQuestionID, int ruleID) { ImpRuleQuesAnswer obj1 = new ImpRuleQuesAnswer(); String myQuery = "SELECT *" + " FROM I_Rule_Case RC" + " JOIN I_Rule_Ques_Answer QA ON QA.answer_id = RC.I_Rule_Ques_Answer_answer_id" + " JOIN I_Rule_Question RQ ON RQ.rule_question_id = QA.I_Rule_Question_rule_question_id" + " WHERE RQ.rule_question_id = " + ruleQuestionID + " AND RC.I_Rule_rule_id = " + ruleID; DBUtils dbUtils = new DBUtils(); SqlDataReader listReader = dbUtils.readOperation(myQuery); while (listReader.Read()) { obj1.answerId = (int)listReader["answer_id"]; obj1.questionId = (int)listReader["rule_question_id"]; } dbUtils.closeDBConnection(); return(obj1); }