private SqlCommand ConsumptionCommand(string query, ConsumptionInput consumption, SqlConnection conn)
{
SqlCommand command = new SqlCommand(query, conn);
command.Parameters.AddWithValue("@food_name", consumption.FoodName);
command.Parameters.AddWithValue("@kcal", consumption.KCal);
command.Parameters.AddWithValue("@protein", consumption.Protein);
command.Parameters.AddWithValue("@fiber", consumption.Fiber);
command.Parameters.AddWithValue("@calium", consumption.Calium);
command.Parameters.AddWithValue("@sodium", consumption.Sodium);
command.Parameters.AddWithValue("@amount", consumption.Amount);
command.Parameters.AddWithValue("@weight_unit_id", consumption.WeightUnitId);
command.Parameters.AddWithValue("@date", consumption.Date);
command.Parameters.AddWithValue("@patient_id", consumption.PatientId);
return(command);
}
public async Task <bool> AddConsumption(ConsumptionInput consumption)
{
bool added;
var insert = $"INSERT INTO Consumption " +
$"(food_name, kcal, protein, fiber, calium, sodium, amount, weight_unit_id, date, patient_id)";
var values = $" VALUES (@food_name, @kcal, @protein, @fiber, @calium, @sodium, @amount, @weight_unit_id, @date, @patient_id)";
var insertQuery = insert + values;
using (SqlConnection conn = new SqlConnection(Environment.GetEnvironmentVariable("sqldb_connection")))
{
conn.Open();
try
{
added = await ConsumptionCommand(insertQuery, consumption, conn).ExecuteNonQueryAsync() > 0;
}
catch (Exception)
{
added = false;
}
conn.Close();
}
return(added);
}
public async Task <bool> UpdateConsumption(int consumptionId, ConsumptionInput consumption)
{
bool updated;
var updateQuery = $"UPDATE Consumption SET " +
$"food_name = @food_name, kcal = @kcal, protein = @protein, fiber = @fiber, " +
$"calium = @calium, sodium = @sodium, amount = @amount, weight_unit_id = @weight_unit_id, " +
$"date = @date, patient_id = @patient_id " +
$"Where Id = {consumptionId}";
using (SqlConnection conn = new SqlConnection(Environment.GetEnvironmentVariable("sqldb_connection")))
{
conn.Open();
try
{
updated = await ConsumptionCommand(updateQuery, consumption, conn).ExecuteNonQueryAsync() > 0;
}
catch (Exception)
{
updated = false;
}
conn.Close();
}
return(updated);
}