public SaveResult InsertOrUpdate(ref QuicklistEntryDTO quickListEntry) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { long entryId = quickListEntry.EntryId; QuicklistEntry dbentry = context.QuicklistEntry.FirstOrDefault(c => c.EntryId == entryId); if (dbentry == null) { // new entity QuicklistEntry entry = _mapper.Map <QuicklistEntry>(quickListEntry); context.QuicklistEntry.Add(entry); context.SaveChanges(); _mapper.Map(entry, quickListEntry); return(SaveResult.Inserted); } else { //existing entity _mapper.Map(quickListEntry, dbentry); context.SaveChanges(); quickListEntry = _mapper.Map <QuicklistEntryDTO>(quickListEntry); // does this line anything? return(SaveResult.Updated); } } } catch (Exception e) { Logger.Log.Error(String.Format(Language.Instance.GetMessageFromKey("UPDATE_ERROR"), e.Message), e); return(SaveResult.Error); } }
public DeleteResult Delete(long characterId, long entryId) { using (OpenNosContext context = DataAccessHelper.CreateContext()) { QuicklistEntry QuicklistEntryItem = context.QuicklistEntry.FirstOrDefault(i => i.CharacterId == characterId && i.EntryId == entryId); if (QuicklistEntryItem != null) { context.QuicklistEntry.Remove(QuicklistEntryItem); context.SaveChanges(); } return(DeleteResult.Deleted); } }