public virtual JsonResult ExportExcelMasterfile(List <ColumnModel> gridConfig, QueryInfo queryInfo) { var data = new ExportExcel(); var tempPath = Path.GetTempPath(); var dataBind = MasterFileService.GetDataForGridMasterfile(queryInfo); string jsonTemp = JsonConvert.SerializeObject(dataBind); var dynamicTemp = JsonConvert.DeserializeObject <dynamic>(jsonTemp); string dataTemp = JsonConvert.SerializeObject(dynamicTemp.Data); var dataItem = JsonConvert.DeserializeObject <List <dynamic> >(dataTemp); data.GridConfigViewModel = gridConfig; data.ListDataSource = dataItem; using (var wb = new XLWorkbook()) { string guid = Guid.NewGuid().ToString(); string filePath = Path.Combine(tempPath, guid + ".xlsx"); if (System.IO.File.Exists(filePath)) { System.IO.File.Delete(filePath); } wb.Worksheets.Add(GenDataTableFromExportExcelType(data), typeof(TEntity).Name).ColumnsUsed().AdjustToContents(); wb.SaveAs(filePath); return(Json(new { FileNameResult = guid + ".xlsx", Error = string.Empty }, JsonRequestBehavior.AllowGet)); } //var content = RenderRazorViewToString("~/Views/Shared/Export/_BusinessReportExportContent.cshtml", data); //return Json(new { Item = content, Error = string.Empty }, JsonRequestBehavior.AllowGet); }
public virtual JsonResult GetDataForGridMasterFile(QueryInfo queryInfo) { var queryData = MasterFileService.GetDataForGridMasterfile(queryInfo); var clientsJson = Json(queryData, JsonRequestBehavior.AllowGet); return(clientsJson); }
public virtual IHttpActionResult GetDataForGridMasterFile(QueryInfo queryInfo) { var queryData = MasterFileService.GetDataForGridMasterfile(queryInfo); return(Ok(queryData)); }