public int PostedStockIssueItems(List <SKIssueItem> items) { int _result = 0; try { // Posting (add) all received item to StockItemTransaction foreach (SKIssueItem item in items) { DataActionMode _transMode = DataActionMode.Add; SKIssueH _issueH = GetIssueInfo(item.SKI_ISSUE_NUM); SKTRAN _sktrans = new SKTRAN(); _sktrans.CreateBy = vars.USER_NAME; _sktrans.CreateDate = DateTime.Now; _sktrans.DOC_DATE = _issueH.IssueDate; _sktrans.DOC_NUM = _issueH.ISSUE_NUM; _sktrans.CURRENCY = item.Currency; _sktrans.ITEMNAME = item.ItemName; _sktrans.ITEMNO = item.ItemNo; _sktrans.LastUpdate = DateTime.Now; _sktrans.SKT_QTY = item.IssueQty; _sktrans.SKT_SKR = item.Id; _sktrans.SKT_STATUS = 1; _sktrans.SKT_U_COST = item.UnitCost; _sktrans.SKT_TOTALCOST = item.TotalItemCost; _sktrans.U_PRICE = item.UnitPrice; _sktrans.U_DISCOUNT = 0m; _sktrans.U_NET_PRICE = item.UnitPrice; _sktrans.U_VAT = 0m; _sktrans.TOTAL_PRICE = item.TotalItemPrice; _sktrans.SK_CODE = item.SK_Code; _sktrans.SK_UNIT = item.Unit; _sktrans.UpdateBy = vars.USER_NAME; _result = UpdateSKTrans(_sktrans, _transMode); } return(_result); } catch { return(_result); } }
public int PostedStockRecivedItems(List <SKReceiveItem> items) { int _result = 0; try { // Posting (add) all received item to StockItemTransaction foreach (SKReceiveItem item in items) { DataActionMode _transMode = DataActionMode.Add; SKReceiveH _skH = getStokInfoById(item.SKR_DOC_NUM); SKTRAN _sktrans = new SKTRAN(); _sktrans.CreateBy = vars.USER_NAME; _sktrans.CreateDate = DateTime.Now; _sktrans.DOC_DATE = _skH.DocDate; _sktrans.DOC_NUM = _skH.DOC_NUM; _sktrans.CURRENCY = item.Currency; _sktrans.ITEMNAME = item.ItemName; _sktrans.ITEMNO = item.ItemNo; _sktrans.LastUpdate = DateTime.Now; _sktrans.SKT_QTY = item.Qty; _sktrans.SKT_SKR = item.SKI_ID; _sktrans.SKT_STATUS = 1; _sktrans.SKT_U_COST = item.AvgUnitCost; _sktrans.SKT_TOTALCOST = item.ItemTotalAmount; _sktrans.U_PRICE = 0m; _sktrans.U_DISCOUNT = 0m; _sktrans.U_NET_PRICE = 0m; _sktrans.U_VAT = 0m; _sktrans.TOTAL_PRICE = 0m; _sktrans.SK_CODE = item.SK_Code; _sktrans.SK_UNIT = item.Unit; _sktrans.UpdateBy = vars.USER_NAME; _result = UpdateSKTrans(_sktrans, _transMode); } return(_result); } catch { return(_result); } }
public int UpdateSKTrans(SKTRAN item, DataActionMode mode) { try { switch (mode) { case DataActionMode.Add: _context.SKTRANS.Add(item); break; case DataActionMode.Edit: var _item = GetSKTRANByItemNo(item.ITEMNO); _item.SKT_STATUS = item.SKT_STATUS; _item.CURRENCY = item.CURRENCY; _item.ITEMNAME = item.ITEMNAME; _item.SKT_QTY = item.SKT_QTY; _item.SKT_U_COST = item.SKT_U_COST; _item.SKT_TOTALCOST = item.SKT_TOTALCOST; _item.TOTAL_PRICE = item.TOTAL_PRICE; _item.U_DISCOUNT = item.U_DISCOUNT; _item.U_NET_PRICE = item.U_NET_PRICE; _item.U_PRICE = item.U_PRICE; _item.U_VAT = item.U_VAT; _item.SK_UNIT = item.SK_UNIT; _item.UpdateBy = item.UpdateBy; _item.LastUpdate = item.LastUpdate; break; } return(_context.SaveChanges()); } catch { return(0); } }