public void UpdateAgentInDatabase(AgentDataModel agent, bool cpuCheck, bool discCheck) { try { _myConnection.Open(); SqlCommand saveAgentCommand = new SqlCommand("updateAgent", _myConnection); saveAgentCommand.CommandType = System.Data.CommandType.StoredProcedure; saveAgentCommand.Parameters.Add(new SqlParameter("@AgentNr", agent.AgentNr)); saveAgentCommand.Parameters.Add(new SqlParameter("@Name", agent.Name)); saveAgentCommand.Parameters.Add(new SqlParameter("@IPAddress", agent.IPAddress)); saveAgentCommand.Parameters.Add(new SqlParameter("@Port", agent.Port)); saveAgentCommand.Parameters.Add(new SqlParameter("@TypeNr", agent.Type.TypeNr)); saveAgentCommand.Parameters.Add(new SqlParameter("@CPUCheck", cpuCheck)); saveAgentCommand.Parameters.Add(new SqlParameter("@DiscCheck", discCheck)); saveAgentCommand.ExecuteNonQuery(); } finally { _myConnection.Close(); } }
public AgentDataModel GetAgentFromDatabase(int agentNr) { AgentDataModel agentList = null; try { _myConnection.Open(); SqlCommand getAgent = new SqlCommand("getAgent", _myConnection); getAgent.CommandType = System.Data.CommandType.StoredProcedure; getAgent.Parameters.Add(new SqlParameter("@AgentNr", agentNr)); SqlDataReader myAgentsSet = getAgent.ExecuteReader(); List <TypeDataModel> typeSet = new DatabaseConnectionMonitor(Properties.Settings.Default.ProdDatabase).GetTypesFromDatabase(); while (myAgentsSet.Read()) { TypeDataModel type = null; int tempTypeNr = (int)myAgentsSet["TypeNr"]; foreach (TypeDataModel temp in typeSet) { if (temp.TypeNr == tempTypeNr) { type = temp; } } agentList = new AgentDataModel((int)myAgentsSet["AgentNr"], myAgentsSet["Name"].ToString(), myAgentsSet["IPAddress"].ToString(), type, (int)myAgentsSet["Port"], (int)myAgentsSet["Status"], myAgentsSet["sysDesc"].ToString(), myAgentsSet["sysName"].ToString(), myAgentsSet["sysUptime"].ToString()); } } finally { _myConnection.Close(); } return(agentList); }