public static List<BLProduct> RetrieveDiscountedProductsFromDB(string databaseConnectionString)
{
List<BLProduct> products = new List<BLProduct>();
SqlConnection sqlConnection = new SqlConnection(databaseConnectionString);
SqlCommand sqlGetDiscounts = new SqlCommand("SELECT ProductID FROM DiscountedProducts", sqlConnection);
SqlDataReader sqlDiscountDataReader = null;
try
{
sqlConnection.Open();
sqlDiscountDataReader = sqlGetDiscounts.ExecuteReader();
while (sqlDiscountDataReader.Read())
products.Add(RetrieveFromDB(databaseConnectionString,
int.Parse(sqlDiscountDataReader["ProductID"].ToString())));
return products;
}
finally
{
if (sqlDiscountDataReader != null)
{
sqlDiscountDataReader.Close();
sqlDiscountDataReader.Dispose();
}
sqlConnection.Close();
sqlConnection.Dispose();
sqlGetDiscounts.Dispose();
}
}
public static List<BLProduct> RetrieveTopNPopularProductsFromDB(string databaseConnectionString,