/// <summary>
/// Gets the data update job data
/// </summary>
/// <returns>Excel Spreadsheet</returns>
public bool GetDataUpdateJob()
{
SqlRunner sqlRunner = new SqlRunner();
// create a work book and add the duj data into their own seperate sheets
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (ExcelPackage pck = new ExcelPackage(new FileInfo(dc.Export + ExportName)))
{
pck.Workbook.Worksheets.Add("Status").Cells["A1"].LoadFromDataTable(sqlRunner.RunSQLDataTable("DataUpdateJobStatus"), true, tableStyle).AutoFitColumns();
pck.Workbook.Worksheets.Add("Error Log").Cells["A1"].LoadFromDataTable(sqlRunner.RunSQLDataTable("DataUpdateJobErrorLog"), true, tableStyle).AutoFitColumns();
pck.Workbook.Worksheets.Add("Error Severe").Cells["A1"].LoadFromDataTable(sqlRunner.RunSQLDataTable("DataUpdateJobErrorSevere"), true, tableStyle).AutoFitColumns();
pck.Workbook.Worksheets.Add("Parallel Step").Cells["A1"].LoadFromDataTable(sqlRunner.RunSQLDataTable("DataUpdateJobParallel"), true, tableStyle).AutoFitColumns();
TabColor(pck, "RowCount", wsName: "Status");
TabColor(pck, "RowCount", wsName: "Error Log");
TabColor(pck, "RowCount", wsName: "Error Severe");
TabColor(pck, "RowCount", wsName: "Parallel Step");
pck.Save();
}
if (File.Exists(dc.Export + ExportName))
{
return(true);
}
else
{
return(false);
}
}
public DataTable ReportedYesterday()
{
SqlRunner sqlRunner = new SqlRunner();
return(sqlRunner.RunSQLDataTable("LicenseManagerReportedToday"));
}
public DataTable AdobeImport()
{
SqlRunner sqlRunner = new SqlRunner();
return(sqlRunner.RunSQLDataTable("AdobeImport"));
}
public DataTable Office365Import()
{
SqlRunner sqlRunner = new SqlRunner();
return(sqlRunner.RunSQLDataTable("Office365Import"));
}
public DataTable ReportedToday()
{
SqlRunner sqlRunner = new SqlRunner();
return(sqlRunner.RunSQLDataTable("InventoryReportedToday"));
}