//methods
public List <Producten> getProductenFromDB(string connectionstring)
{
//de connectie met de databank maken
MySqlConnection conn = new MySqlConnection(connectionstring);
//Het SQL-commando definiëren
MySqlCommand cmd = new MySqlCommand("select * from cafétoepassing_smeyers_tom_gip.producten", conn);
List <Producten> productenLijst = new List <Producten>();
conn.Open();
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
Producten item = new Producten(
Convert.ToInt16(dataReader[0]),
dataReader[1].ToString(),
Convert.ToDouble(dataReader[2])
);
productenLijst.Add(item);
}
conn.Close();
return(productenLijst);
}
private void btnVoegProductToe_Click(object sender, RoutedEventArgs e)
{
Producten product = new Producten(tbxProductNaam.Text, Convert.ToDouble(tbxPrijs.Text));
_controller.addProducten(product);
ClearInput();
}
public ActionResult Post([FromBody] Producten producten)
{
if (_context.Producten.Any(x => x.Name == producten.Name))
{
var product = _context.Producten.First(x => x.Name == producten.Name);
product.Name = producten.Name;
product.ImageUrl = producten.ImageUrl;
product.Alcohol_free = producten.Alcohol_free;
product.Celery_free = producten.Celery_free;
product.Crustacean_free = producten.Crustacean_free;
product.Dairy_free = producten.Dairy_free;
product.Egg_free = producten.Egg_free;
product.Fish_free = producten.Fish_free;
product.Gluten_free = producten.Gluten_free;
product.Kidney_friendly = producten.Kidney_friendly;
product.Kosher = producten.Kosher;
product.Low_potassium = producten.Low_potassium;
product.Lupine_free = producten.Lupine_free;
product.Low_fat_abs = producten.Low_fat_abs;
product.Mustard_free = producten.Mustard_free;
product.No_oil_added = producten.No_oil_added;
product.Low_sugar = producten.Low_sugar;
product.Paleo = producten.Paleo;
product.Peanut_free = producten.Peanut_free;
product.Pecatarian = producten.Pecatarian;
product.Pork_free = producten.Pork_free;
product.Red_meat_free = producten.Red_meat_free;
product.Sesame_free = producten.Sesame_free;
product.Shellfish_free = producten.Shellfish_free;
product.Soy_free = producten.Soy_free;
product.Sugar_conscious = producten.Sugar_conscious;
product.Tree_nut_free = producten.Tree_nut_free;
product.Vegan = producten.Vegan;
product.Vegetarian = producten.Vegetarian;
product.Wheat_free = producten.Wheat_free;
_context.SaveChanges();
return(Json(product));
}
else
{
Product product = new Product {
Name = producten.Name, ImageUrl = producten.ImageUrl, Alcohol_free = producten.Alcohol_free,
Celery_free = producten.Celery_free, Crustacean_free = producten.Crustacean_free, Dairy_free = producten.Dairy_free,
Egg_free = producten.Egg_free, Fish_free = producten.Fish_free, Gluten_free = producten.Gluten_free,
Kidney_friendly = producten.Kidney_friendly, Kosher = producten.Kosher, Low_potassium = producten.Low_potassium,
Lupine_free = producten.Lupine_free, Low_fat_abs = producten.Low_fat_abs, Mustard_free = producten.Mustard_free,
No_oil_added = producten.No_oil_added, Low_sugar = producten.Low_sugar, Paleo = producten.Paleo, Peanut_free = producten.Peanut_free,
Pecatarian = producten.Pecatarian, Pork_free = producten.Pork_free, Red_meat_free = producten.Red_meat_free,
Sesame_free = producten.Sesame_free, Shellfish_free = producten.Shellfish_free, Soy_free = producten.Soy_free,
Sugar_conscious = producten.Sugar_conscious, Tree_nut_free = producten.Tree_nut_free, Vegan = producten.Vegan,
Vegetarian = producten.Vegetarian, Wheat_free = producten.Wheat_free
};
_context.Producten.Add(product);
_context.SaveChanges();
return(Json(product));
}
}
private void lstArtikels_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
Producten product = (Producten)lstArtikels.SelectedItem;
waarde = (decimal)product;
waarde = waarde / 100;
lblGekozenArtikel.Content = ($"{product} \t {waarde}");
}
protected void btnVoegToe_Click(object sender, EventArgs e)
{
Producten product = new Producten(txtNaamProduct.Text, Convert.ToDouble(TxtPrijsProduct.Text));
_controller.addProducten(product);
ClearInput();
Response.Redirect("EigenaarPage.aspx");
}
public void addProductToDB(string connectionstring, Producten item)
{
//de connectie met de databank maken
MySqlConnection conn = new MySqlConnection(connectionstring);
//Het SQL-commando definiëren
string opdracht = "INSERT INTO cafétoepassing_smeyers_tom_gip.producten(Productnaam, Prijs) VALUES(@productnaam, @prijsperproduct)";
MySqlCommand cmd = new MySqlCommand(opdracht, conn);
//voeg de waarden toe, je haalt ze uit het object eval
cmd.Parameters.AddWithValue("productnaam", item.ProductNaam);
cmd.Parameters.AddWithValue("prijsperproduct", item.PrijsProduct);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public ActionResult Post([FromBody] Producten vm)
{
//edit
if (vm.editproduct == true)
{
var OutDatedproduct = _context.Producten.First(product => product.Id == vm.Id);
OutDatedproduct.Name = vm.Name;
OutDatedproduct.ImageUrl = vm.ImageUrl;
OutDatedproduct.Alcohol_free = vm.Alcohol_free;
OutDatedproduct.Celery_free = vm.Celery_free;
OutDatedproduct.Crustacean_free = vm.Crustacean_free;
OutDatedproduct.Dairy_free = vm.Dairy_free;
OutDatedproduct.Egg_free = vm.Egg_free;
OutDatedproduct.Fish_free = vm.Fish_free;
OutDatedproduct.Gluten_free = vm.Gluten_free;
OutDatedproduct.Kidney_friendly = vm.Kidney_friendly;
OutDatedproduct.Kosher = vm.Kosher;
OutDatedproduct.Low_potassium = vm.Low_potassium;
OutDatedproduct.Lupine_free = vm.Lupine_free;
OutDatedproduct.Low_fat_abs = vm.Low_fat_abs;
OutDatedproduct.Mustard_free = vm.Mustard_free;
OutDatedproduct.No_oil_added = vm.No_oil_added;
OutDatedproduct.Low_sugar = vm.Low_sugar;
OutDatedproduct.Paleo = vm.Paleo;
OutDatedproduct.Peanut_free = vm.Peanut_free;
OutDatedproduct.Pecatarian = vm.Pecatarian;
OutDatedproduct.Pork_free = vm.Pork_free;
OutDatedproduct.Red_meat_free = vm.Red_meat_free;
OutDatedproduct.Sesame_free = vm.Sesame_free;
OutDatedproduct.Shellfish_free = vm.Shellfish_free;
OutDatedproduct.Soy_free = vm.Soy_free;
OutDatedproduct.Sugar_conscious = vm.Sugar_conscious;
OutDatedproduct.Tree_nut_free = vm.Tree_nut_free;
OutDatedproduct.Vegan = vm.Vegan;
OutDatedproduct.Vegetarian = vm.Vegetarian;
OutDatedproduct.Wheat_free = vm.Wheat_free;
_context.SaveChanges();
}
//delete
else if (vm.deleteproduct == true)
{
var OutDatedproduct = _context.Producten.First(product => product.Id == vm.Id);
_context.Producten.Remove(OutDatedproduct);
_context.SaveChanges();
}
//add
else if (vm.addproduct == true)
{
_context.Producten.Add(
new Product
{
Name = vm.Name,
ImageUrl = vm.ImageUrl,
Alcohol_free = vm.Alcohol_free,
Celery_free = vm.Celery_free,
Crustacean_free = vm.Crustacean_free,
Dairy_free = vm.Dairy_free,
Egg_free = vm.Egg_free,
Fish_free = vm.Fish_free,
Gluten_free = vm.Gluten_free,
Kidney_friendly = vm.Kidney_friendly,
Kosher = vm.Kosher,
Low_potassium = vm.Low_potassium,
Lupine_free = vm.Lupine_free,
Low_fat_abs = vm.Low_fat_abs,
Mustard_free = vm.Mustard_free,
No_oil_added = vm.No_oil_added,
Low_sugar = vm.Low_sugar,
Paleo = vm.Paleo,
Peanut_free = vm.Peanut_free,
Pecatarian = vm.Pecatarian,
Pork_free = vm.Pork_free,
Red_meat_free = vm.Red_meat_free,
Sesame_free = vm.Sesame_free,
Shellfish_free = vm.Shellfish_free,
Soy_free = vm.Soy_free,
Sugar_conscious = vm.Sugar_conscious,
Tree_nut_free = vm.Tree_nut_free,
Vegan = vm.Vegan,
Vegetarian = vm.Vegetarian,
Wheat_free = vm.Wheat_free
});
_context.SaveChanges();
}
var results = _context.Producten;
return(Json(results));
}
public Product GetProduct(int id)
{
return(Producten.FirstOrDefault(p => p.ProductId == id));
}
public void addProducten(Producten item)
{
ProductenMapper mapper = new ProductenMapper();
mapper.addProductToDB(_connectionString, item);
}
