public async Task <IActionResult> FilterCollegeSubjectsSubject(int groupid)
{
var result = from Subject in _ctx.RequestSubjects.AsNoTracking().OrderBy(x => x.RequestDate).Where(s => s.Subject.StudyGroupID == groupid)
join scName in _ctx.Schools on Subject.Subject.SchoolID equals scName.SchoolID into RequestPage
from m in RequestPage.DefaultIfEmpty()
select new
{
RequestID = Subject.RequestID,
ProfileUrlImage = Subject.Owner.ProfileImageUrl,
Firstname = Subject.Owner.FirstName,
Lastname = Subject.Owner.LastName,
Price = Subject.Price,
Sub = Subject.Subject.Name,
Date = Subject.RequestDate,
SchoolName = m.SchoolName
};
return(Ok(await result.AsNoTracking().ToListAsync()));
}
public async Task <IActionResult> RequestCollegeTutorsPage(int page)
{
page = page * 24;
var result = from Tutor in _ctx.Users.AsNoTracking().OrderBy(x => x.SchoolID).Skip(page).Take(24)
join scName in _ctx.Schools on Tutor.SchoolID equals scName.SchoolID into RequestPage
from m in RequestPage.DefaultIfEmpty()
select new
{
TutorID = Tutor.Id,
TutorStudyGroup = Tutor.StudyGroup.StudyGroupName,
TutorStudyField = Tutor.StudyField.StudyFieldName,
ProfileUrlImage = Tutor.ProfileImageUrl,
Firstname = Tutor.FirstName,
Lastname = Tutor.LastName,
SchoolName = m.SchoolName,
SchoolLogoUrl = m.SchoolLogo
};
return(Ok(await result.AsNoTracking().ToListAsync()));
}
public async Task <IActionResult> RequestCollegeSubjectsPage(int page)
{
page = page * 24;
var result = from Subject in _ctx.RequestSubjects.AsNoTracking().OrderBy(x => x.RequestDate).Skip(page).Take(24)
join scName in _ctx.Schools on Subject.Subject.SchoolID equals scName.SchoolID into RequestPage
from m in RequestPage.DefaultIfEmpty()
select new
{
RequestID = Subject.RequestID,
//ProfileUrlImage = Subject.Owner.ProfileImageUrl,
//Firstname = Subject.Owner.FirstName,
//Lastname = Subject.Owner.LastName,
Price = Subject.Price,
Sub = Subject.Subject.Name,
Date = Subject.RequestDate,
SchoolName = m.SchoolName,
SchoolLogoUrl = m.SchoolLogo,
PaymentTimeType = Subject.PayMentTime
};
return(Ok(await result.AsNoTracking().ToListAsync()));
}