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));
}
