public static bool ToRecipeListDTO(RecipeList input, RecipeListDTO output) { if (input == null) { return(false); } output.ItemVNum = input.ItemVNum; output.MapNpcId = input.MapNpcId; output.RecipeId = input.RecipeId; output.RecipeListId = input.RecipeListId; return(true); }
public IEnumerable <RecipeListDTO> LoadByItemVNum(short itemVNum) { using (OpenNosContext context = DataAccessHelper.CreateContext()) { List <RecipeListDTO> result = new List <RecipeListDTO>(); foreach (RecipeList recipeList in context.RecipeList.Where(r => r.ItemVNum == itemVNum)) { RecipeListDTO dto = new RecipeListDTO(); Mapper.Mapper.Instance.RecipeListMapper.ToRecipeListDTO(recipeList, dto); result.Add(dto); } return(result); } }
public IEnumerable <RecipeListDTO> LoadAll() { using (OpenNosContext context = DataAccessHelper.CreateContext()) { List <RecipeListDTO> result = new List <RecipeListDTO>(); foreach (RecipeList recipeList in context.RecipeList) { RecipeListDTO dto = new RecipeListDTO(); Mapper.Mapper.Instance.RecipeListMapper.ToRecipeListDTO(recipeList, dto); result.Add(dto); } return(result); } }
public IEnumerable <RecipeListDTO> LoadByRecipeId(short recipeId) { using (OpenNosContext context = DataAccessHelper.CreateContext()) { List <RecipeListDTO> result = new List <RecipeListDTO>(); foreach (RecipeList recipeList in context.RecipeList.AsNoTracking().Where(r => r.RecipeId.Equals(recipeId))) { RecipeListDTO dto = new RecipeListDTO(); Mapper.Mappers.RecipeListMapper.ToRecipeListDTO(recipeList, dto); result.Add(dto); } return(result); } }
public IEnumerable <RecipeListDTO> LoadByMapNpcId(int mapNpcId) { using (OpenNosContext context = DataAccessHelper.CreateContext()) { List <RecipeListDTO> result = new List <RecipeListDTO>(); foreach (RecipeList recipeList in context.RecipeList.Where(r => r.MapNpcId == mapNpcId)) { RecipeListDTO dto = new RecipeListDTO(); Mapper.Mappers.RecipeListMapper.ToRecipeListDTO(recipeList, dto); result.Add(dto); } return(result); } }
public void Update(RecipeListDTO recipe) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { RecipeList result = context.RecipeList.FirstOrDefault(r => r.RecipeListId.Equals(recipe.RecipeListId)); if (result != null) { Mapper.Mapper.Instance.RecipeListMapper.ToRecipeList(recipe, result); context.SaveChanges(); } } } catch (Exception e) { Logger.Error(e); } }
public RecipeListDTO LoadById(int recipeListId) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { RecipeListDTO dto = new RecipeListDTO(); if (Mapper.Mapper.Instance.RecipeListMapper.ToRecipeListDTO(context.RecipeList.SingleOrDefault(s => s.RecipeListId.Equals(recipeListId)), dto)) { return(dto); } return(null); } } catch (Exception e) { Logger.Error(e); return(null); } }
public RecipeListDTO LoadFirstByMapNpcId(int mapNpcId) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { RecipeListDTO dto = new RecipeListDTO(); if (Mapper.Mappers.RecipeListMapper.ToRecipeListDTO(context.RecipeList.AsNoTracking().FirstOrDefault(s => s.MapNpcId == mapNpcId), dto)) { return(dto); } return(null); } } catch (Exception e) { Logger.Error(e); return(null); } }
public RecipeListDTO Insert(RecipeListDTO recipeList) { try { using (OpenNosContext context = DataAccessHelper.CreateContext()) { RecipeList entity = new RecipeList(); Mapper.Mapper.Instance.RecipeListMapper.ToRecipeList(recipeList, entity); context.RecipeList.Add(entity); context.SaveChanges(); if (Mapper.Mapper.Instance.RecipeListMapper.ToRecipeListDTO(entity, recipeList)) { return(recipeList); } return(null); } } catch (Exception e) { Logger.Error(e); return(null); } }