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 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 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); } }