public List <PayGrade> ListPayGrades(string accessToken) { var query = new ListPayGrades_Q { }; var result = _queryDispatcher.Dispatch <ListPayGrades_Q, List <PayGrade> >(accessToken, query); return(result); }
public List <PayGrade> Handle(string accessTokenID, ListPayGrades_Q query) { using (var connection = _connFactory.GetConnection()) { connection.Open(); var sql = @" select pg.ID ,pg.PayGradeName ,pg.PayGradeDisplayName ,pg.PayGradeOrderBy ,pg.PayGradeGroup ,pg.IsActive from People.PayGrades pg order by pg.PayGradeOrderBy "; var res = connection.Query <PayGrade>(sql).ToList(); return(res); } }