protected void DownloadTemplate_Click(object sender, DirectEventArgs e)
{
try
{
var serverPath = Server.MapPath("../../../File/Template/importTimeSheetCodeTemplate.xlsx");
DataTable dataTable = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ExcelTimeSheetCode(null));
WorkBook workBook = new WorkBook();
workBook.ImportDataTable(dataTable, true, 0, 0, dataTable.Rows.Count + 1, dataTable.Columns.Count + 1);
workBook.writeXLSX(serverPath);
Response.AddHeader("Content-Disposition", "attachment; filename=" + "importTimeSheetCodeTemplate.xlsx");
if (serverPath != null)
{
Response.WriteFile(serverPath);
}
Response.End();
}
catch (Exception ex)
{
ExtNet.MessageBox.Alert("Có lỗi xảy ra", ex.Message).Show();
}
}