protected void btnOrderFilter_Click(object sender, EventArgs e)
{
objReportViewer.Visible = true;
//Get Filetered Orders in DataSet
OrderAdmin _OrderAdmin = new OrderAdmin();
DataView dv = new DataView();
if (Mode.Equals("12"))
{
DataSet tempDs = FormatReportDataSet(_OrderAdmin.GetAllOrders(ZNodeConfigManager.SiteConfig.PortalID).ToDataSet(false));
dsOrdersLineItems = _OrderAdmin.GetAllOrderLineItems().ToDataSet(false);
dv = new DataView(tempDs.Tables[0]);
}
else if (Mode.Equals("21"))
{
dsOrders = _OrderAdmin.ReportList(Mode, Year, "");
dv = new DataView(dsOrders.Tables[0]);
}
DateTime StartDate = DateTime.Parse(txtStartDate.Text.Trim());
DateTime EndDate = DateTime.Parse(txtEndDate.Text.Trim());
if (Mode.Equals("12"))
{
string Status = ddlOrderStatus.SelectedItem.Text;
if (Status == "ALL")
{
dv.RowFilter = "orderdate >= '" + StartDate + "' and orderdate <= '" + EndDate.AddDays(1) + "'";
}
else
{
dv.RowFilter = "orderdate >= '" + StartDate + "' and orderdate <= '" + EndDate.AddDays(1) + "' and orderstatus = '" + Status + "'";
}
}
if (Mode.Equals("21"))
{
string Status = ddlProfilename.SelectedItem.Text;
if (Status == "ALL")
{
dv.RowFilter = "CreateDte >= '" + StartDate + "' and CreateDte <= '" + EndDate.AddDays(1) + "'";
}
else
{
dv.RowFilter = "CreateDte >= '" + StartDate + "' and CreateDte <= '" + EndDate.AddDays(1) + "' and ProfileName = '" + Status + "'";
}
}
if (dv.ToTable().Rows.Count == 0)
{
lblErrorMsg.Text = "No records found";
objReportViewer.Visible = false;
return;
}
objReportViewer.LocalReport.DataSources.Clear();
ReportParameter param1 = new ReportParameter("CurrentLanguage", System.Globalization.CultureInfo.CurrentCulture.Name);
objReportViewer.LocalReport.SetParameters(new ReportParameter[] { param1 });
this.objReportViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
if (Mode.Equals("12"))
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeOrderDataSet_ZNodeOrder", dv));
else if (Mode.Equals("21"))
objReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ZNodeAccountDataSet_ZNodeAccount", dv));
objReportViewer.LocalReport.Refresh();
}