private void GetStokReceiveInfo(string docNum)
{
switch (_mode)
{
case DataActionMode.Add:
_stockH = new SKReceiveH();
_stockH.SK_Code = _SKCode;
_stockH.CreateBy = vars.USER_NAME;
_stockH.CreateDate = DateTime.Today;
_stockH.Currency = "USD";
_stockH.DocDate = DateTime.Today;
_stockH.DOC_NUM = "";
_stockH.DOC_ID = 0;
_stockH.IsPosted = false;
_stockH.PostedBy = "";
_stockH.PostedDate = null;
_stockH.ModifyBy = vars.USER_NAME;
_stockH.ModifyDate = DateTime.Today;
_stockH.OtherServices = 0m;
_stockH.Reason = "";
_stockH.ReceiveBy = vars.USER_NAME;
_stockH.Remark = "";
_stockH.TaxAndClearing = 0m;
_stockH.TotalAmount = 0m;
_stockH.TotalItemCost = 0m;
_stockH.TransportCost = 0m;
break;
case DataActionMode.Edit:
_stockH = new StockDAL().getStokInfoById(docNum);
break;
}
txtReceiveNo.Text = _stockH.DOC_NUM;
txtItemCost.Text = $"{_stockH.TotalItemCost:N2}";
txtOtherCost.Text = $"{_stockH.OtherServices:N2}";
txtReceiveBy.Text = _stockH.ReceiveBy;
txtRemark.Text = _stockH.Remark;
txtTaxClearing.Text = $"{_stockH.TaxAndClearing:N2}";
txtTotalAmount.Text = $"{_stockH.TotalAmount:N2}";
txtTransport.Text = $"{_stockH.TransportCost:N2}";
cbxCurrency.SelectedValue = _stockH.Currency;
cbxReason.Text = _stockH.Reason;
chkIsPosted.Checked = _stockH.IsPosted;
dtpDocDate.Value = _stockH.DocDate;
UpdateUI();
tsbtnRefresh.PerformClick();
}
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 updateStokReceiveH(SKReceiveH stock, DataActionMode mode)
{
try
{
switch (mode)
{
case DataActionMode.Add:
_context.SKReceiveHs.Add(stock);
break;
case DataActionMode.Edit:
var _stock = getStokInfoById(stock.DOC_NUM);
_stock.Currency = stock.Currency;
_stock.DocDate = stock.DocDate;
_stock.IsPosted = stock.IsPosted;
_stock.PostedDate = stock.PostedDate;
_stock.PostedBy = stock.PostedBy;
_stock.ModifyBy = stock.ModifyBy;
_stock.ModifyDate = stock.ModifyDate;
_stock.OtherServices = stock.OtherServices;
_stock.Reason = stock.Reason;
_stock.ReceiveBy = stock.ReceiveBy;
_stock.Remark = stock.Remark;
_stock.TaxAndClearing = stock.TaxAndClearing;
_stock.TotalAmount = stock.TotalAmount;
_stock.TotalItemCost = stock.TotalItemCost;
_stock.TransportCost = stock.TransportCost;
break;
}
return(_context.SaveChanges());
}
catch
{
return(0);
}
}
