public ISessionCategory Add(ISessionCategory entity)
{
using (var conn = new SQLiteConnection(Database.DatabasePath))
{
using (var context = new DatabaseContext(conn))
{
context.SessionCategory.Add((SessionCategory)entity);
context.SaveChanges();
}
}
return(entity);
}
public ISessionCategory FindBySessionIdAndCategoryId(int sessionId, int categoryId)
{
ISessionCategory result = null;
using (var conn = new SQLiteConnection(Database.DatabasePath))
{
using (var context = new DatabaseContext(conn))
{
result = context.SessionCategory.FirstOrDefault(x => x.SessionId == sessionId && x.CategoryId == categoryId);
}
}
return(result);
}
public void Update(ISessionCategory entity)
{
using (var conn = new SQLiteConnection(Database.DatabasePath))
{
using (var context = new DatabaseContext(conn))
{
var sessionCategory = context.SessionCategory.FirstOrDefault(x => x.Id == entity.Id);
if (sessionCategory != null)
{
context.Entry(sessionCategory).CurrentValues.SetValues(entity);
context.SaveChanges();
}
}
}
}
