public int Food_Relate_User_Del(FoodByUserPraiseViewModel foodByUserSearchViewModelt)
{
int DelNum = _IRelate_Food_UserRepository
.RelateFoodToUserDel(foodByUserSearchViewModelt);
return(DelNum);
}
//根据条件查询点赞
private Expression <Func <User_Relate_Food, bool> > SearchDelRelateWhere(FoodByUserPraiseViewModel foodByUserSearchViewModel)
{
var predicate = WhereExtension.True <User_Relate_Food>();//初始化where表达式
predicate = predicate.And(p => p.Food_InfoId == foodByUserSearchViewModel.Food_InfoId);
predicate = predicate.And(p => p.User_InfoId == foodByUserSearchViewModel.User_InfoId);
predicate = predicate.And(p => p.status == null);
return(predicate);
}
/// <summary>
/// 根据用户id和菜id删 点赞
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public int RelateFoodToUserDel(FoodByUserPraiseViewModel foodByUserSearchViewModel)
{
var preciate = SearchDelRelateWhere(foodByUserSearchViewModel);
var temp = DbSet.Single(preciate);
DbSet.Remove(temp);
return(SaveChanges());
}
/// <summary>
/// 根据用户id和菜id 去关系表查好评
/// </summary>
/// <param name="foodByUserSearchViewModel"></param>
/// <returns></returns>
public int SearchFoodInfoByWhere(FoodByUserPraiseViewModel foodByUserSearchViewModel)
{
int userid = foodByUserSearchViewModel.User_InfoId;
int foodid = foodByUserSearchViewModel.Food_InfoId;
var queryResult = DbSet.Where(k => k.User_InfoId == userid &&
k.Food_InfoId == foodid &&
k.status == null &&
k.User_Info.status == "0").ToList();
return(queryResult.Count);
}
/// <summary>
/// 根据用户和菜单点赞
/// </summary>
/// <param name="foodByUserSearchViewMode"></param>
/// <returns></returns>
public int Food_Relate_User(FoodByUserPraiseViewModel foodByUserSearchViewMode)
{
int count = _IRelate_Food_UserRepository.SearchFoodInfoByWhere(foodByUserSearchViewMode);
if (count > 0)
{
int DelNum = _IRelate_Food_UserRepository
.RelateFoodToUserDel(foodByUserSearchViewMode);
return(0);
}
else
{
var node_Info = _IMapper.Map <FoodByUserPraiseViewModel, User_Relate_Food>(foodByUserSearchViewMode);
_IRelate_Food_UserRepository.Add(node_Info);
_IRelate_Food_UserRepository.SaveChanges();
return(1);
}
}
public ActionResult <FoodByUserSearchResModel> Manage_FoodToUser_Del(FoodByUserPraiseViewModel foodByUserPraiseViewModel)
{
FoodByUserSearchResModel foodByUserSearchResModel = new FoodByUserSearchResModel();
int SearchRowNum = _foodService.Food_Relate_User(foodByUserPraiseViewModel);
if (SearchRowNum > 0)
{
foodByUserSearchResModel.IsSuccess = true;
foodByUserSearchResModel.TotalNum = SearchRowNum;
foodByUserSearchResModel.baseViewModel.Message = "用户点赞成功";
foodByUserSearchResModel.baseViewModel.ResponseCode = 200;
_ILogger.Information("根据用户id和菜单id，用户点赞成功");
return(Ok(foodByUserSearchResModel));
}
else
{
foodByUserSearchResModel.IsSuccess = false;
foodByUserSearchResModel.TotalNum = 0;
foodByUserSearchResModel.baseViewModel.Message = "用户取消赞成功";
foodByUserSearchResModel.baseViewModel.ResponseCode = 200;
_ILogger.Information("根据用户id和菜单id，用户取消赞成功");
return(Ok(foodByUserSearchResModel));
}
}
