public string eliminar_proveedor(DProveedor proveedor)
{
string respuesta = "";
SqlConnection sqlcon = Conexion.conexion();
try
{
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlcon;
sqlcmd.CommandText = "speliminar_proveedor";
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@idproveedor", id_proveedor);
sqlcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
respuesta = ex.Message;
}
return(respuesta);
}
public DataTable buscar_num_documento(DProveedor proveedor)
{
DataTable dt = new DataTable("proveedor");
SqlConnection sqlcon = new SqlConnection();
try
{
sqlcon.ConnectionString = Conexion.cadena;
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlcon;
sqlcmd.CommandText = "spbuscar_proveedor_num_documento";
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@textobuscar", textobuscar);
SqlDataAdapter sqldat = new SqlDataAdapter(sqlcmd);
sqldat.Fill(dt);
}
catch (Exception)
{
dt = null;
}
return(dt);
}