/// <summary>
/// Validate Product
/// </summary>
/// <param name="product">product</param>
/// <returns>Info</returns>
private String ValidateProduct(MProduct product)
{
if (!product.IsBOM())
{
return(product.GetName() + " @NotValid@ @M_BOM_ID@");
}
_product = product;
// Check Old Product BOM Structure
log.Config(_product.GetName());
_products = new List <MProduct>();
if (!ValidateOldProduct(_product))
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " @NotValid@");
}
// New Structure
MBOM[] boms = MBOM.GetOfProduct(GetCtx(), _M_Product_ID, Get_Trx(), null);
for (int i = 0; i < boms.Length; i++)
{
_products = new List <MProduct>();
if (!ValidateBOM(boms[i]))
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " " + boms[i].GetName() + " @NotValid@");
}
}
// OK
_product.SetIsVerified(true);
_product.Save();
return(_product.GetName() + " @IsValid@");
}
/// <summary>
/// Validate BOM
/// </summary>
/// <param name="bom">bom</param>
/// <returns>true if valid</returns>
private bool ValidateBOM(MBOM bom)
{
MBOMProduct[] BOMproducts = MBOMProduct.GetOfBOM(bom);
for (int i = 0; i < BOMproducts.Length; i++)
{
MBOMProduct BOMproduct = BOMproducts[i];
MProduct pp = new MProduct(GetCtx(), BOMproduct.GetM_BOMProduct_ID(), Get_Trx());
if (pp.IsBOM())
{
return(ValidateProduct(pp, bom.GetBOMType(), bom.GetBOMUse()));
}
}
return(true);
}
/// <summary>
/// Validate Product
/// </summary>
/// <param name="product">product</param>
/// <returns>Info</returns>
private String ValidateProduct(MProduct product)
{
if (!product.IsBOM())
{
return(product.GetName() + " @NotValid@ @M_BOM_ID@");
}
_product = product;
// Check Old Product BOM Structure
log.Config(_product.GetName());
_products = new List <MProduct>();
if (!ValidateOldProduct(_product))
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " @NotValid@");
}
// New Structure
MBOM[] boms = MBOM.GetOfProduct(GetCtx(), _M_Product_ID, Get_Trx(), null);
for (int i = 0; i < boms.Length; i++)
{
//When BOM Type = Manufacturing then system will not allow to verify the BOM if sum of component is less or greater then 1
if (boms[i].GetBOMUse() == "M")
{
_product = product;
Decimal count = Util.GetValueOfDecimal(DB.ExecuteScalar("SELECT SUM(BOMQty) FROM M_BOMProduct WHERE IsActive = 'Y' AND M_BOM_ID=" + boms[i].GetM_BOM_ID(), null, null));
if (count != 1)
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " " + boms[i].GetName() + " @NotValid@");
}
}
_products = new List <MProduct>();
if (!ValidateBOM(boms[i]))
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " " + boms[i].GetName() + " @NotValid@");
}
}
// OK
_product.SetIsVerified(true);
_product.Save();
return(_product.GetName() + " @IsValid@");
}
/// <summary>
/// Validate Product
/// </summary>
/// <param name="product">product</param>
/// <returns>Info</returns>
private String ValidateProduct(MProduct product)
{
count = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT COUNT(*) FROM AD_MODULEINFO WHERE IsActive = 'Y' AND PREFIX ='VAMFG_'"));
if (!product.IsBOM())
{
return(product.GetName() + " @NotValid@ @M_BOM_ID@");
}
_product = product;
// Check Old Product BOM Structure
log.Config(_product.GetName());
_products = new List <MProduct>();
if (!ValidateOldProduct(_product))
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " @NotValid@");
}
// New Structure
MBOM[] boms = MBOM.GetOfProduct(GetCtx(), _M_Product_ID, Get_Trx(), null);
// if manufacturing module exist and BOM not contain any record against this product then not to verify Product
if (count > 0 && boms.Length == 0)
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " @NotValid@");
}
for (int i = 0; i < boms.Length; i++)
{
_products = new List <MProduct>();
if (!ValidateBOM(boms[i]))
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " " + boms[i].GetName() + " @NotValid@");
}
}
// OK
_product.SetIsVerified(true);
_product.Save();
return(_product.GetName() + " @IsValid@");
}
/// <summary>
/// Validate BOM
/// </summary>
/// <param name="bom">bom</param>
/// <returns>true if valid</returns>
private bool ValidateBOM(MBOM bom)
{
count = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT COUNT(*) FROM AD_MODULEINFO WHERE IsActive = 'Y' AND PREFIX ='VAMFG_'"));
MBOMProduct[] BOMproducts = MBOMProduct.GetOfBOM(bom);
// if manufacturing module exist and BOM Componet not contain any record against this BOM then not to verify Product
if (count > 0 && BOMproducts.Length == 0)
{
return(false);
}
for (int i = 0; i < BOMproducts.Length; i++)
{
MBOMProduct BOMproduct = BOMproducts[i];
MProduct pp = new MProduct(GetCtx(), BOMproduct.GetM_BOMProduct_ID(), Get_Trx());
if (pp.IsBOM())
{
return(ValidateProduct(pp, bom.GetBOMType(), bom.GetBOMUse()));
}
}
return(true);
}
/// <summary>
/// Validate Product
/// </summary>
/// <param name="product">product</param>
/// <param name="BOMType"></param>
/// <param name="BOMUse"></param>
/// <returns>true if valid</returns>
private bool ValidateProduct(MProduct product, String BOMType, String BOMUse)
{
if (!product.IsBOM())
{
return(true);
}
//
String restriction = "BOMType='" + BOMType + "' AND BOMUse='" + BOMUse + "'";
MBOM[] boms = MBOM.GetOfProduct(GetCtx(), _M_Product_ID, Get_Trx(),
restriction);
if (boms.Length != 1)
{
log.Warning(restriction + " - Length=" + boms.Length);
return(false);
}
if (_products.Contains(product))
{
log.Warning(_product.GetName() + " recursively includes " + product.GetName());
return(false);
}
_products.Add(product);
log.Fine(product.GetName());
//
MBOM bom = boms[0];
MBOMProduct[] BOMproducts = MBOMProduct.GetOfBOM(bom);
for (int i = 0; i < BOMproducts.Length; i++)
{
MBOMProduct BOMproduct = BOMproducts[i];
MProduct pp = new MProduct(GetCtx(), BOMproduct.GetM_BOMProduct_ID(), Get_Trx());
if (pp.IsBOM())
{
return(ValidateProduct(pp, bom.GetBOMType(), bom.GetBOMUse()));
}
}
return(true);
}
/// <summary>
/// when we select BOM on production Plan, if attribute defined on BOM then need to set the same Attributesetinstance
/// </summary>
/// <param name="fields">M_BOM_ID</param>
/// <returns>M_Attributesetinstance_ID</returns>
public int GetAttributeSetInstance(Ctx ctx, string M_BOM_ID)
{
MBOM bom = MBOM.Get(ctx, Convert.ToInt32(M_BOM_ID));
return(bom.GetM_AttributeSetInstance_ID());
}