/// <summary>
/// Validate Product
/// </summary>
/// <param name="product">product</param>
/// <returns>Info</returns>
private String ValidateProduct(VAdvantage.Model.MProduct product)
{
//count = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT COUNT(*) FROM AD_MODULEINFO WHERE IsActive = 'Y' AND PREFIX ='VAMFG_'"));
// JID_0690: If manufaturing Module is not downloaded validate BOM Process was not working.
if (!product.IsBOM())
{
return(product.GetName() + " @NotValid@ @M_BOM_ID@");
}
_product = product;
// Check Old Product BOM Structure
log.Config(_product.GetName());
_products = new List <VAdvantage.Model.MProduct>();
// Check applied if the product is of item type recipee, then bom should validate from second tab of product i.e Bill Of Material else from BOM and BM Components.
// Change by mohit to validate the BOM if created from recipee manaement form.- 28 June 2019.
if (Env.IsModuleInstalled("VA019_") && product.GetVA019_ItemType().Equals(VAdvantage.Model.X_M_Product.VA019_ITEMTYPE_Recipe))
{
if (!ValidateOldProduct(_product))
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " @NotValid@");
}
}
// New Structure
else
{
if (!ValidateOldProduct(_product))
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " @NotValid@");
}
VAdvantage.Model.MBOM[] boms = VAdvantage.Model.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
// JID_0690: If manufaturing Module is not downloaded validate BOM Process was not working.
//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 <VAdvantage.Model.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 Old BOM Product structure
/// </summary>
/// <param name="product">product</param>
/// <returns>true if valid</returns>
private bool ValidateOldProduct(VAdvantage.Model.MProduct product)
{
if (!product.IsBOM())
{
return(true);
}
//
if (_products.Contains(product))
{
log.Warning(_product.GetName() + " recursively includes " + product.GetName());
return(false);
}
_products.Add(product);
log.Fine(product.GetName());
//
VAdvantage.Model.MProductBOM[] productsBOMs = VAdvantage.Model.MProductBOM.GetBOMLines(product);
for (int i = 0; i < productsBOMs.Length; i++)
{
VAdvantage.Model.MProductBOM productsBOM = productsBOMs[i];
VAdvantage.Model.MProduct pp = new VAdvantage.Model.MProduct(GetCtx(), productsBOM.GetM_ProductBOM_ID(), Get_Trx());
if (!pp.IsBOM())
{
log.Finer(pp.GetName());
}
else if (!ValidateOldProduct(pp))
{
return(false);
}
}
return(true);
}
/// <summary>
/// Validate Product
/// </summary>
/// <param name="product">product</param>
/// <returns>Info</returns>
private String ValidateProduct(VAdvantage.Model.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 <VAdvantage.Model.MProduct>();
if (!ValidateOldProduct(_product))
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " @NotValid@");
}
// New Structure
VAdvantage.Model.MBOM[] boms = VAdvantage.Model.MBOM.GetOfProduct(GetCtx(), _M_Product_ID, Get_Trx(), null);
for (int i = 0; i < boms.Length; i++)
{
_products = new List <VAdvantage.Model.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(VAdvantage.Model.MBOM bom)
{
VAdvantage.Model.MBOMProduct[] BOMproducts = VAdvantage.Model.MBOMProduct.GetOfBOM(bom);
for (int i = 0; i < BOMproducts.Length; i++)
{
VAdvantage.Model.MBOMProduct BOMproduct = BOMproducts[i];
VAdvantage.Model.MProduct pp = new VAdvantage.Model.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(VAdvantage.Model.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 <VAdvantage.Model.MProduct>();
if (!ValidateOldProduct(_product))
{
_product.SetIsVerified(false);
_product.Save();
return(_product.GetName() + " @NotValid@");
}
// New Structure
VAdvantage.Model.MBOM[] boms = VAdvantage.Model.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 <VAdvantage.Model.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(VAdvantage.Model.MBOM bom)
{
count = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT COUNT(*) FROM AD_MODULEINFO WHERE IsActive = 'Y' AND PREFIX ='VAMFG_'"));
VAdvantage.Model.MBOMProduct[] BOMproducts = VAdvantage.Model.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++)
{
VAdvantage.Model.MBOMProduct BOMproduct = BOMproducts[i];
VAdvantage.Model.MProduct pp = new VAdvantage.Model.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(VAdvantage.Model.MProduct product, String BOMType, String BOMUse)
{
if (!product.IsBOM())
{
return(true);
}
//
String restriction = "BOMType='" + BOMType + "' AND BOMUse='" + BOMUse + "'";
VAdvantage.Model.MBOM[] boms = VAdvantage.Model.MBOM.GetOfProduct(GetCtx(), _M_Product_ID, Get_Trx(),
restriction);
//VAdvantage.Model.MBOM[] boms = VAdvantage.Model.MBOM.GetOfProduct(GetCtx(), product.GetM_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());
//
VAdvantage.Model.MBOM bom = boms[0];
VAdvantage.Model.MBOMProduct[] BOMproducts = VAdvantage.Model.MBOMProduct.GetOfBOM(bom);
for (int i = 0; i < BOMproducts.Length; i++)
{
VAdvantage.Model.MBOMProduct BOMproduct = BOMproducts[i];
VAdvantage.Model.MProduct pp = new VAdvantage.Model.MProduct(GetCtx(), BOMproduct.GetM_BOMProduct_ID(), Get_Trx());
//VAdvantage.Model.MProduct pp = new VAdvantage.Model.MProduct(GetCtx(), BOMproduct.GetM_ProductBOM_ID(), Get_Trx());
if (pp.IsBOM())
{
return(ValidateProduct(pp, bom.GetBOMType(), bom.GetBOMUse()));
}
}
return(true);
}
/// <summary>
/// Validate Old BOM Product structure
/// </summary>
/// <param name="product">product</param>
/// <returns>true if valid</returns>
private bool ValidateOldProduct(VAdvantage.Model.MProduct product)
{
//count = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT COUNT(*) FROM AD_MODULEINFO WHERE IsActive = 'Y' AND PREFIX ='VAMFG_'"));
if (!product.IsBOM())
{
return(true);
}
//
if (_products.Contains(product))
{
log.Warning(_product.GetName() + " recursively includes " + product.GetName());
return(false);
}
_products.Add(product);
log.Fine(product.GetName());
//
VAdvantage.Model.MProductBOM[] productsBOMs = VAdvantage.Model.MProductBOM.GetBOMLines(product);
// if manufacturing module not exist and Product BOM not containany record against this product thennot to verify BOM
// JID_0690: If manufaturing Module is not downloaded validate BOM Process was not working.
//if (count <= 0 && productsBOMs.Length == 0)
//{
// return false;
//}
for (int i = 0; i < productsBOMs.Length; i++)
{
VAdvantage.Model.MProductBOM productsBOM = productsBOMs[i];
VAdvantage.Model.MProduct pp = new VAdvantage.Model.MProduct(GetCtx(), productsBOM.GetM_ProductBOM_ID(), Get_Trx());
if (!pp.IsBOM())
{
log.Finer(pp.GetName());
}
else if (!ValidateOldProduct(pp))
{
return(false);
}
}
return(true);
}
/// <summary>
/// Validate BOM
/// </summary>
/// <param name="bom">bom</param>
/// <returns>true if valid</returns>
private bool ValidateBOM(VAdvantage.Model.MBOM bom)
{
//count = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT COUNT(*) FROM AD_MODULEINFO WHERE IsActive = 'Y' AND PREFIX ='VAMFG_'"));
VAdvantage.Model.MBOMProduct[] BOMproducts = VAdvantage.Model.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)
// JID_0690: If manufaturing Module is not downloaded validate BOM Process was not working.
if (BOMproducts.Length == 0)
{
return(false);
}
for (int i = 0; i < BOMproducts.Length; i++)
{
VAdvantage.Model.MBOMProduct BOMproduct = BOMproducts[i];
//VAdvantage.Model.MProduct pp = new VAdvantage.Model.MProduct(GetCtx(), BOMproduct.GetM_BOMProduct_ID(), Get_Trx());
VAdvantage.Model.MProduct pp = new VAdvantage.Model.MProduct(GetCtx(), BOMproduct.GetM_ProductBOM_ID(), Get_Trx());
if (pp.IsBOM() && BOMproduct.GetM_ProductBOMVersion_ID() > 0)
{
//return ValidateProduct(pp, bom.GetBOMType(), bom.GetBOMUse());
if (_products.Contains(pp))
{
log.Warning(_product.GetName() + " recursively includes " + pp.GetName());
return(false);
}
_products.Add(pp);
if (!pp.IsVerified())
{
return(false);
}
}
}
return(true);
}