USE TareaBD
GO
CREATE PROCEDURE [dbo].[eliminarCliente]
 -- Add the parameters for the stored procedure here
 @rut int
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 DELETE FROM Cliente WHERE rut = @rut
END
GO
CREATE PROCEDURE [dbo].[buquedaProducto]
 -- Add the parameters for the stored procedure here
 @descr varchar(100)
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 SELECT *
 FROM Producto
 WHERE descripcion LIKE @descr
END
GO

CREATE PROCEDURE [dbo].[insertarCliente]
 -- Add the parameters for the stored procedure here
 @rut int,
 @nombre varchar(100),
 @apaterno varchar(50),
 @amaterno varchar(50),
 @calle varchar(50) = '',
 @numero int = '',
 @comuna varchar(50),
 @ciudad varchar(50),
 @telefono int = '',
 @email varchar(50) = ''
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 INSERT INTO [TareaBD].[dbo].[Cliente]
       ([rut],[nombre],[apaterno],[amaterno],
        [calle],[numero],[comuna],[ciudad],
        [telefono],[e_mail]) 
 VALUES(@rut,@nombre,@apaterno,@amaterno,@calle,@numero,@comuna,@ciudad,@telefono,@email)
END
-- exec dbo.insertarCliente @rut = 17990424,@nombre = 'prueba',@apaterno = 'zapata',@amaterno = 'barra',@comuna = 'prueba', @ciudad = 'CiudadPrueba'
-- Los parametros que no se ingresan los deja en blanco si en un varchar y en 0 si es un int
GO

CREATE PROCEDURE [dbo].[buscarCliente]
 -- Add the parameters for the stored procedure here
 @rut int
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 SELECT [rut],[nombre],[apaterno],[amaterno] ,[calle],
   [numero],[comuna],[ciudad],[telefono],[e_mail]
 FROM [TareaBD].[dbo].[Cliente]
 WHERE rut = @rut
END
GO

CREATE PROCEDURE [dbo].[listarProductos]
 -- Add the parameters for the stored procedure here
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 SELECT [codigo],[descripcion],[precio_compra],[precio_venta],
   [stock],[id_categoria]
 FROM [TareaBD].[dbo].[Producto]
END
GO
GO

CREATE PROCEDURE [dbo].[vendedoresPorApellido]
 -- Add the parameters for the stored procedure here
 @apaterno varchar(50)
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 SELECT [rut],[nombre],[apaterno],[amaterno],[fecha_nacimiento],[fecha_ingreso],[id_oficina]
 FROM [TareaBD].[dbo].[Vendedor]
 WHERE Vendedor.apaterno = @apaterno
END
GO

CREATE PROCEDURE [dbo].[vendedoresPorNombre]
 -- Add the parameters for the stored procedure here
 @nombre varchar(50)
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 SELECT [rut],[nombre],[apaterno],[amaterno],[fecha_nacimiento],[fecha_ingreso],[id_oficina]
 FROM [TareaBD].[dbo].[Vendedor]
 WHERE Vendedor.nombre = @nombre
END
GO

CREATE PROCEDURE [dbo].[listarVendedores]
 -- Add the parameters for the stored procedure here
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 SELECT [rut],[nombre],[apaterno],[amaterno],[fecha_nacimiento],[fecha_ingreso],[id_oficina]
 FROM [TareaBD].[dbo].[Vendedor]
END
GO