public ISpeakerVideo Add(ISpeakerVideo entity)
{
using (var conn = new SQLiteConnection(Database.DatabasePath))
{
using (var context = new DatabaseContext(conn))
{
context.SpeakerVideo.Add((SpeakerVideo)entity);
context.SaveChanges();
}
}
return(entity);
}
public ISpeakerVideo FindBySpeakerIdAndVideoId(int speakerId, int videoId)
{
ISpeakerVideo result = null;
using (var conn = new SQLiteConnection(Database.DatabasePath))
{
using (var context = new DatabaseContext(conn))
{
result = context.SpeakerVideo.FirstOrDefault(x => x.SpeakerId == speakerId && x.VideoId == videoId);
}
}
return(result);
}
public void Update(ISpeakerVideo entity)
{
using (var conn = new SQLiteConnection(Database.DatabasePath))
{
using (var context = new DatabaseContext(conn))
{
var session = context.SpeakerVideo.FirstOrDefault(x => x.Id == entity.Id);
if (session != null)
{
context.Entry(session).CurrentValues.SetValues(entity);
context.SaveChanges();
}
}
}
}
