public int calculateBalance(string stCardId, int adjQty) { StockCardDetailEnt stCardDetailEnt1 = new StockCardDetailEnt(); StockCard_Detail stCardDetail1 = new StockCard_Detail(); stCardDetail1.StockCard_ID = stCardId; int bal= (int)stCardDetailEnt1.getStockCardDetail(stCardDetail1).First().Balance; int adjustedQty = bal + adjQty; return adjustedQty; }
public void updateStock(string vocID, string itemCode, int adjQty, string userId, DateTime date) { StockCardDetailEnt stCardDetailEnt = new StockCardDetailEnt(); StockCard_Detail stCardDetail = new StockCard_Detail(); string stCardId = getStockCardID(itemCode); stCardDetail.StockCard_ID=stCardId; stCardDetail.Tran_ID= getTransactionID("StockCard_Detail"); stCardDetail.Emp_ID=userId; stCardDetail.Date=date; stCardDetail.Dept_Supplier=stCardDetail.Dept_Supplier; stCardDetail.Qty=adjQty; stCardDetail.Balance= calculateBalance(stCardId, adjQty); stCardDetailEnt.createStockCardDetail(stCardDetail); }