public ImpRule getRuleByID(int ruleID)
{
ImpRule ques1 = new ImpRule();
DBUtils dbUtils = new DBUtils();
String myQuery = " select * from I_Rule R"
+ " JOIN I_CLO C ON R.I_CLO_clo_id = C.clo_id"
+ " JOIN App_Course AC ON AC.course_id = C.App_Course_course_id"
+ " JOIN App_Program AP ON AP.program_id = AC.App_Program_program_id"
+ " WHERE rule_id=" + ruleID;
myQuery += " order by 1 desc";
SqlDataReader attributeListReader = dbUtils.readOperation(myQuery);
while (attributeListReader.Read())
{
ques1.ruleId = (int)attributeListReader["rule_id"];
ques1.ruleStatemet = attributeListReader["rule_statement"].ToString();
AppCLO myClo = new AppCLO();
myClo.cloId = (int)attributeListReader["clo_id"];
myClo.cloStatement = attributeListReader["clo_statement"].ToString();
myClo.courseId = (int)attributeListReader["course_id"];
myClo.courseName = attributeListReader["course_name"].ToString();
myClo.programId = (int)attributeListReader["program_id"];
myClo.programName = attributeListReader["program_name"].ToString();
ques1.cloData = myClo;
}
dbUtils.closeDBConnection();
return(ques1);
}
protected void Page_Load(object sender, EventArgs e)
{
ImpDao impDaoObj = new ImpDao();
int cloID = Request.QueryString["cloID"] == null ? 0 : Int32.Parse(Request.QueryString["cloID"]);
if (Page.IsPostBack == false)
{
int ruleID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]);
bool viewMode = Request.QueryString["viewMode"] == null ? false : Boolean.Parse(Request.QueryString["viewMode"]);
bool editMode = Request.QueryString["editMode"] == null ? false : Boolean.Parse(Request.QueryString["editMode"]);
bool deleteMode = Request.QueryString["deleteMode"] == null ? false : Boolean.Parse(Request.QueryString["deleteMode"]);
if (ruleID != 0)
{
if (deleteMode)
{
deleteRule(ruleID);
Response.Redirect("~/KMSPages/ImpRuleList.aspx");
}
ImpRule rule = impDaoObj.getRuleByID(ruleID);
cloID = rule.cloData.cloId;
ruleStmt.Text = rule.ruleStatemet;
if (viewMode == true)
{
ruleStmt.Enabled = false;
DataList1.Enabled = false;
}
Button1.Visible = !viewMode;
cancelBtn.Text = viewMode ? "Close" : "Cancel";
Button1.Text = editMode ? "Update" : "Submit";
}
ViewState["cloID"] = cloID;
AppCLO myClo = impDaoObj.getCloByCloID(cloID);
TextBox1.Text = myClo.programName;
TextBox2.Text = myClo.courseName;
TextBox3.Text = myClo.cloStatement;
}
List <ImpRuleQuestion> quesList = impDaoObj.getRuleQuestionList(Int32.Parse(ViewState["cloID"].ToString()));
DataList1.DataSource = quesList;
DataList1.DataBind();
}
protected void Submit_Button_Click1(object sender, EventArgs e)
{
int selectedItemCount = 0;
String selectedItems = "";
String questionJSON = Request.QueryString["dbQueryValues"];
List <ImpRuleQuestion> listOfQuestionValues = new List <ImpRuleQuestion>();
if (questionJSON != "]")
{
listOfQuestionValues = JsonConvert.DeserializeObject <List <ImpRuleQuestion> >(questionJSON);
}
String dbQueryStr = "";
foreach (DataListItem item in DataList1.Items)
{
if (((RadioButtonList)item.FindControl("radlstPubs")).SelectedItem != null)
{
HiddenField HiddenFieldQuesType = (HiddenField)item.FindControl("hiddenQuesType");
if (HiddenFieldQuesType.Value == "1101")
{
selectedItemCount++;
selectedItems += ((RadioButtonList)item.FindControl("radlstPubs")).SelectedItem.Value + ",";
}
else
{
String selectedValue = ((RadioButtonList)item.FindControl("radlstPubs")).SelectedItem.Value;
HiddenField HiddenFieldQuesID = (HiddenField)item.FindControl("hiddenQuesID");
HiddenField HiddenFieldCalculatedValue = (HiddenField)item.FindControl("HiddenCalculatedValue");
ImpRuleQuestion quesRet = searchQuestionDetails(Int32.Parse(HiddenFieldQuesID.Value), listOfQuestionValues);
if (dbQueryStr != "")
{
dbQueryStr += " OR";
}
dbQueryStr += " (IR2.I_RULE_QUESTION_ID = " + HiddenFieldQuesID.Value;
if (selectedValue.Equals("1601"))
{
dbQueryStr += " AND IR2.COMPARISON_VALUE = " + HiddenFieldCalculatedValue.Value + " )";
}
else if (selectedValue.Equals("1602"))
{
dbQueryStr += " AND IR2.COMPARISON_VALUE > " + HiddenFieldCalculatedValue.Value + " )";
}
else if (selectedValue.Equals("1603"))
{
dbQueryStr += " AND IR2.COMPARISON_VALUE < " + HiddenFieldCalculatedValue.Value + " )";
}
else if (selectedValue.Equals("1604"))
{
dbQueryStr += " AND IR2.COMPARISON_VALUE >= " + HiddenFieldCalculatedValue.Value + " )";
}
else if (selectedValue.Equals("1605"))
{
dbQueryStr += " AND IR2.COMPARISON_VALUE <= " + HiddenFieldCalculatedValue.Value + " )";
}
}
}
}
if (selectedItems.Length > 0)
{
selectedItems = selectedItems.Substring(0, selectedItems.Length - 1);
}
//LogUtils.myLog.Info("Selected Item of Radio Button is: " + selectedItems + " and length is : " + selectedItemCount);
List <int> ruleIdsList = new List <int>();
if (selectedItemCount > 0 || !dbQueryStr.Equals(""))
{
expertSugLbl.Visible = true;
String myQuery = "SELECT * FROM I_Rule R"
+ " WHERE R.rule_id IN ("
+ " SELECT I_Rule_rule_id"
+ " FROM I_Rule_Case IR2"
+ " WHERE 1=1 AND (";
if (selectedItemCount > 0)
{
myQuery += " I_Rule_Ques_Answer_answer_id IN (" + selectedItems + ")";
if (dbQueryStr != "")
{
myQuery += " OR ";
}
}
myQuery += dbQueryStr
+ ") GROUP BY I_Rule_rule_id"
+ " HAVING COUNT(IR2.I_Rule_rule_id) ="
+ " (SELECT COUNT(*) FROM I_RULE_CASE IR1"
+ " WHERE IR1.I_Rule_rule_id = IR2.I_Rule_rule_id)"
+ " )";
DBUtils dbUtilObj = new DBUtils();
SqlDataReader readerQueriesList = dbUtilObj.readOperation(myQuery);
List <ImpRule> impRuleListObj = new List <ImpRule>();
if (readerQueriesList != null && readerQueriesList.HasRows)
{
while (readerQueriesList.Read())
{
ImpRule impRuleObj = new ImpRule();
impRuleObj.ruleId = (int)readerQueriesList["rule_id"];
impRuleObj.ruleStatemet = readerQueriesList["rule_statement"].ToString();
impRuleListObj.Add(impRuleObj);
}
readerQueriesList.Close();
}
else
{
ImpRule impRuleObj = new ImpRule();
impRuleObj.ruleId = 1;
impRuleObj.ruleStatemet = "No suggestion is available";
impRuleListObj.Add(impRuleObj);
}
ruleListTag.DataSource = impRuleListObj;
ruleListTag.DataBind();
}
}
