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