public static IQueryable <LessonTime> GetUnpaidPISession(this PaymentQueryViewModel viewModel, GenericManager <BFDataContext> models)
{
var unpaid = models.FilterByUnpaidLesson();
var items = models.GetTable <LessonTime>()
.Where(r => r.ClassTime < DateTime.Today.AddDays(1))
.Where(r => r.RegisterLesson.LessonPriceType.Status == (int)Naming.DocumentLevelDefinition.自主訓練)
.Where(r => unpaid.Any(l => l.RegisterID == r.RegisterID));
if (viewModel.BranchID.HasValue)
{
items = items.Where(r => r.BranchID == viewModel.BranchID);
}
return(items);
}
public static IQueryable <LessonTime> GetUnpaidTrialSession(this PaymentQueryViewModel viewModel, GenericManager <BFDataContext> models, UserProfile profile)
{
var registerItems = models.PropmptReceivableTrialLesson();
var unpaid = models.FilterByUnpaidLesson(registerItems);
var items = models.GetTable <LessonTime>()
.Where(r => unpaid.Any(l => l.RegisterID == r.RegisterID));
if (profile.IsAssistant() || profile.IsOfficer())
{
}
else
{
items = items
.Where(l => ((l.BranchStore.Status & (int)BranchStore.StatusDefinition.VirtualClassroom) == (int)BranchStore.StatusDefinition.VirtualClassroom &&
l.AttendingCoach == profile.UID) ||
l.BranchID == viewModel.BranchID);
}
return(items);
}
