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