/// <summary>
        /// The insert pick up order.
        /// </summary>
        /// <param name="order">
        /// The order.
        /// </param>
        /// <returns>
        /// The <see cref="Pickup"/>.
        /// </returns>
        public Pickup InsertPickUpOrder(Pickup order)
        {
            var query =
                "INSERT INTO ophaal (ordernummer, winkelid) VALUES (:ordernr, :winkelid) RETURNING ordernummer INTO :lastID";
            var parameters = new List<OracleParameter>
            {
                new OracleParameter("ordernr", order.Id),
                new OracleParameter("winkelid", order.StoreID),
                new OracleParameter("lastID", OracleDbType.Decimal) {Direction = ParameterDirection.ReturnValue}
            };

            string newID;
            if (!Database.ExecuteNonQuery(query, out newID, parameters)) return null;
            return this.GetPickUpById(Convert.ToInt32(newID));
        }
 /// <summary>
 /// The insert pick up order.
 /// </summary>
 /// <param name="order">
 /// The order.
 /// </param>
 /// <returns>
 /// The <see cref="Pickup"/>.
 /// </returns>
 public Pickup InsertPickUpOrder(Pickup order)
 {
     return this.contextPickupOracleContext.InsertPickUpOrder(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");
        }