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