/// <summary>
/// Before Save
/// </summary>
/// <param name="newRecord"></param>
/// <returns></returns>
protected override Boolean BeforeSave(Boolean newRecord)
{
//Check for lock on Locator and Product
//if (Is_ValueChanged("Qty") && IsType(X_Ref_Quantity_Type.ON_HAND) &&
// MCycleCountLock.LockExists(GetCtx(), GetM_Product_ID(), GetM_Locator_ID(), Get_TrxName()))
//{
// s_log.SaveError("Error", Msg.GetMsg(GetCtx(), "LocatorLocked"));
// return false;
//}
if (isBulkUpdate)
{
// validation must already done at storage level not detail/type level
// see Storage.Record.validate()
return(base.BeforeSave(newRecord));
}
// Negative Inventory check
if (newRecord || (Is_ValueChanged("Qty") &&
(IsType(X_Ref_Quantity_Type.ON_HAND) ||
IsType(X_Ref_Quantity_Type.DEDICATED) ||
IsType(X_Ref_Quantity_Type.ALLOCATED) ||
IsType(X_Ref_Quantity_Type.EXPECTED)))
)
{
MWarehouse wh = MWarehouse.Get(GetCtx(), GetM_Warehouse_ID());
if (wh.IsDisallowNegativeInv())
{
if (Env.Signum(GetQty()) < 0)
{
s_log.SaveError("Error", Msg.GetMsg(GetCtx(), "NegativeInventoryDisallowed"));
return(false);
}
Decimal qtyOnHand = Env.ZERO;
Decimal qtyDedicated = Env.ZERO;
Decimal qtyAllocated = Env.ZERO;
String sql = "SELECT SUM(QtyOnHand),SUM(QtyDedicated),SUM(QtyAllocated) "
+ "FROM M_Storage_V s"
+ " INNER JOIN M_Locator l ON (s.M_Locator_ID=l.M_Locator_ID) "
+ "WHERE s.M_Product_ID=" + GetM_Product_ID() // #1
+ " AND l.M_Warehouse_ID=" + GetM_Warehouse_ID()
+ " AND l.M_Locator_ID=" + GetM_Locator_ID();
IDataReader idr = null;
try
{
idr = DB.ExecuteReader(sql, null, Get_TrxName());
if (idr.Read())
{
qtyOnHand = VAdvantage.Utility.Util.GetValueOfDecimal(idr[0]);
if (idr.IsDBNull(0))//if (idr.wasNull())
{
qtyOnHand = Env.ZERO;
}
qtyDedicated = VAdvantage.Utility.Util.GetValueOfDecimal(idr[1]);
if (idr.IsDBNull(1))// wasNull())
{
qtyDedicated = Env.ZERO;
}
qtyAllocated = VAdvantage.Utility.Util.GetValueOfDecimal(idr[2]);
if (idr.IsDBNull(2))// wasNull())
{
qtyAllocated = Env.ZERO;
}
}
idr.Close();
}
catch (Exception e)
{
s_log.Log(Level.SEVERE, sql, e);
}
finally
{
if (idr != null)
{
idr.Close();
idr = null;
}
}
Decimal?asiQtyOnHand = Decimal.Zero;
Decimal?asiQtyDedicated = Decimal.Zero;
Decimal?asiQtyAllocated = Decimal.Zero;
if (IsType(X_Ref_Quantity_Type.ON_HAND))
{
if (newRecord)
{
qtyOnHand = Decimal.Add(qtyOnHand, GetQty());
}
else
{
qtyOnHand = Decimal.Subtract(Decimal.Add(qtyOnHand, GetQty()), Util.GetValueOfDecimal(Get_ValueOld("Qty")));
}
asiQtyOnHand = GetQty();
asiQtyAllocated = MStorageDetail.GetQty(GetCtx(), GetM_Locator_ID(), GetM_Product_ID(), GetM_AttributeSetInstance_ID(), X_Ref_Quantity_Type.ALLOCATED, Get_TrxName());
asiQtyDedicated = MStorageDetail.GetQty(GetCtx(), GetM_Locator_ID(), GetM_Product_ID(), GetM_AttributeSetInstance_ID(), X_Ref_Quantity_Type.DEDICATED, Get_TrxName());
}
else if (IsType(X_Ref_Quantity_Type.DEDICATED))
{
if (newRecord)
{
qtyDedicated = Decimal.Add(qtyDedicated, GetQty());
}
else
{
qtyDedicated = Decimal.Subtract(Decimal.Add(qtyDedicated, GetQty()), Util.GetValueOfDecimal(Get_ValueOld("Qty")));
}
asiQtyOnHand = MStorageDetail.GetQty(GetCtx(), GetM_Locator_ID(), GetM_Product_ID(), GetM_AttributeSetInstance_ID(), X_Ref_Quantity_Type.ON_HAND, Get_TrxName());
asiQtyAllocated = MStorageDetail.GetQty(GetCtx(), GetM_Locator_ID(), GetM_Product_ID(), GetM_AttributeSetInstance_ID(), X_Ref_Quantity_Type.ALLOCATED, Get_TrxName());
asiQtyDedicated = GetQty();
}
else if (IsType(X_Ref_Quantity_Type.ALLOCATED))
{
if (newRecord)
{
qtyAllocated = Decimal.Add(qtyAllocated, GetQty());
}
else
{
qtyAllocated = Decimal.Subtract(Decimal.Add(qtyAllocated, GetQty()), Util.GetValueOfDecimal(Get_ValueOld("Qty")));
}
asiQtyOnHand = MStorageDetail.GetQty(GetCtx(), GetM_Locator_ID(), GetM_Product_ID(), GetM_AttributeSetInstance_ID(), X_Ref_Quantity_Type.ON_HAND, Get_TrxName());
asiQtyAllocated = GetQty();
asiQtyDedicated = MStorageDetail.GetQty(GetCtx(), GetM_Locator_ID(), GetM_Product_ID(), GetM_AttributeSetInstance_ID(), X_Ref_Quantity_Type.DEDICATED, Get_TrxName());
}
asiQtyOnHand = asiQtyOnHand == null ? Env.ZERO : asiQtyOnHand;
asiQtyDedicated = asiQtyDedicated == null ? Env.ZERO : asiQtyDedicated;
asiQtyAllocated = asiQtyAllocated == null ? Env.ZERO : asiQtyAllocated;
if (qtyOnHand.CompareTo(Decimal.Add(qtyDedicated, qtyAllocated)) < 0 ||
asiQtyOnHand.Value.CompareTo(Decimal.Add(asiQtyDedicated.Value, asiQtyAllocated.Value)) < 0)
{
s_log.SaveError("Error", Msg.GetMsg(GetCtx(), "NegativeInventoryDisallowed"));
return(false);
}
}
}
return(base.BeforeSave(newRecord));
}
/// <summary>
/// detail Add
/// Warehouse must already be validated
/// diffQty must always be positive; negative values are not processed
/// </summary>
/// <param name="ctx"></param>
/// <param name="M_Warehouse_ID"></param>
/// <param name="M_Locator_ID"></param>
/// <param name="M_Product_ID"></param>
/// <param name="M_AttributeSetInstance_ID"></param>
/// <param name="reservationAttributeSetInstance_ID"></param>
/// <param name="diffQty"></param>
/// <param name="type"></param>
/// <param name="trx"></param>
/// <returns></returns>
public static Boolean Add(Ctx ctx, int M_Warehouse_ID, int M_Locator_ID,
int M_Product_ID, int M_AttributeSetInstance_ID,
int reservationAttributeSetInstance_ID, Decimal diffQty,
String type, Trx trx)
{
StringBuilder diffText = new StringBuilder("(");
MStorageDetail storage = null;
storage = MStorageDetail.GetCreate(ctx, M_Locator_ID, M_Product_ID,
M_AttributeSetInstance_ID, type, trx);
// Verify
if (storage.GetM_Locator_ID() != M_Locator_ID &&
storage.GetM_Product_ID() != M_Product_ID &&
storage.GetM_AttributeSetInstance_ID() != M_AttributeSetInstance_ID)
{
s_log.Severe("No Storage found - M_Locator_ID=" + M_Locator_ID
+ ",M_Product_ID=" + M_Product_ID + ",ASI="
+ M_AttributeSetInstance_ID);
return(false);
}
MStorageDetail storageASI = null;
if ((M_AttributeSetInstance_ID != reservationAttributeSetInstance_ID) &&
(type == X_Ref_Quantity_Type.RESERVED || type == X_Ref_Quantity_Type.ORDERED))
{
int reservationM_Locator_ID = M_Locator_ID;
if (reservationAttributeSetInstance_ID == 0)
{
MWarehouse wh = MWarehouse.Get(ctx, M_Warehouse_ID);
reservationM_Locator_ID = wh.GetDefaultM_Locator_ID();
}
storageASI = MStorageDetail.Get(ctx, reservationM_Locator_ID,
M_Product_ID, reservationAttributeSetInstance_ID, type,
true, trx);
if (storageASI == null) // create if not existing - should not happen
{
MProduct product = MProduct.Get(ctx, M_Product_ID);
int xM_Locator_ID = MProductLocator.GetFirstM_Locator_ID(product, M_Warehouse_ID);
if (xM_Locator_ID == 0)
{
MWarehouse wh = MWarehouse.Get(ctx, M_Warehouse_ID);
xM_Locator_ID = wh.GetDefaultM_Locator_ID();
}
storageASI = MStorageDetail.GetCreate(ctx, xM_Locator_ID,
M_Product_ID, reservationAttributeSetInstance_ID, type,
trx);
}
}
Boolean changed = false;
if (Env.Signum(diffQty) != 0)
{
if (storageASI == null)
{
storage.SetQty(Decimal.Add(storage.GetQty(), diffQty));
}
else
{
storageASI.SetQty(Decimal.Add(storageASI.GetQty(), diffQty));
}
diffText.Append(type.ToString()).Append("=").Append(diffQty);
changed = true;
}
if (changed)
{
diffText.Append(") -> ").Append(storage.ToString());
s_log.Fine(diffText.ToString());
if (storageASI != null)
{
storageASI.Save(trx); // No AttributeSetInstance
}
// (reserved/ordered)
return(storage.Save(trx));
}
return(true);
}