public static List <string> FetchServerBasedOnProbeTypes(string ProbeType) { try { SQLiteConnection m_dbConnection; List <string> lstServerResults = new List <string>(); ProbeDetails objProbeDetails = new ProbeDetails(); //DB Details m_dbConnection = new SQLiteConnection(@"Data Source=" + ConfigurationManager.AppSettings["LocalDB_DS"] + ";Version=3;"); m_dbConnection.Open(); string sql = ""; sql = @"select distinct Hostname from Diagnostics_MasterData where probetype='" + ProbeType + "'"; SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { lstServerResults.Add(reader["Hostname"].ToString()); //Console.WriteLine("Id: " + reader["Id"] + "\tProbeGroup: " + reader["ProbeGroup"] + "\tProbeName: " + reader["ProbeName"] + "\tHostName: " + reader["HostName"]); } reader.Close(); m_dbConnection.Close(); return(lstServerResults); } catch (Exception) { throw; } }
public static List <ProbeDetails> SelectData(string ServerName) { try { SQLiteConnection m_dbConnection; List <ProbeDetails> lstProbeResults = new List <ProbeDetails>(); ProbeDetails objProbeDetails = new ProbeDetails(); //DB Details m_dbConnection = new SQLiteConnection(@"Data Source=" + ConfigurationManager.AppSettings["LocalDB_DS"] + ";Version=3;"); m_dbConnection.Open(); string sql = @"select * from Diagnostics_MasterData where HostName = '" + ServerName + "'"; SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { objProbeDetails.HostName = reader["HostName"].ToString(); objProbeDetails.ProbeGroup = reader["ProbeGroup"].ToString(); objProbeDetails.ProbeName = reader["ProbeName"].ToString(); objProbeDetails.ProbeType = reader["ProbeType"].ToString(); lstProbeResults.Add(objProbeDetails); //Console.WriteLine("Id: " + reader["Id"] + "\tProbeGroup: " + reader["ProbeGroup"] + "\tProbeName: " + reader["ProbeName"] + "\tHostName: " + reader["HostName"]); } reader.Close(); m_dbConnection.Close(); return(lstProbeResults); } catch (Exception) { throw; } }
public static List <string> FetchMetrics(string MetricsType) { try { SQLiteConnection m_dbConnection; List <string> lstMetricsResults = new List <string>(); ProbeDetails objProbeDetails = new ProbeDetails(); //DB Details m_dbConnection = new SQLiteConnection(@"Data Source=" + ConfigurationManager.AppSettings["LocalDB_DS"] + ";Version=3;"); m_dbConnection.Open(); string sql = string.Empty; switch (MetricsType) { case "Java": sql = @"select MetricsName from Diagnostics_JavaMetrics"; break; case "Oracle": sql = @"select MetricsName from Diagnostics_OracleMetrics"; break; case "MQ": sql = @"select MetricsName from Diagnostics_MQMetrics"; break; default: break; } SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { lstMetricsResults.Add(reader["MetricsName"].ToString()); //Console.WriteLine("Id: " + reader["Id"] + "\tProbeGroup: " + reader["ProbeGroup"] + "\tProbeName: " + reader["ProbeName"] + "\tHostName: " + reader["HostName"]); } reader.Close(); m_dbConnection.Close(); return(lstMetricsResults); } catch (Exception) { throw; } }