protected void Page_Load(object sender, EventArgs e)
{
int cloID = Request.QueryString["cloID"] == null ? 0 : Int32.Parse(Request.QueryString["cloID"]);
ImpDao impDaoObj = new ImpDao();
GeneralUtils genUtilObj = new GeneralUtils();
List <ImpRuleQuestion> dbTypeQuestionList = impDaoObj.getRuleQuestionList(cloID, 1102);
List <AskUserWhereAttributes> listAskWhereUserDetails = new List <AskUserWhereAttributes>();
for (int i = 0; i < dbTypeQuestionList.Count; i++)
{
String dbQueryValue = dbTypeQuestionList[i].dBQueryStatement;
List <int> openBracketOccurences = genUtilObj.getCharacterOccurancesInString(dbQueryValue, '{');
if (openBracketOccurences.Count > 0)
{
List <int> closeBracketOccurences = genUtilObj.getCharacterOccurancesInString(dbQueryValue, '}');
List <int> endBracketCalculation = genUtilObj.getEndDifferenceValue(openBracketOccurences, closeBracketOccurences);
List <String> jsonAskUserList = genUtilObj.getJSONStringAskUser(dbQueryValue, openBracketOccurences, endBracketCalculation);
for (int j = 0; j < jsonAskUserList.Count; j++)
{
AskUserWhereAttributes localAskUserAttribute = JsonConvert.DeserializeObject <AskUserWhereAttributes>(jsonAskUserList[j]);
localAskUserAttribute.questionID = dbTypeQuestionList[i].ruleQuesId;
localAskUserAttribute.questionStatement = dbTypeQuestionList[i].ruleQuestionStatemet;
localAskUserAttribute.whereAskUserToReplace = jsonAskUserList[j];
listAskWhereUserDetails.Add(localAskUserAttribute);
}
}
}
DataList1.DataSource = listAskWhereUserDetails;
DataList1.DataBind();
}
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();
}
}
}
}
private void LoadList()
{
ImpDao queDaoObj = new ImpDao();
List <ImpRuleQuestion> attrList = queDaoObj.getRuleQuestionList();
attributeListTag.DataSource = attrList;
attributeListTag.DataBind();
}
private void LoadList()
{
ImpDao impDaoObj = new ImpDao();
List <ImpRule> ruleList = impDaoObj.getRuleList();
attributeListTag.DataSource = ruleList;
attributeListTag.DataBind();
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
String questionJSON = Request.QueryString["dbQueryValues"];
List <ImpRuleQuestion> listOfQuestionValues = new List <ImpRuleQuestion>();
if (questionJSON != "]")
{
listOfQuestionValues = JsonConvert.DeserializeObject <List <ImpRuleQuestion> >(questionJSON);
}
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"));
RadioButtonList RadioButtonList1 = (RadioButtonList)e.Item.FindControl("radlstPubs");
HiddenField HiddenFieldQuesType = (HiddenField)e.Item.FindControl("hiddenQuesType");
HiddenFieldQuesType.Value = questionTypeID.ToString();
HiddenField HiddenFieldQuesID = (HiddenField)e.Item.FindControl("hiddenQuesID");
HiddenFieldQuesID.Value = ruleQuesID.ToString();
if (questionTypeID == 1101)
{
ImpDao impDaoObj = new ImpDao();
List <ImpRuleQuesAnswer> answerList = impDaoObj.getRuleAnswerList(ruleQuesID, questionTypeID);
RadioButtonList1.DataSource = answerList;
RadioButtonList1.DataTextField = "answerStatemet";
RadioButtonList1.DataValueField = "answerId";
RadioButtonList1.DataBind();
}
else if (questionTypeID == 1102)
{
String calculatedValue = "";
foreach (ImpRuleQuestion quesInner in listOfQuestionValues)
{
if (quesInner.ruleQuesId == ruleQuesID)
{
calculatedValue = quesInner.dbQueryCalculatedValue.ToString();
}
}
HiddenField HiddenFieldCalculatedValue = (HiddenField)e.Item.FindControl("HiddenCalculatedValue");
HiddenFieldCalculatedValue.Value = calculatedValue.ToString();
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() + " = " + calculatedValue,
attributeTypeReader1["CODE_ID"].ToString()));
}
dbUtils1.closeDBConnection();
}
}
}
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 Button1_Click(object Source, EventArgs e)
{
List <AskUserWhereAttributes> listAttributes = new List <AskUserWhereAttributes>();
ImpDao impDaoObj = new ImpDao();
int cloID = Request.QueryString["cloID"] == null ? 0 : Int32.Parse(Request.QueryString["cloID"]);
List <ImpRuleQuestion> dbTypeQuestionList = impDaoObj.getRuleQuestionList(cloID, 1102);
foreach (DataListItem item in DataList1.Items)
{
if (((DropDownList)item.FindControl("ddlItemTemp")).SelectedItem != null)
{
AskUserWhereAttributes localAttr = new AskUserWhereAttributes();
HiddenField jsonStringHiddenElem = (HiddenField)item.FindControl("jsonStringHidden");
String jsonValue = jsonStringHiddenElem.Value;
HiddenField questionIDHiddenElem = (HiddenField)item.FindControl("questionIDHidden");
int questionID = Convert.ToInt32(questionIDHiddenElem.Value);
String selectedItemDDL = ((DropDownList)item.FindControl("ddlItemTemp")).SelectedItem.Value;
localAttr.whereAskUserToReplace = jsonValue;
localAttr.questionID = questionID;
localAttr.selectedItemValue = Convert.ToInt32(selectedItemDDL);
listAttributes.Add(localAttr);
}
}
String questionJSON = "[";
foreach (ImpRuleQuestion quesItem in dbTypeQuestionList)
{
foreach (AskUserWhereAttributes attr in listAttributes)
{
if (quesItem.ruleQuesId == attr.questionID)
{
quesItem.dBQueryStatement =
quesItem.dBQueryStatement.Replace(attr.whereAskUserToReplace, attr.selectedItemValue.ToString());
}
}
int returnedResult = impDaoObj.executeSavedDBQuery(quesItem.dBQueryStatement);
quesItem.dbQueryCalculatedValue = returnedResult;
questionJSON += "{ruleQuesId : " + quesItem.ruleQuesId + ", dbQueryCalculatedValue : " + quesItem.dbQueryCalculatedValue + "},";
}
questionJSON = questionJSON.Substring(0, questionJSON.Length - 1);
questionJSON += "]";
Response.Redirect("~/KMSPages/ImpAskSuggestion.aspx?cloID=" + cloID + "&dbQueryValues=" + questionJSON);
}
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)
{
AppCLO myClo = impDaoObj.getCloByCloID(cloID);
TextBox1.Text = myClo.programName;
TextBox2.Text = myClo.courseName;
TextBox3.Text = myClo.cloStatement;
expertSugLbl.Visible = false;
}
List <ImpRuleQuestion> quesList = impDaoObj.getRuleQuestionList(cloID);
DataList1.DataSource = quesList;
DataList1.DataBind();
}
