public ActionResult GetPoPi(DateViewModels Data) { DataTable dte = new DataTable(); using (DataReportDataContext db = new DataReportDataContext()) { db.CommandTimeout = 60 * 10; //var q = db.POPI(); //dte = q.ToDataTable(); using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dte, "Sheet1"); wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center; wb.Style.Font.Bold = true; Response.Clear(); Response.Buffer = true; Response.Charset = ""; Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment;filename= PoPi.xlsx"); using (MemoryStream MyMemoryStream = new MemoryStream()) { wb.SaveAs(MyMemoryStream); MyMemoryStream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } } } return(RedirectToAction("Index", "PD")); }
public bool createDate([FromBody] DateViewModels model) { _dateService.addDate(model.Dates, model.BigSelecteId); return(true); }