public ActionResult Read_AvoidCallingTimeFrame([DataSourceRequest] DataSourceRequest request) { if (asset.View) { var data = DC_DetailAvoidCallingTimeFrame.GetAll(); return(Json(data.ToDataSourceResult(request))); } else { return(RedirectToAction("NoAccessRights", "Error")); } }
public ActionResult Export([DataSourceRequest] DataSourceRequest request) { if (asset.Export) { var data = DC_DetailAvoidCallingTimeFrame.GetAll().ToList(); IEnumerable datas = data.ToDataSourceResult(request).Data; //using (ExcelPackage excelPkg = new ExcelPackage()) FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\DC_AvoidCallingTimeCompany.xlsx")); var excelPkg = new ExcelPackage(fileInfo); ExcelWorksheet dataSheet = excelPkg.Workbook.Worksheets["AvoidCallingTimeCompany"]; int rowData = 1; foreach (DC_DetailAvoidCallingTimeFrame item in datas) { int i = 1; rowData++; dataSheet.Cells[rowData, i++].Value = item.Item; dataSheet.Cells[rowData, i++].Value = item.FromHour; dataSheet.Cells[rowData, i++].Value = item.ToHour; dataSheet.Cells[rowData, i++].Value = item.Monday; dataSheet.Cells[rowData, i++].Value = item.Tuesday; dataSheet.Cells[rowData, i++].Value = item.Wednesday; dataSheet.Cells[rowData, i++].Value = item.Thursday; dataSheet.Cells[rowData, i++].Value = item.Friday; dataSheet.Cells[rowData, i++].Value = item.Saturday; dataSheet.Cells[rowData, i++].Value = item.Sunday; dataSheet.Cells[rowData, i++].Value = item.RowCreatedUser; dataSheet.Cells[rowData, i++].Value = item.RowCreatedTime; dataSheet.Cells[rowData, i++].Value = item.RowLastUpdatedUser; dataSheet.Cells[rowData, i++].Value = item.RowLastUpdatedTime; } MemoryStream output = new MemoryStream(); excelPkg.SaveAs(output); string fileName = "DC_AvoidCallingTimeCompany_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"; string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; output.Position = 0; return(File(output.ToArray(), contentType, fileName)); } else { ModelState.AddModelError("", "You don't have permission to export data"); return(File("", //The binary data of the XLS file "application/vnd.ms-excel", //MIME type of Excel files "DC_AvoidCallingTimeCompany_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xls")); //Suggested file name in the "Save as" dialog which will be displayed to the end user } }