public async Task CreateAsync(HealthCareModel healthCareModel)
{
var sql = $@"insert into health_care (id, foods, drinks, blood_sugar, blood_pressure, date, notes)
values(@Id, @Foods, @Drinks, @BloodSugar, @BloodPressure, @Date, @Notes);";
using var connection = await _connectionPool.OpenConnectionAsync();
await connection.ExecuteAsync(sql, healthCareModel);
}
public async Task UpdateAsync(HealthCareModel healthCareModel)
{
var sql = $@"update health_care
set foods = @Foods, drinks = @Drinks, blood_sugar = @BloodSugar, blood_pressure = @BloodPressure, date = @Date, updated_at = now(), notes = @Notes
where id = @Id;";
using var connection = await _connectionPool.OpenConnectionAsync();
await connection.ExecuteAsync(sql, healthCareModel);
}
public async Task <IActionResult> Post(CreateHealthCare healthCare)
{
var newHealthCare = new HealthCareModel
{
Foods = healthCare.Foods,
Drinks = healthCare.Drinks,
BloodSugar = healthCare.BloodSugar,
BloodPressure = healthCare.BloodPressure,
Date = healthCare.Date,
Notes = healthCare.Notes
};
await _healthCareService.CreateAsync(newHealthCare);
return(Ok());
}
public UnitOfWork()
{
_context = new HealthCareModel();
}
public async Task <IActionResult> Put(HealthCareModel healthCare)
{
await _healthCareService.UpdateAsync(healthCare);
return(Ok());
}
/// <summary>
/// Public constructor to initialize private variables
/// </summary>
/// <param name="context"></param>
public GenericRepository(HealthCareModel context)
{
this.Context = context;
this.DbSet = context.Set <TEntity>();
}
