Changes between Version 2 and Version 3 of AdvancedApplicationDevelopment

Timestamp:

02/24/26 06:06:08 (4 hours ago)

Author:

221181

Comment:

--

AdvancedApplicationDevelopment

@@ -80 +80 @@
 }
 }}}
+
+=== 2. Примање на нарачка (!PurchaseOrderService.cs) === 
+
+Зошто Transaction?
+
+Кога статусот на нарачката се менува во „Received“, залихите мора да се зголемат. Ако едната операција се изврши, а другата не, ќе настане неконзистентност во податоците.
+
+{{{
+public async Task<bool> ReceivePurchaseOrderAsync(int poId)
+{
+    using var transaction = await _context.Database.BeginTransactionAsync();
+    try
+    {
+        var po = await GetPurchaseOrderByIdAsync(poId);
+        if (po == null || po.Status == "Received")
+            return false;
+
+        
+        foreach (var item in po.PurchaseOrderItems)
+        {
+            var stock = await _context.WarehouseStocks
+                .FirstOrDefaultAsync(ws => ws.WarehouseId == po.WarehouseId && ws.ProductId == item.ProductId);
+
+            if (stock == null)
+            {
+                stock = new WarehouseStock
+                {
+                    WarehouseId = po.WarehouseId,
+                    ProductId = item.ProductId,
+                    QuantityOnHand = item.Quantity
+                };
+                _context.WarehouseStocks.Add(stock);
+            }
+            else
+            {
+                stock.QuantityOnHand += item.Quantity;
+            }
+
+            stock.LastUpdated = DateTime.Now;
+            item.ReceivedQuantity = item.Quantity;
+        }
+
+        po.Status = "Received";
+        po.ActualDeliveryDate = DateTime.Now.Date;
+
+        await _context.SaveChangesAsync();
+        await transaction.CommitAsync();
+        return true;
+    }
+    catch
+    {
+        await transaction.RollbackAsync();
+        return false;
+    }
+}
+}}}