public List <IPresenter> GetPresenters() { using (var db = new RtDataContext(_connectionString)) { return(db.Presenters.Cast <IPresenter>().ToList()); } }
public Guid SaveTalk(ITalk talk) { using (var db = new RtDataContext(_connectionString)) { var dto = db.Talks.FirstOrDefault(t => t.TalkId == talk.TalkId); if (dto == null || talk.TalkId == Guid.Empty) { dto = new TalkDto() { TalkId = Guid.NewGuid() }; db.Talks.InsertOnSubmit(dto); } dto.LocationId = talk.LocationId; dto.PresenterId = talk.PresenterId; dto.Topic = talk.Topic; db.SubmitChanges(); return(dto.TalkId); } }
public List<IPresenter> GetPresenters() { using (var db = new RtDataContext(_connectionString)) { return db.Presenters.Cast<IPresenter>().ToList(); } }
public List <IPresenter> GetPresenters(Func <IPresenter, bool> whereClause) { using (var db = new RtDataContext(_connectionString)) { return(db.Presenters.Where(whereClause).ToList()); } }
public List<IPresenter> GetPresenters(Func<IPresenter, bool> whereClause) { using (var db = new RtDataContext(_connectionString)) { return db.Presenters.Where(whereClause).ToList(); } }
public List <IDetailedTalk> GetTalks(Func <IDetailedTalk, bool> whereClause = null) { using (var db = new RtDataContext(_connectionString)) { var talks = whereClause == null ? db.DetailedTalks : db.DetailedTalks.Where(whereClause); return(talks.ToList()); } }
public List <ILocation> GetLocations(Func <ILocation, bool> whereClause = null) { using (var db = new RtDataContext(_connectionString)) { var locations = whereClause == null ? db.Locations : db.Locations.Where(whereClause); return(locations.ToList()); } }
public List<IDetailedTalk> GetTalks(Func<IDetailedTalk, bool> whereClause = null) { using (var db = new RtDataContext(_connectionString)) { var talks = whereClause == null ? db.DetailedTalks : db.DetailedTalks.Where(whereClause); return talks.ToList(); } }
public List<ILocation> GetLocations(Func<ILocation, bool> whereClause = null) { using (var db = new RtDataContext(_connectionString)) { var locations = whereClause == null ? db.Locations : db.Locations.Where(whereClause); return locations.ToList(); } }
public void DeleteTalk(Guid talkId) { using (var db = new RtDataContext(_connectionString)) { var dto = db.Talks.FirstOrDefault(t => t.TalkId == talkId); if (dto != null) { db.Talks.DeleteOnSubmit(dto); db.SubmitChanges(); } } }
public Guid SaveLocation(ILocation location) { using (var db = new RtDataContext(_connectionString)) { var locationDto = db.Locations.FirstOrDefault(l => l.LocationId == location.LocationId); if (locationDto == null || location.LocationId == Guid.Empty) { locationDto = new LocationDto() { LocationId = Guid.NewGuid() } ; db.Locations.InsertOnSubmit(locationDto); } locationDto.Name = location.Name; db.SubmitChanges(); return locationDto.LocationId; } }
public Guid SavePresenter(IPresenter presenter) { using (var db = new RtDataContext(_connectionString)) { var dto = db.Presenters.FirstOrDefault(p => p.PresenterId == presenter.PresenterId); if (dto == null) { dto = new PresenterDto() {PresenterId = Guid.NewGuid() }; db.Presenters.InsertOnSubmit(dto); } dto.FirstName = presenter.FirstName; dto.LastName = presenter.LastName; db.SubmitChanges(); return dto.PresenterId; } }
public Guid SaveLocation(ILocation location) { using (var db = new RtDataContext(_connectionString)) { var locationDto = db.Locations.FirstOrDefault(l => l.LocationId == location.LocationId); if (locationDto == null || location.LocationId == Guid.Empty) { locationDto = new LocationDto() { LocationId = Guid.NewGuid() }; db.Locations.InsertOnSubmit(locationDto); } locationDto.Name = location.Name; db.SubmitChanges(); return(locationDto.LocationId); } }
public Guid SaveTalk(ITalk talk) { using (var db = new RtDataContext(_connectionString)) { var dto = db.Talks.FirstOrDefault(t => t.TalkId == talk.TalkId); if (dto == null || talk.TalkId == Guid.Empty) { dto = new TalkDto() { TalkId = Guid.NewGuid() }; db.Talks.InsertOnSubmit(dto); } dto.LocationId = talk.LocationId; dto.PresenterId = talk.PresenterId; dto.Topic = talk.Topic; db.SubmitChanges(); return dto.TalkId; } }
public Guid SavePresenter(IPresenter presenter) { using (var db = new RtDataContext(_connectionString)) { var dto = db.Presenters.FirstOrDefault(p => p.PresenterId == presenter.PresenterId); if (dto == null) { dto = new PresenterDto() { PresenterId = Guid.NewGuid() }; db.Presenters.InsertOnSubmit(dto); } dto.FirstName = presenter.FirstName; dto.LastName = presenter.LastName; db.SubmitChanges(); return(dto.PresenterId); } }