/// <summary>
/// Before Save
/// </summary>
/// <param name="newRecord">new</param>
/// <returns>true</returns>
protected override Boolean BeforeSave(Boolean newRecord)
{
// By vikas
// Get Old Value of AttributeSetInstance_ID
_mvlOldAttId = Util.GetValueOfInt(Get_ValueOld("M_AttributeSetInstance_ID"));
// Set Line No
if (GetLine() == 0)
{
String sql = "SELECT COALESCE(MAX(Line),0)+10 AS DefaultValue FROM M_MovementLine WHERE M_Movement_ID=" + GetM_Movement_ID();
int ii = DB.GetSQLValue(Get_TrxName(), sql);
SetLine(ii);
}
// Check Locator For Header Warehouse
MMovement mov = new MMovement(GetCtx(), GetM_Movement_ID(), Get_TrxName());
VAdvantage.Model.MLocator loc = new VAdvantage.Model.MLocator(GetCtx(), GetM_Locator_ID(), Get_TrxName());
Tuple <string, string, string> aInfo = null;
if (Env.HasModulePrefix("DTD001_", out aInfo))
{
if (mov.GetDTD001_MWarehouseSource_ID() == loc.GetM_Warehouse_ID())
{
}
else
{
String sql = "SELECT M_Locator_ID FROM M_Locator WHERE M_Warehouse_ID=" + mov.GetDTD001_MWarehouseSource_ID() + " AND IsDefault = 'Y'";
int ii = DB.GetSQLValue(Get_TrxName(), sql);
SetM_Locator_ID(ii);
}
}
if (GetM_Locator_ID() == GetM_LocatorTo_ID())
{
log.SaveError("Error", Msg.ParseTranslation(GetCtx(), "'From @M_Locator_ID@' and '@M_LocatorTo_ID@' cannot be same."));//change message according to requirement
return(false);
}
if (Env.Signum(GetMovementQty()) == 0 && Util.GetValueOfInt(GetTargetQty()) == 0)
{
log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "MovementQty"));
return(false);
}
//Amit
Tuple <String, String, String> mInfo = null;
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
if (!newRecord && Util.GetValueOfInt(Get_ValueOld("M_Product_ID")) != GetM_Product_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_ProdNotChanged"));
return(false);
}
if (!newRecord && Util.GetValueOfInt(Get_ValueOld("M_Locator_ID")) != GetM_Locator_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_LocatorNotChanged"));
return(false);
}
if (!newRecord && Util.GetValueOfInt(Get_ValueOld("M_RequisitionLine_ID")) != GetM_RequisitionLine_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_ReqNotChanged"));
return(false);
}
}
if (Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA203_'", null, null)) > 0)
{
if (GetM_RequisitionLine_ID() > 0)
{
VAdvantage.Model.MRequisitionLine reqline = new VAdvantage.Model.MRequisitionLine(GetCtx(), GetM_RequisitionLine_ID(), null);
if (GetM_AttributeSetInstance_ID() != reqline.GetM_AttributeSetInstance_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "VA203_AttributeInstanceMustBeSame"));
return(false);
}
}
}
// IF Doc Status = InProgress then No record Save
MMovement move = new MMovement(GetCtx(), GetM_Movement_ID(), null);
if (newRecord && move.GetDocStatus() == "IP")
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_CannotCreate"));
return(false);
}
// Qty Precision
if (newRecord || Is_ValueChanged("QtyEntered"))
{
SetMovementQty(GetMovementQty());
}
int M_Warehouse_ID = 0; VAdvantage.Model.MWarehouse wh = null;
string qry = "select m_warehouse_id from m_locator where m_locator_id=" + GetM_Locator_ID();
M_Warehouse_ID = Util.GetValueOfInt(DB.ExecuteScalar(qry));
wh = VAdvantage.Model.MWarehouse.Get(GetCtx(), M_Warehouse_ID);
qry = "SELECT NVL(SUM(NVL(QtyOnHand,0)),0) AS QtyOnHand FROM M_Storage where m_locator_id=" + GetM_Locator_ID() + " and m_product_id=" + GetM_Product_ID();
if (GetM_AttributeSetInstance_ID() != 0)
{
qry += " AND M_AttributeSetInstance_ID=" + GetM_AttributeSetInstance_ID();
}
OnHandQty = Convert.ToDecimal(DB.ExecuteScalar(qry));
// when record is in completed & closed & Reversed stage - then no need to check qty availablity in warehouse
if (wh.IsDisallowNegativeInv() == true && (!(move.GetDocStatus() == "CO" || move.GetDocStatus() == "CL" || move.GetDocStatus() == "RE")))
{
if (GetDescription() != "RC")
{
if (GetMovementQty() < 0)
{
log.SaveError("Error", Msg.GetMsg(GetCtx(), "Qty Available " + OnHandQty));
//ShowMessage.Info("Qty Available " + OnHandQty, true, null, null);
return(false);
}
else if ((OnHandQty - GetMovementQty()) < 0)
{
log.SaveError("Error", Msg.GetMsg(GetCtx(), "Qty Available " + OnHandQty));
//ShowMessage.Info("Qty Available " + OnHandQty, true, null, null);
return(false);
}
}
}
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
qry = "SELECT NVL(SUM(NVL(QtyOnHand,0)- qtyreserved),0) AS QtyAvailable FROM M_Storage where m_locator_id=" + GetM_Locator_ID() + " and m_product_id=" + GetM_Product_ID();
if (GetM_AttributeSetInstance_ID() != 0)
{
qry += " AND M_AttributeSetInstance_ID=" + GetM_AttributeSetInstance_ID();
}
qtyAvailable = Convert.ToDecimal(DB.ExecuteScalar(qry));
qtyReserved = Util.GetValueOfDecimal(Get_ValueOld("MovementQty"));
if (wh.IsDisallowNegativeInv() == true)
{
if ((qtyAvailable < (GetMovementQty() - qtyReserved)))
{
log.SaveError("Message", Msg.GetElement(GetCtx(), "DTD001_QtyNotAvailable"));
return(false);
}
}
}
// Mandatory Instance
if (GetM_AttributeSetInstanceTo_ID() == 0)
{
if (GetM_AttributeSetInstance_ID() != 0) // Set to from
{
SetM_AttributeSetInstanceTo_ID(GetM_AttributeSetInstance_ID());
}
else
{
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
VAdvantage.Model.MProduct product = GetProduct();
if (product != null &&
product.GetM_AttributeSet_ID() != 0)
{
//MAttributeSet mas = MAttributeSet.Get(GetCtx(), product.GetM_AttributeSet_ID());
//if (mas.IsInstanceAttribute()
// && (mas.IsMandatory() || mas.IsMandatoryAlways()))
//{
// log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "M_AttributeSetInstanceTo_ID"));
// return false;
//}
// Code Addeded by Bharat as Discussed with Mukesh Sir
if (String.IsNullOrEmpty(GetDTD001_AttributeNumber()))
{
return(true);
}
else
{
if (GetDTD001_AttributeNumber() == "" || GetDTD001_AttributeNumber() == null)
{
log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "DTD001_AttributeNumber"));
return(false);
}
}
}
else
{
if (product != null)
{
if (product.GetM_AttributeSet_ID() == 0 && (GetDTD001_AttributeNumber() == "" || GetDTD001_AttributeNumber() == null))
{
return(true);
}
else
{
//log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "DTD001_AttributeNumber"));
//ShowMessage.Info("a", true, "Product is not of Attribute Type", null);
log.SaveError("Product is not of Attribute Type", Msg.GetElement(GetCtx(), "DTD001_AttributeNumber"));
return(false);
}
//Check No Of Attributes Are Equal To Quantity Or Less Than
int Count = CountAttributes(GetDTD001_AttributeNumber());
if (Count != GetMovementQty())
{
if (Count > GetMovementQty())
{
log.SaveError("Error", Msg.GetMsg(GetCtx(), "DTD001_MovementAttrbtGreater"));
return(false);
}
else
{
log.SaveError("Error", Msg.GetMsg(GetCtx(), "DTD001_MovementAttrbtLess"));
return(false);
}
}
}
}
}
else
{
VAdvantage.Model.MProduct product = GetProduct();
if (product != null &&
product.GetM_AttributeSet_ID() != 0)
{
VAdvantage.Model.MAttributeSet mas = VAdvantage.Model.MAttributeSet.Get(GetCtx(), product.GetM_AttributeSet_ID());
if (mas.IsInstanceAttribute() &&
(mas.IsMandatory() || mas.IsMandatoryAlways()))
{
log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "M_AttributeSetInstanceTo_ID"));
return(false);
}
}
}
}
} // ASI
return(true);
}
/// <summary>
/// Before Save
/// </summary>
/// <param name="newRecord">new</param>
/// <returns>true</returns>
protected override Boolean BeforeSave(Boolean newRecord)
{
Decimal VA024_ProvisionPrice = 0;
MProduct product = MProduct.Get(GetCtx(), GetM_Product_ID());
// chck pallet Functionality applicable or not
bool isContainrApplicable = MTransaction.ProductContainerApplicable(GetCtx());
// Get Old Value of AttributeSetInstance_ID
_mvlOldAttId = Util.GetValueOfInt(Get_ValueOld("M_AttributeSetInstance_ID"));
// Set Line No
if (GetLine() == 0)
{
String sql = "SELECT COALESCE(MAX(Line),0)+10 AS DefaultValue FROM M_MovementLine WHERE M_Movement_ID=" + GetM_Movement_ID();
int ii = DataBase.DB.GetSQLValue(Get_TrxName(), sql);
SetLine(ii);
}
// JID_0775: System is not checking on move line that the attribute set instance is mandatory.
if (GetM_AttributeSetInstance_ID() == 0)
{
if (product != null && product.GetM_AttributeSet_ID() != 0)
{
MAttributeSet mas = MAttributeSet.Get(GetCtx(), product.GetM_AttributeSet_ID());
if (mas.IsMandatory() || mas.IsMandatoryAlways())
{
log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "M_AttributeSetInstance_ID"));
return(false);
}
}
}
// Check Locator For Header Warehouse
MMovement mov = new MMovement(GetCtx(), GetM_Movement_ID(), Get_TrxName());
MLocator loc = new MLocator(GetCtx(), GetM_Locator_ID(), Get_TrxName());
Tuple <string, string, string> aInfo = null;
if (Env.HasModulePrefix("DTD001_", out aInfo))
{
if (mov.GetDTD001_MWarehouseSource_ID() == loc.GetM_Warehouse_ID())
{
}
else
{
String sql = "SELECT M_Locator_ID FROM M_Locator WHERE M_Warehouse_ID=" + mov.GetDTD001_MWarehouseSource_ID() + " AND IsDefault = 'Y'";
int ii = DataBase.DB.GetSQLValue(Get_TrxName(), sql);
SetM_Locator_ID(ii);
}
}
// when we try to move product from container to container which are in same locator then no need to check this case
if (GetM_Locator_ID() == GetM_LocatorTo_ID() &&
(Get_ColumnIndex("M_ProductContainer_ID") > 0 && Get_ColumnIndex("Ref_M_ProductContainerTo_ID") > 0 &&
!(GetM_ProductContainer_ID() > 0 || GetRef_M_ProductContainerTo_ID() > 0)))
{
log.SaveError("Error", Msg.ParseTranslation(GetCtx(), "'From @M_Locator_ID@' and '@M_LocatorTo_ID@' cannot be same."));//change message according to requirement
return(false);
}
if (Env.Signum(GetMovementQty()) == 0 && Util.GetValueOfInt(GetTargetQty()) == 0)
{
log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "MovementQty"));
return(false);
}
Tuple <String, String, String> mInfo = null;
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
if (!newRecord && Util.GetValueOfInt(Get_ValueOld("M_Product_ID")) != GetM_Product_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_ProdNotChanged"));
return(false);
}
if (!newRecord && Util.GetValueOfInt(Get_ValueOld("M_Locator_ID")) != GetM_Locator_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_LocatorNotChanged"));
return(false);
}
if (!newRecord && Util.GetValueOfInt(Get_ValueOld("M_RequisitionLine_ID")) != GetM_RequisitionLine_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_ReqNotChanged"));
return(false);
}
}
//if (Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA203_'", null, null)) > 0)
if (Env.IsModuleInstalled("VA203_"))
{
if (GetM_RequisitionLine_ID() > 0)
{
MRequisitionLine reqline = new MRequisitionLine(GetCtx(), GetM_RequisitionLine_ID(), Get_Trx()); // Trx used to handle query stuck problem
if (GetM_AttributeSetInstance_ID() != reqline.GetM_AttributeSetInstance_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "VA203_AttributeInstanceMustBeSame"));
return(false);
}
}
}
// IF Doc Status = InProgress then No record Save
MMovement move = new MMovement(GetCtx(), GetM_Movement_ID(), Get_Trx()); // Trx used to handle query stuck problem
if (newRecord && move.GetDocStatus() == "IP")
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_CannotCreate"));
return(false);
}
// Qty Precision
if (newRecord || Is_ValueChanged("QtyEntered"))
{
SetQtyEntered(GetQtyEntered());
}
// change to set Converted Quantity in Movement quantity if there is differnce in UOM of Base Product and UOM Selected on line
if (newRecord || Is_ValueChanged("QtyEntered") || Is_ValueChanged("C_UOM_ID"))
{
Decimal?qty = Util.GetValueOfDecimal(Get_Value("QtyEntered"));
if (product.GetC_UOM_ID() != Util.GetValueOfInt(Get_Value("C_UOM_ID")))
{
SetMovementQty(MUOMConversion.ConvertProductFrom(GetCtx(), GetM_Product_ID(), Util.GetValueOfInt(Get_Value("C_UOM_ID")), Util.GetValueOfDecimal(Get_Value("QtyEntered"))));
}
}
// Qty Precision
if (newRecord || Is_ValueChanged("QtyEntered"))
{
SetMovementQty(GetMovementQty());
}
string qry;
if (!mov.IsProcessing() || newRecord)
{
MWarehouse wh = null; MWarehouse whTo = null;
wh = MWarehouse.Get(GetCtx(), mov.GetDTD001_MWarehouseSource_ID());
whTo = MWarehouse.Get(GetCtx(), MLocator.Get(GetCtx(), GetM_LocatorTo_ID()).GetM_Warehouse_ID());
qry = "SELECT NVL(SUM(NVL(QtyOnHand,0)),0) AS QtyOnHand FROM M_Storage where m_locator_id=" + GetM_Locator_ID() + " and m_product_id=" + GetM_Product_ID();
if (GetDTD001_AttributeNumber() == null || GetM_AttributeSetInstance_ID() > 0)
{
qry += " AND NVL(M_AttributeSetInstance_ID , 0) =" + GetM_AttributeSetInstance_ID();
}
OnHandQty = Convert.ToDecimal(DB.ExecuteScalar(qry));
qry = "SELECT NVL(SUM(NVL(QtyOnHand,0)),0) AS QtyOnHand FROM M_Storage where m_locator_id=" + GetM_LocatorTo_ID() + " and m_product_id=" + GetM_Product_ID();
qry += " AND NVL(M_AttributeSetInstance_ID, 0) =" + GetM_AttributeSetInstance_ID();
OnHandQtyTo = Convert.ToDecimal(DB.ExecuteScalar(qry));
// SI_0635 : System is giving error of insufficient qty if disallow is true in TO warehouse and false in From warehouse
// when record is in completed & closed stage - then no need to check qty availablity in warehouse
if ((wh.IsDisallowNegativeInv() || whTo.IsDisallowNegativeInv()) &&
(!(move.GetDocStatus() == "CO" || move.GetDocStatus() == "CL" || move.GetDocStatus() == "RE" || move.GetDocStatus() == "VO")))
{
// pick container current qty from transaction based on locator / product / ASI / Container / Movement Date
if (isContainrApplicable && Get_ColumnIndex("M_ProductContainer_ID") >= 0)
{
// qry = @"SELECT SUM(t.ContainerCurrentQty) keep (dense_rank last ORDER BY t.MovementDate, t.M_Transaction_ID) AS CurrentQty FROM m_transaction t
// INNER JOIN M_Locator l ON t.M_Locator_ID = l.M_Locator_ID WHERE t.MovementDate <= " + GlobalVariable.TO_DATE(move.GetMovementDate(), true) +
// " AND t.AD_Client_ID = " + GetAD_Client_ID() +
// @" AND t.M_Locator_ID = " + (move.IsReversal() && GetMovementQty() < 0 ? GetM_LocatorTo_ID() : GetM_Locator_ID()) +
// " AND t.M_Product_ID = " + GetM_Product_ID() + " AND NVL(t.M_AttributeSetInstance_ID,0) = " + GetM_AttributeSetInstance_ID() +
// " AND NVL(t.M_ProductContainer_ID, 0) = " + (move.IsReversal() && !IsMoveFullContainer() && GetMovementQty() < 0 ? GetRef_M_ProductContainerTo_ID() : GetM_ProductContainer_ID());
// containerQty = Util.GetValueOfDecimal(DB.ExecuteScalar(qry.ToString(), null, null)); // dont use Transaction here - otherwise impact goes wrong on completion
// qry = @"SELECT SUM(t.ContainerCurrentQty) keep (dense_rank last ORDER BY t.MovementDate, t.M_Transaction_ID) AS CurrentQty FROM m_transaction t
// INNER JOIN M_Locator l ON t.M_Locator_ID = l.M_Locator_ID WHERE t.MovementDate <= " + GlobalVariable.TO_DATE(move.GetMovementDate(), true) +
// " AND t.AD_Client_ID = " + GetAD_Client_ID() +
// @" AND t.M_Locator_ID = " + (move.IsReversal() && GetMovementQty() < 0 ? GetM_Locator_ID() : GetM_LocatorTo_ID()) +
// " AND t.M_Product_ID = " + GetM_Product_ID() + " AND NVL(t.M_AttributeSetInstance_ID,0) = " + GetM_AttributeSetInstance_ID() +
// " AND NVL(t.M_ProductContainer_ID, 0) = " + (move.IsReversal() && !IsMoveFullContainer() && GetMovementQty() < 0 ? GetM_ProductContainer_ID() : GetRef_M_ProductContainerTo_ID());
// containerQtyTo = Util.GetValueOfDecimal(DB.ExecuteScalar(qry.ToString(), null, null)); // dont use Transaction here - otherwise impact goes wrong on completion
qry = @"SELECT DISTINCT First_VALUE(t.ContainerCurrentQty) OVER (PARTITION BY t.M_Product_ID, t.M_AttributeSetInstance_ID ORDER BY t.MovementDate DESC, t.M_Transaction_ID DESC) AS CurrentQty FROM m_transaction t
INNER JOIN M_Locator l ON t.M_Locator_ID = l.M_Locator_ID WHERE t.MovementDate <= " + GlobalVariable.TO_DATE(move.GetMovementDate(), true) +
" AND t.AD_Client_ID = " + GetAD_Client_ID() +
@" AND t.M_Locator_ID = " + GetM_Locator_ID() +
" AND t.M_Product_ID = " + GetM_Product_ID() + " AND NVL(t.M_ProductContainer_ID, 0) = " + GetM_ProductContainer_ID();
// In Case of Attribute Number do not check qty with attribute from storage
if (GetDTD001_AttributeNumber() == null || GetM_AttributeSetInstance_ID() > 0)
{
qry += " AND NVL(M_AttributeSetInstance_ID , 0) =" + GetM_AttributeSetInstance_ID();
}
containerQty = Util.GetValueOfDecimal(DB.ExecuteScalar(qry.ToString(), null, null)); // dont use Transaction here - otherwise impact goes wrong on completion
qry = @"SELECT DISTINCT First_VALUE(t.ContainerCurrentQty) OVER (PARTITION BY t.M_Product_ID, t.M_AttributeSetInstance_ID ORDER BY t.MovementDate DESC, t.M_Transaction_ID DESC) AS CurrentQty FROM m_transaction t
INNER JOIN M_Locator l ON t.M_Locator_ID = l.M_Locator_ID WHERE t.MovementDate <= " + GlobalVariable.TO_DATE(move.GetMovementDate(), true) +
" AND t.AD_Client_ID = " + GetAD_Client_ID() +
@" AND t.M_Locator_ID = " + GetM_LocatorTo_ID() +
" AND t.M_Product_ID = " + GetM_Product_ID() + " AND NVL(t.M_AttributeSetInstance_ID,0) = " + GetM_AttributeSetInstance_ID() +
" AND NVL(t.M_ProductContainer_ID, 0) = " + GetRef_M_ProductContainerTo_ID();
containerQtyTo = Util.GetValueOfDecimal(DB.ExecuteScalar(qry.ToString(), null, null)); // dont use Transaction here - otherwise impact goes wrong on completion
}
if (wh.IsDisallowNegativeInv() && (OnHandQty - GetMovementQty()) < 0)
{
// check for From Locator
log.SaveError("Info", product.GetName() + " , " + Msg.GetMsg(GetCtx(), "VIS_InsufficientQty") + OnHandQty);
return(false);
}
else if (isContainrApplicable && wh.IsDisallowNegativeInv() && Get_ColumnIndex("M_ProductContainer_ID") >= 0 && (containerQty - GetMovementQty()) < 0)
{
// check container qty - for From Locator
log.SaveError("Info", product.GetName() + " , " + Msg.GetMsg(GetCtx(), "VIS_InsufficientQtyContainer") + containerQty);
return(false);
}
else if (whTo.IsDisallowNegativeInv() && (OnHandQtyTo + GetMovementQty()) < 0)
{
// check for To Locator
log.SaveError("Info", product.GetName() + " , " + Msg.GetMsg(GetCtx(), "VIS_InsufficientQty") + OnHandQtyTo);
return(false);
}
else if (isContainrApplicable && whTo.IsDisallowNegativeInv() && Get_ColumnIndex("M_ProductContainer_ID") >= 0 && (containerQtyTo + GetMovementQty()) < 0)
{
// check for To Locator
log.SaveError("Info", product.GetName() + " , " + Msg.GetMsg(GetCtx(), "VIS_InsufficientQtyContainerTo") + containerQtyTo);
return(false);
}
}
}
if (Env.IsModuleInstalled("DTD001_"))
{
// not used this variable, that why commented
//qry = "SELECT NVL(SUM(NVL(QtyOnHand,0)- qtyreserved),0) AS QtyAvailable FROM M_Storage where m_locator_id=" + GetM_Locator_ID() + " and m_product_id=" + GetM_Product_ID();
//if (GetM_AttributeSetInstance_ID() != 0)
//{
// qry += " AND NVL(M_AttributeSetInstance_ID , 0) = " + GetM_AttributeSetInstance_ID();
//}
//qtyAvailable = Convert.ToDecimal(DB.ExecuteScalar(qry));
qtyReserved = Util.GetValueOfDecimal(Get_ValueOld("MovementQty"));
//if (wh.IsDisallowNegativeInv() == true)
//{
// if ((qtyAvailable < (GetMovementQty() - qtyReserved)))
// {
// log.SaveError("Message", product.GetName() + " , " + Msg.GetMsg(GetCtx(), "DTD001_QtyNotAvailable"));
// return false;
// }
//}
}
//By Amit - 17-April-2017
if (Env.IsModuleInstalled("VA024_"))
{
// checking are we moving product from one warehouse to other warehouse
if (Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT CASE WHEN ((SELECT CASE WHEN o.IsLegalEntity = 'Y' THEN w.AD_Org_ID
ELSE (SELECT AD_Org_ID FROM AD_Org WHERE Ad_Org_id = o.LegalEntityOrg ) END
FROM m_warehouse w INNER JOIN ad_org o ON o.AD_Org_ID = w.AD_Org_ID WHERE w.m_warehouse_id = m.DTD001_MWarehouseSource_ID)) =
(SELECT CASE WHEN o2.IsLegalEntity = 'Y' THEN w2.AD_Org_ID
ELSE (SELECT AD_Org_ID FROM AD_Org WHERE Ad_Org_id = o2.LegalEntityOrg) END
FROM m_warehouse w2 INNER JOIN ad_org o2 ON o2.AD_Org_ID = w2.AD_Org_ID WHERE M_Warehouse_ID = m.M_Warehouse_ID )
THEN 0 ELSE (SELECT ad_org_id FROM m_warehouse WHERE M_Warehouse_ID = m.M_Warehouse_ID ) END AS result FROM m_movement m WHERE m_movement_id = " + GetM_Movement_ID(), null, Get_Trx())) > 0)
{
string qry1 = @"SELECT SUM(o.VA024_UnitPrice) FROM VA024_t_ObsoleteInventory o
WHERE o.IsActive = 'Y' AND o.M_Product_ID = " + GetM_Product_ID() + @" and
( o.M_AttributeSetInstance_ID = " + GetM_AttributeSetInstance_ID() + @" OR o.M_AttributeSetInstance_ID IS NULL )" +
" AND o.AD_Org_ID = " + GetAD_Org_ID();
VA024_ProvisionPrice = Util.GetValueOfDecimal(DB.ExecuteScalar(qry1, null, Get_Trx()));
SetVA024_UnitPrice(Util.GetValueOfDecimal(VA024_ProvisionPrice * GetMovementQty()));
// is used to get cost of binded cost method / costing level of primary accounting schema
Decimal cost = MCost.GetproductCosts(move.GetAD_Client_ID(), move.GetAD_Org_ID(), GetM_Product_ID(),
GetM_AttributeSetInstance_ID(), Get_Trx(), move.GetDTD001_MWarehouseSource_ID());
SetVA024_CostPrice((cost - VA024_ProvisionPrice) * GetMovementQty());
}
}
// Mandatory Instance
if (GetM_AttributeSetInstanceTo_ID() == 0)
{
if (GetM_AttributeSetInstance_ID() != 0) // Set to from
{
SetM_AttributeSetInstanceTo_ID(GetM_AttributeSetInstance_ID());
}
else
{
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
//MProduct product = GetProduct();
if (product != null &&
product.GetM_AttributeSet_ID() != 0)
{
//MAttributeSet mas = MAttributeSet.Get(GetCtx(), product.GetM_AttributeSet_ID());
//if (mas.IsInstanceAttribute()
// && (mas.IsMandatory() || mas.IsMandatoryAlways()))
//{
// log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "M_AttributeSetInstanceTo_ID"));
// return false;
//}
// Code Addeded by Bharat as Discussed with Mukesh Sir
if (String.IsNullOrEmpty(GetDTD001_AttributeNumber()))
{
return(true);
}
else
{
if (GetDTD001_AttributeNumber() == "" || GetDTD001_AttributeNumber() == null)
{
log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "DTD001_AttributeNumber"));
return(false);
}
}
//JID_1422: Check No Of Attributes Are Equal To Quantity Or Less Than
int Count = CountAttributes(GetDTD001_AttributeNumber());
if (Count != GetQtyEntered())
{
if (Count > GetQtyEntered())
{
log.SaveError("DTD001_MovementAttrbtGreater", "");
return(false);
}
else
{
log.SaveError("DTD001_MovementAttrbtLess", "");
return(false);
}
}
}
else
{
if (product != null)
{
if (product.GetM_AttributeSet_ID() == 0 && (GetDTD001_AttributeNumber() == "" || GetDTD001_AttributeNumber() == null))
{
return(true);
}
else
{
//log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "DTD001_AttributeNumber"));
//ShowMessage.Info("a", true, "Product is not of Attribute Type", null);
log.SaveError("Product is not of Attribute Type", Msg.GetElement(GetCtx(), "DTD001_AttributeNumber"));
return(false);
}
//Check No Of Attributes Are Equal To Quantity Or Less Than
//int Count = CountAttributes(GetDTD001_AttributeNumber());
//if (Count != GetMovementQty())
//{
// if (Count > GetMovementQty())
// {
// log.SaveError("Error", Msg.GetMsg(GetCtx(), "DTD001_MovementAttrbtGreater"));
// return false;
// }
// else
// {
// log.SaveError("Error", Msg.GetMsg(GetCtx(), "DTD001_MovementAttrbtLess"));
// return false;
// }
//}
}
}
}
else
{
//MProduct product = GetProduct();
if (product != null &&
product.GetM_AttributeSet_ID() != 0)
{
MAttributeSet mas = MAttributeSet.Get(GetCtx(), product.GetM_AttributeSet_ID());
if (mas.IsInstanceAttribute() &&
(mas.IsMandatory() || mas.IsMandatoryAlways()))
{
log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "M_AttributeSetInstanceTo_ID"));
return(false);
}
}
}
}
} // ASI
return(true);
}
/// <summary>
/// Complete Document
/// </summary>
/// <returns>new status (Complete, In Progress, Invalid, Waiting ..)</returns>
public String CompleteIt()
{
// Re-Check
if (!_justPrepared)
{
String status = PrepareIt();
if (!DocActionVariables.STATUS_INPROGRESS.Equals(status))
{
return(status);
}
}
// Implicit Approval
if (!IsApproved())
{
ApproveIt();
}
log.Info("CompleteIt - " + ToString());
//
MMovement move = new MMovement(GetCtx(), GetM_Movement_ID(), Get_TrxName());
MMovementLineConfirm[] lines = GetLines(false);
#region [Change By Sukhwinder on 11th October,2017 To Check if VA Material Quality Control Module exists or not, and then check if actual value at Quality Control tab exists or not]
if (Env.IsModuleInstalled("VA010_"))
{
try
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < lines.Length; i++)
{
sb.Append(lines[i].Get_ID() + ",");
}
string mMovementLinesConfirm = sb.ToString().Trim(',');
if (!string.IsNullOrEmpty(mMovementLinesConfirm))
{
string qry = DBFunctionCollection.MoveConfirmNoActualValue(mMovementLinesConfirm);
string productsNoActualValue = Util.GetValueOfString(DB.ExecuteScalar(qry));
if (!string.IsNullOrEmpty(productsNoActualValue))
{
//_processMsg = productsNoActualValue + " is/are not verified with all the Quality Parameters." +
// " Please fill actual value for the missing Quality Parameters in Quality Control. ";
_processMsg = productsNoActualValue + " " + Msg.GetMsg(GetCtx(), "VIS_NoActualValueInQC");
return(DocActionVariables.STATUS_INVALID);
}
}
}
catch (Exception ex)
{
log.Severe("Exception When Checking actual value at Quality Control Tab - " + ex.Message);
}
}
#endregion
for (int i = 0; i < lines.Length; i++)
{
MMovementLineConfirm confirm = lines[i];
confirm.Set_TrxName(Get_TrxName());
//Added By Arpit
if (GetDescription() != null && GetDescription().Contains("{->"))
{
//if (!confirm.ProcessLineReverse())
//{
// _processMsg = "ShipLine not saved - " + confirm;
// return DocActionVariables.STATUS_INVALID;
//}
}
else if (!confirm.ProcessLine())
{
_processMsg = "ShipLine not saved - " + confirm;
return(DocActionVariables.STATUS_INVALID);
}
if (confirm.IsFullyConfirmed())
{
confirm.SetProcessed(true);
confirm.Save(Get_TrxName());
}
else
{
if (CreateDifferenceDoc(move, confirm))
{
confirm.SetProcessed(true);
confirm.Save(Get_TrxName());
}
else
{
log.Log(Level.SEVERE, "completeIt - Scrapped=" + confirm.GetScrappedQty()
+ " - Difference=" + confirm.GetDifferenceQty());
_processMsg = "Differnce Doc not created";
return(DocActionVariables.STATUS_INVALID);
}
}
} // for all lines
if (_inventoryInfo != null)
{
_processMsg = " @M_Inventory_ID@: " + _inventoryInfo;
AddDescription(Msg.Translate(GetCtx(), "M_Inventory_ID")
+ ": " + _inventoryInfo);
}
//Amit 21-nov-2014 (Reduce reserved quantity from requisition and warehouse distribution center)
Tuple <String, String, String> mInfo = null;
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
MMovementLine movementLine = null;
MRequisitionLine requisitionLine = null;
MStorage storage = null;
for (int i = 0; i < lines.Length; i++)
{
MMovementLineConfirm confirm = lines[i];
if (confirm.GetDifferenceQty() > 0)
{
movementLine = new MMovementLine(GetCtx(), confirm.GetM_MovementLine_ID(), Get_Trx());
if (movementLine.GetM_RequisitionLine_ID() > 0)
{
requisitionLine = new MRequisitionLine(GetCtx(), movementLine.GetM_RequisitionLine_ID(), Get_Trx());
requisitionLine.SetDTD001_ReservedQty(decimal.Subtract(requisitionLine.GetDTD001_ReservedQty(), confirm.GetDifferenceQty()));
if (!requisitionLine.Save(Get_Trx()))
{
_processMsg = Msg.GetMsg(GetCtx(), "DTD001_ReqNotUpdate");
// _processMsg = "Requisitionline not updated";
return(DocActionVariables.STATUS_INVALID);
}
storage = MStorage.Get(GetCtx(), movementLine.GetM_Locator_ID(), movementLine.GetM_Product_ID(), movementLine.GetM_AttributeSetInstance_ID(), Get_Trx());
if (storage == null)
{
storage = MStorage.Get(GetCtx(), movementLine.GetM_Locator_ID(), movementLine.GetM_Product_ID(), 0, Get_Trx());
}
storage.SetQtyReserved(decimal.Subtract(storage.GetQtyReserved(), confirm.GetDifferenceQty()));
if (!storage.Save(Get_Trx()))
{
Get_Trx().Rollback();
_processMsg = Msg.GetMsg(GetCtx(), "DTD001_StorageNotUpdate");
//_processMsg = "Storage From not updated (MA)";
return(DocActionVariables.STATUS_INVALID);
}
}
}
}
}
//Amit
SetProcessed(true);
SetDocAction(DOCACTION_Close);
Save(Get_Trx());
//Adde by Arpit To complete The Inventory Move if Move Confirmation is completed ,16th Dec,2016
MMovement Mov = new MMovement(GetCtx(), GetM_Movement_ID(), Get_Trx());
if (move.GetDocStatus() != DOCSTATUS_Completed)
{
string Status = Mov.CompleteIt();
if (Status == "CO")
{
move.SetDocStatus(DOCSTATUS_Completed);
move.SetDocAction("CL");
move.SetProcessed(true);
move.Save(Get_Trx());
}
else
{
Get_Trx().Rollback();
_processMsg = Mov.GetProcessMsg();
return(DocActionVariables.STATUS_INVALID);
}
}
//End Here
return(DocActionVariables.STATUS_COMPLETED);
}
/// <summary>
/// Before Save
/// </summary>
/// <param name="newRecord">new</param>
/// <returns>true</returns>
protected override Boolean BeforeSave(Boolean newRecord)
{
Decimal VA024_ProvisionPrice = 0;
MProduct product = MProduct.Get(GetCtx(), GetM_Product_ID());
// By vikas
// Get Old Value of AttributeSetInstance_ID
_mvlOldAttId = Util.GetValueOfInt(Get_ValueOld("M_AttributeSetInstance_ID"));
// Set Line No
if (GetLine() == 0)
{
String sql = "SELECT COALESCE(MAX(Line),0)+10 AS DefaultValue FROM M_MovementLine WHERE M_Movement_ID=" + GetM_Movement_ID();
int ii = DataBase.DB.GetSQLValue(Get_TrxName(), sql);
SetLine(ii);
}
// Check Locator For Header Warehouse
MMovement mov = new MMovement(GetCtx(), GetM_Movement_ID(), Get_TrxName());
MLocator loc = new MLocator(GetCtx(), GetM_Locator_ID(), Get_TrxName());
Tuple <string, string, string> aInfo = null;
if (Env.HasModulePrefix("DTD001_", out aInfo))
{
if (mov.GetDTD001_MWarehouseSource_ID() == loc.GetM_Warehouse_ID())
{
}
else
{
String sql = "SELECT M_Locator_ID FROM M_Locator WHERE M_Warehouse_ID=" + mov.GetDTD001_MWarehouseSource_ID() + " AND IsDefault = 'Y'";
int ii = DataBase.DB.GetSQLValue(Get_TrxName(), sql);
SetM_Locator_ID(ii);
}
}
if (GetM_Locator_ID() == GetM_LocatorTo_ID())
{
log.SaveError("Error", Msg.ParseTranslation(GetCtx(), "'From @M_Locator_ID@' and '@M_LocatorTo_ID@' cannot be same."));//change message according to requirement
return(false);
}
if (Env.Signum(GetMovementQty()) == 0 && Util.GetValueOfInt(GetTargetQty()) == 0)
{
log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "MovementQty"));
return(false);
}
//Amit
Tuple <String, String, String> mInfo = null;
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
if (!newRecord && Util.GetValueOfInt(Get_ValueOld("M_Product_ID")) != GetM_Product_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_ProdNotChanged"));
return(false);
}
if (!newRecord && Util.GetValueOfInt(Get_ValueOld("M_Locator_ID")) != GetM_Locator_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_LocatorNotChanged"));
return(false);
}
if (!newRecord && Util.GetValueOfInt(Get_ValueOld("M_RequisitionLine_ID")) != GetM_RequisitionLine_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_ReqNotChanged"));
return(false);
}
}
//if (Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA203_'", null, null)) > 0)
if (Env.IsModuleInstalled("VA203_"))
{
if (GetM_RequisitionLine_ID() > 0)
{
MRequisitionLine reqline = new MRequisitionLine(GetCtx(), GetM_RequisitionLine_ID(), Get_Trx()); // Trx used to handle query stuck problem
if (GetM_AttributeSetInstance_ID() != reqline.GetM_AttributeSetInstance_ID())
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "VA203_AttributeInstanceMustBeSame"));
return(false);
}
}
}
// IF Doc Status = InProgress then No record Save
MMovement move = new MMovement(GetCtx(), GetM_Movement_ID(), Get_Trx()); // Trx used to handle query stuck problem
if (newRecord && move.GetDocStatus() == "IP")
{
log.SaveError("Message", Msg.GetMsg(GetCtx(), "DTD001_CannotCreate"));
return(false);
}
// change to set Converted Quantity in Movement quantity if there is differnce in UOM of Base Product and UOM Selected on line
if (newRecord || Is_ValueChanged("QtyEntered") || Is_ValueChanged("C_UOM_ID"))
{
Decimal?qty = Util.GetValueOfDecimal(Get_Value("QtyEntered"));
if (product.GetC_UOM_ID() != Util.GetValueOfInt(Get_Value("C_UOM_ID")))
{
SetMovementQty(MUOMConversion.ConvertProductFrom(GetCtx(), GetM_Product_ID(), Util.GetValueOfInt(Get_Value("C_UOM_ID")), Util.GetValueOfDecimal(Get_Value("QtyEntered"))));
}
}
// Qty Precision
if (newRecord || Is_ValueChanged("QtyEntered"))
{
SetMovementQty(GetMovementQty());
}
MWarehouse wh = null; MWarehouse whTo = null;
//string qry = "select m_warehouse_id from m_locator where m_locator_id=" + GetM_Locator_ID();
//M_Warehouse_ID = Util.GetValueOfInt(DB.ExecuteScalar(qry));
wh = MWarehouse.Get(GetCtx(), mov.GetDTD001_MWarehouseSource_ID());
whTo = MWarehouse.Get(GetCtx(), mov.GetM_Warehouse_ID());
string qry = "SELECT NVL(SUM(NVL(QtyOnHand,0)),0) AS QtyOnHand FROM M_Storage where m_locator_id=" + GetM_Locator_ID() + " and m_product_id=" + GetM_Product_ID();
if (GetM_AttributeSetInstance_ID() != 0)
{
qry += " AND M_AttributeSetInstance_ID=" + GetM_AttributeSetInstance_ID();
}
OnHandQty = Convert.ToDecimal(DB.ExecuteScalar(qry));
qry = "SELECT NVL(SUM(NVL(QtyOnHand,0)),0) AS QtyOnHand FROM M_Storage where m_locator_id=" + GetM_LocatorTo_ID() + " and m_product_id=" + GetM_Product_ID();
if (GetM_AttributeSetInstance_ID() != 0)
{
qry += " AND M_AttributeSetInstance_ID=" + GetM_AttributeSetInstance_ID();
}
OnHandQtyTo = Convert.ToDecimal(DB.ExecuteScalar(qry));
// SI_0635 : System is giving error of insufficient qty if disallow is true in TO warehouse and false in From warehouse
// when record is in completed & closed stage - then no need to check qty availablity in warehouse
if ((wh.IsDisallowNegativeInv() || whTo.IsDisallowNegativeInv()) &&
(!(move.GetDocStatus() == "CO" || move.GetDocStatus() == "CL" || move.GetDocStatus() == "RE" || move.GetDocStatus() == "VO")))
{
if (wh.IsDisallowNegativeInv() && (OnHandQty - GetMovementQty()) < 0)
{
// check for From Locator
log.SaveError("Info", product.GetName() + " , " + Msg.GetMsg(GetCtx(), "VIS_InsufficientQty") + OnHandQty);
return(false);
}
else if (whTo.IsDisallowNegativeInv() && (OnHandQtyTo + GetMovementQty()) < 0)
{
// check for To Locator
log.SaveError("Info", product.GetName() + " , " + Msg.GetMsg(GetCtx(), "VIS_InsufficientQty") + OnHandQtyTo);
return(false);
}
}
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
qry = "SELECT NVL(SUM(NVL(QtyOnHand,0)- qtyreserved),0) AS QtyAvailable FROM M_Storage where m_locator_id=" + GetM_Locator_ID() + " and m_product_id=" + GetM_Product_ID();
if (GetM_AttributeSetInstance_ID() != 0)
{
qry += " AND M_AttributeSetInstance_ID=" + GetM_AttributeSetInstance_ID();
}
qtyAvailable = Convert.ToDecimal(DB.ExecuteScalar(qry));
qtyReserved = Util.GetValueOfDecimal(Get_ValueOld("MovementQty"));
//if (wh.IsDisallowNegativeInv() == true)
//{
// if ((qtyAvailable < (GetMovementQty() - qtyReserved)))
// {
// log.SaveError("Message", product.GetName() + " , " + Msg.GetMsg(GetCtx(), "DTD001_QtyNotAvailable"));
// return false;
// }
//}
}
//By Amit - 17-April-2017
if (Env.IsModuleInstalled("VA024_"))
{
// checking are we moving product from one warehouse to other warehouse
if (Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT CASE WHEN ((SELECT CASE WHEN o.IsLegalEntity = 'Y' THEN w.AD_Org_ID
ELSE (SELECT AD_Org_ID FROM AD_Org WHERE Ad_Org_id = o.LegalEntityOrg ) END
FROM m_warehouse w INNER JOIN ad_org o ON o.AD_Org_ID = w.AD_Org_ID WHERE w.m_warehouse_id = m.DTD001_MWarehouseSource_ID)) =
(SELECT CASE WHEN o2.IsLegalEntity = 'Y' THEN w2.AD_Org_ID
ELSE (SELECT AD_Org_ID FROM AD_Org WHERE Ad_Org_id = o2.LegalEntityOrg) END
FROM m_warehouse w2 INNER JOIN ad_org o2 ON o2.AD_Org_ID = w2.AD_Org_ID WHERE M_Warehouse_ID = m.M_Warehouse_ID )
THEN 0 ELSE (SELECT ad_org_id FROM m_warehouse WHERE M_Warehouse_ID = m.M_Warehouse_ID ) END AS result FROM m_movement m WHERE m_movement_id = " + GetM_Movement_ID(), null, Get_Trx())) > 0)
{
MMovement inventory = new MMovement(GetCtx(), GetM_Movement_ID(), Get_Trx());
try
{
string qry1 = @"SELECT SUM(o.VA024_UnitPrice) FROM VA024_t_ObsoleteInventory o
WHERE o.IsActive = 'Y' AND o.M_Product_ID = " + GetM_Product_ID() + @" and
( o.M_AttributeSetInstance_ID = " + GetM_AttributeSetInstance_ID() + @" OR o.M_AttributeSetInstance_ID IS NULL )" +
" AND o.AD_Org_ID = " + GetAD_Org_ID();
VA024_ProvisionPrice = Util.GetValueOfDecimal(DB.ExecuteScalar(qry1, null, Get_Trx()));
SetVA024_UnitPrice(Util.GetValueOfDecimal(VA024_ProvisionPrice * GetMovementQty()));
qry1 = @"SELECT (ct.currentcostprice - " + VA024_ProvisionPrice + ") * " + GetMovementQty();
qry1 += @" FROM m_product p INNER JOIN va024_t_obsoleteinventory oi ON p.m_product_id = oi.M_product_ID
INNER JOIN m_product_category pc ON pc.m_product_category_ID = p.m_product_category_ID
INNER JOIN AD_client c ON c.AD_Client_ID = p.Ad_Client_ID INNER JOIN AD_ClientInfo ci ON c.AD_Client_ID = ci.Ad_Client_ID
INNER JOIN m_cost ct ON ( p.M_Product_ID = ct.M_Product_ID AND ci.C_AcctSchema1_ID = ct.C_AcctSchema_ID )
INNER JOIN c_acctschema asch ON (asch.C_AcctSchema_ID = ci.C_AcctSchema1_ID)
INNER JOIN va024_obsoleteinvline oil ON oil.va024_obsoleteinvline_ID = oi.va024_obsoleteinvline_ID ";
qry1 += @" WHERE ct.AD_Org_ID =
CASE WHEN ( pc.costinglevel IS NOT NULL AND pc.costinglevel = 'O') THEN " + GetAD_Org_ID() + @"
WHEN ( pc.costinglevel IS NOT NULL AND (pc.costinglevel = 'C' OR pc.costinglevel = 'B')) THEN 0
WHEN (pc.costinglevel IS NULL AND asch.costinglevel = 'O') THEN " + GetAD_Org_ID() + @"
WHEN ( pc.costinglevel IS NULL AND (asch.costinglevel = 'C' OR asch.costinglevel = 'B')) THEN 0 END
AND ct.m_costelement_id =
CASE WHEN ( pc.costingmethod IS NOT NULL AND pc.costingmethod != 'C') THEN (SELECT MIN(m_costelement_id) FROM m_costelement
WHERE m_costelement.costingmethod =pc.costingmethod AND m_costelement.Ad_Client_ID = oi.ad_client_id )
WHEN ( pc.costingmethod IS NOT NULL AND pc.costingmethod = 'C' ) THEN pc.m_costelement_id
WHEN ( pc.costingmethod IS NULL AND asch.costingmethod != 'C') THEN (SELECT MIN(m_costelement_id) FROM m_costelement
WHERE m_costelement.costingmethod = asch.costingmethod AND m_costelement.Ad_Client_ID = oi.ad_client_id )
WHEN ( pc.costingmethod IS NULL AND asch.costingmethod = 'C') THEN asch.m_costelement_id END
AND NVL(ct.M_Attributesetinstance_ID , 0) =
CASE WHEN ( pc.costinglevel IS NOT NULL AND pc.costinglevel = 'B') THEN " + GetM_AttributeSetInstance_ID() + @"
WHEN ( pc.costinglevel IS NOT NULL AND (pc.costinglevel = 'C' OR pc.costinglevel = 'O')) THEN 0
WHEN ( pc.costinglevel IS NULL AND asch.costinglevel = 'B') THEN " + GetM_AttributeSetInstance_ID() + @"
WHEN ( pc.costinglevel IS NULL AND (asch.costinglevel = 'C' OR asch.costinglevel = 'O')) THEN 0 END
AND p.M_Product_ID = " + GetM_Product_ID();
SetVA024_CostPrice(Util.GetValueOfDecimal(DB.ExecuteScalar(qry1, null, Get_Trx())));
}
catch { }
}
}
// Mandatory Instance
if (GetM_AttributeSetInstanceTo_ID() == 0)
{
if (GetM_AttributeSetInstance_ID() != 0) // Set to from
{
SetM_AttributeSetInstanceTo_ID(GetM_AttributeSetInstance_ID());
}
else
{
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
//MProduct product = GetProduct();
if (product != null &&
product.GetM_AttributeSet_ID() != 0)
{
//MAttributeSet mas = MAttributeSet.Get(GetCtx(), product.GetM_AttributeSet_ID());
//if (mas.IsInstanceAttribute()
// && (mas.IsMandatory() || mas.IsMandatoryAlways()))
//{
// log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "M_AttributeSetInstanceTo_ID"));
// return false;
//}
// Code Addeded by Bharat as Discussed with Mukesh Sir
if (String.IsNullOrEmpty(GetDTD001_AttributeNumber()))
{
return(true);
}
else
{
if (GetDTD001_AttributeNumber() == "" || GetDTD001_AttributeNumber() == null)
{
log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "DTD001_AttributeNumber"));
return(false);
}
}
}
else
{
if (product != null)
{
if (product.GetM_AttributeSet_ID() == 0 && (GetDTD001_AttributeNumber() == "" || GetDTD001_AttributeNumber() == null))
{
return(true);
}
else
{
//log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "DTD001_AttributeNumber"));
//ShowMessage.Info("a", true, "Product is not of Attribute Type", null);
log.SaveError("Product is not of Attribute Type", Msg.GetElement(GetCtx(), "DTD001_AttributeNumber"));
return(false);
}
//Check No Of Attributes Are Equal To Quantity Or Less Than
int Count = CountAttributes(GetDTD001_AttributeNumber());
if (Count != GetMovementQty())
{
if (Count > GetMovementQty())
{
log.SaveError("Error", Msg.GetMsg(GetCtx(), "DTD001_MovementAttrbtGreater"));
return(false);
}
else
{
log.SaveError("Error", Msg.GetMsg(GetCtx(), "DTD001_MovementAttrbtLess"));
return(false);
}
}
}
}
}
else
{
//MProduct product = GetProduct();
if (product != null &&
product.GetM_AttributeSet_ID() != 0)
{
MAttributeSet mas = MAttributeSet.Get(GetCtx(), product.GetM_AttributeSet_ID());
if (mas.IsInstanceAttribute() &&
(mas.IsMandatory() || mas.IsMandatoryAlways()))
{
log.SaveError("FillMandatory", Msg.GetElement(GetCtx(), "M_AttributeSetInstanceTo_ID"));
return(false);
}
}
}
}
} // ASI
return(true);
}
/// <summary>
/// Move stock to location
/// </summary>
/// <param name="target">storage</param>
/// <returns>no of movements</returns>
private int Move(MStorage target)
{
log.Info(target.ToString());
Decimal qty = Decimal.Negate(target.GetQtyOnHand());//.negate();
// Create Movement
MMovement mh = new MMovement(GetCtx(), 0, Get_Trx());
mh.SetC_DocType_ID(_C_DocType_ID);
mh.SetDescription(GetName());
if (!mh.Save())
{
return(0);
}
int lines = 0;
MStorage[] sources = GetSources(target.GetM_Product_ID(), target.GetM_Locator_ID());
for (int i = 0; i < sources.Length; i++)
{
MStorage source = sources[i];
// Movement Line
MMovementLine ml = new MMovementLine(mh);
ml.SetM_Product_ID(target.GetM_Product_ID());
ml.SetM_LocatorTo_ID(target.GetM_Locator_ID());
ml.SetM_AttributeSetInstanceTo_ID(target.GetM_AttributeSetInstance_ID());
// From
ml.SetM_Locator_ID(source.GetM_Locator_ID());
ml.SetM_AttributeSetInstance_ID(source.GetM_AttributeSetInstance_ID());
Decimal qtyMove = qty;
if (qtyMove.CompareTo(source.GetQtyOnHand()) > 0)
{
qtyMove = source.GetQtyOnHand();
}
ml.SetMovementQty(qtyMove);
//
lines++;
ml.SetLine(lines * 10);
if (!ml.Save())
{
return(0);
}
qty = Decimal.Subtract(qty, qtyMove);
if (Env.Signum(qty) <= 0)
{
break;
}
} // for all movements
// Process
//mh.ProcessIt(MMovement.ACTION_Complete);
mh.ProcessIt(DocActionVariables.ACTION_COMPLETE);
mh.Save();
AddLog(0, null, new Decimal(lines), "@M_Movement_ID@ " + mh.GetDocumentNo() + " ("
+ MRefList.Get(GetCtx(), MMovement.DOCSTATUS_AD_Reference_ID,
mh.GetDocStatus(), Get_Trx()) + ")");
EliminateReservation(target);
return(lines);
}