public RepositoryActionResult<Conference> InsertConference(Conference e) { try { _ctx.Conferences.Add(e); var result = _ctx.SaveChanges(); if (result > 0) { return new RepositoryActionResult<Conference>(e, RepositoryActionStatus.Created); } else { return new RepositoryActionResult<Conference>(e, RepositoryActionStatus.NothingModified, null); } } catch (Exception ex) { return new RepositoryActionResult<Conference>(null, RepositoryActionStatus.Error, ex); } }
public RepositoryActionResult<Conference> UpdateConference(Conference e) { try { // you can only update when an expense already exists for this id var existingExpense = _ctx.Conferences.FirstOrDefault(exp => exp.Id == e.Id); if (existingExpense == null) { return new RepositoryActionResult<Conference>(e, RepositoryActionStatus.NotFound); } // change the original entity status to detached; otherwise, we get an error on attach // as the entity is already in the dbSet // set original entity state to detached _ctx.Entry(existingExpense).State = EntityState.Detached; // attach & save _ctx.Conferences.Attach(e); // set the updated entity state to modified, so it gets updated. _ctx.Entry(e).State = EntityState.Modified; var result = _ctx.SaveChanges(); if (result > 0) { return new RepositoryActionResult<Conference>(e, RepositoryActionStatus.Updated); } else { return new RepositoryActionResult<Conference>(e, RepositoryActionStatus.NothingModified, null); } } catch (Exception ex) { return new RepositoryActionResult<Conference>(null, RepositoryActionStatus.Error, ex); } }