public void insert_into_common_table(Connection connection, int id_store, int id_client, int dist) { try { if (connection._connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } var command = new Oracle.ManagedDataAccess.Client.OracleCommand("insert_into_distance_table", connection._connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add("store_id", OracleDbType.Int32, System.Data.ParameterDirection.Input).Value = id_store; command.Parameters.Add("client_id", OracleDbType.Int32, System.Data.ParameterDirection.Input).Value = id_client; command.Parameters.Add("distance", OracleDbType.Int32, System.Data.ParameterDirection.Input).Value = dist; command.ExecuteNonQuery(); Oracle.ManagedDataAccess.Client.OracleDataReader reader = command.ExecuteReader(); connection.Close(); } catch (Exception e) { connection.Close(); throw; } }
public List <Address> getCityStore(Connection connection) { try { if (connection._connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } var command = new OracleCommand("getCities", connection._connection); command.CommandType = System.Data.CommandType.StoredProcedure; List <Address> addressList = new List <Address>(); OracleParameter output = command.Parameters.Add("l_cursor", OracleDbType.RefCursor); output.Direction = System.Data.ParameterDirection.ReturnValue; command.ExecuteNonQuery(); Oracle.ManagedDataAccess.Client.OracleDataReader reader = command.ExecuteReader(); while (reader.Read()) { Address address = new Address( reader.GetInt32(0), reader.GetString(1)); addressList.Add(address); } connection.Close(); return(addressList); // return null; } catch (Exception e) { connection.Close(); throw; } }
public void InsertProductInList(int list_id, int product_id, int quantity, Connection connection) { try { if (connection._connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } var command = new Oracle.ManagedDataAccess.Client.OracleCommand("insert_product_info", connection._connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add("list_id", OracleDbType.Int32, System.Data.ParameterDirection.Input).Value = list_id; command.Parameters.Add("product_id", OracleDbType.Int32, System.Data.ParameterDirection.Input).Value = product_id; command.Parameters.Add("quantity_2", OracleDbType.Int32, System.Data.ParameterDirection.Input).Value = quantity; command.ExecuteNonQuery(); Oracle.ManagedDataAccess.Client.OracleDataReader reader = command.ExecuteReader(); connection.Close(); } catch (Exception e) { connection.Close(); throw; } }
private void btnLoad_Click(object sender, EventArgs e) { try { dgvPreview.Columns.Clear(); oraClient.OracleCommand cmd = oracleConnection.CreateCommand(); cmd.CommandText = txtWGStatement.Text; using (oraClient.OracleDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { DataTable dataTable = new DataTable(); dataTable.Load(reader); dgvPreview.DataSource = dataTable; } reader.Close(); reader.Dispose(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error in btnLoad_Click()", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public int viewTroops() { Oracle.ManagedDataAccess.Client.OracleConnection conn = new Oracle.ManagedDataAccess.Client.OracleConnection(DbConnect.oradb); String strSQL = "SELECT * FROM V_PlayerTroops"; conn.Open(); Oracle.ManagedDataAccess.Client.OracleCommand cmd = new Oracle.ManagedDataAccess.Client.OracleCommand(strSQL, conn); Oracle.ManagedDataAccess.Client.OracleDataReader dr = cmd.ExecuteReader(); //read the record in dr dr.Read(); if (dr.IsDBNull(0)) { playerTroops = 1; } else { playerTroops = Convert.ToInt16(dr.GetValue(0)) + 1; } conn.Close(); return(playerTroops); }
public List <Products_Info> GetDbProductsList(Connection connection, int id) { try { if (connection._connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } var command = new Oracle.ManagedDataAccess.Client.OracleCommand("returnCartPro", connection._connection); command.CommandType = System.Data.CommandType.StoredProcedure; List <Products_Info> products_Info_list = new List <Products_Info>(); command.Parameters.Add("ID_INPUT", OracleDbType.Int32, System.Data.ParameterDirection.Input).Value = id; Oracle.ManagedDataAccess.Client.OracleParameter p_rc = command.Parameters.Add("rc", OracleDbType.RefCursor, DBNull.Value, System.Data.ParameterDirection.Output); // Oracle.ManagedDataAccess.Client.OracleParameter output = command.Parameters.Add("rc", OracleDbType.RefCursor); // output.Direction = System.Data.ParameterDirection.ReturnValue; command.ExecuteNonQuery(); Oracle.ManagedDataAccess.Client.OracleDataReader reader = command.ExecuteReader(); while (reader.Read()) { Products_Info products_Info = new Products_Info( reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2), reader.GetInt32(3), reader.GetString(4), reader.GetString(5)); products_Info_list.Add(products_Info); } connection.Close(); return(products_Info_list); // return null; } catch (Exception e) { connection.Close(); throw; } }
private void previousOrdersBtn_Click(object sender, EventArgs e) { string[] words = greetingLabel.Text.Split(' '); string name = words[1]; string surname = words[2]; Connection connection = new Connection(); if (connection._connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } var command = new Oracle.ManagedDataAccess.Client.OracleCommand("GETUSERORDERS1", connection._connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add("nume", OracleDbType.Varchar2, System.Data.ParameterDirection.Input).Value = name; command.Parameters.Add("prenume", OracleDbType.Varchar2, System.Data.ParameterDirection.Input).Value = surname; List <Order> orders_list = new List <Order>(); Oracle.ManagedDataAccess.Client.OracleParameter output = command.Parameters.Add("l_cursor", OracleDbType.RefCursor); output.Direction = System.Data.ParameterDirection.ReturnValue; command.ExecuteNonQuery(); Oracle.ManagedDataAccess.Client.OracleDataReader reader = command.ExecuteReader(); while (reader.Read()) { Order order = new Order(reader.GetInt32(0)); orders_list.Add(order); } connection.Close(); seeOrdersForm seeOrdersForm = new seeOrdersForm(connection, orders_list); }
public ActionResult Lister() { User user = (User)Session["User"]; Oracle.ManagedDataAccess.Client.OracleCommand ObjSelct = new Oracle.ManagedDataAccess.Client.OracleCommand("select * from QUESTIONS", user.connexion); Oracle.ManagedDataAccess.Client.OracleDataReader ObjeRead = ObjSelct.ExecuteReader(); List <Question> q = new List <Question>(); while (ObjeRead.Read()) { Question QQ = new Question(); QQ.Id = ObjeRead.GetString(0); QQ.Enoncer = ObjeRead.GetString(1); QQ.flag = ObjeRead.GetString(2); QQ.Dificulter = ObjeRead.GetString(3); q.Add(QQ); } ObjeRead.Close(); return(View(q)); }
/// <summary> /// SQLSelect: Fait un select sur la connection courante /// et met le resultat dans monReader. La commande /// est passé en paramètre. /// </summary> public void SQLSelect(String maCommandeSQLString) { if ((maCommandeSQLString == null) || (maCommandeSQLString == "")) { throw new JCASQLODPException( "Aucune commande SQL n'a été fournie."); } maCommandeSQL.Connection = maConnection; maCommandeSQL.CommandText = maCommandeSQLString; maCommandeSQL.CommandType = CommandType.Text; try { monReader = maCommandeSQL.ExecuteReader(); monReader.Read(); } catch (OracleException excep) { if (ExceptionDetaillee) throw new JCASQLODPException("Commande SQL:" + Environment.NewLine + maCommandeSQLString + Environment.NewLine + excep.Message, excep); else throw excep; } if (ActiverResume) Resumer(); }