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