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