public void SaveStatusToReport()
{
try
{
logger.Debug("------|Start To Save Status To Report File");
string SuiteName = Path.GetFileName(InitializeParamter.DataDriverFile);
string CaseName = BusinessFlows.CaseName;
string StartTime = BusinessFlows.StartTime;
DataTable report = new DataTable();
report = DataTableUtility.GetDataTable();
report.Rows.Add(SuiteName, CaseName, status,
StartTime, EndTime, ElapsedTime, errorMessage, ScreenShotUtility.finalImageFile);
FileInfo newFile = new FileInfo(InitializeParamter.ReportFile);
using (ExcelPackage pck = new ExcelPackage(newFile))
{
var sheetQuery = from sheet in pck.Workbook.Worksheets
where sheet.Name == InitializeParamter.RunDay
select sheet;
if (sheetQuery.Count() == 0)
{
ExcelWorksheet ws = pck.Workbook.Worksheets.Add(InitializeParamter.RunDay);
ws.Cells["A1"].LoadFromDataTable(report, true);
pck.Save();
}
else
{
sheetQuery.First().Cells["A1"].
LoadFromDataTable(report, true);
pck.Save();
}
}
}
catch (Exception e)
{
logger.Fatal("Fail To Save Status To Report");
logger.Fatal(e.Message);
}
}
