private void button1_Click(object sender, EventArgs e)
{
UserCsharp user = new UserCsharp();
UserDao userDao = new UserDao();
user.setNome(textBox1.Text); //seta o nome
user.setEmail(textBox2.Text); // seta o email
userDao.Salvar(user);
textBox1.Text = "";
textBox2.Text = "";
}
}//fim salvar
public UserCsharp Mostrar(long id)
{
string nome;
string email;
bool erroId;
string sql = "select * from userposjava where id = " + id; //comandp select
UserCsharp user = new UserCsharp();
NpgsqlCommand comando = new NpgsqlCommand(sql, conexao.Conectar());
comando.CommandType = CommandType.Text;
NpgsqlDataReader reader;
try
{
reader = comando.ExecuteReader();
if (reader.Read())
{
erroId = false;
user.SetErroId(erroId);
nome = reader[1].ToString();
email = reader[2].ToString();
id = long.Parse(reader[0].ToString());
user.setNome(nome);
user.setEmail(email);
}
else
{
erroId = true;
user.SetErroId(erroId);
}
}
catch (Exception)
{
this.menssagem = "Este Id não existe";
}
return(user);
}//end mostrar
