public ProductsViewModel FindProd(int?ProdID)
        {
            try
            {
                ProductsViewModel prodsvm     = new ProductsViewModel();
                ProductsManager   prodManager = new ProductsManager();


                var prods = prodManager.FindProduct(ProdID);
                var daid1 = prods.daid;
                prodsvm.daid = daid1;

                prodsvm.lstLOB     = prodManager.GetLOBs(daid1);
                prodsvm.lstBuzProd = prodManager.GetBuzProds(daid1);

                prodsvm.ProductID    = prods.ProductID;
                prodsvm.ReqReference = prods.ReqReference;
                prodsvm.BuzProdID    = prods.BuzProdID;
                //to get name instead of id
                prodsvm.BuzProdDesc = prodsvm.lstBuzProd.Where(e => e.BuzProdID.Equals(prods.BuzProdID)).First().BuzProdDesc;
                prodsvm.LobID       = prods.LobID;
                prodsvm.LobDesc     = prodsvm.lstLOB.Where(e => e.LobID.Equals(prods.LobID)).First().LobDesc;
                prodsvm.daid        = prods.daid;

                //prodsvm.lstProd = (IList<tbl_Products>) prods;

                return(prodsvm);
            }
            catch (Exception)
            {
                throw;
            }
        }
        public ProductsViewModel GetProducts(int?designAccelaratorID)
        {
            try
            {
                ProductsViewModel prodviewmodel = new ProductsViewModel();
                ProductsManager   prodManager   = new ProductsManager();

                prodviewmodel.lstLOB     = prodManager.GetLOBs(designAccelaratorID);
                prodviewmodel.lstBuzProd = prodManager.GetBuzProds(designAccelaratorID);
                prodviewmodel.lstProd    = prodManager.GetAllProducts(designAccelaratorID);

                return(prodviewmodel);
            }
            catch (Exception)
            {
                throw;
            }
        }