/// <summary> /// The btn place order delivery_ click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> protected void btnPlaceOrderDelivery_Click(object sender, EventArgs e) { if (!this.Page.IsValid) { return; } // If other delivery address data change it in current customer if (this.txtAlterAddress.Text != this.currentCustomer.Address || this.txtAlterCity.Text != this.currentCustomer.City || this.txtAlterPostal.Text != this.currentCustomer.Postalcode) { this.currentCustomer.Address = this.txtAlterAddress.Text; this.currentCustomer.City = this.txtAlterCity.Text; this.currentCustomer.Postalcode = this.txtAlterPostal.Text; } else { // Making order for delivery var order = new Order(0, this.currentCustomer, DateTime.Now); order = this.transportman.InsertOrder(order); var delivery = new Delivery(order.Id, this.currentCustomer.Address, this.currentCustomer.Postalcode, this.currentCustomer.City, order.Customer, order.Date); delivery = this.transportman.InsertDeliveryOrder(delivery); this.AddingArticlesToDB(order); if (delivery == null) { this.btnPlaceOrderDelivery.Enabled = false; this.btnPlaceOrderPickUp.Enabled = false; return; } this.workingman.EmptyCart(); this.Response.Redirect("~/Succes.aspx"); } }
/// <summary> /// The insert order. /// </summary> /// <param name="order"> /// The order. /// </param> /// <returns> /// The <see cref="Order"/>. /// </returns> public Order InsertOrder(Order order) { var query = "INSERT INTO factuur (ordernummer, klantid, datum) VALUES (seq_factuur.nextval, :klandid, :datum) RETURNING ordernummer INTO :lastID"; var parameters = new List<OracleParameter> { new OracleParameter("klandid", order.Customer.Id), new OracleParameter("datum", order.Date) {OracleDbType = OracleDbType.Date}, new OracleParameter("lastID", OracleDbType.Decimal) {Direction = ParameterDirection.ReturnValue} }; string newID; if (!Database.ExecuteNonQuery(query, out newID, parameters)) return null; return this.GetById(Convert.ToInt32(newID)); }
/// <summary> /// The insert order article. /// </summary> /// <param name="caritem"> /// The caritem. /// </param> /// <param name="order"> /// The order. /// </param> public void InsertOrderArticle(CartItem caritem, Order order) { var query = "INSERT INTO artikel_factuur (ordernummer, artikelnummer, aantal) VALUES (:ordernummer, :artikelnummer, :aantal)"; var parameters = new List<OracleParameter> { new OracleParameter("ordernummer", order.Id), new OracleParameter("artikelnummer", caritem.Product.Id), new OracleParameter("aantal", caritem.Quantity) }; Database.ExecuteNonQuery(query,parameters); }
/// <summary> /// The insert order article. /// </summary> /// <param name="caritem"> /// The caritem. /// </param> /// <param name="order"> /// The order. /// </param> public void InsertOrderArticle(CartItem caritem, Order order) { this._context.InsertOrderArticle(caritem, order); }
/// <summary> /// The insert order. /// </summary> /// <param name="order"> /// The order. /// </param> /// <returns> /// The <see cref="Order"/>. /// </returns> public Order InsertOrder(Order order) { return this._context.InsertOrder(order); }
/// <summary> /// The btn place order pick up_ click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> protected void btnPlaceOrderPickUp_Click(object sender, EventArgs e) { // Making order for Pickup var order = new Order(0, this.currentCustomer, DateTime.Now); order = this.transportman.InsertOrder(order); var pickup = new Pickup(order.Id, this.storeLogic.GetById(this.drpStores.SelectedIndex + 1).Id, order.Customer, order.Date); pickup = this.transportman.InsertPickUpOrder(pickup); this.AddingArticlesToDB(order); if (pickup == null) { this.btnPlaceOrderDelivery.Enabled = false; this.btnPlaceOrderPickUp.Enabled = false; return; } this.workingman.EmptyCart(); this.Response.Redirect("~/Succes.aspx"); }
/// <summary> /// The adding articles to db. /// </summary> /// <param name="order"> /// The order. /// </param> private void AddingArticlesToDB(Order order) { var items = this.workingman.GetCartItems(); foreach (var item in items) { this.transportman.InsertOrderArticle(item, order); } }