/// <summary>
/// ExportExcel File
/// </summary>
/// <returns></returns>
public string ExportExcel()
{
ScheduleTaskCollection collection = ScheduleTaskManager.GetAll(CurrentUser.CompanyID);
DataTable dt = collection.ToDataTable <ScheduleTask>();
string fileName = "ScheduleTask_" + 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, "ScheduleTask List", false);
return(fileName);
}
public virtual DataTable ImportData(DataTable objList)
{
IEnumerable <ScheduleTask> myList = objList.ToList <ScheduleTask>();
ScheduleTaskCollection ErrorList = new ScheduleTaskCollection();
foreach (ScheduleTask objitem in myList)
{
try
{
Save(objitem);
}
catch (Exception objEx)
{
objitem.ErrorMesssage = "<div class='error'>" + objEx.Message + "</div>";
ErrorList.Add(objitem);
}
}
return(ErrorList.ToDataTable <ScheduleTask>());
}