public ActionResult Report(DailyItemizedSalesReportDetailPushDataModels model) { model.FilterType = (int)Commons.EFilterType.OnDay; if (model.EndTime.Hours == 0 && model.EndTime.Minutes == 0) { model.EndTime = new TimeSpan(23, 59, 59); if (model.StartTime.Hours == 0 && model.StartTime.Minutes == 0) { model.FilterType = (int)Commons.EFilterType.None; } } else if (model.StartTime > model.EndTime) { model.FilterType = (int)Commons.EFilterType.Days; } DateTime dFrom = new DateTime(model.FromDate.Year, model.FromDate.Month, model.FromDate.Day, model.StartTime.Hours, model.StartTime.Minutes, 0) , dTo = new DateTime(model.ToDate.Year, model.ToDate.Month, model.ToDate.Day, model.EndTime.Hours, model.EndTime.Minutes, 0); if (dFrom >= dTo) { ModelState.AddModelError("FromDate", CurrentUser.GetLanguageTextFromKey("From Date must be less than To Date.")); } else { dTo = dTo.AddSeconds(59); } if (model.Type == Commons.TypeCompanySelected) //Company { if (model.ListCompanys == null) { ModelState.AddModelError("ListCompanys", CurrentUser.GetLanguageTextFromKey("Please choose company.")); } } else //Store { if (model.ListStores == null) { ModelState.AddModelError("ListStores", CurrentUser.GetLanguageTextFromKey("Please choose store.")); } } if (!ModelState.IsValid) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(View("Index", model)); } //Get Selected Store List <StoreModels> lstStores = new List <StoreModels>(); ////if (model.Type == Commons.TypeCompanySelected) //Company ////{ //// lstStores = model.GetSelectedStoreCompany(); //// model.ListStores = lstStores.Select(ss => ss.Id).ToList(); ////} ////else //Store ////{ //// List<SelectListItem> vbStore = ViewBag.Stores; //// lstStores = model.GetSelectedStore(vbStore); ////} ///////======= Updated 072018 if (model.Type == Commons.TypeCompanySelected) //Company { lstStores = listStoresInfoSession.Where(ww => model.ListCompanys.Contains(ww.CompanyId)).ToList(); model.ListStores = lstStores.Select(ss => ss.Id).ToList(); } else //Store { lstStores = listStoresInfoSession.Where(ww => model.ListStores.Contains(ww.Id)).ToList(); } model.FromDate = new DateTime(model.FromDate.Year, model.FromDate.Month, model.FromDate.Day, 0, 0, 0); model.ToDate = new DateTime(model.ToDate.Year, model.ToDate.Month, model.ToDate.Day, 23, 59, 59); model.FromDateFilter = dFrom; model.ToDateFilter = dTo; //Export excel DailyItemizedSalesReportDetailFactory factory = new DailyItemizedSalesReportDetailFactory(); XLWorkbook wb = new XLWorkbook(); #region Report old DB wb = factory.ExportExcel_WithFilterTime(model, lstStores); #endregion #region Report New DB //wb = factory.ExportExcel_NewDB(model, lstStores); #endregion ViewBag.wb = wb; string sheetName = string.Format("Daily_Detail_Itemized_Sales_Analysis_Report_{0}", DateTime.Now.ToString("MMddyyyy")).Replace(" ", "_"); Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.Charset = System.Text.UTF8Encoding.UTF8.WebName; Response.ContentEncoding = System.Text.UTF8Encoding.UTF8; if (model.FormatExport.Equals(Commons.Html)) { Response.AddHeader("content-disposition", String.Format(@"attachment;filename={0}.html", sheetName)); } else { Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", String.Format(@"attachment;filename={0}.xlsx", sheetName)); } using (var memoryStream = new MemoryStream()) { wb.SaveAs(memoryStream); if (model.FormatExport.Equals(Commons.Html)) { Workbook workbook = new Workbook(); workbook.LoadFromStream(memoryStream); //convert Excel to HTML Worksheet sheet = workbook.Worksheets[0]; using (var ms = new MemoryStream()) { sheet.SaveToHtml(ms); ms.WriteTo(HttpContext.Response.OutputStream); ms.Close(); } } else { memoryStream.WriteTo(HttpContext.Response.OutputStream); } memoryStream.Close(); } HttpContext.Response.End(); return(View("Index", model)); }
public ActionResult Index() { DailyItemizedSalesReportDetailPushDataModels model = new DailyItemizedSalesReportDetailPushDataModels(); return(View(model)); }