public bool Login(string username, string password) { bool isValidated = false; NpgsqlCommand sql = new NpgsqlCommand(); sql.CommandText = "SELECT * FROM " + tablename + " WHERE Username = @Username AND Password = @Password"; //sql.Parameters.AddWithValue("@Tablename", tablename); sql.Parameters.AddWithValue("@Username", username); sql.Parameters.AddWithValue("@Password", password); using (PgDb db = new PgDb()) { try { sql.Connection = db.connection; using (NpgsqlDataReader reader = sql.ExecuteReader()) { if (reader.HasRows) { isValidated = true; } } } catch (Exception e) { } } return(isValidated); }
public UserModel GetModelByUsername(string username) { UserModel model = new UserModel(); string query = "select " + defaultFields + " from " + tablename + " WHERE Username = @Username"; using (PgDb db = new PgDb()) { NpgsqlCommand cmd = new NpgsqlCommand(); cmd.CommandText = query; cmd.Parameters.AddWithValue("@Username", username); cmd.Connection = db.connection; using (NpgsqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { model = Fill(reader); } } } return(model); }