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); }