public DataSet GetListProveedores(ClsProveedores proveedores, String pACCION) { DataSet DtsProveedores = new DataSet(); try { AbrirBaseDatos(); DtsProveedores.Clear(); DtsProveedores.EnforceConstraints = false; Cmd = new OracleCommand(); Cmd.Connection = conexion; Cmd.CommandText = "package_supermercados.stp_mantenimiento_proveedores"; Cmd.CommandType = CommandType.StoredProcedure; Cmd.Parameters.Add(new OracleParameter("p_empresa", OracleDbType.Varchar2)).Value = proveedores.aEMPRESA; Cmd.Parameters.Add(new OracleParameter("p_sucursal", OracleDbType.Varchar2)).Value = proveedores.aSUCURSAL; Cmd.Parameters.Add(new OracleParameter("p_cedula_juridica", OracleDbType.Varchar2)).Value = proveedores.aCEDULA_JURIDICA; Cmd.Parameters.Add(new OracleParameter("p_razon_social", OracleDbType.Varchar2)).Value = proveedores.aRAZON_SOCIAL; Cmd.Parameters.Add(new OracleParameter("p_ubicacion", OracleDbType.Varchar2)).Value = proveedores.aUBICACION; Cmd.Parameters.Add(new OracleParameter("p_email", OracleDbType.Varchar2)).Value = proveedores.aEMAIL; Cmd.Parameters.Add(new OracleParameter("p_telefono", OracleDbType.Varchar2)).Value = proveedores.aTELEFONO; Cmd.Parameters.Add(new OracleParameter("p_accion", OracleDbType.Varchar2)).Value = pACCION; Cmd.Parameters.Add(new OracleParameter("p_recordset", OracleDbType.RefCursor)).Direction = ParameterDirection.Output; OracleDataAdapter DataAdapter = new OracleDataAdapter(Cmd); DataAdapter.Fill(DtsProveedores); cerrar_base(); } catch (Exception Ex) { cerrar_base(); throw new Exception(Ex.Message); } return(DtsProveedores); }
public String MaintenanceProveedores(ClsProveedores proveedores, String pACCION) { String Menssage = ""; try { Cmd = new OracleCommand(); Cmd.Connection = conexion; AbrirBaseDatos(); Cmd.CommandText = "package_supermercados.stp_mantenimiento_proveedores"; Cmd.CommandType = CommandType.StoredProcedure; Cmd.Parameters.Add(new OracleParameter("p_empresa", OracleDbType.Varchar2)).Value = proveedores.aEMPRESA; Cmd.Parameters.Add(new OracleParameter("p_sucursal", OracleDbType.Varchar2)).Value = proveedores.aSUCURSAL; Cmd.Parameters.Add(new OracleParameter("p_cedula_juridica", OracleDbType.Varchar2)).Value = proveedores.aCEDULA_JURIDICA; Cmd.Parameters.Add(new OracleParameter("p_razon_social", OracleDbType.Varchar2)).Value = proveedores.aRAZON_SOCIAL; Cmd.Parameters.Add(new OracleParameter("p_ubicacion", OracleDbType.Varchar2)).Value = proveedores.aUBICACION; Cmd.Parameters.Add(new OracleParameter("p_email", OracleDbType.Varchar2)).Value = proveedores.aEMAIL; Cmd.Parameters.Add(new OracleParameter("p_telefono", OracleDbType.Varchar2)).Value = proveedores.aTELEFONO; Cmd.Parameters.Add(new OracleParameter("p_accion", OracleDbType.Varchar2)).Value = pACCION; Cmd.Parameters.Add(new OracleParameter("p_recordset", OracleDbType.RefCursor)).Direction = ParameterDirection.Output; Cmd.ExecuteNonQuery(); Menssage = "Ejecutado con exito"; cerrar_base(); } catch (Exception Ex) { Menssage = Ex.Message; cerrar_base(); throw new Exception(Ex.Message); } return(Menssage); }