private void AddRuleButton_Click(object sender, System.EventArgs e) { FilterRuleData filterRuleData = new FilterRuleData(); FilterRuleData.FilterRulesRow filterRule = filterRuleData.FilterRules.NewFilterRulesRow(); int questionId = int.Parse(QuestionFilterDropdownlist.SelectedValue), answerId = int.Parse(AnswerFilterDropdownlist.SelectedValue); if (answerId == 0) { filterRule.SetAnswerIdNull(); } else if (answerId < 0) { filterRule.AnswerId = -answerId; } else { filterRule.AnswerId = answerId; } filterRule.QuestionId = questionId; if (TextFilterTextbox.Visible) { filterRule.TextFilter = TextFilterTextbox.Text; } filterRule.FilterId = FilterId; filterRuleData.FilterRules.AddFilterRulesRow(filterRule); new Filter().AddRule(filterRuleData); MessageLabel.Visible = true; ((PageBase)Page).ShowNormalMessage(MessageLabel, ((PageBase)Page).GetPageResource("FilterRuleAddedMessage")); BindFields(); }
public FilterRuleData GetRulesForFilter(int filterId) { FilterRuleData dataSet = new FilterRuleData(); ArrayList commandParameters = new ArrayList(); { commandParameters.Add(new SqlParameter("@FilterId", filterId).SqlValue); } DbConnection.db.LoadDataSet("vts_spFilterRuleGetForFilter", dataSet, new string[] { "FilterRules" }, commandParameters.ToArray()); return(dataSet); }
/// <summary> /// Adds a new filter rule /// </summary> /// <param name="newRule"></param> public void AddRule(FilterRuleData newRule) { SqlConnection connection = new SqlConnection(DbConnection.NewDbConnectionString); SqlCommand insertCommand = new SqlCommand("vts_spFilterRuleAddNew", connection); insertCommand.CommandType = CommandType.StoredProcedure; insertCommand.Parameters.Add(new SqlParameter("@FilterId", SqlDbType.Int, 4, "FilterID")); insertCommand.Parameters.Add(new SqlParameter("@AnswerId", SqlDbType.Int, 4, "AnswerId")); insertCommand.Parameters.Add(new SqlParameter("@QuestionId", SqlDbType.Int, 4, "QuestionId")); insertCommand.Parameters.Add(new SqlParameter("@TextFilter", SqlDbType.NVarChar, 0xfa0, "TextFilter")); insertCommand.Parameters.Add(new SqlParameter("@FilterRuleID", SqlDbType.Int, 4, "FilterRuleID")); insertCommand.Parameters["@FilterRuleID"].Direction = ParameterDirection.Output; DbConnection.db.UpdateDataSet(newRule, "FilterRules", insertCommand, new SqlCommand(), new SqlCommand(), UpdateBehavior.Transactional); }
void AddFilter(QuestionData.QuestionsRow q, AnswerData.AnswersRow a, FilterData.FiltersRow p) { FilterData filterData = new FilterData(); FilterData.FiltersRow filterRow = filterData.Filters.NewFiltersRow(); filterRow.LogicalOperatorTypeID = short.Parse(LogicalOperatorDropDownList.SelectedValue); filterRow.Description = FilterName(q, a, p); filterRow.SurveyId = SurveyId; filterRow.ParentFilterId = p.FilterId; filterData.Filters.AddFiltersRow(filterRow); new Filter().AddFilter(filterData); FilterRuleData filterRuleData = new FilterRuleData(); FilterRuleData.FilterRulesRow filterRuleRow = filterRuleData.FilterRules.NewFilterRulesRow(); filterRuleRow.QuestionId = q.QuestionId; filterRuleRow.AnswerId = a.AnswerId; filterRuleRow.FilterId = filterRow.FilterId; filterRuleData.FilterRules.AddFilterRulesRow(filterRuleRow); new Filter().AddRule(filterRuleData); }
/// <summary> /// Adds a new filter rule /// </summary> /// <param name="newRule"></param> public void AddRule(FilterRuleData newRule) { FilterFactory.Create().AddRule(newRule); }