public async Task <object> MakeGlue(string code) { if (code == null || code == string.Empty) { return(new IngredientDto()); } var item = await(from a in _context.GlueIngredient join b in _context.Glues on a.GlueID equals b.ID join c in _context.Ingredients on a.IngredientID equals c.ID select new GlueIngredientDto { ID = a.GlueID, Name = b.Name, Code = b.Code, Ingredient = c, Percentage = a.Percentage }).FirstOrDefaultAsync(x => x.Code.Contains(code)); var list = new List <IngredientDto>(); var glues = new GlueDto(); glues.ID = item.ID; glues.Name = item.Name; glues.Code = item.Code; list.Add(new IngredientDto { ID = item.Ingredient.ID, Name = item.Ingredient.Name, Percentage = item.Percentage, Code = item.Ingredient.Code, }); glues.Ingredients = list; return(glues); }
public async Task <object> GetGlueWithIngredientByGlueID(int glueid) { var model2 = await(from a in _context.GlueIngredient join b in _context.Glues on a.GlueID equals b.ID join c in _context.Ingredients on a.IngredientID equals c.ID select new GlueIngredientDto { ID = a.GlueID, Name = b.Name, Code = b.Code, Ingredient = c, Percentage = a.Percentage, Position = a.Position, Allow = a.Allow }).ToListAsync(); var glues = new GlueDto(); var list = new List <IngredientDto>(); foreach (var item in model2) { if (item.ID.Equals(glueid)) { glues.ID = item.ID; glues.Name = item.Name; glues.Code = item.Code; list.Add(new IngredientDto { ID = item.Ingredient.ID, Name = item.Ingredient.Name, Percentage = item.Percentage, Code = item.Ingredient.Code, MaterialNO = item.Ingredient.MaterialNO, Position = item.Position, Allow = item.Allow }); } } glues.Ingredients = list.OrderBy(x => x.Position).ToList(); return(glues); }
public async Task <object> GetGlueWithIngredientByGlueName(string glueName) { var model2 = await(from a in _context.GlueIngredient join b in _context.Glues on a.GlueID equals b.ID join c in _context.Ingredients on a.IngredientID equals c.ID select new GlueIngredientDto { ID = a.GlueID, Name = b.Name, Code = b.Code, Ingredient = c, Percentage = a.Percentage }).ToListAsync(); var glues = new GlueDto(); var list = new List <IngredientDto>(); foreach (var item in model2) { if (item.Name.Equals(glueName)) { glues.ID = item.ID; glues.Name = item.Name; glues.Code = item.Code; list.Add(new IngredientDto { ID = item.Ingredient.ID, Name = item.Ingredient.Name, Percentage = item.Percentage, Code = item.Ingredient.Code, }); } } glues.Ingredients = list.DistinctBy(x => x.Name).ToList(); return(glues); }
public async Task <object> MakeGlue(int glueid) { var model2 = await(from a in _context.GlueIngredient join b in _context.Glues on a.GlueID equals b.ID join c in _context.Ingredients on a.IngredientID equals c.ID select new GlueIngredientDto { ID = a.GlueID, Name = b.Name, Code = b.Code, Ingredient = c, Percentage = a.Percentage }).ToListAsync(); var glues = new GlueDto(); var list = new List <IngredientDto>(); foreach (var item in model2) { if (item.ID == glueid) { glues.ID = item.ID; glues.Name = item.Name; glues.Code = item.Code; list.Add(new IngredientDto { ID = item.Ingredient.ID, Name = item.Ingredient.Name, Percentage = item.Percentage, Code = item.Ingredient.Code, }); } } glues.Ingredients = list; return(glues); }