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);
}
