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