static NoEventSeriesMixin() { NoEventSeries = new EventSeries() { CollectionSeriesID = null, Description = DiversityResources.EventSeries_NoES_Header, ModificationState = ModificationState.Unmodified, SeriesCode = string.Empty, SeriesStart = DateTime.MinValue, SeriesEnd = DateTime.MinValue }; }
public IObservable<Unit> InsertEventSeries(EventSeries series, IEnumerable<ILocalizable> localizations) { var res = InsertESCompleted.FilterByUserState(series) .PipeErrors() .Select(p => p.Result) .StoreMapping(series, Mapping) .ReplayOnlyFirst(); var svcLocs = new ObservableCollection<Svc.Localization>(localizations.Select(l => l.ToServiceObject())); _svc.InsertEventSeriesAsync(series.ToServiceObject(), svcLocs, this.GetCreds(), series); return res; }
public int InsertEventSeries(EventSeries series, IEnumerable<Localization> localizations, UserCredentials login) { using (var db = login.GetConnection()) using (var t = new Transaction(db)) { db.Insert(series); var geoString = SerializeLocalizations(localizations); if (!string.IsNullOrWhiteSpace(geoString)) db.Execute("UPDATE [dbo].[CollectionEventSeries] SET geography=GEOGRAPHY::STGeomFromText(@0, 4326) WHERE SeriesID=@1", geoString, series.CollectionEventSeriesID); t.Complete(); return series.CollectionEventSeriesID; } }
public int InsertEventSeries(EventSeries series, IEnumerable<Localization> localizations, UserCredentials login) { using (var db = login.GetConnection()) using (var t = new Transaction(db)) { db.Insert(series); var geoString = SerializeLocalizations(localizations); if (!string.IsNullOrWhiteSpace(geoString)) db.Execute("Update [dbo].[CollectionEventSeries] Set geography=@0 Where SeriesID=@1", geoString, series.CollectionEventSeriesID); t.Complete(); return series.CollectionEventSeriesID; } }
internal static IQueryable<Localization> GeoPoints(EventSeries es, DiversityDataContext ctx) { return from gp in ctx.GeoTour where gp.RelatedID == es.SeriesID select gp; }
internal static IQueryable<Event> Events(EventSeries es, DiversityDataContext ctx) { return from ev in ctx.Events where ev.SeriesID == es.SeriesID select ev; }
internal static IQueryable<GeoPointForSeries> GeoPoints(EventSeries es, DiversityDataContext ctx) { return from gp in ctx.GeoTour where gp.SeriesID == es.SeriesID select gp; }