public void Update(PajamaOrder pajamaOrder)
{
using var db = new SqlConnection(ConnectionString);
var sql = @"UPDATE [PajamaOrder]
SET [OrderId] = @OrderId,
[PajamaId] = @PajamaId,
[Quantity] = @Quantity
WHERE id = @id";
db.Execute(sql, pajamaOrder);
}
public void Add(PajamaOrder pajamaOrder)
{
var sql = @"INSERT INTO [PajamaOrder] ([OrderId],[PajamaId],[Quantity])
OUTPUT inserted.id
VALUES(@orderId, @pajamaId, @quantity)";
using var db = new SqlConnection(ConnectionString);
var id = db.ExecuteScalar <int>(sql, pajamaOrder);
pajamaOrder.Id = id;
}
public IActionResult UpdatePajamaOrder(PajamaOrder pajamaOrder)
{
_repo.Update(pajamaOrder);
return(Ok(pajamaOrder));
}
public IActionResult AddPajamaOrder(PajamaOrder pajamaOrder)
{
_repo.Add(pajamaOrder);
return(Created($"api/PajamaOrders/{pajamaOrder.Id}", pajamaOrder));
}
