public static List <Product> GetGroceryProducts(Grocerylist groceryList)
{
using (OracleConnection connection = Connection)
{
try
{
OracleCommand command = CreateOracleCommand(connection, "SELECT * FROM PRODUCT WHERE ID = BOODSCHAPPENLIJST_PRODUCTEN.product_ID AND BOODSCHAPPENLIJST_PRODUCTEN.boodschappenlijst_ID = :groceryListID");
command.Parameters.Add(":groceryListID", groceryList.ID);
OracleDataReader reader = ExecuteQuery(command);
List <Product> products = new List <Product>();
while (reader.Read())
{
int id = Convert.ToInt32(reader["ID"].ToString());
string name = reader["naam"].ToString();
string imageURL = reader["imgurl"].ToString();
double price = Convert.ToDouble(reader["prijs"].ToString());
DateTime lastModified = Convert.ToDateTime(reader["laastgewijzigd"].ToString());
products.Add(new Product(id, name, price, imageURL, lastModified, null));
}
return(products);
}
finally
{
connection.Close();
}
}
}
public static List<Product> GetGroceryProducts(Grocerylist groceryList)
{
using (OracleConnection connection = Connection)
{
try
{
OracleCommand command = CreateOracleCommand(connection, "SELECT * FROM PRODUCT WHERE ID = BOODSCHAPPENLIJST_PRODUCTEN.product_ID AND BOODSCHAPPENLIJST_PRODUCTEN.boodschappenlijst_ID = :groceryListID");
command.Parameters.Add(":groceryListID", groceryList.ID);
OracleDataReader reader = ExecuteQuery(command);
List<Product> products = new List<Product>();
while (reader.Read())
{
int id = Convert.ToInt32(reader["ID"].ToString());
string name = reader["naam"].ToString();
string imageURL = reader["imgurl"].ToString();
double price = Convert.ToDouble(reader["prijs"].ToString());
DateTime lastModified = Convert.ToDateTime(reader["laastgewijzigd"].ToString());
products.Add(new Product(id, name, price, imageURL, lastModified, null));
}
return products;
}
finally
{
connection.Close();
}
}
}