public static IQueryable <CourseContract> FilterByUserRoleScope(this IQueryable <CourseContract> items, GenericManager <BFDataContext> models, UserProfile profile)

        {
            if (profile.IsAssistant() || profile.IsOfficer())
            {
                return(items);
            }
            else if (profile.IsManager() || profile.IsViceManager())
            {
                return(models.FilterByBranchStoreManager(items, profile));
            }
            else if (profile.IsCoach())
            {
                return(items.Where(c => c.FitnessConsultant == profile.UID));
            }
            else
            {
                return(items.Where(c => false));
            }
        }
        public static IQueryable <CourseContractRevision> FilterByUserRoleScope(this IQueryable <CourseContractRevision> items, GenericManager <BFDataContext> models, UserProfile profile)

        {
            if (profile.IsManager() || profile.IsViceManager())
            {
                items = items.Join(models.FilterByBranchStoreManager(models.GetTable <CourseContract>(), profile),
                                   r => r.OriginalContract, c => c.ContractID, (r, c) => r);
            }
            else if (profile.IsAssistant() || profile.IsOfficer())
            {
            }
            else if (profile.IsCoach())
            {
                items = items.Where(c => c.CourseContract.FitnessConsultant == profile.UID);
            }
            else
            {
                items = items.Where(c => false);
            }

            return(items);
        }