public void DeleteWarehouseItem(WarehouseItem warehouseItem) { if (dataContext.WarehouseItems.Contains(warehouseItem)) { dataContext.WarehouseItems.Remove(warehouseItem); } else { throw new ArgumentException($"There isn't item with {warehouseItem.Id} id in warehouse"); } }
public WarehouseMutationOrderDetail VHasWarehouseItemTo(WarehouseMutationOrderDetail warehouseMutationOrderDetail, IWarehouseMutationOrderService _warehouseMutationOrderService, IWarehouseItemService _warehouseItemService) { WarehouseMutationOrder warehouseMutationOrder = _warehouseMutationOrderService.GetObjectById(warehouseMutationOrderDetail.WarehouseMutationOrderId); WarehouseItem warehouseItemTo = _warehouseItemService.FindOrCreateObject(warehouseMutationOrder.WarehouseToId, warehouseMutationOrderDetail.ItemId); if (warehouseItemTo == null) { warehouseMutationOrderDetail.Errors.Add("Generic", "Tidak terasosiasi dengan item dari warehouse yang dituju"); } return(warehouseMutationOrderDetail); }
public StockAdjustmentDetail VHasWarehouseItem(StockAdjustmentDetail stockAdjustmentDetail, IStockAdjustmentService _stockAdjustmentService, IWarehouseItemService _warehouseItemService) { StockAdjustment stockAdjustment = _stockAdjustmentService.GetObjectById(stockAdjustmentDetail.StockAdjustmentId); WarehouseItem warehouseItem = _warehouseItemService.FindOrCreateObject(stockAdjustment.WarehouseId, stockAdjustmentDetail.ItemId); if (warehouseItem == null) { stockAdjustmentDetail.Errors.Add("Generic", "Tidak terasosiasi dengan warehouse"); } return(stockAdjustmentDetail); }
public RollerWarehouseMutationDetail VHasWarehouseItemFrom(RollerWarehouseMutationDetail rollerWarehouseMutationDetail, IRollerWarehouseMutationService _rollerWarehouseMutationService, IWarehouseItemService _warehouseItemService) { RollerWarehouseMutation rollerWarehouseMutation = _rollerWarehouseMutationService.GetObjectById(rollerWarehouseMutationDetail.RollerWarehouseMutationId); WarehouseItem warehouseItemFrom = _warehouseItemService.FindOrCreateObject(rollerWarehouseMutation.WarehouseFromId, rollerWarehouseMutationDetail.ItemId); if (warehouseItemFrom == null) { rollerWarehouseMutationDetail.Errors.Add("Generic", "Tidak terasosiasi dengan item dari warehouse yang sebelum"); } return(rollerWarehouseMutationDetail); }
public void Delete(WarehouseItem warehouseItem) { using (var storage = new Storage()) { var itemToDelete = storage.Get <WarehouseItemDto>().SingleOrDefault(t => t.Id == warehouseItem.Id); if (itemToDelete != null) { storage.Remove(itemToDelete); } } }
public void RemoveFactureTest() { Car Car1 = new Car("Alfa Romeo", "Brera", "Italia Independent", 210, "Matte Grey", VehicleType.Coupe, FuelType.Diesel, Transmission.Manual); Client c1 = new Client("Jan", "Kowalski", 111111, Guid.Parse("1981e86b-2f16-4b61-9d91-664bfed3ebc5")); WarehouseItem wi1 = new WarehouseItem(Car1, 10000, Guid.Parse("594e4c41-7e20-432c-9773-085d75e9b90b")); Facture f1 = new Facture(c1, wi1, Guid.Parse("594e4c41-7e20-432c-9773-085d75e9b90b"), Convert.ToDateTime("5.11.2020")); dataRepository.AddFacture(f1); Assert.AreEqual(dataRepository.GetFacture(f1.Id), f1); dataRepository.DeleteFacture(f1); Assert.AreEqual(0, dataRepository.GetAllFactures().Count()); }
public void RemoveBillTest() { Car Car1 = new Car("Alfa Romeo", "Brera", "Italia Independent", 210, "Matte Grey", VehicleType.Coupe, FuelType.Diesel, Transmission.Manual); WarehouseItem wi1 = new WarehouseItem(Car1, 10000, Guid.Parse("594e4c41-7e20-432c-9773-085d75e9b90b")); BillOfSale b1 = new BillOfSale(wi1, Guid.Parse("594e4c41-7e20-432c-9773-085d75e9b90b"), Convert.ToDateTime("5.11.2020")); dataRepository.AddBill(b1); Assert.AreEqual(dataRepository.GetBill(b1.Id), b1); dataRepository.DeleteBill(b1); Assert.AreEqual(0, dataRepository.GetAllBillesOfSale().Count()); }
public void RemoveWarehouseItemTest() { Assert.AreEqual(0, dataRepository.GetAllWarehouseItems().Count()); Car Car1 = new Car("Alfa Romeo", "Brera", "Italia Independent", 210, "Matte Grey", VehicleType.Coupe, FuelType.Diesel, Transmission.Manual); Client c1 = new Client("Jan", "Kowalski", 111111, Guid.Parse("1981e86b-2f16-4b61-9d91-664bfed3ebc5")); WarehouseItem wi1 = new WarehouseItem(Car1, 10000, Guid.Parse("594e4c41-7e20-432c-9773-085d75e9b90b")); dataRepository.AddWarehouseItem(wi1); Assert.AreEqual(1, dataRepository.GetAllWarehouseItems().Count()); dataRepository.DeleteWarehouseItem(wi1); Assert.AreEqual(0, dataRepository.GetAllWarehouseItems().Count()); }
/*public CashSalesInvoiceDetail VHasQuantityPricing(CashSalesInvoiceDetail cashSalesInvoiceDetail, IItemService _itemService, IQuantityPricingService _quantityPricingService) * { * Item item = _itemService.GetObjectById(cashSalesInvoiceDetail.ItemId); * IList<QuantityPricing> quantityPricings = _quantityPricingService.GetObjectsByItemTypeId(item.ItemTypeId); * if (quantityPricings.Any()) * { * cashSalesInvoiceDetail.Errors.Add("Generic", "Tidak ada QuantityPricing terasosiasi"); * } * return cashSalesInvoiceDetail; * }*/ public CashSalesInvoiceDetail VIsValidQuantityOrdered(CashSalesInvoiceDetail cashSalesInvoiceDetail, ICashSalesInvoiceService _cashSalesInvoiceService, IWarehouseItemService _warehouseItemService) { CashSalesInvoice cashSalesInvoice = _cashSalesInvoiceService.GetObjectById(cashSalesInvoiceDetail.CashSalesInvoiceId); WarehouseItem warehouseItem = _warehouseItemService.FindOrCreateObject(cashSalesInvoice.WarehouseId, cashSalesInvoiceDetail.ItemId); if (warehouseItem.Quantity - cashSalesInvoiceDetail.Quantity < 0) { cashSalesInvoiceDetail.Errors.Add("Generic", "Quantity harus lebih kecil atau sama dengan WarehouseItem Quantity"); return(cashSalesInvoiceDetail); } return(cashSalesInvoiceDetail); }
public async void AddStock(int barCode, int stock) { WarehouseItem i = db.Stock.Find(barCode); if (i != null) { i.amount += stock; await db.SaveChangesAsync(); } }
public RetailPurchaseInvoiceDetail VIsValidQuantityOrdered(RetailPurchaseInvoiceDetail retailPurchaseInvoiceDetail, IRetailPurchaseInvoiceService _retailPurchaseInvoiceService, IWarehouseItemService _warehouseItemService) { RetailPurchaseInvoice retailPurchaseInvoice = _retailPurchaseInvoiceService.GetObjectById(retailPurchaseInvoiceDetail.RetailPurchaseInvoiceId); WarehouseItem warehouseItem = _warehouseItemService.FindOrCreateObject(retailPurchaseInvoice.WarehouseId, retailPurchaseInvoiceDetail.ItemId); if (warehouseItem.Quantity - retailPurchaseInvoiceDetail.Quantity < 0) { retailPurchaseInvoiceDetail.Errors.Add("Generic", "Quantity harus lebih kecil atau sama dengan WarehouseItem Quantity"); return(retailPurchaseInvoiceDetail); } return(retailPurchaseInvoiceDetail); }
public RetailPurchaseInvoiceDetail VIsValidQuantity(RetailPurchaseInvoiceDetail retailPurchaseInvoiceDetail, IRetailPurchaseInvoiceService _retailPurchaseInvoiceService, IWarehouseItemService _warehouseItemService) { RetailPurchaseInvoice retailPurchaseInvoice = _retailPurchaseInvoiceService.GetObjectById(retailPurchaseInvoiceDetail.RetailPurchaseInvoiceId); WarehouseItem warehouseItem = _warehouseItemService.FindOrCreateObject(retailPurchaseInvoice.WarehouseId, retailPurchaseInvoiceDetail.ItemId); if (retailPurchaseInvoiceDetail.Quantity <= 0 || retailPurchaseInvoiceDetail.Quantity >= warehouseItem.Quantity) { retailPurchaseInvoiceDetail.Errors.Add("Quantity", "Quantity harus lebih besar dari 0 dan lebih kecil dari WarehouseItem Quantity"); return(retailPurchaseInvoiceDetail); } return(retailPurchaseInvoiceDetail); }
public BarringOrderDetail FinishObject(BarringOrderDetail barringOrderDetail, DateTime FinishedDate, IBarringOrderService _barringOrderService, IStockMutationService _stockMutationService, IBarringService _barringService, IItemService _itemService, IWarehouseItemService _warehouseItemService) { barringOrderDetail.FinishedDate = FinishedDate; if (_validator.ValidFinishObject(barringOrderDetail, _barringOrderService)) { _repository.FinishObject(barringOrderDetail); // add barring order quantity final // if valid, complete barring order = true BarringOrder barringOrder = _barringOrderService.GetObjectById(barringOrderDetail.BarringOrderId); barringOrder.QuantityFinal += 1; _barringOrderService.AdjustQuantity(barringOrder); if (_barringOrderService.GetValidator().ValidCompleteObject(barringOrder, this)) { _barringOrderService.CompleteObject(barringOrder, this, _barringService, _itemService, _warehouseItemService); } bool CaseAdditionElse = false; bool CaseAdditionBarring = true; // add barring quantity Barring barring = _barringService.GetObjectById(barringOrderDetail.BarringId); WarehouseItem warehouseBarring = _warehouseItemService.FindOrCreateObject(barringOrder.WarehouseId, barring.Id); StockMutation stockMutation = _stockMutationService.CreateStockMutationForBarringOrder(barringOrderDetail, warehouseBarring, CaseAdditionBarring); _stockMutationService.StockMutateObject(stockMutation, _itemService, _barringService, _warehouseItemService); // deduce bars quantity if (barringOrderDetail.IsBarRequired) { Item leftbar = (barringOrderDetail.HasLeftBar && barring.LeftBarItemId != null) ? _itemService.GetObjectById((int)barring.LeftBarItemId) : null; Item rightbar = (barringOrderDetail.HasRightBar && barring.RightBarItemId != null) ? _itemService.GetObjectById((int)barring.RightBarItemId) : null; if (leftbar != null) { WarehouseItem warehouseLeftBar = _warehouseItemService.FindOrCreateObject(barringOrder.WarehouseId, leftbar.Id); StockMutation stockMutationLeftBar = _stockMutationService.CreateStockMutationForBarringOrder(barringOrderDetail, warehouseLeftBar, CaseAdditionElse); _stockMutationService.StockMutateObject(stockMutationLeftBar, _itemService, _barringService, _warehouseItemService); } if (rightbar != null) { WarehouseItem warehouseRightBar = _warehouseItemService.FindOrCreateObject(barringOrder.WarehouseId, rightbar.Id); StockMutation stockMutationRightBar = _stockMutationService.CreateStockMutationForBarringOrder(barringOrderDetail, warehouseRightBar, CaseAdditionElse); _stockMutationService.StockMutateObject(stockMutationRightBar, _itemService, _barringService, _warehouseItemService); } } // deduce blanket quantity WarehouseItem warehouseBlanket = _warehouseItemService.FindOrCreateObject(barringOrder.WarehouseId, barring.BlanketItemId); StockMutation stockMutationBlanket = _stockMutationService.CreateStockMutationForBarringOrder(barringOrderDetail, warehouseBlanket, CaseAdditionElse); _stockMutationService.StockMutateObject(stockMutationBlanket, _itemService, _barringService, _warehouseItemService); } return(barringOrderDetail); }
public void AddInventory(Transform targetTransform, WarehouseItem droppedObject) { GameManager.Instance.AdjustCash(-droppedObject.Value / 2); GameManager.Instance.PlayAudioClip(GameManager.SoundEffects.TrashCrumple); var ph = droppedObject.GetComponent <Draggable>().placeholder; if (ph != null) { Destroy(ph); } Destroy(droppedObject.gameObject); }
public CashSalesInvoiceDetail VIsValidQuantity(CashSalesInvoiceDetail cashSalesInvoiceDetail, ICashSalesInvoiceService _cashSalesInvoiceService, IWarehouseItemService _warehouseItemService) { CashSalesInvoice cashSalesInvoice = _cashSalesInvoiceService.GetObjectById(cashSalesInvoiceDetail.CashSalesInvoiceId); WarehouseItem warehouseItem = _warehouseItemService.FindOrCreateObject(cashSalesInvoice.WarehouseId, cashSalesInvoiceDetail.ItemId); if (cashSalesInvoiceDetail.Quantity <= 0 || cashSalesInvoiceDetail.Quantity > warehouseItem.Quantity) { cashSalesInvoiceDetail.Errors.Add("Quantity", "Quantity harus lebih besar dari 0 dan lebih kecil atau sama dengan WarehouseItem Quantity"); return(cashSalesInvoiceDetail); } return(cashSalesInvoiceDetail); }
public BarringOrderDetail UnfinishObject(BarringOrderDetail barringOrderDetail, IBarringOrderService _barringOrderService, IStockMutationService _stockMutationService, IBarringService _barringService, IItemService _itemService, IWarehouseItemService _warehouseItemService) { if (_validator.ValidUnfinishObject(barringOrderDetail, _barringOrderService)) { _repository.UnfinishObject(barringOrderDetail); // deduce barring order quantity final BarringOrder barringOrder = _barringOrderService.GetObjectById(barringOrderDetail.BarringOrderId); barringOrder.QuantityFinal -= 1; _barringOrderService.AdjustQuantity(barringOrder); // reverse stock mutation Barring barring = _barringService.GetObjectById(barringOrderDetail.BarringId); WarehouseItem warehouseBarring = _warehouseItemService.FindOrCreateObject(barringOrder.WarehouseId, barring.Id); IList <StockMutation> stockMutations = _stockMutationService.SoftDeleteStockMutationForBarringOrder(barringOrderDetail, warehouseBarring); foreach (var stockMutation in stockMutations) { _stockMutationService.ReverseStockMutateObject(stockMutation, _itemService, _barringService, _warehouseItemService); } if (barringOrderDetail.IsBarRequired) { Item leftbar = (barringOrderDetail.HasLeftBar && barring.LeftBarItemId != null) ? _itemService.GetObjectById((int)barring.LeftBarItemId) : null; Item rightbar = (barringOrderDetail.HasRightBar && barring.RightBarItemId != null) ? _itemService.GetObjectById((int)barring.RightBarItemId) : null; if (leftbar != null) { WarehouseItem warehouseLeftBar = _warehouseItemService.FindOrCreateObject(barringOrder.WarehouseId, leftbar.Id); IList <StockMutation> stockMutationLeftBars = _stockMutationService.SoftDeleteStockMutationForBarringOrder(barringOrderDetail, warehouseLeftBar); foreach (var stockMutationLeftBar in stockMutationLeftBars) { _stockMutationService.ReverseStockMutateObject(stockMutationLeftBar, _itemService, _barringService, _warehouseItemService); } } if (rightbar != null) { WarehouseItem warehouseRightBar = _warehouseItemService.FindOrCreateObject(barringOrder.WarehouseId, rightbar.Id); IList <StockMutation> stockMutationRightBars = _stockMutationService.SoftDeleteStockMutationForBarringOrder(barringOrderDetail, warehouseRightBar); foreach (var stockMutationRightBar in stockMutationRightBars) { _stockMutationService.ReverseStockMutateObject(stockMutationRightBar, _itemService, _barringService, _warehouseItemService); } } } WarehouseItem warehouseBlanket = _warehouseItemService.FindOrCreateObject(barringOrder.WarehouseId, barring.BlanketItemId); IList <StockMutation> stockMutationBlankets = _stockMutationService.SoftDeleteStockMutationForBarringOrder(barringOrderDetail, warehouseBlanket); foreach (var stockMutationBlanket in stockMutationBlankets) { _stockMutationService.ReverseStockMutateObject(stockMutationBlanket, _itemService, _barringService, _warehouseItemService); } } return(barringOrderDetail); }
public RecoveryAccessoryDetail VQuantityInStock(RecoveryAccessoryDetail recoveryAccessoryDetail, IRecoveryOrderService _recoveryOrderService, IRecoveryOrderDetailService _recoveryOrderDetailService, IItemService _itemService, IWarehouseItemService _warehouseItemService) { RecoveryOrderDetail detail = _recoveryOrderDetailService.GetObjectById(recoveryAccessoryDetail.RecoveryOrderDetailId); RecoveryOrder recoveryOrder = _recoveryOrderService.GetObjectById(detail.RecoveryOrderId); WarehouseItem warehouseItem = _warehouseItemService.FindOrCreateObject(recoveryOrder.WarehouseId, recoveryAccessoryDetail.ItemId); if (warehouseItem.Quantity < recoveryAccessoryDetail.Quantity) { recoveryAccessoryDetail.Errors.Add("Quantity", "Tidak boleh lebih dari jumlah stock barang"); } return(recoveryAccessoryDetail); }
public void StockMutateObject(StockMutation stockMutation, IItemService _itemService, IBarringService _barringService, IWarehouseItemService _warehouseItemService) { // decimal stockAdjustmentDetailPrice = (stockMutation.Status == Constant.MutationStatus.Addition) ? stockAdjustmentDetail.Price : ((-1) * stockAdjustmentDetail.Price); // item.AvgCost = _barringService.CalculateAvgCost(item, stockAdjustmentDetail.Quantity, stockAdjustmentDetailPrice); // barring.AvgCost = _barringService.CalculateAvgCost(barring, stockAdjustmentDetail.Quantity, stockAdjustmentDetailPrice); int Quantity = (stockMutation.Status == Constant.MutationStatus.Addition) ? stockMutation.Quantity : (-1) * stockMutation.Quantity; WarehouseItem warehouseItem = _warehouseItemService.GetObjectById(stockMutation.WarehouseItemId); Item item = _itemService.GetObjectById(stockMutation.ItemId); Barring barring = _barringService.GetObjectById(stockMutation.ItemId); if (warehouseItem != null) { if (stockMutation.ItemCase == Constant.ItemCase.Ready) { _warehouseItemService.AdjustQuantity(warehouseItem, Quantity); } } if (barring == null) { // itemService in action if (stockMutation.ItemCase == Constant.ItemCase.Ready) { _itemService.AdjustQuantity(item, Quantity); } else if (stockMutation.ItemCase == Constant.ItemCase.PendingDelivery) { _itemService.AdjustPendingDelivery(item, Quantity); } else if (stockMutation.ItemCase == Constant.ItemCase.PendingReceival) { _itemService.AdjustPendingReceival(item, Quantity); } } else { // barringService in action if (stockMutation.ItemCase == Constant.ItemCase.Ready) { _barringService.AdjustQuantity(barring, Quantity); } else if (stockMutation.ItemCase == Constant.ItemCase.PendingDelivery) { _barringService.AdjustPendingDelivery(barring, Quantity); } else if (stockMutation.ItemCase == Constant.ItemCase.PendingReceival) { _barringService.AdjustPendingReceival(barring, Quantity); } } }
public void WarehouseItemTest() { var warehouse = CreateTestWarehouse(); var goodsItem = CreateTestGoodsItem(); try { var item = new WarehouseItem(); item.GoodsItemID = goodsItem.GoodsItemID; item.RepairPrice = 22.56; item.SalePrice = 663.44; item.StartPrice = 354.0; item.Total = 33.2; item.WarehouseID = warehouse.WarehouseID; var store = CreateStore(); store.SaveWarehouseItem(item); var savedItem = store.GetWarehouseItem(item.WarehouseItemIDGuid); Assert.IsNotNull(savedItem); Assert.AreEqual(savedItem.GoodsItemID, item.GoodsItemID); Assert.AreEqual(savedItem.SalePrice, item.SalePrice); Assert.AreEqual(savedItem.RepairPrice, item.RepairPrice); Assert.AreEqual(savedItem.StartPrice, item.StartPrice); Assert.AreEqual(savedItem.Total, item.Total); Assert.AreEqual(savedItem.WarehouseID, item.WarehouseID); item.RepairPrice = 122.56; item.SalePrice = 1663.44; item.StartPrice = 1354.0; item.Total = 333.2; store.SaveWarehouseItem(item); savedItem = store.GetWarehouseItem(item.WarehouseItemIDGuid); Assert.IsNotNull(savedItem); Assert.AreEqual(savedItem.GoodsItemID, item.GoodsItemID); Assert.AreEqual(savedItem.SalePrice, item.SalePrice); Assert.AreEqual(savedItem.RepairPrice, item.RepairPrice); Assert.AreEqual(savedItem.StartPrice, item.StartPrice); Assert.AreEqual(savedItem.Total, item.Total); Assert.AreEqual(savedItem.WarehouseID, item.WarehouseID); store.DeleteWarehouseItem(item.WarehouseItemIDGuid); savedItem = store.GetWarehouseItem(item.WarehouseItemIDGuid); Assert.IsNull(savedItem); } finally { DeleteTestWarehouse(); DeleteTestGoodsItem(); } }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } WarehouseItem = await _context.WarehouseItems.FindAsync(id); if (WarehouseItem != null) { _context.CompanyWarehouseItemMappings.RemoveRange(_context.CompanyWarehouseItemMappings.Where(p => p.WarehouseItemId == WarehouseItem.Id)); _context.WarehouseItems.Remove(WarehouseItem); try { await _context.SaveChangesAsync(); } catch (Exception ex) { if (ex.GetBaseException() is SqlException) { if (ex.InnerException != null) { int errorCode = ((SqlException)ex.InnerException).Number; switch (errorCode) { case 2627: // Unique constraint error break; case 547: // Constraint check violation _toastNotification.AddErrorToastMessage("Το είδος έχει κινήσεις και δεν μπορεί να διαγραφεί"); break; case 2601: // Duplicated key row error break; default: break; } } } else { //ToDo handle normal exception throw; } } } return(RedirectToPage("./Index")); }
public WarehouseItem AddObject(Warehouse warehouse, Item item, IWarehouseService _warehouseService, IItemService _itemService) { WarehouseItem warehouseItem = new WarehouseItem() { WarehouseId = warehouse.Id, ItemId = item.Id, Quantity = 0, Warehouse = warehouse, Item = item }; return(CreateObject(warehouseItem, _warehouseService, _itemService)); }
protected Infragistics.WebUI.UltraWebGrid.UltraGridRow GetUnSelectedGridRow(object obj) { WarehouseItem item = (WarehouseItem)obj; return(new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { "", item.ItemCode, item.ItemName } )); }
public void Update(WarehouseItem warehouseItem) { using (var storage = new Storage()) { var itemToUpdate = storage.Get <WarehouseItemDto>().SingleOrDefault(t => t.Id == warehouseItem.Id); if (itemToUpdate != null) { itemToUpdate.Quantity = warehouseItem.Quantity; itemToUpdate.Kind = warehouseItem.Kind; itemToUpdate.Price = warehouseItem.Price; } } }
public string PrintError(WarehouseItem obj) { string erroroutput = ""; KeyValuePair <string, string> first = obj.Errors.ElementAt(0); erroroutput += first.Key + "," + first.Value; foreach (KeyValuePair <string, string> pair in obj.Errors.Skip(1)) { erroroutput += Environment.NewLine; erroroutput += pair.Key + "," + pair.Value; } return(erroroutput); }
public WarehouseItem Remove(int ID) { try { WarehouseItem wi = items.Find(w => w.ID == ID); items.Remove(wi); return(wi); } catch { throw new WarehouseItemException(); } }
protected Infragistics.WebUI.UltraWebGrid.UltraGridRow GetSelectedGridRow(object obj) { WarehouseItem item = (WarehouseItem)obj; return(new Infragistics.WebUI.UltraWebGrid.UltraGridRow( new object[] { "", item.ItemCode, item.ItemName, this.htItemQty[item.ItemCode].ToString() } )); }
public static void UpdateWarehouseItem(WarehouseItem item) { var param = new[] { new SqlParameter("@id", item.Id), new SqlParameter("@warehouseId", item.WarehouseId), new SqlParameter("@condition", item.Condition), new SqlParameter("@count", item.Count), new SqlParameter("@name", item.Name), new SqlParameter("@description", item.Description), }; SqlHelper.ExecuteNonQuery(SP_WAREHOUSEITEM_UPDATE, param); }
public void UpdateWarehouseItemTest() { Car Car1 = new Car("Alfa Romeo", "Brera", "Italia Independent", 210, "Matte Grey", VehicleType.Coupe, FuelType.Diesel, Transmission.Manual); Client c1 = new Client("Jan", "Kowalski", 111111, Guid.Parse("1981e86b-2f16-4b61-9d91-664bfed3ebc5")); WarehouseItem wi1 = new WarehouseItem(Car1, 10000, Guid.Parse("594e4c41-7e20-432c-9773-085d75e9b90b")); dataRepository.AddWarehouseItem(wi1); Car Car2 = new Car("Skoda", "Fabia", "Style", 210, "Silver Metalic", VehicleType.Small_car, FuelType.Petrol, Transmission.Manual); WarehouseItem wi2 = new WarehouseItem(Car2, 210000, Guid.Parse("6f16b79d-f9fd-4cc3-8e46-78f8a799b176")); dataRepository.UpdateWarehouseItem(wi1.Id, wi2); Assert.AreEqual(wi2, dataRepository.GetAllWarehouseItems().First()); }
public RollerWarehouseMutationDetail VNonNegativeStockQuantity(RollerWarehouseMutationDetail rollerWarehouseMutationDetail, IRollerWarehouseMutationService _rollerWarehouseMutationService, IItemService _itemService, IBarringService _barringService, IWarehouseItemService _warehouseItemService, bool CaseConfirm) { int Quantity = CaseConfirm ? 1 : -1; RollerWarehouseMutation rollerWarehouseMutation = _rollerWarehouseMutationService.GetObjectById(rollerWarehouseMutationDetail.RollerWarehouseMutationId); WarehouseItem warehouseItemFrom = _warehouseItemService.FindOrCreateObject(rollerWarehouseMutation.WarehouseFromId, rollerWarehouseMutationDetail.ItemId); if (warehouseItemFrom.Quantity + Quantity < 0) { rollerWarehouseMutationDetail.Errors.Add("Quantity", "Stock barang tidak boleh menjadi kurang dari 0"); return(rollerWarehouseMutationDetail); } return(rollerWarehouseMutationDetail); }
/// <summary> /// Operating events. Displaing current amount of car part from WarehouseItem. /// </summary> /// <param name="workshop">Workshop object</param> /// <param name="stock">WarehouseItem object</param> /// <param name="part">the necessary part that name is entered by user</param> public static void Events(Workshop workshop, WarehouseItem stock, string part) { int amount; Console.Write("Warehouse has the notification: "); workshop.OrderSendEvent += new Order(DisplayInformation); workshop.SendOrder(ref part); Console.Write("Warehouse sends reply: "); stock.OrderReadyEvent += new Order(DisplayInformation); stock.ReplyToOrder(part); amount = WarehouseItem.CheckAmount(); Console.WriteLine("Current number of parts in stock: " + amount); }
public void PostNewItem(ItemDTO item, string username, int warehouseId) { if(item.Id == 0) { // NEW ITEM Item newItem = new Item { Name = item.Name, ImageUrl = item.ImageUrl }; _itemRepo.Add(newItem); _itemRepo.SaveChanges(); WarehouseItem wi = new WarehouseItem { ItemId = newItem.Id, WarehouseId = warehouseId, Quantity = item.WarehouseQty }; _warehouseItemRepo.Add(wi); _warehouseItemRepo.SaveChanges(); } }