public bool Login(User loginModel) { using (IDbConnection con = CreateConnection()) { try { User user = con.Query <User>("select password from users where username = @username", new { username = loginModel.username }).FirstOrDefault(); return(user != null && !string.IsNullOrEmpty(user.password) ? cryptoHelper.VerifyHashedPassword(user.password, loginModel.password) : false); } catch (System.Exception ex) { logger.LogError(ex, "Failed to login user", new { user = JsonConvert.SerializeObject(loginModel) }); return(false); } } }