public SaveResult InsertOrUpdate(ref StaticBuffDTO staticBuff) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { long id = staticBuff.CharacterId; short cardid = staticBuff.CardId; StaticBuff entity = context.StaticBuff.FirstOrDefault(c => c.CardId == cardid && c.CharacterId == id); if (entity == null) { staticBuff = Insert(staticBuff, context); return(SaveResult.Inserted); } staticBuff.StaticBuffId = entity.StaticBuffId; staticBuff = Update(entity, staticBuff, context); return(SaveResult.Updated); } } catch (Exception e) { Logger.Error(e); return(SaveResult.Error); } }
public static bool ToStaticBuffDTO(StaticBuff input, StaticBuffDTO output) { if (input == null) { return(false); } output.CardId = input.CardId; output.CharacterId = input.CharacterId; output.RemainingTime = input.RemainingTime; output.StaticBuffId = input.StaticBuffId; return(true); }
public IEnumerable <StaticBuffDTO> LoadByCharacterId(long characterId) { using (OpenNosContext context = DataAccessHelper.CreateContext()) { List <StaticBuffDTO> result = new List <StaticBuffDTO>(); foreach (StaticBuff entity in context.StaticBuff.AsNoTracking().Where(i => i.CharacterId == characterId)) { StaticBuffDTO dto = new StaticBuffDTO(); Mapper.Mappers.StaticBuffMapper.ToStaticBuffDTO(entity, dto); result.Add(dto); } return(result); } }
private static StaticBuffDTO Update(StaticBuff entity, StaticBuffDTO sb, OpenNosContext context) { if (entity != null) { Mapper.Mappers.StaticBuffMapper.ToStaticBuff(sb, entity); context.SaveChanges(); } if (Mapper.Mappers.StaticBuffMapper.ToStaticBuffDTO(entity, sb)) { return(sb); } return(null); }
public static StaticBuffDTO LoadById(long sbId) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { StaticBuffDTO dto = new StaticBuffDTO(); if (Mapper.Mappers.StaticBuffMapper.ToStaticBuffDTO(context.StaticBuff.AsNoTracking().FirstOrDefault(s => s.StaticBuffId.Equals(sbId)), dto)) //who the f**k was so retarded and set it to respawn ?!? { return(dto); } return(null); } } catch (Exception e) { Logger.Error(e); return(null); } }
private static StaticBuffDTO Insert(StaticBuffDTO sb, OpenNosContext context) { try { StaticBuff entity = new StaticBuff(); Mapper.Mappers.StaticBuffMapper.ToStaticBuff(sb, entity); context.StaticBuff.Add(entity); context.SaveChanges(); if (Mapper.Mappers.StaticBuffMapper.ToStaticBuffDTO(entity, sb)) { return(sb); } return(null); } catch (Exception e) { Logger.Error(e); return(null); } }