Exemple #1
0
        // This method will create txt report file and inserts into portfolio reports.....
        public static void GenerateTextReport(Schedule report)
        {
            DataSet tables = ExtecuteReport(report);

            if (tables.Tables[0].Rows.Count >= 1 || report.StoredProcedureName.Contains("spSelectDepartmentalBreakdownreportLevel"))
            {
                TextWriter twWriter = new StreamWriter("c:\\temp\\" + report.Selectedname + report.ReportName + DateTime.Now.ToString("ddMMyy") + "-" + report.ID + ".txt");

                try
                {
                    twWriter.WriteLine();
                    twWriter.Write("Report: " + " " + report.ReportName);
                    twWriter.WriteLine();
                    twWriter.Write("Schedule Name:" + " " + report.Selectedname);
                    twWriter.WriteLine();
                    twWriter.Write("Date range:" + " " + report.ListofFilters.Split('=', ',')[5].TrimStart('\'').TrimEnd('\'') + " TO " + report.ListofFilters.Split('=', ',')[7].TrimStart('\'').TrimEnd('\''));
                    twWriter.WriteLine();
                    twWriter.WriteLine();
                    if (report.StoredProcedureName.Contains("spSelectDepartmentalBreakdownreportLevel"))
                    {
                        // TextReports.GenerateTXTData(twWriter, " " + '\t', tables.Tables[0], GetColumns(report.Columns), Listoftotals(report.Totals));
                        TextReports.Departmentalreport(twWriter, " " + '\t', tables, GetColumns(report.Columns), report.ListofFilters.Split('=', ',')[93], GetLevels(tables), Listoftotals(report.Totals));
                    }
                    else
                    {
                        if (tables.Tables.Count >= 3)
                        {
                            foreach (DataTable dt in tables.Tables)
                            {
                                List <string> columns = new List <string>();
                                foreach (DataColumn dc in dt.Columns)
                                {
                                    columns.Add(dc.ColumnName);
                                }
                                TextReports.GenerateTXTData(twWriter, " " + '\t', dt, columns, Listoftotals(report.Totals));
                                twWriter.WriteLine();
                            }
                        }
                        else
                        {
                            TextReports.GenerateTXTData(twWriter, " " + '\t', tables.Tables[0], GetColumns(report.Columns), Listoftotals(report.Totals));
                        }
                    }
                    SendEmail.InsertPortfoliodetails("c:\\temp\\" + report.Selectedname + report.ReportName + DateTime.Now.ToString("ddMMyy") + "-" + report.ID + ".txt", report.EmailAddresses, report.Portfolioreportid, report.ID);
                }
                catch { ReportStatus(report.ID, "ERROR"); }

                finally { twWriter.Close(); }
            }
            else
            {
                ReportStatus(report.ID, "No Data");
            }
        }
Exemple #2
0
        // This method will create CSV report file and inserts into portfolio reports.....
        public static void GenerateCSVReport(Schedule report)
        {
            DataSet tables = ExtecuteReport(report);

            if (tables.Tables[0].Rows.Count >= 1)
            {
                TextWriter twWriter = new StreamWriter("c:\\temp\\" + report.Selectedname + "-" + report.ReportName + DateTime.Now.ToString("ddMMyy") + "-" + report.ID + ".csv", false, Encoding.UTF8);

                try
                {
                    twWriter.WriteLine();
                    twWriter.Write(report.ReportName);
                    twWriter.WriteLine();
                    twWriter.WriteLine();
                    twWriter.Write("Schedule Name:" + " " + report.Selectedname);
                    twWriter.WriteLine();
                    twWriter.WriteLine();
                    twWriter.Write("Date range:" + " " + report.ListofFilters.Split('=', ',')[5].TrimStart('\'').TrimEnd('\'') + " TO " + report.ListofFilters.Split('=', ',')[7].TrimStart('\'').TrimEnd('\''));
                    twWriter.WriteLine();
                    twWriter.WriteLine();
                    if (report.StoredProcedureName == "spSelectDepartmentalBreakdownreportLevel")
                    {
                        //TextReports.GenerateTXTData(twWriter, ",", tables.Tables[0], GetColumns(report.Columns), Listoftotals(report.Totals));
                        TextReports.Departmentalreport(twWriter, ",", tables, GetColumns(report.Columns), report.ListofFilters.Split('=', ',')[93], GetLevels(tables), Listoftotals(report.Totals));
                    }
                    else
                    {
                        if (tables.Tables.Count >= 3)
                        {
                            int i = 0;
                            foreach (DataTable dt in tables.Tables)
                            {
                                List <string> columns = new List <string>();
                                foreach (DataColumn dc in dt.Columns)
                                {
                                    columns.Add(dc.ColumnName);
                                }
                                twWriter.Write(report.Columns.Split(',')[i]);
                                TextReports.GenerateTXTData(twWriter, ",", dt, columns, Listoftotals(report.Totals));
                                twWriter.WriteLine();
                                i++;
                            }
                        }
                        else
                        {
                            TextReports.GenerateTXTData(twWriter, ",", tables.Tables[0], GetColumns(report.Columns), Listoftotals(report.Totals));
                        }
                    }

                    if (report.GraphBindings != string.Empty)
                    {
                        List <string> pics  = new List <string>();
                        int           repid = 0;
                        foreach (string graph in report.GraphBindings.Split('-'))
                        {
                            GraphicalReport.GenerateGraph("Z:\\inetpub\\wwwroot\\proimages\\" + report.Selectedname + "-" + report.ReportName + DateTime.Now.ToString("ddMMyy") + repid.ToString() + "-" + report.ID + ".png", tables.Tables[0], graph, report.ReportName, report.Selectedname + "-" + report.ReportName + DateTime.Now.ToString("ddMMyy") + repid.ToString() + "-" + report.ID + ".png", report.GraphType);
                            pics.Add("Z:\\inetpub\\wwwroot\\proimages\\" + report.Selectedname + "-" + report.ReportName + DateTime.Now.ToString("ddMMyy") + repid.ToString() + "-" + report.ID + ".png");
                            repid++;
                        }
                        GraphicalReport.CreateGraphsinExcel(pics, "c:\\temp\\" + report.Selectedname + "-" + report.ReportName + DateTime.Now.ToString("ddMMyy") + "-" + report.ID + ".xls", report.ReportName);
                        SendEmail.InsertPortfoliodetails("c:\\temp\\" + report.Selectedname + "-" + report.ReportName + DateTime.Now.ToString("ddMMyy") + "-" + report.ID + ".xls", report.EmailAddresses, report.Portfolioreportid, report.ID);
                    }
                    SendEmail.InsertPortfoliodetails("c:\\temp\\" + report.Selectedname + "-" + report.ReportName + DateTime.Now.ToString("ddMMyy") + "-" + report.ID + ".csv", report.EmailAddresses, report.Portfolioreportid, report.ID);
                }
                catch { ReportStatus(report.ID, "ERROR"); }

                finally { twWriter.Close(); }
            }
            else
            {
                ReportStatus(report.ID, "No Data");
            }
        }