public ActionResult _ComplianceDepartmentExcel([DataSourceRequest] DataSourceRequest request, Search search)
{
var dcaService = new TracerComplianceDepartment();
DataSourceResult result = dcaService._complianceDepartmentExcel(request, search);
JsonResult jr = new JsonResult();
jr = Json(result, JsonRequestBehavior.AllowGet);
jr.MaxJsonLength = Int32.MaxValue;
jr.RecursionLimit = 100;
return(jr);
}
public ActionResult LoadComplianceDepartmentGrid(Search search)
{
var tcService = new TracerComplianceDepartment();
DataTable tPivotTable = new DataTable();
tPivotTable = tcService.DynamicGroupByDepartmentColumns(search);
try
{
string JSONString = string.Empty;
JsonResult jr = new JsonResult();
JSONString = JsonConvert.SerializeObject(tPivotTable);
var _result = new
{
outputData = JSONString,
ExceedFlag = tcService.ExceedLimit,
RecordStatus = tcService.RecordStatus,
OutputDepartmentList = tcService.OutputDepartmentIds
};
jr = Json(_result, JsonRequestBehavior.AllowGet);
jr.MaxJsonLength = Int32.MaxValue;
jr.RecursionLimit = 100;
return(jr);
}
catch (Exception ex)
{
ExceptionLog exceptionLog = new ExceptionLog
{
ExceptionText = "Reports: " + ex.Message,
PageName = "_ComplianceDepartmentChart",
MethodName = "LoadComplianceDepartmentGrid",
UserID = Convert.ToInt32(AppSession.UserID),
SiteId = Convert.ToInt32(AppSession.SelectedSiteId),
TransSQL = "",
HttpReferrer = null
};
exceptionService.LogException(exceptionLog);
return(RedirectToAction("Error", "Transfer"));
}
}