Exemple #1
0
 public ActionResult SalesOfEachQuarter(DateTime?date)
 {
     if (date.GetValueOrDefault().Month == 0)
     {
         ModelState.AddModelError("", "You must input month !!!");
     }
     else
     {
         ListReports list = new ListReports();
         Session["date"] = date;
         var model = list.SalesOfEachQuarter(date.GetValueOrDefault());
         ViewBag.Date = list.FirstDayOfQuarter(date.GetValueOrDefault()) + " - " + list.LastDayOfQuarter(date.GetValueOrDefault());
         return(View(model));
     }
     return(View());
 }
Exemple #2
0
        public FileResult ExportSalesOfEachQuarter()
        {
            DataTable dt = new DataTable("Grid");

            dt.Columns.AddRange(new DataColumn[5] {
                new DataColumn("Key"),
                new DataColumn("Amount $"),
                new DataColumn("Min $"),
                new DataColumn("Max $"),
                new DataColumn("AVG $")
            });

            try
            {
                if (Session["date"].ToString() != "")
                {
                    ListReports list = new ListReports();
                    DateTime    date = (DateTime)Session["date"];

                    var model1 = list.SalesOfEachQuarter(date);

                    foreach (var rp in model1)
                    {
                        dt.Rows.Add(rp.Id, rp.Amount, rp.Min, rp.Max, rp.AVG);
                    }

                    using (XLWorkbook wb = new XLWorkbook())
                    {
                        wb.Worksheets.Add(dt);
                        using (MemoryStream stream = new MemoryStream())
                        {
                            wb.SaveAs(stream);
                            return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
                                        "SalesOfEachQuarter from " + list.FirstDayOfQuarter(date) + " to " + list.LastDayOfQuarter(date) + " - " + DateTime.Now + ".xlsx"));
                        }
                    }
                }

                var model = new ListReports().SalesOfEachQuarter();

                foreach (var rp in model)
                {
                    dt.Rows.Add(rp.Id, rp.Amount, rp.Min, rp.Max, rp.AVG);
                }

                using (XLWorkbook wb = new XLWorkbook())
                {
                    wb.Worksheets.Add(dt);
                    using (MemoryStream stream = new MemoryStream())
                    {
                        wb.SaveAs(stream);
                        return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "SalesOfEachQuarter - " + DateTime.Now + ".xlsx"));
                    }
                }
            }
            catch (Exception)
            {
                var model = new ListReports().SalesOfEachQuarter();

                foreach (var rp in model)
                {
                    dt.Rows.Add(rp.Id, rp.Amount, rp.Min, rp.Max, rp.AVG);
                }

                using (XLWorkbook wb = new XLWorkbook())
                {
                    wb.Worksheets.Add(dt);
                    using (MemoryStream stream = new MemoryStream())
                    {
                        wb.SaveAs(stream);
                        return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "SalesOfEachQuarter - " + DateTime.Now + ".xlsx"));
                    }
                }
            }
        }