SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[stp_RegistraProveedor]
@nom AS VARCHAR(50),
@rut AS VARCHAR(50),
@rubro AS VARCHAR(30),
@email AS VARCHAR(20),
@telefono as varchar(20),
@contrasena AS VARCHAR(20),
@pais as int
as
begin
set nocount on
begin transaction
insert into proveedor (nomempresa,rubro,rut_proveedor,telefono,email)
values (@nom,@rut,@rubro,@email,@telefono)
insert into proveedores(id_pais)
values(@pais)
commit transaction
set nocount off
end
try
{
SqlCommand cmd = new SqlCommand("stp_RegistraProveedor", connectionString);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@nom", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@rut", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@rubro", SqlDbType.VarChar, 30);
cmd.Parameters.Add("@email", SqlDbType.VarChar, 20);
cmd.Parameters.Add("@telefono", SqlDbType.VarChar, 20);
cmd.Parameters.Add("@contrasena", SqlDbType.VarChar, 30);
cmd.Parameters.Add("@pais", SqlDbType.Int);
cmd.Parameters["@nom"].Value = txtcontrasenaNuevoProveedor.Text;
cmd.Parameters["@rut"].Value = txtRutNuevoProveedor.Text;
cmd.Parameters["@rubro"].Value = txtcontrasenaNuevoProveedor.Text;
cmd.Parameters["@email"].Value = txtRutNuevoProveedor.Text;
cmd.Parameters["@telefono"].Value = txtcontrasenaNuevoProveedor.Text;
cmd.Parameters["@contrasena"].Value = txtRutNuevoProveedor.Text;
connectionString.Open();
cmd.ExecuteNonQuery();
connectionString.Close();
cargardatos();
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@nom", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@rut", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@rubro", SqlDbType.VarChar, 30);
cmd.Parameters.Add("@email", SqlDbType.VarChar, 20);
cmd.Parameters.Add("@telefono", SqlDbType.VarChar, 20);
cmd.Parameters.Add("@contrasena", SqlDbType.VarChar, 30);
cmd.Parameters.Add("@pais", SqlDbType.Int);
cmd.Parameters["@pais"].Value = ddlPaises.SelectedItem;
cmd.Parameters["@nom"].Value = txtNomEmpresa.Text;
cmd.Parameters["@rut"].Value = txtRutNuevoProveedor.Text;
cmd.Parameters["@rubro"].Value = txtRubroNuevoProveedor.Text;
cmd.Parameters["@email"].Value = txtEmailNuevoProveedor.Text;
cmd.Parameters["@telefono"].Value = txtTelefonoNuevoProveedor.Text;
cmd.Parameters["@contrasena"].Value = txtcontrasenaNuevoProveedor.Text;
cmd.Parameters["@pais"].Value = dropCountries.SelectedItem.Value;