Пример #1
0
        public ActionResult Index(RangeReleaseReport model)
        {
            //using (ESKAPEDEContext db = new ESKAPEDEContext())
            //{
            //    var filename = string.Format("{0}{1}-{2}", "ReportSKPD", model.Start.ToShortDateString().ToString().Replace("/", ""), model.From.ToShortDateString().Replace("/", ""));
            //    //GridView grid = new GridView();
            //    //grid.DataSource = db.ReportRequests.ToList();
            //    ////.Where(a => a.TGL_SKPD >= model.Start && a.TGL_SKPD <= model.From).ToList();
            //    //grid.DataBind();

            //    //Response.ClearContent();
            //    //Response.AddHeader("content-disposition", "attachment; filename=" + filename + ".xls");
            //    //Response.ContentType = "application/vnd.ms-excel";

            //    //StringWriter sw = new StringWriter();
            //    //HtmlTextWriter htw = new HtmlTextWriter(sw);
            //    //// Render the grid contents => the writer objects => Response object
            //    //grd.RenderControl(htw);
            //    //Response.Write(sw.ToString());

            //    //Response.End();
            //    //return View("Index");
            //    //Create a response stream to create and write the Excel file
            //    GridView grid = new GridView();
            //    grid.DataSource = db.ReportRequests.ToList();
            //    grid.DataBind();
            //    System.Web.HttpContext curContext = System.Web.HttpContext.Current;
            //    curContext.Response.Clear();
            //    curContext.Response.AddHeader("content-disposition", "attachment;filename=" + filename);
            //    curContext.Response.Charset = "";
            //    curContext.Response.Cache.SetCacheability(HttpCacheability.NoCache);
            //    Response.ContentType = "application/excel";

            //    //Convert the rendering of the gridview to a string representation
            //    StringWriter sw = new StringWriter();
            //    HtmlTextWriter htw = new HtmlTextWriter(sw);
            //    grid.RenderControl(htw);

            //    //Open a memory stream that you can use to write back to the response
            //    byte[] byteArray = Encoding.ASCII.GetBytes(sw.ToString());
            //    MemoryStream s = new MemoryStream(byteArray);
            //    StreamReader sr = new StreamReader(s, Encoding.ASCII);

            //    //Write the stream back to the response
            //    curContext.Response.Write(sr.ReadToEnd());
            //    curContext.Response.End();
            //    return View("Index");
            //}
            //var filename = string.Format("{0}{1}-{2}.pdf", "ReportSKPD", model.Start.ToShortDateString().ToString().Replace("/", ""), model.From.ToShortDateString().Replace("/", ""));
            //IEnumerable<ReportRequest> rr = db.ReportRequests;

            //if (rr == null)
            //{
            //    return RedirectToAction("PerjadinNotRelease");
            //}
            //else
            //{
            //    MemoryStream memory = new MemoryStream();
            //    var PrintPageUrl = ConfigurationManager.AppSettings["Report"];
            //    var PrintReportUrl = string.Format("{0}?start={1}&end={2}", PrintPageUrl, model.Start.Ticks, model.From.Ticks);
            //    PdfDocument document = new PdfDocument() { Url = PrintReportUrl };
            //    PdfOutput output = new PdfOutput() { OutputStream = memory };

            //    PdfConvert.ConvertHtmlToPdf(document, output);
            //    memory.Position = 0;

            //    return File(memory, "application/pdf", Server.UrlEncode(filename));
            //}
            //var contacts = db.RequestReleases;
            //var grid = new System.Web.UI.WebControls.GridView();

            //grid.DataSource = contacts.ToList();
            //grid.DataBind();

            //Response.ClearContent();
            //Response.AddHeader("content-disposition", "attachment; filename=YourFileName.xls");
            //Response.ContentType = "application/excel";
            //StringWriter sw = new StringWriter();
            //HtmlTextWriter htw = new HtmlTextWriter(sw);
            //grid.RenderControl(htw);
            //Response.Write(sw.ToString());
            //Response.End();
            //return View("Index");

            //Create a workbook
            using (ExcelPackage pck = new ExcelPackage())
            {
                var filename = string.Format("{0}{1}-{2}", "ReportSKPD", model.Start.ToShortDateString().ToString().Replace("/", ""), model.From.ToShortDateString().Replace("/", ""));
                Int64 start = model.Start.Ticks;
                Int64 end = model.From.Ticks;
                DateTime DTstart = new DateTime(start);
                DateTime DTend = new DateTime(end);
                var contacts = db.ReportRequests.Where(a => a.TGL_SKPD >= DTstart && a.TGL_SKPD <= DTend);
                if (contacts.Count() != 0)
                {
                    var grid = new System.Web.UI.WebControls.GridView();
                    System.Data.DataTable dt = new System.Data.DataTable();
                    grid.DataSource = contacts.ToList();
                    grid.DataBind();

                    if (grid.HeaderRow != null)
                    {

                        for (int i = 0; i < grid.HeaderRow.Cells.Count; i++)
                        {
                            dt.Columns.Add(grid.HeaderRow.Cells[i].Text);
                        }
                    }

                    //  add each of the data rows to the table
                    foreach (GridViewRow row in grid.Rows)
                    {
                        DataRow dr;
                        dr = dt.NewRow();

                        for (int i = 0; i < row.Cells.Count; i++)
                        {
                            dr[i] = row.Cells[i].Text;//.Replace(" ", "");
                        }
                        dt.Rows.Add(dr);
                    }

                    //Create the worksheet
                    ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Report");

                    //Load the datatable into the sheet, starting from cell A1. Print the column names on row 1
                    ws.Cells["A1"].LoadFromDataTable(dt, true);

                    //Format the header for column 1-3
                    //using (ExcelRange rng = ws.Cells["A1:C1"])
                    //{
                    //    rng.Style.Font.Bold = true;
                    //    rng.Style.Fill.PatternType = ExcelFillStyle.Solid;                      //Set Pattern for the background to Solid
                    //    rng.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(79, 129, 189));  //Set color to dark blue
                    //    rng.Style.Font.Color.SetColor(Color.White);
                    //}

                    //Example how to Format Column 1 as numeric
                    //using (ExcelRange col = ws.Cells[2, 1, 2 + dt.Rows.Count, 1])
                    //{
                    //    col.Style.Numberformat.Format = "#,##0.00";
                    //    col.Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
                    //}

                    //Write it back to the client
                    Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                    Response.AddHeader("content-disposition", "attachment;  filename=" + filename);
                    Response.BinaryWrite(pck.GetAsByteArray());
                    return View("Index");
                }
                else
                {
                    return View("Index");
                }
            }
        }
Пример #2
0
        public ActionResult PrintReport(RangeReleaseReport model)
        {
            var filename = string.Format("{0}{1}-{2}.pdf", "ReportSKPD", model.Start.ToShortDateString().ToString().Replace("/", ""), model.From.ToShortDateString().Replace("/", ""));
            IEnumerable<ReportRequest> rr = db.ReportRequests;

            if (rr == null)
            {
                return RedirectToAction("PerjadinNotRelease");
            }
            else
            {
                MemoryStream memory = new MemoryStream();
                var PrintPageUrl = ConfigurationManager.AppSettings["Report"];
                var PrintReportUrl = string.Format("{0}?start={1}&end={2}", PrintPageUrl, model.Start.ToShortDateString().ToString(), model.From.ToShortDateString().ToString());
                PdfDocument document = new PdfDocument() { Url = PrintReportUrl };
                PdfOutput output = new PdfOutput() { OutputStream = memory };

                PdfConvert.ConvertHtmlToPdf(document, output);
                memory.Position = 0;

                return File(memory, "application/pdf", Server.UrlEncode(filename));
            }
        }