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