public static List<BLProduct> RetrieveListFromDB(string databaseConnectionString, string sqlConditionString)
{
List<BLProduct> products = new List<BLProduct>();
SqlConnection sqlConnection = new SqlConnection(databaseConnectionString);
SqlCommand sqlGetProducts = new SqlCommand($"SELECT ID, CategoryID, Name, Description, Price, Popularity, StockQuantity, VAT FROM Products WHERE {sqlConditionString}", sqlConnection);
SqlDataReader sqlReader = null;
try
{
sqlConnection.Open();
sqlReader = sqlGetProducts.ExecuteReader();
while (sqlReader.Read())
{
BLProduct product = new BLProduct(id: int.Parse(sqlReader["ID"].ToString()), categoryId: int.Parse(sqlReader["CategoryID"].ToString()),
name: sqlReader["Name"].ToString(), description: sqlReader["Description"].ToString(),
price: double.Parse(sqlReader["Price"].ToString()),
popularity: int.Parse(sqlReader["Popularity"].ToString()),
stockQuantity: int.Parse(sqlReader["StockQuantity"].ToString()),
VAT: double.Parse(sqlReader["VAT"].ToString()));
product.GetDiscountFromDB(databaseConnectionString);
product.GetTrailerUrlFromDB(databaseConnectionString);
products.Add(product);
}
return products;
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
sqlReader.Dispose();
}
sqlConnection.Close();
sqlConnection.Dispose();
sqlGetProducts.Dispose();
}
}
public static List<BLProduct> RetrieveDiscountedProductsFromDB(string databaseConnectionString)
