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