public static Classe_usuario Logar(string nome, string senha)
{
Classe_usuario usuario = new Classe_usuario();
NpgsqlConnection conexao = null;
try
{
conexao = new ConectaDB().getConexao();
//string sql = "SELECT * FROM usuario WHERE nome = '" + nome + "' and senha = '" + senha + "'";
string sql = "SELECT * FROM usuario WHERE nome = 'fael' and senha = '123'";
NpgsqlCommand cmd = new NpgsqlCommand(sql, conexao);
NpgsqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
usuario.nome = dr["nome"].ToString();
usuario.senha = dr["senha"].ToString();
}
conexao.Close();
}
catch (Exception ex)
{
throw new Exception("Erro ao logar. " + ex.Message);
}
return(usuario);
}
private void btnEntrar_Click(object sender, EventArgs e)
{
Classe_usuario usuario = Classe_usuario.Logar(boxUsuario.Text, boxSenha.Text);
this.Hide();
FormMenu ss = new FormMenu();
ss.Show();
}
public void save()
{
Classe_usuario usuario = new Classe_usuario();
NpgsqlConnection conexao = null;
conexao = new ConectaDB().getConexao();
//string sql = "SELECT * FROM usuario WHERE nome = '" + nome + "' and senha = '" + senha + "'";
string sql = "INSERT INTO contratante (nome, email, nascimento, cpf, rg, endereco, complemento, cep, telefone, tel_recado, ncasa) " +
String.Format("values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}' , '{10}')",
this.nome, this.email, this.nascimento.ToString("yyyy-MM-dd"), this.cpf, this.rg, this.endereco, this.complemento, this.cep, this.telefone, this.tel_recado, this.ncasa);
NpgsqlCommand cmd = new NpgsqlCommand(sql, conexao);
cmd.ExecuteNonQuery();
conexao.Close();
}
