public async Task <IActionResult> UpdateProfile(long userId, [FromBody] UserProfileDto userProfileDto)
{
if (!ModelState.IsValid)
{
return(new BadRequestObjectResult(ModelState));
}
using (var tx = TransactionScopeBuilder.New())
{
// NOTE: no need for transaction *** although due the def. TX level the DbContext has (serializabe) *** we should add to have repeatable read or read committed
var user = dbContext
.Set <User>()
.Include(u => u.Profile)
.First(u => u.Id == userId);
user.Profile = user.Profile ?? new UserProfile();
user.Profile.AllowedCalories = userProfileDto.AllowedCalories;
await dbContext.SaveChangesAsync();
tx.Complete();
}
return(Ok());
}
public async Task <IActionResult> CreateMeal(long userId, [FromBody] MealDto mealDto)
{
if (!ModelState.IsValid)
{
return(new BadRequestObjectResult(ModelState));
}
long?mealId = null;
using (var tx = TransactionScopeBuilder.New())
{
var user = dbContext
.Set <User>()
.First(u => u.Id == userId);
// NOTE: with DDD it would be a user.AddMeal(date, calories, desc) where inside I'd set the back-ref to User as well (always valid object graph)!
var meal = new UserMeal()
{
Date = mealDto.Date,
Calories = mealDto.Calories,
Description = mealDto.Description
};
user.Meals.Add(meal);
// it's not NH, so to get the ID we need to save
await dbContext.SaveChangesAsync();
mealId = meal.Id;
tx.Complete();
}
return(this.Created(mealId));
}
public async Task <IActionResult> UpdateMeal(long userId, long mealId, [FromBody] MealDto mealDto)
{
if (!ModelState.IsValid)
{
return(new BadRequestObjectResult(ModelState));
}
using (var tx = TransactionScopeBuilder.New())
{
var meal = (
from u in dbContext.Set <User>()
from m in u.Meals
where u.Id == userId && m.Id == mealId
select m
).First();
meal.Date = mealDto.Date;
meal.Calories = mealDto.Calories;
meal.Description = mealDto.Description;
await dbContext.SaveChangesAsync();
tx.Complete();
}
return(Ok());
}
public async Task <IActionResult> DeleteMeal(long userId, long mealId)
{
using (var tx = TransactionScopeBuilder.New())
{
var result = (
from u in dbContext.Set <User>()
from m in u.Meals
where u.Id == userId && m.Id == mealId
select new { User = u, Meal = m }
).First();
// NOTE: remove will just unassign if the 1:N is mapped without IsRequired (and will delete if ISRequired was used at mapping)
result.User.Meals.Remove(result.Meal);
await dbContext.SaveChangesAsync();
tx.Complete();
}
return(Ok());
}