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