/// <summary>
/// ExportExcel File
/// </summary>
/// <returns></returns>
public string ExportExcel()
{
T_LMS_Master_AnnualLeaveCollection collection = T_LMS_Master_AnnualLeaveManager.GetAll();
DataTable dt = collection.ToDataTable <T_LMS_Master_AnnualLeave>();
string fileName = "T_LMS_Master_AnnualLeave_" + SystemConfig.CurrentDate.ToString("MM-dd-yyyy");
string[] RemoveColumn = { "CompanyID", "TargetDisplayID", "ReturnDisplay", "TotalRecord", "CreatedUser", "CreatedDate" };
for (int i = 0; i < RemoveColumn.Length; i++)
{
if (dt.Columns.Contains(RemoveColumn[i]))
{
dt.Columns.Remove(RemoveColumn[i]);
}
}
FileInputHelper.ExportExcel(dt, fileName, "T_LMS_Master_AnnualLeave List", false);
return(fileName);
}