public void DeleteNutritionGoal(NutritionGoal goal)
{
using (var conn = CreateConnection())
using (var tran = conn.BeginTransaction())
{
try
{
conn.Execute("UPDATE NutritionGoal SET Deleted=@Deleted WHERE Id=@Id", new { goal.Id, Deleted = DateTimeOffset.Now }, tran);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
}
}
public void ActivateNutritionGoal(NutritionGoal goal)
{
using (var conn = CreateConnection())
using (var tran = conn.BeginTransaction())
{
try
{
conn.Execute("UPDATE NutritionGoal SET Active=0 WHERE UserId=@UserId", new { goal.UserId }, tran);
conn.Execute("UPDATE NutritionGoal SET Active=1 WHERE Id=@Id", new { goal.Id }, tran);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
}
}