/// <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 IsUpdateRequired()
{
XmlDocument doc = new XmlDocument();
DataTable dt = new DataTable();
SqlRunner sql = new SqlRunner();
var o = GetDataFromAPI().Content;
doc.LoadXml(o);
dt.Columns.Add("Type");
dt.Columns.Add("Current Version");
dt.Columns.Add("Latest Version");
dt.Columns.Add("Update Required");
foreach (XmlNode appNode in doc.DocumentElement.ChildNodes)
{
if (appNode.InnerText.Contains("Snow License Manager 9"))
{
foreach (XmlNode versionNode in appNode.ChildNodes)
{
if (versionNode.Name == "Version")
{
DataRow dr = dt.NewRow();
string SVRLicenseManagerVersion = sql.RunSQLString("LicenseManagerVersion");
dr["Type"] = "Snow License Manager";
dr["Current Version"] = SVRLicenseManagerVersion;
dr["Latest Version"] = versionNode.InnerText;
dr["Update Required"] = VersionCheck(SVRLicenseManagerVersion, versionNode.InnerText);
dt.Rows.Add(dr);
}
}
}
if (appNode.InnerText.Contains("Snow Inventory Server 6"))
{
foreach (XmlNode versionNode in appNode.ChildNodes)
{
if (versionNode.Name == "Version")
{
DataRow dr = dt.NewRow();
string SVRInventoryServerVersion = sql.RunSQLString("InventoryServerVersion");
dr["Type"] = "Snow Inventory Server";
dr["Current Version"] = SVRInventoryServerVersion;
dr["Latest Version"] = versionNode.InnerText;
dr["Update Required"] = VersionCheck(SVRInventoryServerVersion, versionNode.InnerText);
dt.Rows.Add(dr);
}
}
}
}
return(dt);
}
public DataTable ReportedYesterday()
{
SqlRunner sqlRunner = new SqlRunner();
return(sqlRunner.RunSQLDataTable("LicenseManagerReportedToday"));
}
public string SRSImportDate()
{
SqlRunner sqlRunner = new SqlRunner();
return(sqlRunner.RunSQLString("SRSUpdateDate"));
}
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"));
}