public void excluir(autorDTO dto)
{
SqlCommand cmd = new SqlCommand("delete from tbAutor where codAutor=@cod", con.conectarBD());
cmd.Parameters.Add("@cod", SqlDbType.VarChar).Value = dto.CodAutor;
cmd.ExecuteNonQuery();
con.desconectarBD();
}
public void atualizar(autorDTO dto)
{
SqlCommand cmd = new SqlCommand("update tbAutor set autor=@autor where codAutor=@cod", con.conectarBD());
cmd.Parameters.Add("@cod", SqlDbType.VarChar).Value = dto.CodAutor;
cmd.Parameters.Add("@autor", SqlDbType.VarChar).Value = dto.Autor;
cmd.ExecuteNonQuery();
con.desconectarBD();
}
public void Inserir(autorDTO dto)
{
SqlCommand cmd = new SqlCommand("insert into tbAutor values(@codAutor,@autor)", con.conectarBD());
cmd.Parameters.Add("@codAutor", SqlDbType.VarChar).Value = dto.CodAutor;
cmd.Parameters.Add("@autor", SqlDbType.VarChar).Value = dto.Autor;
cmd.ExecuteNonQuery();
con.desconectarBD();
}
public void BuscarUsuario(autorDTO dto, string txt)
{
SqlCommand cmd = new SqlCommand("Select * from tbAutor where codAutor=@cod", con.conectarBD());
cmd.Parameters.AddWithValue("@cod", dto.CodAutor);
dr = cmd.ExecuteReader();
while (dr.Read())
{
dto.CodAutor = dr[0].ToString();
dto.Autor = dr[1].ToString();
}
con.desconectarBD();
}
