public List<FoodEntity> Get_List_Food_By_StoreID(string id)
{
List<FoodEntity> list = new List<FoodEntity>();
if (dbContext == null)
{
dbContext = new FoodDeliveryEntities();
}
var listvar = dbContext.GET_LIST_FOOD_BY_STOREID(id).ToList();
foreach (var obj in listvar)
{
FoodEntity entity = new FoodEntity
{
FoodID = "" + obj.FoodID,
FoodName = obj.FoodName,
FoodImage = obj.FoodImage,
Price = (decimal)obj.Price,
CategoryID = "" + obj.CategoryID,
StoreID=""+obj.StoreID
};
list.Add(entity);
}
return list;
}
public async Task <FoodEntity> InsertFood(FoodEntity food)
{
await _repository.InsertFood(food);
_unitOfWork.Commit();
return(food);
}
public FoodEntity GET_OBJECT_FOOD_BY_FOODID(string foodID)
{
FoodController objController = new FoodController();
FoodEntity entity = objController.Get_Object_Food_By_FoodID(foodID);
return(entity);
}
public Either <Error, int> Insert(FoodInsertModel entity)
{
try
{
if (entity == null)
{
return(new Left <Error, int>(new ArgumentNotSet(nameof(entity))));
}
using (var context = _factory.Create())
{
var foodEntity = new FoodEntity()
{
Name = entity.Name,
Type = entity.Type,
Price = entity.Price,
Description = entity.Description,
IsInactive = entity.IsInactive,
DailyMenuId = entity.DailyMenuId,
RestaurantId = entity.RestaurantId,
};
var addedEntity = context.Food.Add(foodEntity).Entity;
context.SaveChanges();
return(new Right <Error, int>(addedEntity.Id));
}
}
catch (Exception ex)
{
return(new Left <Error, int>(new UnknownError(ex.ToString())));
}
}
public async Task AddFood(string name, DateTime at)
{
if (foodEntities == null)
{
foodEntities = await database.GetFood();
}
var foodEntity = foodEntities.SingleOrDefault(fm => fm.Name == name);
if (foodEntity == null)
{
foodEntity = new FoodEntity {
Name = name
};
await database.Save(foodEntity);
foodEntities = await database.GetFood();
foodEntity = foodEntities.Single(fm => fm.Name == name);
}
var foodRecordEntity = new FoodRecordEntity {
FoodId = foodEntity.Id, At = at
};
await database.Save(foodRecordEntity);
foodRecordEntities = await database.GetFoodRecords();
}
public ActionResult <FoodDto> PartiallyUpdateFood(int id, [FromBody] JsonPatchDocument <FoodUpdateDto> patchDoc)
{
if (patchDoc == null)
{
return(BadRequest());
}
FoodEntity existingEntity = _foodRepository.GetSingle(id);
if (existingEntity == null)
{
return(NotFound());
}
FoodUpdateDto foodUpdateDto = _mapper.Map <FoodUpdateDto>(existingEntity);
patchDoc.ApplyTo(foodUpdateDto);
TryValidateModel(foodUpdateDto);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_mapper.Map(foodUpdateDto, existingEntity);
FoodEntity updated = _foodRepository.Update(id, existingEntity);
if (!_foodRepository.Save())
{
throw new Exception("Updating a fooditem failed on save.");
}
return(Ok(_mapper.Map <FoodDto>(updated)));
}
public async Task <ActionResult> AddFood(AddFoodDTO addFoodDTO)
{
try
{
var food = new FoodEntity()
{
Name = addFoodDTO.Name,
Brand = addFoodDTO.Brand,
ServingSize = addFoodDTO.ServingSize,
Calories = addFoodDTO.Calories,
Protein = addFoodDTO.Protein,
Fat = addFoodDTO.Fat,
Carbs = addFoodDTO.Carbs,
Alcohol = addFoodDTO.Alcohol,
Fiber = addFoodDTO.Fiber
};
await foodRepository.AddFood(food);
return(new AcceptedResult());
}
catch (Exception e)
{
Console.WriteLine(e);
return(new ConflictResult());
}
}
public FoodEntity CreateFood(FoodEntity newFood)
{
var next_Id = _foods.OrderByDescending(f => f.Id).FirstOrDefault().Id + 1;
newFood.Id = next_Id;
_foods.Add(newFood);
return(newFood);
}
private dynamic ExpandSingleFoodItem(FoodEntity foodItem, ApiVersion version)
{
var links = GetLinks(foodItem.Id, version);
FoodDto item = _mapper.Map <FoodDto>(foodItem);
var resourceToReturn = item.ToDynamic() as IDictionary <string, object>;
resourceToReturn.Add("links", links);
return(resourceToReturn);
}
public static void SpawnFood(string foodName)
{
if (ConsoleSystem.Caller?.Pawn is not Player callerPawn || foodName is null)
{
return;
}
Log.Info(FoodEntity.CreateEyepos(foodName, callerPawn) is null
? $"Could not find a food template named {foodName}"
: $"Spawned a food entity with a template of {foodName}");
}
/// <summary>
/// Store new record. Throws if conflicting record already exists.
/// </summary>
/// <param name="foodInfo"></param>
public void Store(FoodInfo foodInfo)
{
var table = GetTable();
var entity = new FoodEntity(foodInfo.Category, foodInfo.Food)
{
Data = JsonConvert.SerializeObject(foodInfo)
};
table.Execute(TableOperation.Insert(entity));
}
public async Task Save(FoodEntity entity)
{
if (entity.Id == 0)
{
await connection.InsertAsync(entity);
}
else
{
await connection.UpdateAsync(entity);
}
}
public ActionResult <int> GetCaloriesSingleFood(ApiVersion version, int id)
{
FoodEntity foodItem = _foodRepository.GetSingle(id);
if (foodItem == null)
{
return(NotFound());
}
return(Ok(foodItem.Calories));
}
public async Task UpdateFood(FoodEntity food)
{
var query = $@"SELECT * FROM gft_teste.food where type = 'Entree';UPDATE `gft_teste`.`food`
SET
`name` = '{food.Name}',
`type` = '{food.Type}',
`time_meal` = '{food.TimeMeal}'
WHERE `Id` = {food.Id};
";
await _unitOfWork.BaseRepository().Update(query, food);
}
public ActionResult GetSingleFood(ApiVersion version, int id)
{
FoodEntity foodItem = _foodRepository.GetSingle(id);
if (foodItem == null)
{
return(NotFound());
}
return(Ok(ExpandSingleFoodItem(foodItem, version)));
}
public void AddFood(FoodView foodView)
{
var food = new FoodEntity()
{
//Id = foodView.FoodId,
Name = foodView.Name,
CaloriesPer100G = foodView.CaloriesPer100G
};
_repo.Add(food);
}
private void Update()
{
var f = food;
if (f == null || f.cookCurrent == -1)
{
progressBarMain.SetActive(false);
}
else
{
progressBarMain.SetActive(true);
if (f.cookCurrent == -2)
{
progressBarRenderer.transform.localScale = Vector3.one;
progressBarRenderer.color = Color.red;
}
else
{
progressBarRenderer.transform.localScale = new Vector3(f.cookPercentage, 1f, 1f);
progressBarRenderer.color = f.cookCurrent == 0 ? Color.green : Color.yellow;
}
}
if (f && f.isMine && f.cookCurrent >= 0)
{
cooking.SetActive(true);
if (!source.isPlaying)
{
source.clip = boiling;
source.Play();
}
// scuffed way to check if new item
if (f != cookingFood)
{
cookingFood = f;
nextCookTime = Time.time + (f.cookCurrent > 0 ? cookTime : burnTime);
}
if (Time.time >= nextCookTime)
{
f.RaiseEvent('k', true);
nextCookTime = Time.time + (f.cookCurrent > 0 ? cookTime : burnTime);
}
}
else
{
source.Stop();
cooking.SetActive(false);
cookingFood = null;
}
}
public async Task <BaseResult <FoodEntity> > Delete(FoodEntity entity)
{
var number = await foodRepository.Detail(entity.id);
var result = new BaseResult <FoodEntity>();
if (number.code != "0")
{
throw new Exception("数据不存在");
}
return(await foodRepository.Delete(entity));
}
public List <FoodEntity> GetFoodEntityList(FoodEntity condition_entity)
{
GenericWhereEntity <FoodEntity> where_entity = new GenericWhereEntity <FoodEntity>();
if (condition_entity.FOOD_ID != null)
{
where_entity.Where(n => (n.FOOD_ID == condition_entity.FOOD_ID));
}
if (condition_entity.RESTAURANT_ID != null)
{
where_entity.Where(n => (n.RESTAURANT_ID == condition_entity.RESTAURANT_ID));
}
return(EntityExecution.SelectAll(where_entity));
}
public void UpdateFood()
{
var servico = new FoodService(null, null);
var food = new FoodEntity();
food.Id = 1;
food.Name = "coffeer";
food.TimeMeal = Gft.Domain.Entities.Enums.EnumTime.morning;
food.Type = Gft.Domain.Entities.Enums.EnumFoodType.drink;
servico.UpdateFood(food);
Assert.True(true, "Atualizado com sucesso");
}
public async Task <FoodEntity> SaveFood(FoodEntity foodEntity)
{
if (foodEntity == null)
{
throw new ApplicationException("Unable to parse input entity");
}
foodEntity.Id = Guid.NewGuid().ToString();
_gretaFoodDb.Foods.Add(foodEntity);
await _gretaFoodDb.SaveChangesAsync();
return(foodEntity);
}
public FoodResponse ToFoodResponse(FoodEntity foodEntity)
{
return(new FoodResponse
{
Id = foodEntity.Id,
FoodName = foodEntity.FoodName,
PicturePathFood = foodEntity.PicturePathFood,
Qualification = foodEntity.Qualification,
Remarks = foodEntity.Remarks,
EstablishmentLocationId = foodEntity.EstablishmentLocationId,
TypeFoods = ToTypeFoodResponse(foodEntity.TypeFoods),
User = ToUserResponse(foodEntity.User)
});
}
public void Activate(PlayerEntity player)
{
if (foodID == -1)
{
var item = PlateEntity.CreateEntity() as PlateEntity;
UnitEntityManager.Local.Register(item);
item.Activate(player);
}
else
{
var item = FoodEntity.CreateEntity() as FoodEntity;
item.foodID = foodID;
UnitEntityManager.Local.Register(item);
item.Activate(player);
}
}
public void UpdateAllFood(List <FoodView> newFoodList)
{
var allFood = new List <FoodEntity>();
foreach (var foodView in newFoodList)
{
var food = new FoodEntity()
{
Id = foodView.FoodId,
Name = foodView.Name,
CaloriesPer100G = foodView.CaloriesPer100G
};
allFood.Add(food);
}
_repo.UpdateAll(allFood);
}
public async Task <BaseResult <FoodEntity> > Add([FromForm] FoodEntity entity)
{
if (entity.image == null)
{
IFormFileCollection file = Request.Form.Files;
if (file != null && file.Count == 1)
{
//文件存放路径
string path = "";
//path = $"{_hostingEnvironment.WebRootPath}/Upload/Food";
//path = "E:/Upload/Food";
path = "C:/backTh/wwwroot/Food";// 绝对路劲
if (!Directory.Exists(path))
{
//路径不存在则新建路径
if (!string.IsNullOrEmpty(path))
{
Directory.CreateDirectory(path);
}
}
string fileName = file[0].FileName;
string fileExt = Path.GetExtension(fileName); //获取文件扩展名
string newFileName = Guid.NewGuid() + fileExt; //随机生成新文件名
string savePath = ""; //完整路径
savePath = path + "/" + newFileName;
using (var stream = new FileStream(savePath, FileMode.Create))
{
//写入本地
file[0].CopyTo(stream);
stream.Flush();
}
//保存到数据库
string filePath = "/wwwroot/Food/" + newFileName;
entity.image = filePath;
}
else
{
//throw new Exception("请上传一张图片且只能上传一张");
var result = new BaseResult <FoodEntity>();
result.code = "-1";
result.desc = "请上传一张图片且只能上传一张";
return(result);
}
}
return(await foodRepository.Add(entity));
}
public async Task <IActionResult> InsertFood([FromBody] FoodEntity food)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var insertFood = await _service.InsertFood(food);
return(Ok($"{food.Name} cadastrado com sucesso!"));
}
catch (Exception)
{
throw;
}
}
public async Task <IActionResult> Update([FromBody] FoodEntity food)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var update = await _service.UpdateFood(food);
return(Ok(food));
}
catch (Exception)
{
throw;
}
}
public ActionResult RemoveFood(int id)
{
FoodEntity foodItem = _foodRepository.GetSingle(id);
if (foodItem == null)
{
return(NotFound());
}
_foodRepository.Delete(id);
if (!_foodRepository.Save())
{
throw new Exception("Deleting a fooditem failed on save.");
}
return(NoContent());
}
public void Given_valid_FoodCreateDto_should_return_uri_resource()
{
var foodCreateDto = new FoodCreateDto()
{
Name = "Portata1",
Type = "Antipasto",
Calories = 100,
Created = DateTime.Now
};
var foodEntityDto = new FoodEntity()
{
Id = 10,
Name = "Portata1",
Type = "Antipasto",
Calories = 100,
Created = DateTime.Now
};
var foodDto = new FoodDto()
{
Id = 10,
Name = "Portata1",
Type = "Antipasto",
Calories = 100,
Created = DateTime.Now
};
GetMock <IMapper>().Setup(x => x.Map <FoodEntity>(It.IsAny <FoodCreateDto>())).Returns(foodEntityDto);
GetMock <IMapper>().Setup(x => x.Map <FoodDto>(It.IsAny <FoodEntity>())).Returns(foodDto);
GetMock <IFoodRepository>().Setup(x => x.Save()).Returns(true);
GetMock <IFoodRepository>().Setup(x => x.GetSingle(It.IsAny <int>())).Returns(foodEntityDto);
var actionResult = ClassUnderTest.AddFood(ApiVersion.Default, foodCreateDto);
var result = actionResult as CreatedAtRouteResult;
result.Should().NotBeNull();
result.Value.Should().BeOfType <FoodDto>();
var resultFood = result.Value as FoodDto;
resultFood.Id.Should().Be(foodDto.Id);
}
void OnFoodCollected(FoodEntity food)
{
if (previousFood != null && previousFood == food)
{
streakOf++;
}
else
{
streakOf = 1;
}
score += streakOf * food.points;
if (uiManager != null)
{
uiManager.UpdateScore(score);
}
previousFood = food;
}