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