private Boolean updateStockOnHand(Location stkLocation,Product stkProduct,string LotNo,double Qty,decimal TotalCost) { var blnResult = false; var queryStock = (from stock in StockOnHands where stock.Location.Id == stkLocation.Id && stock.Product.Id == stkProduct.Id && stock.LotNo == LotNo select stock).FirstOrDefault(); if(queryStock != null){ queryStock.QuantityOnHand = queryStock.QuantityOnHand + Qty; queryStock.CostPrice = queryStock.CostPrice + TotalCost; queryStock.IsAvailableForSale = false; blnResult = true; } else{ StockOnHand newStock = new StockOnHand(); newStock.Location = stkLocation; newStock.Product = stkProduct; newStock.LotNo = LotNo; newStock.CostPrice = TotalCost; newStock.IsAvailableForSale = false; newStock.QuantityOnHand = Qty; newStock.SellingPrice = 0; blnResult = true; } return blnResult; }
partial void StockOnHands_Updated(StockOnHand entity) { }