public bool UpdateServiceCollection(ServerTypes ServerType, string NodeName)
{
try
{
VSFramework.VSAdaptor adapter = new VSFramework.VSAdaptor();
string sql = "Select * from NodeDetails where NodeId=(Select ID from Nodes where Name='" + NodeName + "') and Name='" + ServerType.ToString().Replace("_", " ") + " - UpdateCollection' and Value=1";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
adapter.FillDatasetAny("VitalSigns", "VitalSigns", sql, ref ds, "NodeDetails");
dt = ds.Tables["NodeDetails"];
if (dt.Rows.Count > 0)
{
string Names = String.Join(",", dt.AsEnumerable().Select(r => r.Field <string>("Name").ToString()));
string IDs = String.Join(",", dt.AsEnumerable().Select(r => r.Field <Int32>("ID").ToString()));
WriteHistoryEntry("ID " + IDs + " AND Names " + Names + " have been marked for resetCollection. Resetting value to False now...");
sql = "UPDATE NodeDetails set Value=0 where ID in (" + IDs + ")";
adapter.ExecuteNonQueryAny("VitalSigns", "VitalSigns", sql);
WriteHistoryEntry("ID " + IDs + " have been reset. Leaving function");
return(true);
}
return(false);
}
catch (Exception ex)
{
WriteHistoryEntry("Error in UpdateServiceCollection. Error: " + ex.Message);
}
return(true);
}
public bool RegisterServer(int sid, string ip, int port, string name, ServerTypes type)
{
Logging.Debug(string.Format(" {0} {1} {2} {3}", sid.ToString().PadLeft(3), type.ToString().PadLeft(5), ip.PadRight(16), name));
var server = Worker.Singleton.Serverlist.RemoveAll(s => s.SID == sid);
Worker.Singleton.Serverlist.Add(new Serverinformation()
{
ip = Helper.IpToLong(ip), port = port, type = type, name = name, count = 0, SID = sid
});
return(true);
}
