public School GetByIdWithSchoolClasses(Guid id)
{
return(_ctx
.Schools
.Include(x => x.SchoolClasses)
.Where(SchoolQueries.GetByIdWithSchoolClasses(id))
.FirstOrDefault(SchoolQueries.GetById(id)));
}
public async Task <IActionResult> GetSchools()
{
var sqlDatabase = _stObjMap.StObjs.Obtain <SqlDefaultDatabase>();
using (var ctx = new SqlStandardCallContext())
{
SchoolQueries schoolQueries = new SchoolQueries(ctx, sqlDatabase);
List <SchoolData> schools = await schoolQueries.GetAllSchool();
return(Ok(schools));
}
}
public async Task <IActionResult> GetIdSchoolOfUser()
{
int userId = _authenticationInfo.ActualUser.UserId;
var sqlDatabase = _stObjMap.StObjs.Obtain <SqlDefaultDatabase>();
using (var ctx = new SqlStandardCallContext())
{
SchoolQueries schoolQueries = new SchoolQueries(ctx, sqlDatabase);
TimedUserQueries timedUserQueries = new TimedUserQueries(ctx, sqlDatabase);
GroupQueries groupQueries = new GroupQueries(ctx, sqlDatabase);
GroupData groupData = await groupQueries.GetIdSchoolByConnectUser(userId);
if (groupData == null || groupData.ParentZoneId == 0)
{
//if user not in school default by school id In'TECH
// int idSchool = await groupQueries.GetIdSchoolByName( "IN'TECH" );
return(Ok(groupData.ZoneId));
}
return(Ok(groupData.ParentZoneId));
}
}
public School GetById(Guid id)
{
return(_ctx
.Schools
.FirstOrDefault(SchoolQueries.GetById(id)));
}
