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();
if (dateFrom != DateTime.MinValue)
filter.From = dateFrom;
var dateTo = txtDateTo.Text.TryParseDateTime();
if (dateTo != DateTime.MinValue)
filter.To = dateTo.AddDays(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);
var tr = new Thread(Save);
CommonStatistic.ThreadImport = tr;
tr.Start(paging);
}
catch (Exception ex)
{
//Debug.LogError(ex, sender, e);
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;
_paging.Fields["PriceType"].Filter = ddlPriceTypes.SelectedValue != "0"
? new EqualFieldFilter
{
ParamName = "@PriceType",
Value = ddlPriceTypes.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 = _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;
}
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 = 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;
}
//----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;
}
