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)); }