/// <summary>
/// ExportExcel File
/// </summary>
/// <returns></returns>
public string ExportExcel()
{
SettingCollection collection = SettingManager.GetAll(CurrentUser.CompanyID);
DataTable dt = collection.ToDataTable <Setting>();
string fileName = "Setting_" + 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, "Setting List", false);
return(fileName);
}