private void c1DataFilter1_FilterAutoGenerating(object sender, C1.DataFilter.FilterAutoGeneratingEventArgs e)
{
switch (e.Property.Name)
{
case "Model":
var modelFilter = (C1.Win.DataFilter.ChecklistFilter)e.Filter;
modelFilter.ShowSearchBox = true;
modelFilter.SelectAll();
break;
case "Brand":
var brandFilter = (C1.Win.DataFilter.ChecklistFilter)e.Filter;
brandFilter.SelectAll();
break;
case "Liter":
var literFilter = (C1.Win.DataFilter.RangeFilter)e.Filter;
literFilter.Maximum = _carsTable.AsEnumerable().Max(x => x.Field <double>("Liter"));
literFilter.Minimum = _carsTable.AsEnumerable().Min(x => x.Field <double>("Liter"));
literFilter.Increment = 0.01;
break;
case "TransmissSpeedCount":
var tskFilter = new C1.Win.DataFilter.ChecklistFilter("TransmissSpeedCount");
tskFilter.HeaderText = "Transmiss speed count";
tskFilter.ShowSelectAll = false;
tskFilter.SelectAll();
e.Filter = tskFilter;
break;
case "Category":
var categoryFilter = (C1.Win.DataFilter.ChecklistFilter)e.Filter;
categoryFilter.ShowSelectAll = false;
categoryFilter.SelectAll();
break;
case "Price":
var priceFilter = (C1.Win.DataFilter.RangeFilter)e.Filter;
priceFilter.Maximum = _carsTable.AsEnumerable().Max(x => x.Field <double>("Price"));
priceFilter.Minimum = _carsTable.AsEnumerable().Min(x => x.Field <double>("Price"));
priceFilter.Increment = 1000;
priceFilter.Digits = 0;
break;
default:
e.Cancel = true;
break;
}
}
private void c1DataFilter1_FilterAutoGenerating(object sender, C1.DataFilter.FilterAutoGeneratingEventArgs e)
{
switch (e.Property.Name)
{
case "PostId":
var postFilter = new C1.Win.DataFilter.ChecklistFilter("PostId")
{
DisplayMemberPath = "Title",
ValueMemberPath = "Id",
SelectionMode = C1.DataFilter.SelectionMode.Single,
ShowSearchBox = false,
LayoutType = C1.DataFilter.LayoutType.List,
MaxHeight = 200,
HeaderText = e.Filter.HeaderText,
ItemsSource = Employee.Posts
};
postFilter.Items[0].Selected = true;
e.Filter = postFilter;
break;
case "EmploymentDate":
var eDate = (C1.Win.DataFilter.DateRangeFilter)e.Filter;
var data = (List <Employee>)c1DataFilter1.DataSource;
eDate.Minimum = data.Min(x => x.EmploymentDate);
eDate.Maximum = data.Max(x => x.EmploymentDate);
break;
case "CountryId":
var cntFilter = new C1.Win.DataFilter.ChecklistFilter("CountryId")
{
DisplayMemberPath = "Name",
ValueMemberPath = "Id",
SelectionMode = C1.DataFilter.SelectionMode.Multiple,
ShowSearchBox = false,
ShowSelectAll = true,
HeaderText = e.Filter.HeaderText,
ItemsSource = Employee.Countries
};
cntFilter.SelectAll();
e.Filter = cntFilter;
break;
default:
e.Cancel = true;
break;
}
}
private void c1DataFilter1_FilterAutoGenerating(object sender, C1.DataFilter.FilterAutoGeneratingEventArgs e)
{
switch (e.Property.Name)
{
case "OrderDate":
var orderDateFilter = (C1.Win.DataFilter.DateRangeFilter)e.Filter;
orderDateFilter.Maximum = _ordersTable.AsEnumerable().Max(x => x.Field <DateTime>("OrderDate"));
orderDateFilter.Minimum = _ordersTable.AsEnumerable().Min(x => x.Field <DateTime>("OrderDate"));
orderDateFilter.HeaderText = "Order date";
break;
case "RequiredDate":
var reqDateFilter = (C1.Win.DataFilter.DateRangeFilter)e.Filter;
reqDateFilter.Maximum = _ordersTable.AsEnumerable().Max(x => x.Field <DateTime>("RequiredDate"));
reqDateFilter.Minimum = _ordersTable.AsEnumerable().Min(x => x.Field <DateTime>("RequiredDate"));
reqDateFilter.HeaderText = "Required date";
break;
case "Freight":
var freightFilter = (C1.Win.DataFilter.RangeFilter)e.Filter;
freightFilter.Maximum = (double)_ordersTable.AsEnumerable().Max(x => x.Field <decimal>("Freight"));
freightFilter.Minimum = (double)_ordersTable.AsEnumerable().Min(x => x.Field <decimal>("Freight"));
freightFilter.Increment = 10;
freightFilter.HeaderText = "Freight";
break;
case "ShipCountry":
var countryFilter = (C1.Win.DataFilter.ChecklistFilter)e.Filter;
countryFilter.HeaderText = "Ship country";
countryFilter.ShowSelectAll = true;
countryFilter.ShowSearchBox = true;
countryFilter.SelectAll();
break;
default:
e.Cancel = true;
break;
}
}
private void C1DataFilter_FilterAutoGenerating(object sender, C1.DataFilter.FilterAutoGeneratingEventArgs e)
{
switch (e.Property.Name)
{
case "Model":
var modelFilter = (ChecklistFilter)e.Filter;
modelFilter.SelectAll();
break;
case "Brand":
var brandFilter = (ChecklistFilter)e.Filter;
brandFilter.SelectAll();
break;
case "Liter":
var literFilter = (RangeFilter)e.Filter;
literFilter.Maximum = _carsTable.AsEnumerable().Max(x => x.Field <double>("Liter"));
literFilter.Minimum = _carsTable.AsEnumerable().Min(x => x.Field <double>("Liter"));
literFilter.Increment = 0.01;
break;
case "TransmissSpeedCount":
var transmissFilter = (ChecklistFilter)e.Filter;
transmissFilter.HeaderText = "Transmiss Speed Count";
transmissFilter.ShowSelectAll = false;
transmissFilter.SelectAll();
break;
case "Category":
var categoryFilter = (ChecklistFilter)e.Filter;
categoryFilter.ShowSelectAll = false;
categoryFilter.SelectAll();
break;
case "TransmissAutomatic":
var taFilter = (ChecklistFilter)e.Filter;
taFilter.HeaderText = "Transmiss Automatic";
taFilter.ItemsSource = new List <TransmissAutomatic>()
{
new TransmissAutomatic()
{
DisplayValue = "Yes", Value = "Yes"
},
new TransmissAutomatic()
{
DisplayValue = "No", Value = "No"
},
new TransmissAutomatic()
{
DisplayValue = "Empty", Value = string.Empty
}
};
taFilter.DisplayMemberPath = "DisplayValue";
taFilter.ValueMemberPath = "Value";
taFilter.ShowSelectAll = false;
taFilter.SelectAll();
break;
case "Price":
var priceFilter = (RangeFilter)e.Filter;
priceFilter.Maximum = _carsTable.AsEnumerable().Max(x => x.Field <double>("Price"));
priceFilter.Minimum = _carsTable.AsEnumerable().Min(x => x.Field <double>("Price"));
priceFilter.Increment = 1000;
priceFilter.Format = "F0";
break;
default:
e.Cancel = true;
break;
}
}
private void c1DataFilter1_FilterAutoGenerating(object sender, C1.DataFilter.FilterAutoGeneratingEventArgs e)
{
switch (e.Property.Name)
{
case "Model":
var modelFilter = (C1.Win.DataFilter.ChecklistFilter)e.Filter;
modelFilter.ShowSearchBox = true;
modelFilter.SelectAll();
break;
case "Brand":
var brandFilter = (C1.Win.DataFilter.ChecklistFilter)e.Filter;
brandFilter.SelectAll();
break;
case "Liter":
var literFilter = (C1.Win.DataFilter.RangeFilter)e.Filter;
literFilter.Maximum = _carsTable.AsEnumerable().Max(x => x.Field <double>("Liter"));
literFilter.Minimum = _carsTable.AsEnumerable().Min(x => x.Field <double>("Liter"));
literFilter.Increment = 0.01;
break;
case "TransmissSpeedCount":
var tskFilter = new C1.Win.DataFilter.ChecklistFilter("TransmissSpeedCount");
tskFilter.HeaderText = "Transmiss speed count";
tskFilter.ShowSelectAll = false;
tskFilter.SelectAll();
e.Filter = tskFilter;
break;
case "Category":
var categoryFilter = (C1.Win.DataFilter.ChecklistFilter)e.Filter;
categoryFilter.ShowSelectAll = false;
categoryFilter.SelectAll();
break;
case "TransmissAutomatic":
var taFilter = (C1.Win.DataFilter.ChecklistFilter)e.Filter;
taFilter.ItemsSource = new List <TransmissAutomatic>()
{
new TransmissAutomatic()
{
DisplayValue = "Yes", Value = "Yes"
},
new TransmissAutomatic()
{
DisplayValue = "No", Value = "No"
},
new TransmissAutomatic()
{
DisplayValue = "No information", Value = DBNull.Value
}
};
taFilter.DisplayMemberPath = "DisplayValue";
taFilter.ValueMemberPath = "Value";
taFilter.ShowSelectAll = false;
taFilter.LayoutType = C1.DataFilter.LayoutType.List;
taFilter.SelectAll();
break;
case "Price":
var priceFilter = (C1.Win.DataFilter.RangeFilter)e.Filter;
priceFilter.Maximum = _carsTable.AsEnumerable().Max(x => x.Field <double>("Price"));
priceFilter.Minimum = _carsTable.AsEnumerable().Min(x => x.Field <double>("Price"));
priceFilter.Increment = 1000;
priceFilter.Digits = 0;
break;
default:
e.Cancel = true;
break;
}
}
