Code: Select all
var StudentsInfoBasedonTutorialID =( from user in context.aspnet_Users
join enroll in context.EnrollmentEntries
on user.UserId equals enroll.UserId
join enrollbridge in context.EnrollmentEntriesInLearningCarts
on enroll.EnrollmentEntryDatabaseID equals enrollbridge.EnrollmentEntryDatabaseID
join lc in context.LearningCarts
on enrollbridge.LearningCartsDatabaseId equals lc.LearningCartsDatabaseId
join ilcshare in context.ILCSharedResourceDbSet
.Where( o => o.OriginatorLearningCartsDatabaseId == lcOfInterest.LearningCartsDatabaseId && o.ILCResourceDatabaseID == resoucedbid )
on lc.LearningCartsDatabaseId equals ilcshare.RecipientLearningCartsDatabaseId
into shareusergroup from ilcshare in shareusergroup.DefaultIfEmpty()
select new
{
userid = user.UserId,
username = user.UserName,
learningcartid = lc.LearningCartsDatabaseId,
status = ilcshare.Status == null ? ilcshare.Status : 0
}).Where(o => o.status == 0 || o.status == 3 || o.status == 4 ).ToList();