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