/// <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");
}