private static void CheckDeleteLocation(JobAdsDataContext dc, JobAd jobAd, IHaveDescriptionEntity entity) { var entityLocations = Locations(entity); if (entityLocations == 0) { return; } var locations = Locations(jobAd); // There were locations but they have now been removed. if (locations == 0) { DeleteLocations(dc, entity); } // There were locations but there is now a different number of them. // (shouldn't happen, only one location per job ad is allowed but just in case ...) if (locations > 0 && entityLocations != locations) { DeleteLocations(dc, entity); } }
private static void DeleteIndustries(JobAdsDataContext dc, IHaveDescriptionEntity entity) { // Cannot update in place so delete whatever is already there. if (entity.JobAdIndustryEntities != null && entity.JobAdIndustryEntities.Count > 0) { dc.JobAdIndustryEntities.DeleteAllOnSubmit(entity.JobAdIndustryEntities); } }
private static IEnumerable <Guid> GetRecentOpenJobAdIds(JobAdsDataContext dc, Range range) { if (range.Skip == 0) { return(range.Take != null ? GetRecentOpenJobAdIdsTakeQuery(dc, range) : GetRecentOpenJobAdIdsQuery(dc)); } return(range.Take != null ? GetRecentOpenJobAdIdsSkipTakeQuery(dc, range) : GetRecentOpenJobAdIdsSkipQuery(dc, range)); }
private static void DeleteLocations(JobAdsDataContext dc, IHaveDescriptionEntity entity) { dc.LocationReferenceEntities.DeleteAllOnSubmit(from e in entity.JobAdLocationEntities select e.LocationReferenceEntity); dc.JobAdLocationEntities.DeleteAllOnSubmit(entity.JobAdLocationEntities); entity.JobAdLocationEntities.Clear(); }
private IQueryable <JobAd> GetJobAds(JobAdsDataContext dc, IEnumerable <Guid> ids) { dc.LoadOptions = JobAdLoadOptions; return(GetJobAdsQuery(dc, new SplitList <Guid>(ids).ToString(), _commands)); }
private static IQueryable <JobAdEntry> GetJobAdEntries(JobAdsDataContext dc, IEnumerable <Guid> ids) { dc.LoadOptions = JobAdEntryLoadOptions; return(GetJobAdEntriesQuery(dc, new SplitList <Guid>(ids).ToString())); }
private JobAd GetJobAd(JobAdsDataContext dc, Guid id) { dc.LoadOptions = JobAdLoadOptions; return(GetJobAdQuery(dc, id, _commands)); }
private static JobAdEntry GetJobAdEntry(JobAdsDataContext dc, Guid id) { dc.LoadOptions = JobAdEntryLoadOptions; return(GetJobAdEntryQuery(dc, id)); }