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