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