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 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 Status UpdateCookBook(TCookBook cookBook)
{
EFHelper <TCookBook> eFHelper = new EFHelper <TCookBook>();
int result = eFHelper.Update(cookBook);
if (result > 0)
{
Status nutritionInfoStatus = new Status
{
StatusCode = 200,
Message = "修改成功",
ReturnTime = DateTime.Now
};
return(nutritionInfoStatus);
}
else
{
CookBookStatus status = new CookBookStatus
{
StatusCode = 0,
Message = "修改失败",
ReturnTime = DateTime.Now,
};
return(status);
}
}
public Status DeleteNutritionInfo(int id)
{
this._logger.LogWarning("The server execute UpdateNutritionInfo Fuction --" + DateTime.Now.ToString());
EFHelper <TNutrientInformation> eFHelper = new EFHelper <TNutrientInformation>();
try
{
TNutrientInformation result = eFHelper.getList(a => a.Id == id).FirstOrDefault();
if (result == null)
{
this._logger.LogWarning("This object is null ");
throw new Exception();
}
else
{
eFHelper.Delete(result);
CookBookStatus status = new CookBookStatus()
{
StatusCode = 200,
Message = "删除成功",
ReturnTime = DateTime.Now
};
return(status);
}
}
catch (Exception ex)
{
this._logger.LogWarning("The server execute DeleteNutritionInfo Fuction --" + ex.Message + DateTime.Now.ToString());
CookBookStatus status = new CookBookStatus()
{
StatusCode = 0,
Message = "删除失败",
ReturnTime = DateTime.Now
};
return(status);
}
}
