public List <Dataproduct> ProductList()
{
List <Dataproduct> productList = new List <Dataproduct>();
string query = "SELECT * FROM product";
dal.Conn.Open();
MySqlCommand command = new MySqlCommand(query, dal.Conn);
MySqlDataReader reader = command.ExecuteReader();
try
{
//read through all the data
while (reader.Read())
{
//create productlist
Dataproduct product = new Dataproduct();
product.Id = reader.GetInt32("Id");
product.Name = reader.GetString("Name");
product.Sellprice = reader.GetDecimal("Sellprice");
// save uitlening to the list
productList.Add(product);
}
}
catch
{
Console.WriteLine("kan de query niet uitvoeren! LOL");
}
dal.Conn.Close();
return(productList);
}
public IActionResult CartRemove(Dataproduct Cartproduct)
{
string cookie = Request.Cookies["CartItems"];
Dictionary <int, int> artikeldictionary = new Dictionary <int, int>();
artikeldictionary = JsonConvert.DeserializeObject <Dictionary <int, int> >(cookie);
artikeldictionary.Remove(Cartproduct.Id + Cartproduct.Quantity);
return(Redirect("../../cart/cart"));
}
public void ProductCreate(Dataproduct ProductNew)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("@Name", ProductNew.Name);
dict.Add("@Description", ProductNew.Description);
dict.Add("@Sellprice", ProductNew.Sellprice);
dict.Add("@Quantity", ProductNew.Quantity);
string query = "INSERT INTO `product`( `Name`, `Description`, `Quantity`, `Sellprice`) VALUES (@Name,@Description, @Quantity , @Sellprice)";
dal.DataQuery(query, dict);
}
public void producten(Dataproduct productadd)
{
dal.Conn.Open();
MySqlCommand Com = new MySqlCommand();
Com.Connection = dal.Conn;
Com.CommandText = "productadd";
Com.CommandType = CommandType.StoredProcedure;
Com.Parameters.AddWithValue("@name", productadd.Name);
Com.Parameters["@name"].Direction = ParameterDirection.Input;
Com.Parameters.AddWithValue("@description", productadd.Description);
Com.Parameters["@description"].Direction = ParameterDirection.Input;
Com.Parameters.AddWithValue("@quantity", productadd.Quantity);
Com.Parameters["@quantity"].Direction = ParameterDirection.Input;
Com.Parameters.AddWithValue("@sellprice", productadd.Sellprice);
Com.Parameters["@sellprice"].Direction = ParameterDirection.Input;
Com.ExecuteNonQuery();
}
public IActionResult ProductAdd(Dataproduct ProductNew)
{
logic.productadd(ProductNew);
return(RedirectToAction("Products"));
}
public void productadd(Dataproduct ProductNew)
{
dallaag.producten(ProductNew);
}
public IActionResult MakeOrder(Dataproduct dataProduct, DataOrder dataOrder)
{
return(RedirectToPage("orders"));
}
