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