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 string SRSImportDate()
{
SqlRunner sqlRunner = new SqlRunner();
return(sqlRunner.RunSQLString("SRSUpdateDate"));
}