public void InsertOrderAdres2(Order order) { using (OracleConnection connection = Connection) { string insert2 = "INSERT INTO ORDER_ADRES VALUES (:ORDERID, :ADRESID, 'OFFERTEADRES')"; using (OracleCommand command2 = new OracleCommand(insert2, connection)) { command2.Parameters.Add(new OracleParameter("ORDERID", order.OrderId)); command2.Parameters.Add(new OracleParameter("ADRESID", order.FactuurAdres.AdresId)); command2.ExecuteNonQuery(); } } }
public void InsertOrderAdres(Order order) { using (OracleConnection connection = Connection) { string insert = "INSERT INTO ORDER_ADRES VALUES(:ORDERID, :ADRESID, 'BEZORGADRES')"; using (OracleCommand command = new OracleCommand(insert, connection)) { command.Parameters.Add(new OracleParameter("ORDERID", order.OrderId)); command.Parameters.Add(new OracleParameter("ADRESID", order.BezorgAdres.AdresId)); command.ExecuteNonQuery(); } } }
public void InsertExemplaar(Exemplaar exemplaar, Order order) { using (OracleConnection connection = Connection) { string insert = "INSERT INTO EXEMPLAAR VALUES (seq_Exemplaar_ID.nextval, :ORDERID, :PRODUCTID, :VERKOOPPRIJS)"; using (OracleCommand command = new OracleCommand(insert, connection)) { command.Parameters.Add(new OracleParameter("ORDERID", null)); command.Parameters.Add(new OracleParameter("PRODUCT", exemplaar.Product.ProductId)); command.Parameters.Add(new OracleParameter("VERKOOPPRIJS", exemplaar.Verkoopprijs)); command.ExecuteNonQuery(); } } }
public void InsertOrder(Order order) { string dagstring = DateTime.Now.Day.ToString(); if (dagstring.Length < 2) { dagstring = '0' + dagstring; } string datumString = dagstring + '-' + DateTime.Now.Month.ToString() + '-' + DateTime.Now.Year.ToString(); using (OracleConnection connection = Connection) { string insert = "INSERT INTO \"Order\" VALUES (seq_Order_ID.nextval, :ACCOUNTID, TO_DATE(:DATUM, 'DD-MM-YYYY'))"; using (OracleCommand command = new OracleCommand(insert, connection)) { command.Parameters.Add(new OracleParameter("ACCOUNTID", order.Account.AccountId.ToString())); command.Parameters.Add(new OracleParameter("DATUM", datumString)); command.ExecuteNonQuery(); } } }
protected void btnBestel_OnClick(object sender, EventArgs e) { if (Session["email"] != null) { int currentAccountId = administratie.FindParticulier(Session["email"].ToString(), Session["wachtwoord"].ToString()); Particulier particulier = administratie.getParticulierFromId(currentAccountId); DateTime datum = DateTime.Now; List<Exemplaar> exemplarenList = new List<Exemplaar>(); foreach (Product p in products) { int nummer = administratie.selectLastExemplaar() + 1; Exemplaar exemplaar = new Exemplaar(nummer, p.Prijs, p); administratie.InsertExemplaar(exemplaar, null); exemplarenList.Add(exemplaar); } Adres adres = new Adres(1, "6961PL", 3, "Zonnedauw", "Eerbeek"); Adres adres2 = new Adres(2, "5612BT", 2, "Visserstraat", "Eindhoven"); Order order = new Order(0, particulier, datum, exemplarenList, adres, adres2); administratie.InsertOrder(order); int orderId = administratie.lastOrderId(); foreach (Exemplaar exemplaar in exemplarenList) { administratie.UpdateExemplaarOrderId(exemplaar.Serienummer, orderId); Response.Redirect("Homepage.aspx"); } } }
public void InsertExemplaar(Exemplaar exemplaar, Order order) { db.InsertExemplaar(exemplaar, order); }
public void InsertOrder(Order order) { db.InsertOrder(order); order.OrderId = db.SelectLastOrderId(); db.InsertOrderAdres(order); db.InsertOrderAdres2(order); }