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(); }