public string insertOrderDetails(AddOrderDetailEntity detail)
{
try
{
_connection.ConnectionString = _connectionString;
_connection.Open();
cmd = _connection.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "NORTHWIND.PAKET.PROC_ADD_ORDER_DETAIL";
cmd.Parameters.Add("P_ORDERDETAIL_ORDERID", OracleDbType.Int64, System.Data.ParameterDirection.Input).Value = detail.orderId;
cmd.Parameters.Add("P_ORDERDETAIL_PRODUCTID", OracleDbType.Int64, System.Data.ParameterDirection.Input).Value = detail.productId;
cmd.Parameters.Add("P_ORDERDETAIL_UNITPRICE", OracleDbType.Int64, System.Data.ParameterDirection.Input).Value = detail.unitPrice;
cmd.Parameters.Add("P_ORDERDETAIL_QUANTITY", OracleDbType.Int64, System.Data.ParameterDirection.Input).Value = detail.quantity;
cmd.Parameters.Add("P_ORDERDETAIL_DISCOUNT", OracleDbType.Int64, System.Data.ParameterDirection.Input).Value = detail.discount;
cmd.ExecuteNonQuery();
_connection.Close();
return("Ekleme Başarılı");
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
public string addOrderDetail(AddOrderDetailEntity detail_data)
{
BaseClass bc = new BaseClass();
return(bc.insertOrderDetails(detail_data));
}
