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