public void UpdateIngredient(WhatYouGotLibrary.Models.Ingredient ingredient) { Entities.Ingredient currentIngredient = _context.Ingredient.Find(ingredient.Id); Entities.Ingredient newIngredient = Mapper.Map(ingredient); _context.Entry(currentIngredient).CurrentValues.SetValues(newIngredient); }
public IActionResult Create(IngredientViewModel model) { var response = ResponseModelFactory.CreateInstance; if (model.SchoolUuid == null && AuthContextService.CurrentUser.SchoolGuid == null) { response.SetFailed("请登录学校账号"); return(Ok(response)); } using (_dbContext) { if (model.SchoolUuid != null) { var query = _dbContext.Ingredient.FirstOrDefault(x => x.IsDelete != 1 && x.SchoolUuid == model.SchoolUuid && x.FoodName == model.FoodName); if (query != null) { response.SetFailed("该食材已存在"); return(Ok(response)); } } else { var query = _dbContext.Ingredient.FirstOrDefault(x => x.IsDelete != 1 && x.SchoolUuid == AuthContextService.CurrentUser.SchoolGuid && x.FoodName == model.FoodName); if (query != null) { response.SetFailed("该食材已存在"); return(Ok(response)); } } var Ingredient = new Entities.Ingredient() { IngredientUuid = Guid.NewGuid(), FoodName = model.FoodName, TypeUuid = model.TypeUuid, HeatEnergy = model.HeatEnergy, Protein = model.Protein, Fat = model.Fat, Saccharides = model.Saccharides, Va = model.Va, AddTime = model.AddTime, AddPeople = model.AddPeople, IsDelete = 0, Accessory = model.Accessory, SchoolUuid = model.SchoolUuid != null ? model.SchoolUuid : AuthContextService.CurrentUser.SchoolGuid, }; _dbContext.Ingredient.Add(Ingredient); var num = _dbContext.SaveChanges(); if (num > 0) { response.SetSuccess("添加成功"); } else { response.SetFailed("添加失败"); } return(Ok(response)); } }
public static void Insert(Entities.Ingredient entity, ContextType contextType = ContextType.Default) { using (var context = ContextSwitcher.CreateContext(contextType)) { context.Ingredients.Add(entity); context.SaveChanges(); } }
/// <summary> /// Method to convert a ingredient to an entity class so it can be added to the database /// </summary> /// <param name="ingredient">The ingredient to be converted</param> /// <returns>An instance of the ingredient entity</returns> private Entities.Ingredient CreateIngredientEntity(IngredientDTO ingredient) { var ingredientEntity = new Entities.Ingredient { Name = ingredient.Name }; return(ingredientEntity); }
public static Ingredient ConvertToDTO(this Entities.Ingredient ingredient) { return(new Ingredient { ID = ingredient.ID, Weight = ingredient.Weight, TypeID = ingredient.IngredientType.ID, Type = ingredient.IngredientType.Name }); }
// Storage to domain public static Result <Ingredient> ToIngredientDomain(this Entities.Ingredient dbIngredient) { Result <IngredientNameValue> ingredientNameOrError = IngredientNameValue.Create(dbIngredient.Name); Result <IngredientQuantityValue> ingredientQuantityOrError = IngredientQuantityValue.Create(dbIngredient.Quantity); Result okOrError = Result.FirstFailureOrOk(ingredientNameOrError, ingredientQuantityOrError); if (okOrError.IsFailure) { return(Result.FromError <Ingredient>(okOrError)); } return(Ingredient.Create(dbIngredient.Id, dbIngredient.CreatedOn, dbIngredient.DeletedOn, ingredientNameOrError.Value, ingredientQuantityOrError.Value, dbIngredient.PizzaFk)); }
public IActionResult ToSync() { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { var schoollist = _dbContext.School.Where(x => x.IsDelete == 0).ToList(); var schoolEnt = schoollist.Find(x => x.SchoolName == "萧山三中"); //var schoolEnt = schoollist.Find(x => x.SchoolName == "xxxx1"); schoollist.Remove(schoolEnt); var ingredients = _dbContext.Ingredient.Where(x => x.SchoolUuid == schoolEnt.SchoolUuid && x.IsDelete == 0).ToList(); for (int n = 0; n < schoollist.Count; n++) { for (int i = 0; i < ingredients.Count; i++) { if (!_dbContext.Ingredient.Any(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && x.FoodName == ingredients[i].FoodName)) { var ing = new Entities.Ingredient() { IngredientUuid = Guid.NewGuid(), SchoolUuid = schoollist[n].SchoolUuid, AddTime = DateTime.Now.ToString("yyyy-MM-dd"), AddPeople = "", FoodName = ingredients[i].FoodName, TypeUuid = ingredients[i].TypeUuid, IsDelete = 0, HeatEnergy = ingredients[i].HeatEnergy, Protein = ingredients[i].Protein, Fat = ingredients[i].Fat, Va = ingredients[i].Va, Saccharides = ingredients[i].Saccharides, Accessory = ingredients[i].Accessory, }; _dbContext.Ingredient.Add(ing); } } //_dbContext.Ingredient.AddRange(ingredients); _dbContext.SaveChanges(); } var cuisines = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoolEnt.SchoolUuid && x.IsDelete == 0).ToList(); for (int n = 0; n < schoollist.Count; n++) { for (int i = 0; i < cuisines.Count; i++) { if (!_dbContext.Cuisine.Any(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && x.CuisineName == cuisines[i].CuisineName)) { var cui = new Entities.Cuisine() { CuisineUuid = Guid.NewGuid(), SchoolUuid = schoollist[n].SchoolUuid, AddTime = DateTime.Now.ToString("yyyy-MM-dd"), AddPeople = "", LikeNum = 0, IsDelete = 0, CuisineName = cuisines[i].CuisineName, Price = cuisines[i].Price, Burdening = cuisines[i].Burdening, Ingredient = cuisines[i].Ingredient, Abstract = cuisines[i].Abstract, CuisineType = cuisines[i].CuisineType, Accessory = cuisines[i].Accessory, }; _dbContext.Cuisine.Add(cui); } } //_dbContext.Cuisine.AddRange(cuisines); _dbContext.SaveChanges(); } var nweekmenus = _dbContext.NweekMenu.Where(x => x.SchoolUuid == schoolEnt.SchoolUuid && x.IsDelete == 0).OrderByDescending(x => x.Datetimes).Take(3).ToList(); for (int n = 0; n < schoollist.Count; n++) { for (int i = 0; i < nweekmenus.Count; i++) { if (!_dbContext.NweekMenu.Any(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.Datetimes == nweekmenus[0].Datetimes && x.IsDelete == 0)) { var ids1 = nweekmenus[i].MonMon.ToLower().Split(','); var names1 = _dbContext.Cuisine.Where(x => ids1.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var MonMonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names1 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var MonMon = string.Join(",", MonMonLs); var ids2 = nweekmenus[i].MonNoon.ToLower().Split(','); var names2 = _dbContext.Cuisine.Where(x => ids2.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var MonNoonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names2 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var MonNoon = string.Join(",", MonNoonLs); var ids3 = nweekmenus[i].MonNight.ToLower().Split(','); var names3 = _dbContext.Cuisine.Where(x => ids3.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var MonNightLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names3 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var MonNight = string.Join(",", MonNightLs); var ids4 = nweekmenus[i].TuesMon.ToLower().Split(','); var names4 = _dbContext.Cuisine.Where(x => ids4.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var TuesMonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names4 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var TuesMon = string.Join(",", TuesMonLs); var ids5 = nweekmenus[i].TuesNoon.ToLower().Split(','); var names5 = _dbContext.Cuisine.Where(x => ids5.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var TuesNoonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names5 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var TuesNoon = string.Join(",", TuesNoonLs); var ids6 = nweekmenus[i].TuesNight.ToLower().Split(','); var names6 = _dbContext.Cuisine.Where(x => ids6.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var TuesNightLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names6 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var TuesNight = string.Join(",", TuesNightLs); var ids7 = nweekmenus[i].WedMon.ToLower().Split(','); var names7 = _dbContext.Cuisine.Where(x => ids7.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var WedMonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names7 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var WedMon = string.Join(",", WedMonLs); var ids8 = nweekmenus[i].WedNoon.ToLower().Split(','); var names8 = _dbContext.Cuisine.Where(x => ids8.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var WedNoonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names8 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var WedNoon = string.Join(",", WedNoonLs); var ids9 = nweekmenus[i].WedNight.ToLower().Split(','); var names9 = _dbContext.Cuisine.Where(x => ids9.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var WedNightLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names9 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var WedNight = string.Join(",", WedNightLs); var ids10 = nweekmenus[i].ThursMon.ToLower().Split(','); var names10 = _dbContext.Cuisine.Where(x => ids10.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var ThursMonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names10 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var ThursMon = string.Join(",", ThursMonLs); var ids11 = nweekmenus[i].ThursNoon.ToLower().Split(','); var names11 = _dbContext.Cuisine.Where(x => ids11.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var ThursNoonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names11 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var ThursNoon = string.Join(",", ThursNoonLs); var ids12 = nweekmenus[i].ThursNight.ToLower().Split(','); var names12 = _dbContext.Cuisine.Where(x => ids12.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var ThursNightLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names12 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var ThursNight = string.Join(",", ThursNightLs); var ids13 = nweekmenus[i].FriMon.ToLower().Split(','); var names13 = _dbContext.Cuisine.Where(x => ids13.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var FriMonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names13 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var FriMon = string.Join(",", FriMonLs); var ids14 = nweekmenus[i].FriNoon.ToLower().Split(','); var names14 = _dbContext.Cuisine.Where(x => ids14.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var FriNoonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names14 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var FriNoon = string.Join(",", FriNoonLs); var ids15 = nweekmenus[i].FriNight.ToLower().Split(','); var names15 = _dbContext.Cuisine.Where(x => ids15.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var FriNightLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names15 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var FriNight = string.Join(",", FriNightLs); var ids16 = nweekmenus[i].SatMon.ToLower().Split(','); var names16 = _dbContext.Cuisine.Where(x => ids16.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var SatMonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names16 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var SatMon = string.Join(",", SatMonLs); var ids17 = nweekmenus[i].SatNoon.ToLower().Split(','); var names17 = _dbContext.Cuisine.Where(x => ids17.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var SatNoonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names17 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var SatNoon = string.Join(",", SatNoonLs); var ids18 = nweekmenus[i].SatNight.ToLower().Split(','); var names18 = _dbContext.Cuisine.Where(x => ids18.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var SatNightLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names18 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var SatNight = string.Join(",", SatNightLs); var ids19 = nweekmenus[i].SunMon.ToLower().Split(','); var names19 = _dbContext.Cuisine.Where(x => ids19.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var SunMonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names19 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var SunMon = string.Join(",", SunMonLs); var ids20 = nweekmenus[i].SunNoon.ToLower().Split(','); var names20 = _dbContext.Cuisine.Where(x => ids20.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var SunNoonLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names20 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var SunNoon = string.Join(",", SunNoonLs); var ids21 = nweekmenus[i].SunNight.ToLower().Split(','); var names21 = _dbContext.Cuisine.Where(x => ids21.Contains(x.CuisineUuid.ToString().ToLower())).Select(x => x.CuisineName).ToList(); var SunNightLs = _dbContext.Cuisine.Where(x => x.SchoolUuid == schoollist[n].SchoolUuid && x.IsDelete == 0 && names21 .Contains(x.CuisineName)).Select(x => x.CuisineUuid).ToArray(); var SunNight = string.Join(",", SunNightLs); var menu = new NweekMenu() { NweekMenuUuid = Guid.NewGuid(), SchoolUuid = schoollist[n].SchoolUuid, MonMon = MonMon, MonNight = MonNight, MonNoon = MonNoon, TuesMon = TuesMon, TuesNight = TuesNight, TuesNoon = TuesNoon, WedMon = WedMon, WedNight = WedNight, WedNoon = WedNoon, ThursMon = ThursMon, ThursNight = ThursNight, ThursNoon = ThursNoon, FriMon = FriMon, FriNight = FriNight, FriNoon = FriNoon, SatMon = SatMon, SatNight = SatNight, SatNoon = SatNoon, SunMon = SunMon, SunNight = SunNight, SunNoon = SunNoon, AddTime = DateTime.Now.ToString("yyyy-MM-dd"), AddPeople = "", IsDelete = 0, Datetimes = nweekmenus[0].Datetimes, }; _dbContext.NweekMenu.Add(menu); } } _dbContext.SaveChanges(); } } return(Ok(response)); }
public WhatYouGotLibrary.Models.Ingredient GetIngredientById(int id) { Entities.Ingredient ingredient = _context.Ingredient.Find(id); return(Mapper.Map(ingredient)); }
public void DeleteIngredientById(int id) { Entities.Ingredient ingredient = _context.Ingredient.Find(id); _context.Remove(ingredient); }
public void AddIngredient(WhatYouGotLibrary.Models.Ingredient ingredient) { Entities.Ingredient newIngredient = Mapper.Map(ingredient); _context.Add(newIngredient); }
/// <summary> /// Initializes this object using an Ingredient entity object /// </summary> public Ingredient(Entities.Ingredient ingredient) { this.Id = ingredient.Id; }