public User GetUserByEmail(string email)
{
using var con = _dbConnectionService.GetDatabaseConnectionObject();
string sql = @$ "SELECT * FROM users
WHERE email = '{email}';";
con.Open();
using var cmd = new NpgsqlCommand(sql, con);
using NpgsqlDataReader reader = cmd.ExecuteReader();
return(ParseUser(reader));
}
