protected void Button1_Click(object sender, EventArgs e) { System.IO.MemoryStream m_stream = new System.IO.MemoryStream(); GRN_BL objGrn = new GRN_BL(); rptWBServiceProvider rpt = new rptWBServiceProvider(); Guid warehouseId = new Guid(cboWarehouse.SelectedValue); int wbServiceProviderId = cboWBServiceProvider.SelectedIndex == 0 ? -2 : int.Parse(cboWBServiceProvider.SelectedValue); DateTime startDate = string.IsNullOrEmpty(txtStartDate.Text) ? DateTime.Parse("1/1/2010") : DateTime.Parse(txtStartDate.Text); DateTime endDate = string.IsNullOrEmpty(txtEndDate.Text) ? DateTime.Now : DateTime.Parse(txtEndDate.Text); int serviceType = int.Parse(cboServiceType.SelectedValue); DataTable dt = objGrn.GetWBServiceProviderReport(warehouseId, wbServiceProviderId, startDate, endDate, serviceType); decimal sumNumberOfBags, sumNetWeight; int rowsCount = dt.Rows.Count; string NoOfRegords = ""; if (rowsCount == 0) { Messages1.SetMessage("No record found with specified criteria.", WarehouseApplication.Messages.MessageType.Warning); WebViewer1.ClearCachedReport(); return; } else { sumNumberOfBags = decimal.Parse(dt.Compute("Sum(NumberOfBags)", "").ToString()); sumNetWeight = decimal.Parse(dt.Compute("Sum(NetWeight)", "").ToString()); NoOfRegords = rowsCount == 1 ? "1 record found." : rowsCount + " records found."; Messages1.SetMessage(NoOfRegords, WarehouseApplication.Messages.MessageType.Success); rpt.SumNumberOfBags = sumNumberOfBags; rpt.SumNetWeight = sumNetWeight; } rpt.Warehouse = cboWarehouse.SelectedItem.Text; rpt.WBServiceProvider = cboWBServiceProvider.SelectedIndex == 0 ? "All" : cboWBServiceProvider.SelectedItem.Text; rpt.DateFrom = string.IsNullOrEmpty(txtStartDate.Text) ? "No Limit" : txtStartDate.Text; rpt.DateTo = string.IsNullOrEmpty(txtEndDate.Text) ? "Present Date" : txtEndDate.Text; rpt.DataSource = dt; rpt.Run(); if (this.xlsExport1 == null) { this.xlsExport1 = new DataDynamics.ActiveReports.Export.Xls.XlsExport(); } // this.xlsExport1.MinColumnWidth = (float)(0.5); this.xlsExport1.Export(rpt.Document, m_stream); m_stream.Position = 0; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("content-disposition", "inline; filename=MyExport.xls"); Response.BinaryWrite(m_stream.ToArray()); Response.End(); }
protected void btnGenerate_Click(object sender, EventArgs e) { try { Messages1.ClearMessage(); GRN_BL objGrn = new GRN_BL(); rptWBServiceProvider rpt = new rptWBServiceProvider(); Guid warehouseId = new Guid(cboWarehouse.SelectedValue); int wbServiceProviderId = cboWBServiceProvider.SelectedIndex == 0 ? -2 : int.Parse(cboWBServiceProvider.SelectedValue); DateTime startDate = string.IsNullOrEmpty(txtStartDate.Text) ? DateTime.Parse("1/1/2010") : DateTime.Parse(txtStartDate.Text); DateTime endDate = string.IsNullOrEmpty(txtEndDate.Text) ? DateTime.Now : DateTime.Parse(txtEndDate.Text); int serviceType = int.Parse(cboServiceType.SelectedValue); DataTable dt = objGrn.GetWBServiceProviderReport(warehouseId, wbServiceProviderId, startDate, endDate, serviceType); decimal sumNumberOfBags, sumNetWeight; int rowsCount = dt.Rows.Count; string NoOfRegords = ""; if (rowsCount == 0) { Messages1.SetMessage("No record found with specified criteria.", WarehouseApplication.Messages.MessageType.Warning); WebViewer1.ClearCachedReport(); return; } else { sumNumberOfBags = decimal.Parse(dt.Compute("Sum(NumberOfBags)", "").ToString()); sumNetWeight = decimal.Parse(dt.Compute("Sum(NetWeight)", "").ToString()); NoOfRegords = rowsCount == 1 ? "1 record found." : rowsCount + " records found."; Messages1.SetMessage(NoOfRegords, WarehouseApplication.Messages.MessageType.Success); rpt.SumNumberOfBags = sumNumberOfBags; rpt.SumNetWeight = sumNetWeight; } rpt.Warehouse = cboWarehouse.SelectedItem.Text; rpt.WBServiceProvider = cboWBServiceProvider.SelectedIndex == 0 ? "All" : cboWBServiceProvider.SelectedItem.Text; rpt.DateFrom = string.IsNullOrEmpty(txtStartDate.Text) ? "No Limit" : txtStartDate.Text; rpt.DateTo = string.IsNullOrEmpty(txtEndDate.Text) ? "Present Date" : txtEndDate.Text; rpt.DataSource = dt; WebViewer1.Report = rpt; } catch (Exception ex) { Messages1.SetMessage(ex.Message, WarehouseApplication.Messages.MessageType.Error); } }