public void AddFilter(Filter f)
{
if (filters.Count > 0 && f.Prefix == "")
{
f.Prefix = "AND";
}
filters.Add(f);
if (filters.Count > 0)
{
filters[0].Prefix = "";
}
Session[FilterSessionID + "DataFilters"] = filters;
LoadFilterPanel();
btnAddNewFilter.Visible = false;
btnAndNewFilter.Visible = true;
btnOrNewFilter.Visible = true;
OnDataBound();
}
protected void updateFilterButton_Click(object sender, EventArgs e)
{
int filterID = Int32.Parse(((Button)sender).ID.Split('_')[1]);
Filter f = new Filter();
f = filters[filterID];
Panel p = (Panel)(pnlNewFilter.FindControl("dataFilters" + filterID.ToString()));
f.ColumnName = ((DropDownList)p.FindControl("ddlColumnName_" + filterID.ToString())).SelectedValue;
f.Operation = ((DropDownList)p.FindControl("ddlColumnOperation_" + filterID.ToString())).SelectedValue;
f.ColumnValue = ((TextBox)p.FindControl("txtColumnValue_" + filterID.ToString())).Text;
UpdateFilter(filterID, f);
}
public void RemoveFilter(Filter filter)
{
if (filter.ColumnValue == "")
{
foreach (Filter f in Filters)
{
if (filter.ColumnName == f.ColumnName && filter.Operation == f.Operation)
{
Filters.Remove(f);
break;
}
}
}
else
{
foreach (Filter f in Filters)
{
if (filter.ColumnName == f.ColumnName && filter.Operation == f.Operation && filter.ColumnValue == f.ColumnValue)
{
Filters.Remove(f);
}
}
}
if (filters.Count > 0)
{
filters[0].Prefix = "";
}
else
{
btnAndNewFilter.Visible = false;
btnOrNewFilter.Visible = false;
btnAddNewFilter.Visible = true;
}
Session[FilterSessionID + "DataFilters"] = filters;
LoadFilterPanel();
OnDataBound();
}
public void UpdateFilter(int index, Filter f)
{
filters[index] = f;
Session[FilterSessionID + "DataFilters"] = filters;
LoadFilterPanel();
OnDataBound();
}
public void InsertFilter(int index, Filter f)
{
filters.Insert(index, f);
if (filters.Count > 0)
{
filters[0].Prefix = "";
}
}
