public void InsertStockOrUpdate(Stock aStock) { Stock stock=new Stock(); StockDAO aDao=new StockDAO(); stock = aDao.GetStockByItemid(aStock.Item.ItemId); if(stock.StockId==0) { aDao.InsertStock(aStock); } else if(stock.StockId>0) { double pricePrevious = stock.Stocks*stock.UnitPrice; double priceNow = aStock.Stocks * aStock.UnitPrice; double totalStocks = stock.Stocks + aStock.Stocks; double totalPrice = priceNow + pricePrevious; stock.Stocks = totalStocks; if (totalStocks != 0 && totalPrice != 0) { aStock.UnitPrice = totalPrice / totalStocks; } else aStock.UnitPrice = 0; stock.StockId = stock.StockId; aDao.UpdateStock(stock); } }
public void UpdateKitchenStockForDamage(Stock aStock) { Stock stock = new Stock(); StockDAO aDao = new StockDAO(); stock = aDao.GetStockByItemidFrominventory_kitchen_stock(aStock.Item.ItemId); if (stock.StockId == 0) { aDao.InsertStock(aStock); } else if (stock.StockId > 0) { double pricePrevious = stock.Stocks * stock.UnitPrice; //double priceNow = aStock.Stocks * aStock.UnitPrice; double totalStocks = stock.Stocks - aStock.Stocks; // double totalPrice = priceNow + pricePrevious; stock.Stocks = totalStocks; if (pricePrevious != 0 && totalStocks != 0) { stock.UnitPrice = pricePrevious / totalStocks; } else stock.UnitPrice = 0; stock.StockId = stock.StockId; aDao.UpdateKitchenStock(stock); } }
public void UpdateKitchenStockForSendOut(Stock aStock) { Stock stock = new Stock(); StockDAO aDao = new StockDAO(); stock = aDao.GetStockByItemidFrominventory_kitchen_stock(aStock.Item.ItemId); if (stock.StockId == 0) { aDao.InsertStock(aStock); } else if (stock.StockId > 0) { double totalStocks = stock.Stocks - aStock.Stocks; // double totalPrice = priceNow + pricePrevious; stock.Stocks = totalStocks; stock.StockId = stock.StockId; aDao.UpdateKitchenStock(stock); } }