public Status UseNutritionNameBySearchInfo(string NutritionName) { this._logger.LogWarning("The Server execute UseNutritionNameBySearchInfo --" + DateTime.Now.ToString()); using (DietaryNutritionContext dbcontext = new DietaryNutritionContext()) { var result = dbcontext.TNutrientInformation.Where(a => a.Name == NutritionName || a.OtherName == NutritionName).ToList(); if (result.Count > 0) { NutritionInfoStatus nutritionInfoStatus = new NutritionInfoStatus { StatusCode = 200, Message = "获取成功", ReturnTime = DateTime.Now, NutrientInformation = result }; return(nutritionInfoStatus); } else { Status status = new Status { StatusCode = 0, Message = "获取失败", ReturnTime = DateTime.Now, }; return(status); } } }
public Status UseFoodNameBySearchInfo(string foodname) { this._logger.LogWarning("The Server execute UseFoodNameBySearchInfo --" + DateTime.Now.ToString()); using (DietaryNutritionContext dbcontext = new DietaryNutritionContext()) { var result = dbcontext.TFoodNutrition.Where(a => a.FoodName == foodname).ToList(); if (result.Count > 0) { FoodNutritionStatus nutritionInfoStatus = new FoodNutritionStatus { StatusCode = 200, Message = "获取成功", ReturnTime = DateTime.Now, FoodNutritions = result }; return(nutritionInfoStatus); } else { Status status = new Status { StatusCode = 0, Message = "获取失败", ReturnTime = DateTime.Now, }; return(status); } } }
public Status GetAllNutritionInfo() { this._logger.LogWarning("The Server execute GetAllNutritionInfo Function --" + DateTime.Now.ToString()); using (DietaryNutritionContext dbcontext = new DietaryNutritionContext()) { var result = dbcontext.TNutrientInformation.ToList(); if (result.Count > 0) { NutritionInfoStatus nutritionInfoStatus = new NutritionInfoStatus { StatusCode = 200, Message = "获取成功", ReturnTime = DateTime.Now, NutrientInformation = result }; return(nutritionInfoStatus); } else { Status status = new Status { StatusCode = 0, Message = "获取失败", ReturnTime = DateTime.Now, }; return(status); } } }
public CookBookStatus UseCookBookNameBySearchInfo(string cookbookname) { this._logger.LogWarning("The server execute UseCookBookNameBySearchInfo Fuction --" + DateTime.Now.ToString()); using (DietaryNutritionContext dbcontext = new DietaryNutritionContext()) { var result = dbcontext.TCookBook.Where(a => a.Name == cookbookname).ToList(); if (result.Count > 0) { CookBookStatus nutritionInfoStatus = new CookBookStatus { StatusCode = 200, Message = "获取成功", ReturnTime = DateTime.Now, CookBooks = result }; return(nutritionInfoStatus); } else { CookBookStatus status = new CookBookStatus { StatusCode = 0, Message = "获取失败", ReturnTime = DateTime.Now, }; return(status); } } }
public CookBookStatus GetAllCookBook() { this._logger.LogWarning("The server execute GetAllCookBook Function --" + DateTime.Now.ToString()); using (DietaryNutritionContext dbcontext = new DietaryNutritionContext()) { var result = dbcontext.TCookBook.ToList(); if (result.Count > 0) { CookBookStatus cookBookStatus = new CookBookStatus() { StatusCode = 200, Message = "获取成功", ReturnTime = DateTime.Now, CookBooks = result }; return(cookBookStatus); } else { CookBookStatus status = new CookBookStatus { StatusCode = 0, Message = "获取失败", ReturnTime = DateTime.Now, }; return(status); } } }
public Status DeleteCookBook(int id) { this._logger.LogWarning("The server execute DeleteCookBook Fuction --" + DateTime.Now.ToString()); using (DietaryNutritionContext dbcontext = new DietaryNutritionContext()) { var query = dbcontext.TCookBook.Where(a => a.Id == id).FirstOrDefault(); if (query != null) { dbcontext.TCookBook.Remove(query); int result = dbcontext.SaveChanges(); if (result > 0) { Status status = new Status { StatusCode = 200, Message = "删除成功", ReturnTime = DateTime.Now, }; return(status); } else { Status status = new Status { StatusCode = 0, Message = "删除失败", ReturnTime = DateTime.Now, }; return(status); } } else { Status status = new Status { StatusCode = 0, Message = "没有查询到该食谱", ReturnTime = DateTime.Now, }; return(status); } } }
public Status AddFoodNutrionInfo(string foodname, string nutritionalingredient, string introduce, List <IFormFile> files) { TFoodNutrition foodNutrition = new TFoodNutrition() { FoodName = foodname, Introduce = introduce, NutritionalIngredient = nutritionalingredient }; List <string> filenames = new List <string>(); string resultfilename = string.Empty; bool flag = false; this._logger.LogWarning("The server execute AddFoodNutrionInfo Fuction --" + DateTime.Now.ToString()); using (DietaryNutritionContext dbcontext = new DietaryNutritionContext()) { try { if (foodNutrition.FoodName != "") { flag = FileSave(files, foodNutrition.FoodName, out filenames); } else { flag = FileSave(files, DateTime.Now.ToString(), out filenames); } if (!flag) { Status status = new Status { StatusCode = 0, Message = "上传图片失败", ReturnTime = DateTime.Now, }; return(status); } filenames.Sort(); resultfilename = string.Join("", filenames.ToArray()); foodNutrition.Images = resultfilename; dbcontext.Add(foodNutrition); int result = dbcontext.SaveChanges(); if (result > 0) { Status status = new Status { StatusCode = 200, Message = "添加成功", ReturnTime = DateTime.Now, }; return(status); } else { Status status = new Status { StatusCode = 0, Message = "添加失败", ReturnTime = DateTime.Now, }; return(status); } } catch (Exception) { Status status = new Status { StatusCode = 0, Message = "添加失败", ReturnTime = DateTime.Now, }; return(status); } } }
public Status AddCookBook(string cookBookname, string flavour, string material, string nutritionalingredient, List <IFormFile> files) { TCookBook cookBook = new TCookBook() { Name = cookBookname, Flavour = flavour, Material = material, NutritionalIngredient = nutritionalingredient }; List <string> filenames = new List <string>(); string resultfilename = string.Empty; bool flag = false; this._logger.LogWarning("The server execute AddCookBook Fuction --" + DateTime.Now.ToString()); using (DietaryNutritionContext dbcontext = new DietaryNutritionContext()) { try { if (cookBook.Name != "") { flag = FileSave(files, cookBook.Name, out filenames); } else { flag = FileSave(files, DateTime.Now.ToString(), out filenames); } if (!flag) { Status status = new Status { StatusCode = 0, Message = "上传图片失败", ReturnTime = DateTime.Now, }; return(status); } filenames.Sort(); resultfilename = string.Join("", filenames.ToArray()); cookBook.Image = resultfilename; dbcontext.Add(cookBook); int result = dbcontext.SaveChanges(); if (result > 0) { Status status = new Status { StatusCode = 200, Message = "添加成功", ReturnTime = DateTime.Now, }; return(status); } else { Status status = new Status { StatusCode = 0, Message = "添加失败", ReturnTime = DateTime.Now, }; return(status); } } catch (Exception) { Status status = new Status { StatusCode = 0, Message = "添加失败", ReturnTime = DateTime.Now, }; return(status); } } }