public void TestAddAndDeleteAgentFromDatabase()
{
List <AgentDataModel> agentsBeforeAdd = databaseConnection.GetAgentsFromDatabase();
AgentDataModel newAgent = new AgentDataModel("Test-Server", "10.10.10.10", new TypeDataModel(1, "Server"), 161);
databaseConnection.AddAgentToDatabase(newAgent, false, false);
List <AgentDataModel> agentsAfterAdd = databaseConnection.GetAgentsFromDatabase();
Assert.AreEqual(agentsBeforeAdd.Count + 1, agentsAfterAdd.Count);
// Check old Agents
int i;
for (i = 0; i < agentsBeforeAdd.Count; i++)
{
Assert.AreEqual(agentsBeforeAdd[i].AgentNr, agentsAfterAdd[i].AgentNr);
Assert.AreEqual(agentsBeforeAdd[i].Name, agentsAfterAdd[i].Name);
Assert.AreEqual(agentsBeforeAdd[i].IPAddress, agentsAfterAdd[i].IPAddress);
Assert.AreEqual(agentsBeforeAdd[i].Type.TypeNr, agentsAfterAdd[i].Type.TypeNr);
Assert.AreEqual(agentsBeforeAdd[i].Port, agentsAfterAdd[i].Port);
Assert.AreEqual(agentsBeforeAdd[i].Status, agentsAfterAdd[i].Status);
Assert.AreEqual(agentsBeforeAdd[i].SysDescription, agentsAfterAdd[i].SysDescription);
Assert.AreEqual(agentsBeforeAdd[i].SysName, agentsAfterAdd[i].SysName);
Assert.AreEqual(agentsBeforeAdd[i].SysUptime, agentsAfterAdd[i].SysUptime);
}
// Check new Agent
Assert.AreEqual(newAgent.Name, agentsAfterAdd[i].Name);
Assert.AreEqual(newAgent.IPAddress, agentsAfterAdd[i].IPAddress);
Assert.AreEqual(newAgent.Type.TypeNr, agentsAfterAdd[i].Type.TypeNr);
Assert.AreEqual(newAgent.Port, agentsAfterAdd[i].Port);
Assert.AreEqual(newAgent.Status, agentsAfterAdd[i].Status);
// Delete new Agent
databaseConnection.DeleteAgentInDatabase(agentsAfterAdd[i].AgentNr);
List <AgentDataModel> agentsAfterDelete = databaseConnection.GetAgentsFromDatabase();
Assert.AreEqual(agentsAfterDelete.Count, agentsBeforeAdd.Count);
}
public void DeleteAgent(int agentNr)
{
try
{
_databaseConnection.DeleteAgentInDatabase(agentNr);
}
catch (SqlException e)
{
ExceptionCore.HandleException(ExceptionCategory.Fatal, e);
}
catch (Exception e)
{
ExceptionCore.HandleException(ExceptionCategory.Normal, e);
}
}