public bool CheckDuplicate(ProductsViewModel prodviewmodel)
        {
            try
            {
                ProductsManager prodManager = new ProductsManager();

                var product = prodManager.FindProductReqRef(prodviewmodel.ReqReference, prodviewmodel.LobID, prodviewmodel.BuzProdID, prodviewmodel.daid);

                if (product != null && product.ProductID != prodviewmodel.ProductID && product.ReqReference.ToUpper() == prodviewmodel.ReqReference.ToUpper() &&
                    product.LobID == prodviewmodel.LobID && product.BuzProdID == prodviewmodel.BuzProdID)
                {
                    return(true);
                }
                return(false);
            }
            catch (Exception)
            {
                throw;
            }
        }