public void WriteResults(string testID, int callID, DateTime originalDomainTimeCalled, DateTime newDomainTimeCalled, DateTime testDateTime, string resultoriginal = null, string resultnew = null) { var gete = new GetAppsettings(); string strConn = gete.ReturnDatabaseConnection(); using (SqlConnection Conn = new SqlConnection(strConn)) { try { Conn.Open(); Console.WriteLine("Connection Open\n"); string sql = "Insert Into DataReturns(TestID, CallID, OriginalDomainReturn, NewDomainReturn, OriginalDomainTimeCalled, NewDomainTimeCalled, TestDateTime) VALUES (@param1, @param2, @param3, @param4, @param5, @param6, @param7)"; SqlCommand sqlCommand1 = new SqlCommand(sql, Conn); sqlCommand1.Parameters.Add("@param1", SqlDbType.NVarChar, 20).Value = testID; sqlCommand1.Parameters.Add("@param2", SqlDbType.Int).Value = callID; sqlCommand1.Parameters.Add("@param3", SqlDbType.NVarChar, -1).Value = resultoriginal; sqlCommand1.Parameters.Add("@param4", SqlDbType.NVarChar, -1).Value = resultnew; sqlCommand1.Parameters.Add("@param5", SqlDbType.DateTime).Value = originalDomainTimeCalled; sqlCommand1.Parameters.Add("@param6", SqlDbType.DateTime).Value = newDomainTimeCalled; sqlCommand1.Parameters.Add("@param7", SqlDbType.DateTime).Value = testDateTime; sqlCommand1.CommandType = CommandType.Text; sqlCommand1.ExecuteNonQuery(); Conn.Close(); Console.WriteLine("Connection Close"); } catch (Exception e) { Console.WriteLine(e.StackTrace); } } }
public static (List <string> dataread, List <string> listquerystringlist) ReturnDomainsandQueryStrings() { var gete = new GetAppsettings(); string strConn = gete.ReturnDatabaseConnection(); var dataread = new List <string>(); var listquerystringlist = new List <string>(); using (SqlConnection Conn = new SqlConnection(strConn)) { try { Conn.Open(); Console.WriteLine("Connection Open\n"); SqlCommand sqlCommand1 = new SqlCommand("SELECT Domain FROM Domains", Conn); var dataReader = sqlCommand1.ExecuteReader(); while (dataReader.Read()) { dataread.Add(dataReader.GetString(0)); } Conn.Close(); Conn.Open(); SqlCommand sqlCommand2 = new SqlCommand("SELECT QueryString FROM QueryStringList", Conn); var dataReader2 = sqlCommand2.ExecuteReader(); while (dataReader2.Read()) { listquerystringlist.Add(dataReader2.GetString(0)); } Conn.Close(); Console.WriteLine("Connection Close"); } catch (Exception e) { Console.WriteLine(e.StackTrace); } return(dataread, listquerystringlist); } }
public static List <string> ReturnDomainsOrQueryStringList(string domainOrQueryStringList) { var gete = new GetAppsettings(); string strConn = gete.ReturnDatabaseConnection(); var dataread = new List <string>(); switch (domainOrQueryStringList) { case "Domain": using (SqlConnection Conn = new SqlConnection(strConn)) { try { Conn.Open(); Console.WriteLine("Connection Open\n"); SqlCommand sqlCommand1 = new SqlCommand("SELECT Domain FROM Domains", Conn); var dataReader = sqlCommand1.ExecuteReader(); while (dataReader.Read()) { dataread.Add(dataReader.GetString(0)); } Conn.Close(); Console.WriteLine("Connection Close"); } catch (Exception e) { Console.WriteLine(e.StackTrace); } break; } case "QueryStringList": using (SqlConnection Conn = new SqlConnection(strConn)) { try { Conn.Open(); Console.WriteLine("Connection Open\n"); var sqlCommand1 = new SqlCommand("SELECT QueryString FROM QueryStringList", Conn); var dataReader = sqlCommand1.ExecuteReader(); while (dataReader.Read()) { dataread.Add(dataReader.GetString(0)); } Conn.Close(); Console.WriteLine("Connection Close"); } catch (Exception e) { Console.WriteLine(e.StackTrace); } break; } } return(dataread); }