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);
}
