public void Insert(List <ShopDTO> shops) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (ShopDTO item in shops) { Shop entity = new Shop(); Mapper.Mappers.ShopMapper.ToShop(item, entity); context.Shop.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public DeleteResult DeleteByEquipmentSerialId(Guid id) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { List <CellonOption> deleteentities = context.CellonOption.Where(s => s.EquipmentSerialId == id).ToList(); if (deleteentities.Count != 0) { context.CellonOption.RemoveRange(deleteentities); context.SaveChanges(); } return(DeleteResult.Deleted); } } catch (Exception e) { Logger.Error(string.Format(Language.Instance.GetMessageFromKey("DELETE_ERROR"), id, e.Message), e); return(DeleteResult.Error); } }
public void Insert(List <DropDTO> drops) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (DropDTO drop in drops) { Drop entity = new Drop(); Mapper.Mappers.DropMapper.ToDrop(drop, entity); context.Drop.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public void Insert(List <MapTypeMapDTO> mapTypeMaps) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (MapTypeMapDTO mapTypeMap in mapTypeMaps) { MapTypeMap entity = new MapTypeMap(); Mapper.Mapper.Instance.MapTypeMapMapper.ToMapTypeMap(mapTypeMap, entity); context.MapTypeMap.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public void Insert(List <ComboDTO> combos) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (ComboDTO combo in combos) { Combo entity = new Combo(); Mapper.Mapper.Instance.ComboMapper.ToCombo(combo, entity); context.Combo.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public void Insert(List <RespawnMapTypeDTO> respawnMapTypes) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (RespawnMapTypeDTO RespawnMapType in respawnMapTypes) { RespawnMapType entity = new RespawnMapType(); Mapper.Mapper.Instance.RespawnMapTypeMapper.ToRespawnMapType(RespawnMapType, entity); context.RespawnMapType.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
private static CharacterRelationDTO update(CharacterRelation entity, CharacterRelationDTO relation, OpenNosContext context) { if (entity != null) { try { Mapper.Mappers.CharacterRelationMapper.ToCharacterRelation(relation, entity); context.SaveChanges(); } catch (InvalidOperationException ex) { Logger.Warn($"The Character Relation with ID:{relation.CharacterRelationId} is Wrong! Error:{ex.Message}"); } } if (Mapper.Mappers.CharacterRelationMapper.ToCharacterRelationDTO(entity, relation)) { return(relation); } return(null); }
public void Insert(List <NpcMonsterDTO> npcMonsters) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (NpcMonsterDTO item in npcMonsters) { NpcMonster entity = new NpcMonster(); Mapper.Mappers.NpcMonsterMapper.ToNpcMonster(item, entity); context.NpcMonster.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
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 { return(DeleteResult.Error); } }
public void Insert(IEnumerable <MapMonsterDTO> mapMonsters) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (MapMonsterDTO monster in mapMonsters) { MapMonster entity = new MapMonster(); Mapper.Mappers.MapMonsterMapper.ToMapMonster(monster, entity); context.MapMonster.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public void Insert(List <BCardDTO> cards) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (BCardDTO card in cards) { BCard entity = new BCard(); Mapper.Mapper.Instance.BCardMapper.ToBCard(card, entity); context.BCard.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public void Insert(List <MapNpcDTO> npcs) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (MapNpcDTO Item in npcs) { MapNpc entity = new MapNpc(); Mapper.Mappers.MapNpcMapper.ToMapNpc(Item, entity); context.MapNpc.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public void Insert(List <QuestObjectiveDTO> quests) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (QuestObjectiveDTO quest in quests) { QuestObjective entity = new QuestObjective(); Mapper.Mappers.QuestObjectiveMapper.ToQuestObjective(quest, entity); context.QuestObjective.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public DeleteResult DeleteGuidList(IEnumerable <Guid> guids) { using (OpenNosContext context = DataAccessHelper.CreateContext()) { Guid[] enumerable = guids as Guid[] ?? guids.ToArray(); try { foreach (Guid id in enumerable) { ItemInstance entity = context.ItemInstance.FirstOrDefault(i => i.Id == id); if (entity != null && entity.Type != InventoryType.FamilyWareHouse) { context.ItemInstance.Remove(entity); } } context.SaveChanges(); } catch (Exception ex) { Logger.LogUserEventError("DELETEGUIDLIST_EXCEPTION", "Saving Process", "Items were not deleted!", ex); foreach (Guid id in enumerable) { try { Delete(id); } catch (Exception exc) { // 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", $"FALLBACK FUNCTION FAILED! Detailed Item Information: Item ID = {id}", exc); } } } return(DeleteResult.Deleted); } }
public void Insert(List <ScriptedInstanceDTO> scriptedInstances) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (ScriptedInstanceDTO scriptedInstance in scriptedInstances) { ScriptedInstance entity = new ScriptedInstance(); Mapper.Mapper.Instance.ScriptedInstanceMapper.ToScriptedInstance(scriptedInstance, entity); context.ScriptedInstance.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public DeleteResult Delete(long id) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { Mate mate = context.Mate.FirstOrDefault(c => c.MateId.Equals(id)); if (mate != null) { context.Mate.Remove(mate); context.SaveChanges(); } return(DeleteResult.Deleted); } } catch (Exception e) { Logger.Error(string.Format(Language.Instance.GetMessageFromKey("DELETE_MATE_ERROR"), e.Message), e); return(DeleteResult.Error); } }
public void Insert(List <SkillDTO> skills) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (SkillDTO skill in skills) { Skill entity = new Skill(); Mapper.Mappers.SkillMapper.ToSkill(skill, entity); context.Skill.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public void Insert(List <PortalDTO> portals) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { context.Configuration.AutoDetectChangesEnabled = false; foreach (PortalDTO item in portals) { Portal entity = new Portal(); Mapper.Mappers.PortalMapper.ToPortal(item, entity); context.Portal.Add(entity); } context.Configuration.AutoDetectChangesEnabled = true; context.SaveChanges(); } } catch (Exception e) { Logger.Error(e); } }
public DeleteResult DeleteById(long id) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { Quest deleteEntity = context.Quest.Find(id); if (deleteEntity != null) { context.Quest.Remove(deleteEntity); context.SaveChanges(); } return(DeleteResult.Deleted); } } catch (Exception e) { Logger.Error(string.Format(Language.Instance.GetMessageFromKey("DELETE_ERROR"), id, e.Message), e); return(DeleteResult.Error); } }
private MailDTO insert(MailDTO mail, OpenNosContext context) { try { Mail entity = new Mail(); Mapper.Mapper.Instance.MailMapper.ToMail(mail, entity); context.Mail.Add(entity); context.SaveChanges(); if (Mapper.Mapper.Instance.MailMapper.ToMailDTO(entity, mail)) { return(mail); } return(null); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException Logger.Error(new InvalidOperationException(message, raise)); } } return(null); } catch (Exception e) { Logger.Error(e); return(null); } }
public DeleteResult DeleteById(int mapMonsterId) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { MapMonster monster = context.MapMonster.First(i => i.MapMonsterId.Equals(mapMonsterId)); if (monster != null) { context.MapMonster.Remove(monster); 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.Mappers.SkillMapper.ToSkill(skill, entity); context.Skill.Add(entity); context.SaveChanges(); if (Mapper.Mappers.SkillMapper.ToSkillDTO(entity, skill)) { return(skill); } return(null); } } catch (Exception e) { Logger.Error(e); return(null); } }
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 DropDTO Insert(DropDTO drop) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { Drop entity = new Drop(); context.Drop.Add(entity); context.SaveChanges(); if (Mapper.Mappers.DropMapper.ToDropDTO(entity, drop)) { return(drop); } return(null); } } catch (Exception e) { Logger.Error(e); return(null); } }
public DeleteResult DeleteByMapNpcId(int mapNpcId) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { IQueryable <RecipeList> recipeLists = context.RecipeList.Where(i => i.MapNpcId == mapNpcId); if (recipeLists.Any()) { context.RecipeList.RemoveRange(recipeLists); context.SaveChanges(); } return(DeleteResult.Deleted); } } catch (Exception e) { Logger.Error(e); return(DeleteResult.Error); } }
public DeleteResult DeleteById(long id) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { MinilandObject item = context.MinilandObject.First(i => i.MinilandObjectId.Equals(id)); if (item != null) { context.MinilandObject.Remove(item); context.SaveChanges(); } return(DeleteResult.Deleted); } } catch (Exception e) { Logger.Error(e); return(DeleteResult.Error); } }
public DeleteResult Delete(string characterName) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { Character character = context.Character.FirstOrDefault(c => c.Name.Equals(characterName)); FamilyCharacter familyCharacter = context.FamilyCharacter.FirstOrDefault(c => c.CharacterId.Equals(character.CharacterId)); if (character != null && familyCharacter != null) { context.FamilyCharacter.Remove(familyCharacter); context.SaveChanges(); } return(DeleteResult.Deleted); } } catch (Exception e) { Logger.Error(string.Format(Language.Instance.GetMessageFromKey("DELETE_FAMILYCHARACTER_ERROR"), e.Message), e); return(DeleteResult.Error); } }
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 DeleteById(int portalId) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { Portal portal = context.Portal.Single(i => i.PortalId.Equals(portalId)); if (portal != null) { context.Portal.Remove(portal); context.SaveChanges(); } return(DeleteResult.Deleted); } } catch (Exception e) { Logger.Error(e); return(DeleteResult.Error); } }
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); } }