public List<Winkelmandje> loadCart(int klantnr)
{
MySqlConnection conn = new MySqlConnection(ConnStr);
conn.Open();
string qry = "SELECT Foto, tblwinkelmandje.ArtNr, Naam, Aantal, Prijs, (Aantal * Prijs) as Totaal FROM tblwinkelmandje INNER JOIN " +
"tblproduct ON tblwinkelmandje.ArtNr = tblproduct.ArtNr WHERE KlantNr =" + klantnr + " ORDER BY tblwinkelmandje.ArtNr";
MySqlCommand cmd = new MySqlCommand(qry, conn);
MySqlDataReader dtr = cmd.ExecuteReader();
List<Winkelmandje> _lijst = new List<Winkelmandje>();
while (dtr.Read())
{
Winkelmandje winkelmandje = new Winkelmandje();
winkelmandje.Foto = dtr["Foto"].ToString();
winkelmandje.ArtNr = Convert.ToInt32(dtr["ArtNr"]);
winkelmandje.Naam = dtr["Naam"].ToString();
winkelmandje.Aantal = Convert.ToInt32(dtr["Aantal"]);
winkelmandje.Prijs = Convert.ToDouble(dtr["Prijs"]);
winkelmandje.Totaal = Convert.ToDouble(dtr["Totaal"]);
_lijst.Add(winkelmandje);
}
conn.Close();
return _lijst;
}
public void insertCart(Winkelmandje winkelmandje)
{
MySqlConnection conn = new MySqlConnection(ConnStr);
conn.Open();
string qry = "INSERT INTO tblwinkelmandje(KlantNr,ArtNr, Aantal) VALUES ('" + winkelmandje.KlantNr + "','" + winkelmandje.ArtNr + "','" + winkelmandje.Aantal + "')";
MySqlCommand cmd = new MySqlCommand(qry, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
