protected void btnFilter_Click(object sender, EventArgs e)
{
var flogical = new LogicalFilter();
//-----Selection filter
if (ddSelect.SelectedIndex != 0)
{
if (ddSelect.SelectedIndex == 2)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null;
}
}
flogical.AddFilter(_selectionFilter);
}
//----OrderID filter
if (!string.IsNullOrEmpty(txtOrderID.Text))
{
flogical.AddLogicalOperation("AND");
flogical.AddFilter(new EqualFieldFilter {
Value = txtOrderID.Text.TryParseInt().ToString(), ParamName = "@OrderId"
});
}
_paging.Fields["ID"].Filter = flogical.FilterCount() > 0 ? flogical : null;
//----Status filter
var stFilter = new CompareFieldFilter();
if (!string.IsNullOrEmpty(ddlStatusName.SelectedValue))
{
if (!OrderService.GetOrderStatuses(true).Any(item => item.Key.ToLower() == ddlStatusName.SelectedValue))
{
ddlStatusName.Items.Remove(ddlStatusName.SelectedValue);
ddlStatusName.SelectedValue = string.Empty;
}
else
if (ddlStatusName.SelectedIndex != 0)
{
stFilter.ParamName = "@StatusName";
stFilter.Expression = ddlStatusName.SelectedValue;
_paging.Fields["StatusName"].Filter = stFilter;
}
else
{
_paging.Fields["StatusName"].Filter = null;
}
}
else
{
_paging.Fields["StatusName"].Filter = null;
}
//----Sum filter
var sumFilter = new RangeFieldFilter {
ParamName = "@Sum"
};
try
{
int priceFrom = 0;
sumFilter.From = int.TryParse(txtSumFrom.Text, out priceFrom) ? priceFrom : 0;
}
catch (Exception)
{
}
try
{
int priceTo = 0;
sumFilter.To = int.TryParse(txtSumTo.Text, out priceTo) ? priceTo : int.MaxValue;
}
catch (Exception)
{
}
_paging.Fields["Sum"].Filter = sumFilter.From.HasValue || sumFilter.To.HasValue ? sumFilter : null;
//---- Name filter
_paging.Fields["BuyerName"].Filter = !string.IsNullOrEmpty(txtBuyerName.Text) ? new CompareFieldFilter {
ParamName = "@BuyerName", Expression = txtBuyerName.Text
} : null;
//---- Billing Name filter
_paging.Fields["BillingName"].Filter = !string.IsNullOrEmpty(txtBillingName.Text) ? new CompareFieldFilter {
ParamName = "@BillingName", Expression = txtBillingName.Text
} : null;
_paging.Fields["PaymentMethod"].Filter = ddlPaymentMethod.SelectedValue != "any"
? new EqualFieldFilter
{
ParamName = "@PaymentMethod",
Value = ddlPaymentMethod.SelectedValue
}
: null;
_paging.Fields["ShippingMethodName"].Filter = ddlShippingMethod.SelectedValue != "any"
? new EqualFieldFilter
{
ParamName = "@ShippingMethodName",
Value = ddlShippingMethod.SelectedValue
}
: null;
_paging.Fields["PaymentDate"].Filter = ddlPayed.SelectedValue != "any"
? ddlPayed.SelectedValue == "yes"
? new NullFieldFilter {
ParamName = "@PaymentDate", Null = false
}
: new NullFieldFilter {
ParamName = "@PaymentDate", Null = true
}
: null;
//---OrderDate filter
var dfilter = new DateTimeRangeFieldFilter {
ParamName = "@dateOrdSearch"
};
if (!string.IsNullOrEmpty(txtDateFrom.Text))
{
DateTime?d = null;
try
{
d = DateTime.Parse(txtDateFrom.Text);
}
catch (Exception)
{
}
if (d.HasValue)
{
var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 0, 0, 0, 0);
dfilter.From = dt;
}
}
if (!string.IsNullOrEmpty(txtDateTo.Text))
{
DateTime?d = null;
try
{
d = DateTime.Parse(txtDateTo.Text);
}
catch (Exception)
{
}
if (d.HasValue)
{
var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 23, 59, 59, 99);
dfilter.To = dt;
}
}
if (dfilter.From.HasValue || dfilter.To.HasValue)
{
_paging.Fields["OrderDate"].Filter = dfilter;
}
else
{
_paging.Fields["OrderDate"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
}
protected void btnFilter_Click(object sender, EventArgs e)
{
//-----Selection filter
if (ddSelect.SelectedIndex != 0)
{
if (ddSelect.SelectedIndex == 2)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null;
}
}
if (_selectionFilter != null)
{
_paging.Fields["ID"].Filter = _selectionFilter;
}
}
else
{
_paging.Fields["ID"].Filter = null;
}
//----Enabled filter
if (ddlEnabled.SelectedIndex != 0)
{
var efilter = new EqualFieldFilter {
ParamName = "@enabled"
};
if (ddlEnabled.SelectedIndex == 1)
{
efilter.Value = "1";
}
if (ddlEnabled.SelectedIndex == 2)
{
efilter.Value = "0";
}
_paging.Fields["Enabled"].Filter = efilter;
}
else
{
_paging.Fields["Enabled"].Filter = null;
}
//----Price filter
var priceFilter = new RangeFieldFilter {
ParamName = "@price"
};
int priceFrom;
priceFilter.From = int.TryParse(txtPriceFrom.Text, out priceFrom) ? priceFrom : 0;
int priceTo;
priceFilter.To = int.TryParse(txtPriceTo.Text, out priceTo) ? priceTo : int.MaxValue;
if (!string.IsNullOrEmpty(txtPriceFrom.Text) || !string.IsNullOrEmpty(txtPriceTo.Text))
{
_paging.Fields["Price"].Filter = priceFilter;
}
else
{
_paging.Fields["Price"].Filter = null;
}
//----Qty filter
var qtyFilter = new RangeFieldFilter {
ParamName = "@Amount"
};
int from;
qtyFilter.From = int.TryParse(txtQtyFrom.Text, out from) ? from : int.MinValue;
int to;
qtyFilter.To = int.TryParse(txtQtyTo.Text, out to) ? to : int.MaxValue;
if (!string.IsNullOrEmpty(txtQtyFrom.Text) || !string.IsNullOrEmpty(txtQtyTo.Text))
{
_paging.Fields["Amount"].Filter = qtyFilter;
}
else
{
_paging.Fields["Amount"].Filter = null;
}
//----SortOrder filter
var soFilter = new RangeFieldFilter {
ParamName = "@SortOrder"
};
try
{
soFilter.From = int.Parse(txtSortOrderFrom.Text);
}
catch (Exception)
{
soFilter.From = int.MinValue;
}
try
{
soFilter.To = int.Parse(txtSortOrderTo.Text);
}
catch (Exception)
{
soFilter.To = int.MaxValue;
}
if (ShowMethod == EShowMethod.Normal)
{
if (!string.IsNullOrEmpty(txtSortOrderFrom.Text) || !string.IsNullOrEmpty(txtSortOrderTo.Text))
{
_paging.Fields["ProductCategories.SortOrder"].Filter = soFilter;
}
else
{
_paging.Fields["ProductCategories.SortOrder"].Filter = null;
}
}
if (!string.IsNullOrEmpty(txtArtNo.Text))
{
var sfilter = new CompareFieldFilter {
Expression = txtArtNo.Text, ParamName = "@artno"
};
_paging.Fields["ArtNo"].Filter = sfilter;
}
else
{
_paging.Fields["ArtNo"].Filter = null;
}
//----Name filter
if (!string.IsNullOrEmpty(txtName.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtName.Text, ParamName = "@name"
};
_paging.Fields["Name"].Filter = nfilter;
}
else
{
_paging.Fields["Name"].Filter = null;
}
//---Photo filter
if (ddPhoto.SelectedIndex != 0)
{
var phfilter = new NullFieldFilter();
if (ddPhoto.SelectedIndex == 1)
{
phfilter.Null = false;
}
if (ddPhoto.SelectedIndex == 2)
{
phfilter.Null = true;
}
phfilter.ParamName = "@PhotoName";
_paging.Fields["PhotoName"].Filter = phfilter;
}
else
{
_paging.Fields["PhotoName"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
//lblFound.Text = _paging.TotalRowsCount.ToString();
//pnlFilterCount.Visible = true;
//pnlNormalCount.Visible = false;
}
