private void AdjustInventory(Guid documentId,Guid storeId) { tblSourcingDocument document = ExistingDocument(documentId); foreach (var lineItem in document.tblSourcingLineItem) { var inventory = _context.tblCommoditySupplierInventory.FirstOrDefault(p=>p.CommodityId==lineItem.CommodityId && p.GradeId==lineItem.GradeId && p.WareHouseId==storeId && p.SupplierId==document.DocumentRecipientCostCentreId); if(inventory==null) { inventory=new tblCommoditySupplierInventory(); inventory.id = Guid.NewGuid(); inventory.CommodityId = lineItem.CommodityId.Value; inventory.GradeId = lineItem.GradeId.Value; inventory.WareHouseId = storeId; inventory.SupplierId = document.DocumentRecipientCostCentreId; inventory.IM_Status = 0; inventory.Balance = 0; inventory.IM_DateCreated = DateTime.Now; _context.tblCommoditySupplierInventory.AddObject(inventory); } var balance = lineItem.Weight.Value - lineItem.FinalWeight.Value; inventory.Balance += balance; inventory.IM_DateLastUpdated = DateTime.Now; _context.SaveChanges(); } }
/// <summary> /// Deprecated Method for adding a new object to the tblCommoditySupplierInventory EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTotblCommoditySupplierInventory(tblCommoditySupplierInventory tblCommoditySupplierInventory) { base.AddObject("tblCommoditySupplierInventory", tblCommoditySupplierInventory); }
/// <summary> /// Create a new tblCommoditySupplierInventory object. /// </summary> /// <param name="id">Initial value of the id property.</param> /// <param name="wareHouseId">Initial value of the WareHouseId property.</param> /// <param name="commodityId">Initial value of the CommodityId property.</param> /// <param name="supplierId">Initial value of the SupplierId property.</param> /// <param name="gradeId">Initial value of the GradeId property.</param> /// <param name="unavailableBalance">Initial value of the UnavailableBalance property.</param> /// <param name="iM_DateCreated">Initial value of the IM_DateCreated property.</param> /// <param name="iM_DateLastUpdated">Initial value of the IM_DateLastUpdated property.</param> /// <param name="iM_Status">Initial value of the IM_Status property.</param> public static tblCommoditySupplierInventory CreatetblCommoditySupplierInventory(global::System.Guid id, global::System.Guid wareHouseId, global::System.Guid commodityId, global::System.Guid supplierId, global::System.Guid gradeId, global::System.Decimal unavailableBalance, global::System.DateTime iM_DateCreated, global::System.DateTime iM_DateLastUpdated, global::System.Int32 iM_Status) { tblCommoditySupplierInventory tblCommoditySupplierInventory = new tblCommoditySupplierInventory(); tblCommoditySupplierInventory.id = id; tblCommoditySupplierInventory.WareHouseId = wareHouseId; tblCommoditySupplierInventory.CommodityId = commodityId; tblCommoditySupplierInventory.SupplierId = supplierId; tblCommoditySupplierInventory.GradeId = gradeId; tblCommoditySupplierInventory.UnavailableBalance = unavailableBalance; tblCommoditySupplierInventory.IM_DateCreated = iM_DateCreated; tblCommoditySupplierInventory.IM_DateLastUpdated = iM_DateLastUpdated; tblCommoditySupplierInventory.IM_Status = iM_Status; return tblCommoditySupplierInventory; }