public async Task <int> GetTraitContextId(string contextName)
{
return(await _controller.QueryFirstAsync <int>(
"SELECT tc.CKTraitContextId FROM CK.tCKTraitContext tc WHERE tc.ContextName = @contextName",
new { contextName = contextName }
));
}
public async Task <UserData> GetUserByName(string firstName, string lastName)
{
return(await _controller.QueryFirstAsync <UserData>(
"SELECT * FROM CK.tUser u WHERE u.FirstName = @FirstName AND u.LastName = @LastName",
new { FirstName = firstName, LastName = lastName }
));
}
public async Task <GroupData> GetIdSchoolByPeriodId(int zoneId)
{
GroupData data = await _controller.QueryFirstAsync <GroupData>("select * from CK.vZone where ZoneId = @ZoneId", new { ZoneId = zoneId });
return(data);
}