private CharacterSkillDTO Insert(CharacterSkillDTO characterSkill, OpenNosContext context) { CharacterSkill entity = _mapper.Map <CharacterSkill>(characterSkill); context.CharacterSkill.Add(entity); context.SaveChanges(); return(_mapper.Map <CharacterSkillDTO>(entity)); }
private CharacterSkillDTO Update(CharacterSkill entity, CharacterSkillDTO characterSkill, OpenNosContext context) { if (entity != null) { _mapper.Map(characterSkill, entity); context.SaveChanges(); } return(_mapper.Map <CharacterSkillDTO>(characterSkill)); }
public DeleteResult Delete(long characterId, short skillVNum) { using (var context = DataAccessHelper.CreateContext()) { CharacterSkill invItem = context.CharacterSkill.FirstOrDefault(i => i.CharacterId == characterId && i.SkillVNum == skillVNum); if (invItem != null) { context.CharacterSkill.Remove(invItem); context.SaveChanges(); } return(DeleteResult.Deleted); } }
private SaveResult InsertOrUpdate(ref CharacterSkillDTO characterSkill, OpenNosContext context) { long characterSkillId = characterSkill.CharacterSkillId; CharacterSkill entity = context.CharacterSkill.FirstOrDefault(i => i.CharacterSkillId == characterSkillId); if (entity == null) //new entity { characterSkill = Insert(characterSkill, context); return(SaveResult.Inserted); } else //existing entity { characterSkill = Update(entity, characterSkill, context); return(SaveResult.Updated); } }