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);
}
}
}
/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
public int Add(T t)
{
dbContent.Entry <T>(t).State = EntityState.Added;
return(dbContent.SaveChanges());
}
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);
}
}
}
