private void AddToItem(ItemInventoryBatch itemInventoryBatch, string e) { IObjectSpace objectSpace = View.ObjectSpace.CreateNestedObjectSpace(); InventoryItemBatchItems items = objectSpace.CreateObject <InventoryItemBatchItems>( ); items.InventoryBatch = itemInventoryBatch; items.NDC = "123456"; items.Qty = 1; items.Lot = "lot123"; items.ExpirationDate = DateTime.Now; items.Save(); objectSpace.CommitChanges(); }
private int AddToItems(object sender, string itemnumber, string lot, string expdate, string scan) { // this counts for non serialized numbers // editor1 = ((DetailView)View).FindItem("Items") as ListPropertyEditor; IObjectSpace objectspace = this.ObjectSpace.CreateNestedObjectSpace(); // InventoryItemBatchItems iiBi = this.ObjectSpace.GetObject<InventoryItemBatchItems>(); ItemInventoryBatch iib = objectToShow; // Find the item in the item list // bool found = false; Session session; session = objectToShow.Session; CriteriaOperator op = GroupOperator.Combine(GroupOperatorType.And, new BinaryOperator("InventoryBatch", iib.Oid), new BinaryOperator("NDC", itemnumber), new BinaryOperator("Lot", lot)); InventoryItemBatchItems itemToUpdate = (InventoryItemBatchItems)session.FindObject(typeof(InventoryItemBatchItems), op, true); if (itemToUpdate != null) { itemToUpdate.Qty++; itemToUpdate.Save(); session.CommitTransaction(); } else { InventoryItemBatchItems iibi; iibi = objectspace.CreateObject <InventoryItemBatchItems>(); iibi.InventoryBatch = objectspace.GetObject <ItemInventoryBatch>((ItemInventoryBatch)this.View.CurrentObject); //iibi.InventoryBatch.Oid = iib.Oid; iibi.NDC = itemnumber; iibi.Lot = lot; iibi.Qty = 1; DateTime result; if (DateTime.TryParse(expdate, out result)) { iibi.ExpirationDate = result; } iibi.Save(); objectspace.CommitChanges(); // objectspace.Refresh(); } objectToShow.Save(); this.View.ObjectSpace.CommitChanges(); objectToShow.ItemInventoryBatchS.Reload(); objectToShow.Item.Reload(); //jectSpace.ReloadObject(); this.View.ObjectSpace.Refresh(); return(1); }