public override DataSet Clone()
{
FilterData data = (FilterData)base.Clone();
data.InitVars();
return(data);
}
/// <summary>
/// Adds a new filter
/// </summary>
/// <param name="newFilter"></param>
public void AddFilter(FilterData newFilter)
{
SqlConnection connection = new SqlConnection(DbConnection.NewDbConnectionString);
SqlCommand insertCommand = new SqlCommand("vts_spFilterAddNew", connection);
insertCommand.CommandType = CommandType.StoredProcedure;
insertCommand.Parameters.Add(new SqlParameter("@SurveyId", SqlDbType.Int, 4, "SurveyId"));
insertCommand.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 200, "Description"));
insertCommand.Parameters.Add(new SqlParameter("@LogicalOperatorTypeID", SqlDbType.Int, 4, "LogicalOperatorTypeID"));
insertCommand.Parameters.Add(new SqlParameter("@FilterId", SqlDbType.Int, 4, "FilterId"));
insertCommand.Parameters.Add(new SqlParameter("@ParentFilterId", SqlDbType.Int, 4, "ParentFilterId"));
insertCommand.Parameters["@FilterId"].Direction = ParameterDirection.Output;
DbConnection.db.UpdateDataSet(newFilter, "Filters", insertCommand, new SqlCommand(), new SqlCommand(), UpdateBehavior.Transactional);
}
/// <summary>
/// Update the filter options
/// </summary>
/// <param name="updatedFilter"></param>
public void UpdateFilter(FilterData updatedFilter)
{
FilterFactory.Create().UpdateFilter(updatedFilter);
}
/// <summary>
/// Adds a new filter
/// </summary>
/// <param name="newFilter"></param>
public void AddFilter(FilterData newFilter)
{
FilterFactory.Create().AddFilter(newFilter);
}
public FiltersRowChangeEvent(FilterData.FiltersRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public void RemoveFiltersRow(FilterData.FiltersRow row)
{
base.Rows.Remove(row);
}
public void AddFiltersRow(FilterData.FiltersRow row)
{
base.Rows.Add(row);
}
public FilterData GetFilters(int surveyId)
{
FilterData dataSet = new FilterData();
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@SurveyID", surveyId).SqlValue);
}
DbConnection.db.LoadDataSet("vts_spFilterGetForSurvey", dataSet, new string[] { "Filters" }, commandParameters.ToArray());
return dataSet;
}
public FilterData GetFilterById(int filterId)
{
FilterData dataSet = new FilterData();
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@FilterId", filterId).SqlValue);
}
DbConnection.db.LoadDataSet("vts_spFilterGetDetails", dataSet, new string[] { "Filters" }, commandParameters.ToArray());
return dataSet;
}
public FilterData GetEmptyFilter()
{
var dataSet = new FilterData();
dataSet.Filters.AddFiltersRow(0, "", 0, 0);
return dataSet;
}
/// <summary>
/// Update the filter options
/// </summary>
/// <param name="updatedFilter"></param>
public void UpdateFilter(FilterData updatedFilter)
{
SqlConnection connection = new SqlConnection(DbConnection.NewDbConnectionString);
SqlCommand insertCommand = new SqlCommand("vts_spFilterUpdate", connection);
insertCommand.CommandType = CommandType.StoredProcedure;
insertCommand.Parameters.Add(new SqlParameter("@FilterId", SqlDbType.Int, 4, "FilterId"));
insertCommand.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 200, "Description"));
insertCommand.Parameters.Add(new SqlParameter("@LogicalOperatorTypeID", SqlDbType.SmallInt, 4, "LogicalOperatorTypeID"));
insertCommand.Parameters.Add(new SqlParameter("@ParentFilterId", SqlDbType.Int, 4, "ParentFilterId"));
DbConnection.db.UpdateDataSet(updatedFilter, "Filters", insertCommand, new SqlCommand(), insertCommand, UpdateBehavior.Transactional);
}
private void CreatefilterButton_Click(object sender, System.EventArgs e)
{
if (FilterNameTextBox.Text.Length == 0)
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("InvalidFilterDescriptionMessage"));
}
else
{
FilterData filterData = new FilterData();
FilterData.FiltersRow filterRow = filterData.Filters.NewFiltersRow();
filterRow.LogicalOperatorTypeID = short.Parse(LogicalOperatorDropDownList.SelectedValue);
filterRow.Description = FilterNameTextBox.Text;
filterRow.SurveyId = SurveyId;
filterRow.ParentFilterId = int.Parse(ParentFilterNameDropDownList.SelectedValue);
filterData.Filters.AddFiltersRow(filterRow);
new Filter().AddFilter(filterData);
UINavigator.NavigateToFilterEditor(SurveyId, ((PageBase)Page).MenuIndex);
}
}
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);
}
private string GetFilterPart(FilterData.FiltersRow f, string splitChar)
{
var split = f.Description.Split(new[] { splitChar[0] });
return split.Any()
? split[0]
: f.Description;
}
public string FilterName(QuestionData.QuestionsRow q, AnswerData.AnswersRow a, FilterData.FiltersRow f)
{
const string splitChar = "|";
return f.FilterId == 0
? FilterName(q, a, splitChar)
: FilterName(q, a, f, splitChar);
}
public string FilterName(QuestionData.QuestionsRow q, AnswerData.AnswersRow a, FilterData.FiltersRow f, string splitChar)
{
return GetSubstr(GetFilterPart(f, splitChar)) + splitChar + FilterName(q, a, splitChar);
}