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();
}
private void LoadList()
{
ImpDao queDaoObj = new ImpDao();
List <ImpRuleQuestion> attrList = queDaoObj.getRuleQuestionList();
attributeListTag.DataSource = attrList;
attributeListTag.DataBind();
}
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();
}