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); }