public List <TransStock> CheckRemainingItem(Int32 ItemID)
{
List <TransStock> lst = new List <TransStock>();
try
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter()
{
ParameterName = "ItemID", Value = ItemID, DbType = DbType.Int32
});
DataSet ds = conn.GetDataSet("GetItemRemaining", param);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
TransStock o = new TransStock();
foreach (DataRow dr in ds.Tables[0].Rows)
{
o = new TransStock();
o.StockID = Convert.ToInt32(dr["StockID"].ToString());
o.ItemID = Convert.ToInt32(dr["ItemID"].ToString());
o.Serial = dr["Serial"].ToString();
o.SaleHeaderID = Convert.ToInt32(dr["SaleHeaderID"].ToString());
o.SaleDetailID = Convert.ToInt32(dr["SaleDetailID"].ToString());
o.Active = dr["Active"].ToString();
lst.Add(o);
}
}
}
catch (Exception ex)
{
}
return(lst);
}
public void UpdateStock()
{
if (transItem.Reason_code == (int)EjItemReasonCodes.NORMAL_ITEM)
{
//Update stock
TransStock transStock = new TransStock();
transStock.Organization_no = PosSettings.Default.Organization;
transStock.Store_no = PosSettings.Default.Store;
transStock.Sku = transItem.Sku;
transStock.Transaction_type = (int)TransStockTypes.SALE_OUT;
transStock.Reference_number = TransItem.Trans_no.ToString().PadLeft(10, '0') + "/" + TransItem.Line_no.ToString().PadLeft(3, '0');
transStock.Quantity = PosContext.Instance.PosMath.Negate(transItem.Quantity);
transStock.Transaction_time = DateTime.Now;
transStock.Add();
StockBalance stockBalance = new StockBalance();
stockBalance.Organization_no = PosSettings.Default.Organization;
stockBalance.Store_no = PosSettings.Default.Store;
stockBalance.Sku = transItem.Sku;
stockBalance.Quantity_on_hand = PosContext.Instance.PosMath.Negate(transItem.Quantity);
stockBalance.AddBalance();
}
}
