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);
}
}
