|
public GetStaffEligibleForReview ( ) : IEnumerable |
||
| return | IEnumerable |
|
public IEnumerable<Person> GetStaffEligibleForReview()
{
const string sql = @"where
isCurrentlyEmployed = 1 and
datediff(Year, DateOfJoin, GetDate()) >= 3
and isNewPensionScheme = 1";
var people = database.Query<Person>(sql);
return people;
}
}