private SourcingInventory Map(tblSourcingInventory inventory) { return new SourcingInventory(inventory.id) { Balance = inventory.Balance.Value, UnavailableBalance = inventory.UnavailableBalance, Value = 0, Commodity = _commodityRepository.GetById(inventory.CommodityId), Warehouse = _costCentreRepository.GetById(inventory.WareHouseId) as Warehouse, Grade = _commodityRepository.GetGradeByGradeId(inventory.GradeId), }; }
public void AdjustInventoryBalance(Guid costCentreId,Guid commodityid, Guid gradeId, decimal qty) { DateTime date = DateTime.Now; var inventory = _ctx.tblSourcingInventory.FirstOrDefault(s => s.CommodityId == commodityid && s.GradeId == gradeId && s.WareHouseId== costCentreId); if (inventory == null) { inventory = new tblSourcingInventory(); inventory.id = Guid.NewGuid(); inventory.GradeId = gradeId; inventory.CommodityId = commodityid; inventory.WareHouseId = costCentreId; inventory.IM_DateCreated = date; inventory.IM_Status = 1; inventory.Balance = 0; inventory.UnavailableBalance = 0; _ctx.tblSourcingInventory.AddObject(inventory); } inventory.Balance += qty; inventory.IM_DateLastUpdated = date; _ctx.SaveChanges(); }
/// <summary> /// Create a new tblSourcingInventory 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="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 tblSourcingInventory CreatetblSourcingInventory(global::System.Guid id, global::System.Guid wareHouseId, global::System.Guid commodityId, global::System.Guid gradeId, global::System.Decimal unavailableBalance, global::System.DateTime iM_DateCreated, global::System.DateTime iM_DateLastUpdated, global::System.Int32 iM_Status) { tblSourcingInventory tblSourcingInventory = new tblSourcingInventory(); tblSourcingInventory.id = id; tblSourcingInventory.WareHouseId = wareHouseId; tblSourcingInventory.CommodityId = commodityId; tblSourcingInventory.GradeId = gradeId; tblSourcingInventory.UnavailableBalance = unavailableBalance; tblSourcingInventory.IM_DateCreated = iM_DateCreated; tblSourcingInventory.IM_DateLastUpdated = iM_DateLastUpdated; tblSourcingInventory.IM_Status = iM_Status; return tblSourcingInventory; }
/// <summary> /// Deprecated Method for adding a new object to the tblSourcingInventory EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTotblSourcingInventory(tblSourcingInventory tblSourcingInventory) { base.AddObject("tblSourcingInventory", tblSourcingInventory); }