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(); }