public async Task <UserData> GetUserByEmail(string address)
{
return(await _controller.QuerySingleAsync <UserData>(
"select UserId, FirstName, LastName from CK.vUser where PrimaryEMail = @Address",
new { Address = address }
));
}
public async Task <int> GetAclIdBySchoolId(int idSchool)
{
return(await _controller.QuerySingleAsync <int>("SELECT AclPeriodManagementId FROM IPR.tSchool where SchoolId = @IdSchool ", new { IdSchool = idSchool }));
}