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