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 Stock GetStockByItemid(int itemId)
{
Stock stock = new Stock();
StockDAO aDao = new StockDAO();
stock = aDao.GetStockByItemid(itemId);
return stock;
}
