public ActionResult _ExportExcel(SearchInsuranceContract input)
{
using (XLWorkbook wb = new XLWorkbook())
{
var result = new ListInsuranceContractDetailViewModel();
result = _insuranceContractService.searchInsuranceContract(input);
var data = result.resultList;
if (data.Any())
{
wb.Worksheets.Add(MapToTable(data), "Hợp đồng Bảo hiểm");
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", $"attachment;filename={DateTime.Now:yyyyMMdd}_InsuranceContractTemplate.xlsx");
using (MemoryStream myMemoryStream = new MemoryStream())
{
wb.SaveAs(myMemoryStream);
myMemoryStream.WriteTo(Response.OutputStream);
Response.End();
return(Content("Thành công"));
}
}
return(Content("Không có dữ liệu"));
}
}
public JsonResult searchInsuranceContractInau(SearchInsuranceContract input)
{
var result = new ListInsuranceContractDetailViewModel();
input.userId = RDAuthorize.UserId;
if (input._processStatusList != null)
{
input.processStatusList = JsonConvert.SerializeObject(input._processStatusList);
}
else
{
input.processStatusList = "";
}
result = _insuranceContractService.searchInsuranceContractInau(input);
return(Json(new
{
data = result.resultList,
recordsTotal = result.TotalRecord,
recordsFiltered = result.TotalRecord,
}));
}
