public void Alterar(BruxosDTO rogDTO)
{
query = $"update bruxos set nome = '{rogDTO.Nome}', cpf = '{rogDTO.Cpf}',endereco = '{rogDTO.Endereco}',telefone = '{rogDTO.Telefone}',email = '{rogDTO.Email}' where id = '{rogDTO.Id}';";
conexao.executarComandos(query);
}
public void Delete(BruxosDTO rogDTO)
{
query = $"delete from bruxos where id = '{rogDTO.Id}';";
conexao.executarComandos(query);
}
public void Criar(BruxosDTO rogDTO)
{
query = $"insert into bruxos(id, nome, cpf, endereco, telefone, email, senha) values (null,'{rogDTO.Nome}','{rogDTO.Cpf}','{rogDTO.Endereco}','{rogDTO.Telefone}','{rogDTO.Email}','{rogDTO.Senha}');";
conexao.executarComandos(query);
}