private void ExportToStream(object oReport, string sFileName, StringBuilder sb, exportTo eExport)
{
System.IO.Stream oStream = null;
StreamWriter sw = null;
ExportOptions oOptions = new ExportOptions();
ExportRequestContext oRequest = new ExportRequestContext();
Response.Buffer = true;
Response.ClearHeaders();
Response.ClearContent();
if (eExport == exportTo.TXT)
{
oStream = new MemoryStream();
sw = new StreamWriter(oStream, System.Text.Encoding.Default);
sw.WriteLine(sb);
sw.Flush();
oStream.Seek(0, SeekOrigin.Begin);
Response.ContentType = "application/vnd.ms-excel";
}
else if (eExport == exportTo.XLS)
{
oOptions.ExportFormatType = ExportFormatType.Excel;
oOptions.FormatOptions = new ExcelFormatOptions();
oRequest.ExportInfo = oOptions;
oStream = ((ReportDocument)oReport).ExportToStream(ExportFormatType.Excel);
Response.ContentType = "application/vnd.ms-excel";
}
else if (eExport == exportTo.PDF)
{
oOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
oOptions.FormatOptions = new PdfRtfWordFormatOptions();
oRequest.ExportInfo = oOptions;
oStream = ((ReportDocument)oReport).ExportToStream(ExportFormatType.PortableDocFormat);
Response.ContentType = "application/pdf";
}
else if (eExport == exportTo.DOC)
{
oOptions.ExportFormatType = ExportFormatType.WordForWindows;
oOptions.FormatOptions = new PdfRtfWordFormatOptions();
oRequest.ExportInfo = oOptions;
oStream = ((ReportDocument)oReport).ExportToStream(ExportFormatType.WordForWindows);
Response.ContentType = "application/msword";
}
Response.AppendHeader("Content-Disposition", "Attachment; Filename=\"" + sFileName.Replace(" ", "_") + "\"");
byte[] streamByte = new byte[oStream.Length];
oStream.Read(streamByte, 0, (int)oStream.Length);
Response.BinaryWrite(streamByte);
Response.End();
if (oStream != null)
{
oStream.Close();
}
if (sw != null)
{
sw.Close();
}
}
private void getReport(bool sendToPrinter, exportTo eExport)
{
string reportName = "AdmRptPrgList";
cCriteria.Visible = false; cClearCriButton.Visible = false; cShowCriButton.Visible = (bool)Session[KEY_bShCriVisible];
DataTable dt = (new AdminSystem()).GetRptDt(58, "GetAdmRptPrgList", base.LImpr, base.LCurr, UpdCriteria(false), GetRptCriteria(), LcAppConnString, LcAppPw, false, false, false, CommandTimeOut);
CovertRptUTC(dt);
if (dt.Rows.Count > 0)
{
if (dt.Columns.Contains("ReportName"))
{
reportName = dt.Rows[0]["ReportName"].ToString();
}
}
else
{
PreMsgPopup("For your information, no data is currently available as per your reporting criteria.");
}
if (Config.DeployType == "DEV" && Config.AppNameSpace == "RO")
{
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.DataSetName = "DsAdmRptPrgList";
ds.Tables[0].TableName = "DtAdmRptPrgList";
string xsdPath = Server.MapPath("~/reports/AdmRptPrgListReport.xsd");
using (System.IO.StreamWriter writer = new System.IO.StreamWriter(xsdPath))
{
ds.WriteXmlSchema(writer);
writer.Close();
}
}
reportName = reportName + "_" + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
DataView dvItem = GetReportItem(); DataView dvSct = GetReportSct();
foreach (DataRowView drv in dvSct)
{
SetReportSct(dvItem, drv["ReportSctName"].ToString());
}
rp.Refresh();
if (sendToPrinter)
{
rp.PrintOptions.PrinterName = cPrinter.SelectedItem.Value;
rp.PrintOptions.PaperOrientation = PaperOrientation.Portrait;
}
rp.SetDataSource(dt);
cViewer.ReportSource = rp;
if (cViewerWidth.Value != string.Empty)
{
cViewer.Width = Unit.Pixel(int.Parse(cViewerWidth.Value));
}
cViewer.Visible = true;
cViewer.DisplayGroupTree = false;
if (sendToPrinter)
{
rp.PrintToPrinter(1, false, 0, 0);
}
if (eExport == exportTo.TXT)
{
StringBuilder sb = new StringBuilder();
if (dt.Columns.Contains("CultureDescIn"))
{
sb.Append("Culture Requested" + (char)9);
}
if (dt.Columns.Contains("SystemNameIn"))
{
sb.Append("System Requested" + (char)9);
}
if (dt.Columns.Contains("QId"))
{
sb.Append("Menu Order" + (char)9);
}
if (dt.Columns.Contains("MenuText"))
{
sb.Append("Menu Label" + (char)9);
}
if (dt.Columns.Contains("ProgramType"))
{
sb.Append("Program Type" + (char)9);
}
if (dt.Columns.Contains("ProgramName"))
{
sb.Append("Program Name" + (char)9);
}
if (dt.Columns.Contains("Everyone"))
{
sb.Append("Everyone Access" + (char)9);
}
if (dt.Columns.Contains("ClientTierList"))
{
sb.Append("Client Tier List" + (char)9);
}
if (dt.Columns.Contains("RuleTierList"))
{
sb.Append("Rule Tier List" + (char)9);
}
if (dt.Columns.Contains("DataTierList"))
{
sb.Append("Data Tier List" + (char)9);
}
if (dt.Columns.Contains("ClientRule"))
{
sb.Append("Client Rule" + (char)9);
}
if (dt.Columns.Contains("WebRule"))
{
sb.Append("Web Rule" + (char)9);
}
if (dt.Columns.Contains("ServerRule"))
{
sb.Append("Server Rule" + (char)9);
}
sb.Append(Environment.NewLine);
DataView dv = new DataView(dt);
foreach (DataRowView drv in dv)
{
if (dt.Columns.Contains("CultureDescIn"))
{
sb.Append(drv["CultureDescIn"].ToString() + (char)9);
}
if (dt.Columns.Contains("SystemNameIn"))
{
sb.Append(drv["SystemNameIn"].ToString() + (char)9);
}
if (dt.Columns.Contains("QId"))
{
sb.Append(drv["QId"].ToString() + (char)9);
}
if (dt.Columns.Contains("MenuText"))
{
sb.Append(drv["MenuText"].ToString() + (char)9);
}
if (dt.Columns.Contains("ProgramType"))
{
sb.Append(drv["ProgramType"].ToString() + (char)9);
}
if (dt.Columns.Contains("ProgramName"))
{
sb.Append(drv["ProgramName"].ToString() + (char)9);
}
if (dt.Columns.Contains("Everyone"))
{
sb.Append(drv["Everyone"].ToString() + (char)9);
}
if (dt.Columns.Contains("ClientTierList"))
{
sb.Append(drv["ClientTierList"].ToString() + (char)9);
}
if (dt.Columns.Contains("RuleTierList"))
{
sb.Append(drv["RuleTierList"].ToString() + (char)9);
}
if (dt.Columns.Contains("DataTierList"))
{
sb.Append(drv["DataTierList"].ToString() + (char)9);
}
if (dt.Columns.Contains("ClientRule"))
{
sb.Append(drv["ClientRule"].ToString() + (char)9);
}
if (dt.Columns.Contains("WebRule"))
{
sb.Append(drv["WebRule"].ToString() + (char)9);
}
if (dt.Columns.Contains("ServerRule"))
{
sb.Append(drv["ServerRule"].ToString() + (char)9);
}
sb.Append(Environment.NewLine);
}
ExportToStream(null, reportName + ".csv", sb.Insert(0, (Config.ExportExcelCSV ? "sep=\t\n": "")).Replace("\r\n", "\n"), exportTo.TXT);
}
else if (eExport == exportTo.XLS)
{
ExportToStream(rp, reportName + ".xls", null, exportTo.XLS);
}
else if (eExport == exportTo.PDF)
{
ExportToStream(rp, reportName + ".pdf", null, exportTo.PDF);
}
else if (eExport == exportTo.DOC)
{
ExportToStream(rp, reportName + ".doc", null, exportTo.DOC);
}
}
private void getReport(bool sendToPrinter, exportTo eExport)
{
string reportName = "AdmRptUsr";
cCriteria.Visible = false; cClearCriButton.Visible = false; cShowCriButton.Visible = (bool)Session[KEY_bShCriVisible];
DataTable dt = (new AdminSystem()).GetRptDt(53, "GetAdmRptUsr", base.LImpr, base.LCurr, UpdCriteria(false), GetRptCriteria(), LcAppConnString, LcAppPw, false, false, false, Config.CommandTimeOut);
CovertRptUTC(dt);
if (dt.Rows.Count > 0)
{
if (dt.Columns.Contains("ReportName"))
{
reportName = dt.Rows[0]["ReportName"].ToString();
}
}
else
{
PreMsgPopup("For your information, no data is currently available as per your reporting criteria.");
}
if (Config.DeployType == "DEV" && Config.AppNameSpace == "RO")
{
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.DataSetName = "DsAdmRptUsr";
ds.Tables[0].TableName = "DtAdmRptUsr";
string xsdPath = Server.MapPath("~/reports/AdmRptUsrReport.xsd");
using (System.IO.StreamWriter writer = new System.IO.StreamWriter(xsdPath))
{
ds.WriteXmlSchema(writer);
writer.Close();
}
}
reportName = reportName + "_" + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
DataView dvItem = GetReportItem(); DataView dvSct = GetReportSct();
foreach (DataRowView drv in dvSct)
{
SetReportSct(dvItem, drv["ReportSctName"].ToString());
}
rp.Refresh();
if (sendToPrinter)
{
rp.PrintOptions.PrinterName = cPrinter.SelectedItem.Value;
rp.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
}
rp.SetDataSource(dt);
cViewer.ReportSource = rp;
if (cViewerWidth.Value != string.Empty)
{
cViewer.Width = Unit.Pixel(int.Parse(cViewerWidth.Value));
}
cViewer.Visible = true;
cViewer.DisplayGroupTree = false;
if (sendToPrinter)
{
rp.PrintToPrinter(1, false, 0, 0);
}
if (eExport == exportTo.TXT)
{
StringBuilder sb = new StringBuilder();
if (dt.Columns.Contains("a.Active"))
{
sb.Append("a.Active" + (char)9);
}
if (dt.Columns.Contains("b.UsrGroupId"))
{
sb.Append("b.UsrGroupId" + (char)9);
}
if (dt.Columns.Contains("CurrCompany"))
{
sb.Append("Current Selected Company" + (char)9);
}
if (dt.Columns.Contains("UsrGroupIn"))
{
sb.Append("Selected User Group" + (char)9);
}
if (dt.Columns.Contains("ActiveIn"))
{
sb.Append("Active" + (char)9);
}
if (dt.Columns.Contains("UsrGroupName"))
{
sb.Append("User Group" + (char)9);
}
if (dt.Columns.Contains("CultureTypeName"))
{
sb.Append("Culture" + (char)9);
}
if (dt.Columns.Contains("RowAuthorityDesc"))
{
sb.Append("Row Authority" + (char)9);
}
if (dt.Columns.Contains("ColAuthorityDesc"))
{
sb.Append("Col Authority" + (char)9);
}
if (dt.Columns.Contains("LoginName"))
{
sb.Append("Login Name" + (char)9);
}
if (dt.Columns.Contains("UsrName"))
{
sb.Append("User Name" + (char)9);
}
if (dt.Columns.Contains("UsrEmail"))
{
sb.Append("User Email" + (char)9);
}
if (dt.Columns.Contains("CompanyDesc"))
{
sb.Append("Company" + (char)9);
}
if (dt.Columns.Contains("InvestorName"))
{
sb.Append("Investor" + (char)9);
}
if (dt.Columns.Contains("CustomerName"))
{
sb.Append("Customer" + (char)9);
}
if (dt.Columns.Contains("VendorName"))
{
sb.Append("Vendor" + (char)9);
}
if (dt.Columns.Contains("AgentName"))
{
sb.Append("Agent Name" + (char)9);
}
if (dt.Columns.Contains("BrokerName"))
{
sb.Append("Broker Name" + (char)9);
}
if (dt.Columns.Contains("MemberName"))
{
sb.Append("Member" + (char)9);
}
if (dt.Columns.Contains("iUsrName"))
{
sb.Append("Impr User Name" + (char)9);
}
if (dt.Columns.Contains("iCompanyDesc"))
{
sb.Append("Impr Company Name" + (char)9);
}
if (dt.Columns.Contains("iInvestorName"))
{
sb.Append("Impr Investor Name" + (char)9);
}
if (dt.Columns.Contains("iCustomerName"))
{
sb.Append("Impr Customer Name" + (char)9);
}
if (dt.Columns.Contains("iVendorName"))
{
sb.Append("Impr Vendor Name" + (char)9);
}
if (dt.Columns.Contains("iAgentName"))
{
sb.Append("Impr Agent Name" + (char)9);
}
if (dt.Columns.Contains("iBrokerName"))
{
sb.Append("Impr Broker Name" + (char)9);
}
if (dt.Columns.Contains("iMemberName"))
{
sb.Append("Impr Member Name" + (char)9);
}
sb.Append(Environment.NewLine);
DataView dv = new DataView(dt);
foreach (DataRowView drv in dv)
{
if (dt.Columns.Contains("a.Active"))
{
sb.Append(drv["a.Active"].ToString() + (char)9);
}
if (dt.Columns.Contains("b.UsrGroupId"))
{
sb.Append(drv["b.UsrGroupId"].ToString() + (char)9);
}
if (dt.Columns.Contains("CurrCompany"))
{
sb.Append(drv["CurrCompany"].ToString() + (char)9);
}
if (dt.Columns.Contains("UsrGroupIn"))
{
sb.Append(drv["UsrGroupIn"].ToString() + (char)9);
}
if (dt.Columns.Contains("ActiveIn"))
{
sb.Append(drv["ActiveIn"].ToString() + (char)9);
}
if (dt.Columns.Contains("UsrGroupName"))
{
sb.Append(drv["UsrGroupName"].ToString() + (char)9);
}
if (dt.Columns.Contains("CultureTypeName"))
{
sb.Append(drv["CultureTypeName"].ToString() + (char)9);
}
if (dt.Columns.Contains("RowAuthorityDesc"))
{
sb.Append(drv["RowAuthorityDesc"].ToString() + (char)9);
}
if (dt.Columns.Contains("ColAuthorityDesc"))
{
sb.Append(drv["ColAuthorityDesc"].ToString() + (char)9);
}
if (dt.Columns.Contains("LoginName"))
{
sb.Append(drv["LoginName"].ToString() + (char)9);
}
if (dt.Columns.Contains("UsrName"))
{
sb.Append(drv["UsrName"].ToString() + (char)9);
}
if (dt.Columns.Contains("UsrEmail"))
{
sb.Append(drv["UsrEmail"].ToString() + (char)9);
}
if (dt.Columns.Contains("CompanyDesc"))
{
sb.Append(drv["CompanyDesc"].ToString() + (char)9);
}
if (dt.Columns.Contains("InvestorName"))
{
sb.Append(drv["InvestorName"].ToString() + (char)9);
}
if (dt.Columns.Contains("CustomerName"))
{
sb.Append(drv["CustomerName"].ToString() + (char)9);
}
if (dt.Columns.Contains("VendorName"))
{
sb.Append(drv["VendorName"].ToString() + (char)9);
}
if (dt.Columns.Contains("AgentName"))
{
sb.Append(drv["AgentName"].ToString() + (char)9);
}
if (dt.Columns.Contains("BrokerName"))
{
sb.Append(drv["BrokerName"].ToString() + (char)9);
}
if (dt.Columns.Contains("MemberName"))
{
sb.Append(drv["MemberName"].ToString() + (char)9);
}
if (dt.Columns.Contains("iUsrName"))
{
sb.Append(drv["iUsrName"].ToString() + (char)9);
}
if (dt.Columns.Contains("iCompanyDesc"))
{
sb.Append(drv["iCompanyDesc"].ToString() + (char)9);
}
if (dt.Columns.Contains("iInvestorName"))
{
sb.Append(drv["iInvestorName"].ToString() + (char)9);
}
if (dt.Columns.Contains("iCustomerName"))
{
sb.Append(drv["iCustomerName"].ToString() + (char)9);
}
if (dt.Columns.Contains("iVendorName"))
{
sb.Append(drv["iVendorName"].ToString() + (char)9);
}
if (dt.Columns.Contains("iAgentName"))
{
sb.Append(drv["iAgentName"].ToString() + (char)9);
}
if (dt.Columns.Contains("iBrokerName"))
{
sb.Append(drv["iBrokerName"].ToString() + (char)9);
}
if (dt.Columns.Contains("iMemberName"))
{
sb.Append(drv["iMemberName"].ToString() + (char)9);
}
sb.Append(Environment.NewLine);
}
ExportToStream(null, reportName + ".csv", sb.Insert(0, (Config.ExportExcelCSV ? "sep=\t\n": "")).Replace("\r\n", "\n"), exportTo.TXT);
}
else if (eExport == exportTo.XLS)
{
ExportToStream(rp, reportName + ".xls", null, exportTo.XLS);
}
else if (eExport == exportTo.PDF)
{
ExportToStream(rp, reportName + ".pdf", null, exportTo.PDF);
}
else if (eExport == exportTo.DOC)
{
ExportToStream(rp, reportName + ".doc", null, exportTo.DOC);
}
}
private void getReport(bool sendToPrinter, exportTo eExport)
{
string reportName = "AdmRptSred";
cCriteria.Visible = false; cClearCriButton.Visible = false; cShowCriButton.Visible = (bool)Session[KEY_bShCriVisible];
DataTable dt = (new AdminSystem()).GetRptDt(59, "GetAdmRptSred", base.LImpr, base.LCurr, UpdCriteria(false), GetRptCriteria(), LcAppConnString, LcAppPw, false, false, false);
CovertRptUTC(dt);
if (dt.Rows.Count > 0)
{
if (dt.Columns.Contains("ReportName"))
{
reportName = dt.Rows[0]["ReportName"].ToString();
}
}
else
{
PreMsgPopup("For your information, no data is currently available as per your reporting criteria.");
}
if (Config.DeployType == "DEV" && Config.AppNameSpace == "RO")
{
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.DataSetName = "DsAdmRptSred";
ds.Tables[0].TableName = "DtAdmRptSred";
string xsdPath = Server.MapPath("~/reports/AdmRptSredReport.xsd");
using (System.IO.StreamWriter writer = new System.IO.StreamWriter(xsdPath))
{
ds.WriteXmlSchema(writer);
writer.Close();
}
}
reportName = reportName + "_" + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
DataView dvItem = GetReportItem(); DataView dvSct = GetReportSct();
foreach (DataRowView drv in dvSct)
{
SetReportSct(dvItem, drv["ReportSctName"].ToString());
}
rp.Refresh();
if (sendToPrinter)
{
rp.PrintOptions.PrinterName = cPrinter.SelectedItem.Value;
rp.PrintOptions.PaperOrientation = PaperOrientation.Portrait;
}
rp.SetDataSource(dt);
cViewer.ReportSource = rp;
if (cViewerWidth.Value != string.Empty)
{
cViewer.Width = Unit.Pixel(int.Parse(cViewerWidth.Value));
}
cViewer.Visible = true;
cViewer.DisplayGroupTree = false;
if (sendToPrinter)
{
rp.PrintToPrinter(1, false, 0, 0);
}
if (eExport == exportTo.TXT)
{
StringBuilder sb = new StringBuilder();
if (dt.Columns.Contains("InMonthEnding"))
{
sb.Append("Month Ending" + (char)9);
}
if (dt.Columns.Contains("InNumMonths"))
{
sb.Append("# of Months" + (char)9);
}
if (dt.Columns.Contains("EmpType"))
{
sb.Append("Employee Type" + (char)9);
}
if (dt.Columns.Contains("MemberName"))
{
sb.Append("Member Name" + (char)9);
}
if (dt.Columns.Contains("Salary"))
{
sb.Append("Salary or Wages" + (char)9);
}
if (dt.Columns.Contains("TxBenefit"))
{
sb.Append("Taxable Benefits" + (char)9);
}
sb.Append(Environment.NewLine);
DataView dv = new DataView(dt);
foreach (DataRowView drv in dv)
{
if (dt.Columns.Contains("InMonthEnding"))
{
sb.Append(drv["InMonthEnding"].ToString() + (char)9);
}
if (dt.Columns.Contains("InNumMonths"))
{
sb.Append(drv["InNumMonths"].ToString() + (char)9);
}
if (dt.Columns.Contains("EmpType"))
{
sb.Append(drv["EmpType"].ToString() + (char)9);
}
if (dt.Columns.Contains("MemberName"))
{
sb.Append(drv["MemberName"].ToString() + (char)9);
}
if (dt.Columns.Contains("Salary"))
{
sb.Append(drv["Salary"].ToString() + (char)9);
}
if (dt.Columns.Contains("TxBenefit"))
{
sb.Append(drv["TxBenefit"].ToString() + (char)9);
}
sb.Append(Environment.NewLine);
}
ExportToStream(null, reportName + ".xls", sb.Replace("\r\n", "\n"), exportTo.TXT);
}
else if (eExport == exportTo.XLS)
{
ExportToStream(rp, reportName + ".xls", null, exportTo.XLS);
}
else if (eExport == exportTo.PDF)
{
ExportToStream(rp, reportName + ".pdf", null, exportTo.PDF);
}
else if (eExport == exportTo.DOC)
{
ExportToStream(rp, reportName + ".doc", null, exportTo.DOC);
}
}
