public DeleteResult Delete(long familyId)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Family Fam = context.Family.FirstOrDefault(c => c.FamilyId == familyId);
if (Fam != null)
{
context.Family.Remove(Fam);
context.SaveChanges();
}
return(DeleteResult.Deleted);
}
}
catch (Exception e)
{
Logger.Error(string.Format(Language.Instance.GetMessageFromKey("DELETE_ERROR"), familyId, e.Message), e);
return(DeleteResult.Error);
}
}
public DeleteResult DeleteByMonsterVNum(short monsterVNum)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
IEnumerable <BCard> bCards = context.BCard.Where(s => s.NpcMonsterVNum == monsterVNum);
foreach (BCard bcard in bCards)
{
context.BCard.Remove(bcard);
}
context.SaveChanges();
return(DeleteResult.Deleted);
}
}
catch (Exception e)
{
Logger.Error(e);
return(DeleteResult.Error);
}
}
public AccountDTO LoadById(long accountId)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Account account = context.Account.FirstOrDefault(a => a.AccountId.Equals(accountId));
if (account != null)
{
AccountDTO accountDTO = new AccountDTO();
if (Mapper.Mapper.Instance.AccountMapper.ToAccountDTO(account, accountDTO))
{
return(accountDTO);
}
}
}
}
catch (Exception e)
{
Logger.Error(e);
}
return(null);
}
public DeleteResult DeleteById(long mailId)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Mail mail = context.Mail.First(i => i.MailId.Equals(mailId));
if (mail != null)
{
context.Mail.Remove(mail);
context.SaveChanges();
}
return(DeleteResult.Deleted);
}
}
catch (Exception e)
{
Logger.Error(e);
return(DeleteResult.Error);
}
}
public DeleteResult Delete(long accountId)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Account account = context.Account.FirstOrDefault(c => c.AccountId.Equals(accountId));
if (account != null)
{
context.Account.Remove(account);
context.SaveChanges();
}
return(DeleteResult.Deleted);
}
}
catch (Exception e)
{
Logger.Error(string.Format(Language.Instance.GetMessageFromKey("DELETE_ACCOUNT_ERROR"), accountId, e.Message), e);
return(DeleteResult.Error);
}
}
public DeleteResult DeleteById(int itemId)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
ShopItem Item = context.ShopItem.FirstOrDefault(i => i.ShopItemId.Equals(itemId));
if (Item != null)
{
context.ShopItem.Remove(Item);
context.SaveChanges();
}
return(DeleteResult.Deleted);
}
}
catch (Exception e)
{
Logger.Error(e);
return(DeleteResult.Error);
}
}
public DeleteResult Delete(long bazaarItemId)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
BazaarItem BazaarItem = context.BazaarItem.FirstOrDefault(c => c.BazaarItemId.Equals(bazaarItemId));
if (BazaarItem != null)
{
context.BazaarItem.Remove(BazaarItem);
context.SaveChanges();
}
return(DeleteResult.Deleted);
}
}
catch (Exception e)
{
Logger.Error(string.Format(Language.Instance.GetMessageFromKey("DELETE_ERROR"), bazaarItemId, e.Message), e);
return(DeleteResult.Error);
}
}
public DeleteResult DeleteById(int mapNpcId)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
MapNpc npc = context.MapNpc.First(i => i.MapNpcId.Equals(mapNpcId));
if (npc != null)
{
context.MapNpc.Remove(npc);
context.SaveChanges();
}
return(DeleteResult.Deleted);
}
}
catch (Exception e)
{
Logger.Error(e);
return(DeleteResult.Error);
}
}
public SkillDTO Insert(SkillDTO skill)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Skill entity = new Skill();
Mapper.Mapper.Instance.SkillMapper.ToSkill(skill, entity); context.Skill.Add(entity);
context.SaveChanges();
if (Mapper.Mapper.Instance.SkillMapper.ToSkillDTO(entity, skill))
{
return(skill);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public DeleteResult Delete(long characterRelationId)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
CharacterRelation relation = context.CharacterRelation.SingleOrDefault(c => c.CharacterRelationId.Equals(characterRelationId));
if (relation != null)
{
context.CharacterRelation.Remove(relation);
context.SaveChanges();
}
return(DeleteResult.Deleted);
}
}
catch (Exception e)
{
Logger.Error(string.Format(Language.Instance.GetMessageFromKey("DELETE_CHARACTER_ERROR"), characterRelationId, e.Message), e);
return(DeleteResult.Error);
}
}
public SaveResult InsertOrUpdate(ref CharacterDTO character)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
long characterId = character.CharacterId;
Character entity = context.Character.FirstOrDefault(c => c.CharacterId.Equals(characterId));
if (entity == null)
{
character = insert(character, context);
return(SaveResult.Inserted);
}
character = update(entity, character, context);
return(SaveResult.Updated);
}
}
catch (Exception e)
{
Logger.Error(string.Format(Language.Instance.GetMessageFromKey("INSERT_ERROR"), character, e.Message), e);
return(SaveResult.Error);
}
}
public DeleteResult DeleteGuidList(IEnumerable <Guid> guids)
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
try
{
foreach (Guid id in guids)
{
ItemInstance entity = context.ItemInstance.FirstOrDefault(i => i.Id == id);
if (entity != null)
{
context.ItemInstance.Remove(entity);
}
}
context.SaveChanges();
}
catch
{
foreach (Guid id in guids)
{
try
{
Delete(id);
}
catch (Exception ex)
{
// TODO: Work on: statement conflicted with the REFERENCE constraint
// "FK_dbo.BazaarItem_dbo.ItemInstance_ItemInstanceId". The
// conflict occurred in database "opennos", table "dbo.BazaarItem",
// column 'ItemInstanceId'.
Logger.LogUserEventError("ONSAVEDELETION_EXCEPTION", "Saving Process", $"Detailed Item Information: Item ID = {id}", ex);
}
}
}
return(DeleteResult.Deleted);
}
}
public ComboDTO Insert(ComboDTO combo)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Combo entity = new Combo();
Mapper.Mapper.Instance.ComboMapper.ToCombo(combo, entity);
context.Combo.Add(entity);
context.SaveChanges();
if (Mapper.Mapper.Instance.ComboMapper.ToComboDTO(entity, combo))
{
return(combo);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public DeleteResult DeleteByPrimaryKey(long accountId, byte characterSlot)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
// actually a Character wont be deleted, it just will be disabled for future traces
Character character = context.Character.SingleOrDefault(c => c.AccountId.Equals(accountId) && c.Slot.Equals(characterSlot) && c.State.Equals((byte)CharacterState.Active));
if (character != null)
{
character.State = (byte)CharacterState.Inactive;
context.SaveChanges();
}
return(DeleteResult.Deleted);
}
}
catch (Exception e)
{
Logger.Error(string.Format(Language.Instance.GetMessageFromKey("DELETE_CHARACTER_ERROR"), characterSlot, e.Message), e);
return(DeleteResult.Error);
}
}
public MaintenanceLogDTO Insert(MaintenanceLogDTO maintenanceLog)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
MaintenanceLog entity = new MaintenanceLog();
Mapper.Mappers.MaintenanceLogMapper.ToMaintenanceLog(maintenanceLog, entity);
context.MaintenanceLog.Add(entity);
context.SaveChanges();
if (Mapper.Mappers.MaintenanceLogMapper.ToMaintenanceLogDTO(entity, maintenanceLog))
{
return(maintenanceLog);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public SaveResult InsertOrUpdate(ref AccountDTO account)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
long accountId = account.AccountId;
Account entity = context.Account.FirstOrDefault(c => c.AccountId.Equals(accountId));
if (entity == null)
{
account = insert(account, context);
return SaveResult.Inserted;
}
account = update(entity, account, context);
return SaveResult.Updated;
}
}
catch (Exception e)
{
Logger.Error(string.Format(Language.Instance.GetMessageFromKey("UPDATE_ACCOUNT_ERROR"), account.AccountId, e.Message), e);
return SaveResult.Error;
}
}
public ScriptedInstanceDTO Insert(ScriptedInstanceDTO scriptedInstance)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
ScriptedInstance entity = new ScriptedInstance();
Mapper.Mappers.ScriptedInstanceMapper.ToScriptedInstance(scriptedInstance, entity);
context.ScriptedInstance.Add(entity);
context.SaveChanges();
if (Mapper.Mappers.ScriptedInstanceMapper.ToScriptedInstanceDTO(entity, scriptedInstance))
{
return(scriptedInstance);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public GeneralLogDTO Insert(GeneralLogDTO generalLog)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
GeneralLog entity = new GeneralLog();
Mapper.Mappers.GeneralLogMapper.ToGeneralLog(generalLog, entity);
context.GeneralLog.Add(entity);
context.SaveChanges();
if (Mapper.Mappers.GeneralLogMapper.ToGeneralLogDTO(entity, generalLog))
{
return(generalLog);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public NpcMonsterDTO Insert(NpcMonsterDTO npc)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
NpcMonster entity = new NpcMonster();
Mapper.Mappers.NpcMonsterMapper.ToNpcMonster(npc, entity);
context.NpcMonster.Add(entity);
context.SaveChanges();
if (Mapper.Mappers.NpcMonsterMapper.ToNpcMonsterDTO(entity, npc))
{
return(npc);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public SaveResult InsertOrUpdate(ref MinigameLogDTO minigameLog)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
long minigameLogId = minigameLog.MinigameLogId;
MinigameLog entity = context.MinigameLog.FirstOrDefault(c => c.MinigameLogId.Equals(minigameLogId));
if (entity == null)
{
minigameLog = insert(minigameLog, context);
return(SaveResult.Inserted);
}
minigameLog = update(entity, minigameLog, context);
return(SaveResult.Updated);
}
}
catch (Exception e)
{
Logger.Error(e);
return(SaveResult.Error);
}
}
public ItemDTO Insert(ItemDTO item)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Item entity = new Item();
Mapper.Mappers.ItemMapper.ToItem(item, entity);
context.Item.Add(entity);
context.SaveChanges();
if (Mapper.Mappers.ItemMapper.ToItemDTO(entity, item))
{
return(item);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public BCardDTO Insert(ref BCardDTO cardObject)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
BCard entity = new BCard();
Mapper.Mapper.Instance.BCardMapper.ToBCard(cardObject, entity);
context.BCard.Add(entity);
context.SaveChanges();
if (Mapper.Mapper.Instance.BCardMapper.ToBCardDTO(entity, cardObject))
{
return(cardObject);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public CardDTO Insert(ref CardDTO card)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Card entity = new Card();
Mapper.Mappers.CardMapper.ToCard(card, entity);
context.Card.Add(entity);
context.SaveChanges();
if (Mapper.Mappers.CardMapper.ToCardDTO(entity, card))
{
return(card);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public NpcMonsterSkillDTO Insert(ref NpcMonsterSkillDTO npcMonsterSkill)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
NpcMonsterSkill entity = new NpcMonsterSkill();
Mapper.Mapper.Instance.NpcMonsterSkillMapper.ToNpcMonsterSkill(npcMonsterSkill, entity);
context.NpcMonsterSkill.Add(entity);
context.SaveChanges();
if (Mapper.Mapper.Instance.NpcMonsterSkillMapper.ToNpcMonsterSkillDTO(entity, npcMonsterSkill))
{
return(npcMonsterSkill);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public RecipeDTO Insert(RecipeDTO recipe)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Recipe entity = new Recipe();
Mapper.Mappers.RecipeMapper.ToRecipe(recipe, entity);
context.Recipe.Add(entity);
context.SaveChanges();
if (Mapper.Mappers.RecipeMapper.ToRecipeDTO(entity, recipe))
{
return(recipe);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public SaveResult InsertOrUpdate(ref GeneralLogDTO GeneralLog)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
long LogId = GeneralLog.LogId;
GeneralLog entity = context.GeneralLog.FirstOrDefault(c => c.LogId.Equals(LogId));
if (entity == null)
{
GeneralLog = insert(GeneralLog, context);
return(SaveResult.Inserted);
}
GeneralLog = update(entity, GeneralLog, context);
return(SaveResult.Updated);
}
}
catch (Exception e)
{
Logger.Error(string.Format(Language.Instance.GetMessageFromKey("UPDATE_GeneralLog_ERROR"), GeneralLog.LogId, e.Message), e);
return(SaveResult.Error);
}
}
public PortalDTO Insert(PortalDTO portal)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Portal entity = new Portal();
Mapper.Mappers.PortalMapper.ToPortal(portal, entity);
context.Portal.Add(entity);
context.SaveChanges();
if (Mapper.Mappers.PortalMapper.ToPortalDTO(entity, portal))
{
return(portal);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public TeleporterDTO Insert(TeleporterDTO teleporter)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
Teleporter entity = new Teleporter();
Mapper.Mapper.Instance.TeleporterMapper.ToTeleporter(teleporter, entity);
context.Teleporter.Add(entity);
context.SaveChanges();
if (Mapper.Mapper.Instance.TeleporterMapper.ToTeleporterDTO(entity, teleporter))
{
return(teleporter);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public MapMonsterDTO Insert(MapMonsterDTO mapMonster)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
MapMonster entity = new MapMonster();
Mapper.Mappers.MapMonsterMapper.ToMapMonster(mapMonster, entity);
context.MapMonster.Add(entity);
context.SaveChanges();
if (Mapper.Mappers.MapMonsterMapper.ToMapMonsterDTO(entity, mapMonster))
{
return(mapMonster);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
public MapTypeDTO Insert(ref MapTypeDTO mapType)
{
try
{
using (OpenNosContext context = DataAccessHelper.CreateContext())
{
MapType entity = new MapType();
Mapper.Mapper.Instance.MapTypeMapper.ToMapType(mapType, entity);
context.MapType.Add(entity);
context.SaveChanges();
if (Mapper.Mapper.Instance.MapTypeMapper.ToMapTypeDTO(entity, mapType))
{
return(mapType);
}
return(null);
}
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
