public void PostUrl([FromBody] UrlProduct urlProduct, string connectionString) //Post the URL into the PUrl_table
{
using (new TimeMeasure("PostProduct - URL"))
{
string query = "INSERT into PUrl_Table(Url, Flag) VALUES (@Url, @Flag)";
SqlConnection connection = new SqlConnection(connectionString);
using (SqlCommand insertCommand = new SqlCommand(query, connection))
{
connection.Open();
insertCommand.Parameters.AddWithValue("@Url", urlProduct.Url);
insertCommand.Parameters.AddWithValue("@Flag", urlProduct.Flag);
insertCommand.ExecuteNonQuery();
connection.Close();
}
}
}
public List <UrlProduct> GetAllUrls(string connectionString) //Get all URLS in the PURL table
{
using (new TimeMeasure("GetAllUrlProducts"))
{
var result = new List <UrlProduct>();
string sql = "select * from PUrl_Table";
using (SqlConnection databaseConnection = new SqlConnection(connectionString))
{
databaseConnection.Open();
using (SqlCommand selectCommand = new SqlCommand(sql, databaseConnection))
{
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
string url = reader.GetString(0);
int flag = reader.GetInt32(1);
UrlProduct urlProduct = new UrlProduct()
{
Url = url,
Flag = flag
};
result.Add(urlProduct);
}
}
}
}
databaseConnection.Close();
}
return(result);
}
}
