public async Task <int> Delete(CoffeeItem coffeeItem)
{
await ThrowExceptionIfCoffeeDoesNotExist(coffeeItem.Id);
var sql = @"DELETE FROM Coffee
WHERE Id = @Id;";
using (var conn = sqlServerConnectionProvider.GetDbConnection())
{
return(await conn.ExecuteAsync(sql, new
{
coffeeItem.Id,
coffeeItem.Name,
coffeeItem.Description,
coffeeItem.CaffeineContent
}));
}
}
public IActionResult Post(CoffeeItem item)
{
CoffeeItem exist = _context.CoffeeItems.Find(item.Id);
if (exist == null)
{
_context.CoffeeItems.Add(item);
_context.SaveChanges();
return(CreatedAtRoute("coffee", new { id = item.Id }, item));
}
else
{
Debug.Print("SERVER INFO item name:" + item.Name);
exist.Name = item.Name;
_context.SaveChanges();
return(CreatedAtRoute("coffee", new { id = item.Id }, item));
}
}
public async Task <int> Update(CoffeeItem coffeeItem)
{
await ThrowExceptionIfCoffeeDoesNotExist(coffeeItem.Id);
var sql = @"UPDATE Coffee
SET name = @Name, description = @Description, caffeineContent = @CaffeineContent
WHERE Id = @Id;";
using (var conn = sqlServerConnectionProvider.GetDbConnection())
{
return(await conn.ExecuteAsync(sql, new
{
coffeeItem.Id,
coffeeItem.Name,
coffeeItem.Description,
coffeeItem.CaffeineContent
}));
}
}
//SQL Delete Coffee
public void DeleteCoffeeItem(CoffeeItem item)
{
//TODO
}
public async Task <IActionResult> UpdateCoffee(int coffeeId, CoffeeItem coffeeItem)
{
return(await mediator.Send(new UpdateCoffeeCommand(coffeeId, coffeeItem)));
}
public UpdateCoffeeCommand(int coffeeCoffeeId, CoffeeItem coffeeItem)
{
this.CoffeeId = coffeeCoffeeId;
this.CoffeeItem = coffeeItem;
}
