public override DataSet Clone()
{
FilterRuleData data = (FilterRuleData)base.Clone();
data.InitVars();
return(data);
}
/// <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);
}
/// <summary>
/// Adds a new filter rule
/// </summary>
/// <param name="newRule"></param>
public void AddRule(FilterRuleData newRule)
{
FilterFactory.Create().AddRule(newRule);
}
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;
}
public FilterRulesRowChangeEvent(FilterRuleData.FilterRulesRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public void RemoveFilterRulesRow(FilterRuleData.FilterRulesRow row)
{
base.Rows.Remove(row);
}
public void AddFilterRulesRow(FilterRuleData.FilterRulesRow row)
{
base.Rows.Add(row);
}
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();
}
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);
}
