public SaveResult InsertOrUpdate(ref QuestLogDTO quest) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { long questId = quest.QuestId; long characterId = quest.CharacterId; QuestLog entity = context.QuestLog.FirstOrDefault(c => c.QuestId.Equals(questId) && c.CharacterId.Equals(characterId)); if (entity == null) { quest = Insert(quest, context); return(SaveResult.Inserted); } quest.QuestId = entity.QuestId; quest = Update(entity, quest, context); return(SaveResult.Updated); } } catch (Exception e) { Logger.Error(e); return(SaveResult.Error); } }
public void InsertQuestLog(long characterId, string ipAddress, long questId, DateTime lastDaily) { var log = new QuestLogDTO { CharacterId = characterId, IpAddress = ipAddress, QuestId = questId, LastDaily = lastDaily }; DAOFactory.QuestLogDAO.InsertOrUpdate(ref log); }
public static bool ToQuestLog(QuestLogDTO input, QuestLog output) { if (input == null) { return(false); } output.CharacterId = input.CharacterId; output.QuestId = input.QuestId; output.IpAddress = input.IpAddress; output.LastDaily = input.LastDaily; return(true); }
public IEnumerable <QuestLogDTO> LoadByCharacterId(long characterId) { using (OpenNosContext context = DataAccessHelper.CreateContext()) { List <QuestLogDTO> result = new List <QuestLogDTO>(); foreach (QuestLog questLog in context.QuestLog.Where(s => s.CharacterId == characterId)) { QuestLogDTO dto = new QuestLogDTO(); Mapper.Mappers.QuestLogMapper.ToQuestLogDTO(questLog, dto); result.Add(dto); } return(result); } }
public QuestLogDTO Update(QuestLog old, QuestLogDTO replace, OpenNosContext context) { if (old != null) { Mapper.Mappers.QuestLogMapper.ToQuestLog(replace, old); context.Entry(old).State = EntityState.Modified; context.SaveChanges(); } if (Mapper.Mappers.QuestLogMapper.ToQuestLogDTO(old, replace)) { return(replace); } return(null); }
public QuestLogDTO LoadById(long id) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { QuestLogDTO dto = new QuestLogDTO(); if (Mapper.Mappers.QuestLogMapper.ToQuestLogDTO(context.QuestLog.FirstOrDefault(i => i.Id.Equals(id)), dto)) { return(dto); } return(null); } } catch (Exception e) { Logger.Error(e); return(null); } }
public QuestLogDTO Insert(QuestLogDTO questLog, OpenNosContext context) { try { QuestLog entity = new QuestLog(); Mapper.Mappers.QuestLogMapper.ToQuestLog(questLog, entity); context.QuestLog.Add(entity); context.SaveChanges(); if (Mapper.Mappers.QuestLogMapper.ToQuestLogDTO(entity, questLog)) { return(questLog); } return(null); } catch (Exception e) { Logger.Error(e); return(null); } }