public List <AgentDataModel> GetAgentsFromDatabase()
{
List <AgentDataModel> agentList = new List <AgentDataModel>();
try
{
_myConnection.Open();
SqlCommand getAgents = new SqlCommand("getAgents", _myConnection);
getAgents.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader myAgentsSet = getAgents.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.Add(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);
}
public AgentDataModel(int agentNr, String name, String iPAddress, TypeDataModel type, int port, int status, string sysDesc, string sysName, string sysUptime)
{
_agentNr = agentNr;
_name = name;
_iPAddress = iPAddress;
_type = type;
_port = port;
_status = status;
_sysDesc = sysDesc;
_sysName = sysName;
_sysUptime = sysUptime;
}
public AgentDataModel(String name, String iPAddress, TypeDataModel type, int port)
{
_agentNr = 0;
_name = name;
_iPAddress = iPAddress;
_type = type;
_port = port;
_status = 1;
_sysDesc = "";
_sysName = "";
_sysUptime = "";
}