public void CreateFoodEntry(FoodEntryCreateModel createModel)
{
try
{
Guid foodEntryId = createModel.FoodEntryId;
int userId = createModel.UserId;
int foodId = createModel.FoodId;
string dateAdded = createModel.DateAdded.ToString("yyyy-MM-dd");
double servingAmount = createModel.ServingAmount;
int selectedServingId = createModel.SelectedServingId;
string sql = $"call create_food_entry('{foodEntryId}',{userId},{foodId},'{dateAdded}',{servingAmount},{selectedServingId})";
using (var connection = _dbConnectionFactory.CreateConnection(ConfigurationsHelper.ConnectionString))
{
connection.Open();
connection.Execute(sql);
}
}
catch (Exception e)
{
throw e;
}
}
public IActionResult CreateFoodEntry([FromBody] FoodEntryCreateModel createModel)
{
CreateFoodEntryResponse response = _foodEntryService.CreateFoodEntry(createModel);
if (!response.ResponseStatus.HasError())
{
return(Ok());
}
return(StatusCode(response.ResponseStatus.Status, response.ResponseStatus.Message));
}
public CreateFoodEntryResponse CreateFoodEntry(FoodEntryCreateModel createModel)
{
CreateFoodEntryResponse response = new CreateFoodEntryResponse();
try
{
_foodEntryRepository.CreateFoodEntry(createModel);
response.ResponseStatus.SetOk();
}
catch (Exception e)
{
_logger.LogError(e.ToString());
response.ResponseStatus.SetError(ResponseStatusCode.INTERNAL_SERVER_ERROR,
e.ToString());
}
return(response);
}
