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;
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = _selectionFilter;
}
//----ActivateDate filter
if (!string.IsNullOrEmpty(txtMessageText.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtMessageText.Text, ParamName = "@MessageText"
};
_paging.Fields["MessageText"].Filter = nfilter;
}
else
{
_paging.Fields["MessageText"].Filter = null;
}
//---OrderDate filter
var dfilter = new DateTimeRangeFieldFilter {
ParamName = "@AddDate"
};
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["AddDate"].Filter = dfilter;
}
else
{
_paging.Fields["AddDate"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
}
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 btnDownload_Click(object sender, EventArgs e)
{
if (CommonStatistic.IsRun)
{
lError.Visible = true;
lError.Text = Resource.Admin_Restrict_Action_In_demo;
return;
}
var paging = new SqlPaging
{
TableName = "[Order].[Order]"
};
paging.AddField(new Field {
Name = "*"
});
if (chkStatus.Checked)
{
paging.AddField(new Field
{
Name = "OrderStatusID",
NotInQuery = true,
Filter = new EqualFieldFilter {
ParamName = "@OrderStatusID", Value = ddlStatus.SelectedValue
}
});
}
if (chkDate.Checked)
{
var filter = new DateTimeRangeFieldFilter {
ParamName = "@RDate"
};
var dateFrom = txtDateFrom.Text.TryParseDateTime();
filter.From = dateFrom != DateTime.MinValue ? dateFrom : new DateTime(2000, 1, 1);
var dateTo = txtDateTo.Text.TryParseDateTime();
filter.To = dateTo != DateTime.MinValue ? dateTo.AddDays(1) : new DateTime(3000, 1, 1);
paging.AddField(new Field {
Name = "OrderDate", NotInQuery = true, Filter = filter
});
}
var ordersCount = paging.TotalRowsCount;
if (ordersCount == 0)
{
return;
}
CommonStatistic.Init();
CommonStatistic.IsRun = true;
CommonStatistic.CurrentProcess = Request.Url.PathAndQuery;
CommonStatistic.CurrentProcessName = Resource.Admin_ExportOrdersExcel_DownloadOrders;
CommonStatistic.TotalRow = ordersCount;
linkCancel.Visible = true;
OutDiv.Visible = true;
btnDownload.Visible = false;
pnSearch.Visible = false;
try
{
// Directory
if (!Directory.Exists(_strFilePath))
{
Directory.CreateDirectory(_strFilePath);
}
CommonStatistic.StartNew(() => Save(paging));
}
catch (Exception ex)
{
Debug.LogError(ex);
lError.Text = ex.Message;
lError.Visible = true;
CommonStatistic.IsRun = false;
}
}
protected void btnFilter_Click(object sender, EventArgs e)
{
if (ddSelect.SelectedIndex != 0)
{
if (ddSelect.SelectedIndex == 2)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null;
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = null;
}
//----Firstname filter
if (!string.IsNullOrEmpty(txtSearchFirstName.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtSearchFirstName.Text, ParamName = "@firstname"
};
_paging.Fields["Firstname"].Filter = nfilter;
}
else
{
_paging.Fields["Firstname"].Filter = null;
}
//----lastname filter
if (!string.IsNullOrEmpty(txtSearchLastname.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtSearchLastname.Text, ParamName = "@lastname"
};
_paging.Fields["Lastname"].Filter = nfilter;
}
else
{
_paging.Fields["Lastname"].Filter = null;
}
//----email filter
if (!string.IsNullOrEmpty(txtSearchEmail.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtSearchEmail.Text, ParamName = "@email"
};
_paging.Fields["Email"].Filter = nfilter;
}
else
{
_paging.Fields["Email"].Filter = null;
}
//----RegDate filter
if (!string.IsNullOrEmpty(txtDateFrom.Text) || !string.IsNullOrEmpty(txtDateTo.Text))
{
var nfilter = new DateTimeRangeFieldFilter();
try
{
nfilter.From = DateTime.Parse(txtDateFrom.Text);
}
catch (Exception)
{
nfilter.From = DateTime.Parse("01.01.1900");
}
try
{
nfilter.To = DateTime.Parse(txtDateTo.Text);
}
catch (Exception)
{
nfilter.To = DateTime.MaxValue;
}
nfilter.ParamName = "@RegistrationDateTime";
_paging.Fields["RegistrationDateTime"].Filter = nfilter;
}
else
{
_paging.Fields["RegistrationDateTime"].Filter = null;
}
_paging.Fields["CustomerGroupId"].Filter = ddlCustomerGroup.SelectedValue != "0"
? new EqualFieldFilter
{
ParamName = "@CustomerGroupId",
Value = ddlCustomerGroup.SelectedValue
}
: 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;
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = null;
}
//----Email filter
_paging.Fields["Email"].Filter = !string.IsNullOrEmpty(txtEmail.Text)
? new CompareFieldFilter {
ParamName = "@Email", Expression = txtEmail.Text
}
: null;
//-- productName
_paging.Fields["Name"].Filter = !string.IsNullOrEmpty(txtName.Text)
? new CompareFieldFilter {
ParamName = "@Name", Expression = txtName.Text
}
: null;
//----Text filter
_paging.Fields["[Text]"].Filter = !string.IsNullOrEmpty(txtText.Text)
? new CompareFieldFilter {
ParamName = "@Text", Expression = txtText.Text
}
: null;
//----Checked filter
_paging.Fields["Checked"].Filter = ddlChecked.SelectedValue != "-1"
? new EqualFieldFilter {
ParamName = "@Checked", Value = ddlChecked.SelectedValue
}
: null;
//---AddDate filter
var dfilter = new DateTimeRangeFieldFilter {
ParamName = "@dateRewiews"
};
if (!string.IsNullOrEmpty(txtDateFrom.Text))
{
DateTime?d = default(DateTime?);
try
{
d = DateTime.Parse(txtDateFrom.Text);
}
catch (Exception ex)
{
//Debug.LogError(ex, sender, e);
Debug.LogError(ex);
}
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 = default(DateTime?);
try
{
d = DateTime.Parse(txtDateTo.Text);
}
catch (Exception ex)
{
//Debug.LogError(ex, sender, e);
Debug.LogError(ex);
}
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["AddDate"].Filter = dfilter;
}
else
{
_paging.Fields["AddDate"].Filter = null;
}
}
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;
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = _selectionFilter;
}
//----FirstName filter
if (!string.IsNullOrEmpty(txtFirstName.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtFirstName.Text, ParamName = "@FirstName"
};
_paging.Fields["FirstName"].Filter = nfilter;
}
else
{
_paging.Fields["FirstName"].Filter = null;
}
//----Login filter
//if (!string.IsNullOrEmpty(txtLogin.Text))
//{
// var nfilter = new CompareFieldFilter { Expression = txtLogin.Text, ParamName = "@Login" };
// _paging.Fields["Login"].Filter = nfilter;
//}
//else
//{
// _paging.Fields["Login"].Filter = null;
//}
//---LastName
if (!string.IsNullOrEmpty(txtLastName.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtLastName.Text, ParamName = "@LastName"
};
_paging.Fields["LastName"].Filter = nfilter;
}
else
{
_paging.Fields["LastName"].Filter = null;
}
//---Email Filter
if (!string.IsNullOrEmpty(txtEmail.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtEmail.Text, ParamName = "@Email"
};
_paging.Fields["Email"].Filter = nfilter;
}
else
{
_paging.Fields["Email"].Filter = null;
}
//----Subscribed4News
if (subscribed4News.SelectedIndex != 0)
{
var beforeFilter = new EqualFieldFilter {
ParamName = "@Subscribed4News"
};
if (subscribed4News.SelectedIndex == 1)
{
beforeFilter.Value = "1";
}
if (subscribed4News.SelectedIndex == 2)
{
beforeFilter.Value = "0";
}
_paging.Fields["Subscribed4News"].Filter = beforeFilter;
}
else
{
_paging.Fields["Subscribed4News"].Filter = null;
}
//---OrderDate filter
var dfilter = new DateTimeRangeFieldFilter {
ParamName = "@RegistrationDateTime"
};
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["RegistrationDateTime"].Filter = dfilter;
}
else
{
_paging.Fields["RegistrationDateTime"].Filter = null;
}
pageNumberer.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;
}
}
_paging.Fields["Id"].Filter = _selectionFilter;
}
else
{
_paging.Fields["Id"].Filter = _selectionFilter;
}
//----Email filter
if (!string.IsNullOrEmpty(txtEmail.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtEmail.Text, ParamName = "@Email"
};
_paging.Fields["Email"].Filter = nfilter;
}
else
{
_paging.Fields["Email"].Filter = null;
}
//---AddDate filter
var dfilter1 = new DateTimeRangeFieldFilter {
ParamName = "@SubscribeDate"
};
if (!string.IsNullOrEmpty(txtSubscribeDateFrom.Text))
{
DateTime?d = null;
try
{
d = DateTime.Parse(txtSubscribeDateFrom.Text);
}
catch (Exception)
{
}
if (d.HasValue)
{
var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 0, 0, 0, 0);
dfilter1.From = dt;
}
}
if (!string.IsNullOrEmpty(txtSubscribeDateTo.Text))
{
DateTime?d = null;
try
{
d = DateTime.Parse(txtSubscribeDateTo.Text);
}
catch (Exception)
{
}
if (d.HasValue)
{
var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 23, 59, 59, 99);
dfilter1.To = dt;
}
}
if (dfilter1.From.HasValue || dfilter1.To.HasValue)
{
_paging.Fields["SubscribeDate"].Filter = dfilter1;
}
else
{
_paging.Fields["SubscribeDate"].Filter = null;
}
//---AddDate filter
var dfilter2 = new DateTimeRangeFieldFilter {
ParamName = "@UnsubscribeDate"
};
if (!string.IsNullOrEmpty(txtUnsubscribeDateFrom.Text))
{
DateTime?d = null;
try
{
d = DateTime.Parse(txtUnsubscribeDateFrom.Text);
}
catch (Exception)
{
}
if (d.HasValue)
{
var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 0, 0, 0, 0);
dfilter2.From = dt;
}
}
if (!string.IsNullOrEmpty(txtUnsubscribeDateTo.Text))
{
DateTime?d = null;
try
{
d = DateTime.Parse(txtUnsubscribeDateTo.Text);
}
catch (Exception)
{
}
if (d.HasValue)
{
var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 23, 59, 59, 99);
dfilter2.To = dt;
}
}
if (dfilter2.From.HasValue || dfilter2.To.HasValue)
{
_paging.Fields["UnsubscribeDate"].Filter = dfilter2;
}
else
{
_paging.Fields["UnsubscribeDate"].Filter = null;
}
//----Enable filter
if (ddSubscribe.SelectedIndex != 0)
{
var enableFilter = new EqualFieldFilter {
ParamName = "@Subscribe"
};
if (ddSubscribe.SelectedIndex == 1)
{
enableFilter.Value = "1";
}
if (ddSubscribe.SelectedIndex == 2)
{
enableFilter.Value = "0";
}
_paging.Fields["Subscribe"].Filter = enableFilter;
}
else
{
_paging.Fields["Subscribe"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
}
