//-------------Search products--------//
        public static void SearchProductPL()
        {
            string     productid;
            ECEntities product;

            try
            {
                Console.Clear();
                Console.WriteLine("************************************************************************************");
                Console.WriteLine("                                 Search Product                          ");
                Console.WriteLine("************************************************************************************");
                Console.WriteLine("Enter the Product(ID):)");
                productid = Console.ReadLine();
                product   = ECBL.SearchProductBL(productid);
                if (product != null)
                {
                    Console.WriteLine("Product is found");
                    Console.WriteLine("*********************************************************************************");
                    Console.WriteLine("ProductId:" + product.ProductID + "\n ProductName:" + product.ProductName + "\n Description" + product.Description + "\n Quantity" + product.Quantity + "\n Price" + product.Price);
                    Console.WriteLine("*********************************************************************************");
                }
                else
                {
                    Console.WriteLine("Product not found");
                }
            }
            catch (ECExceptions ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
        //-----------Update products-----------//
        public static void UpdateProductPL()
        {
            string productid;

            try
            {
                Console.Clear();
                Console.WriteLine("*******************************************************************************");
                Console.WriteLine("                                 Update Product Details                       ");
                Console.WriteLine("******************************************************************************");
                Console.WriteLine("Enter the Product:(ID)");
                productid = Console.ReadLine();
                ECEntities product = ECBL.SearchProductBL(productid);
                if (product != null)
                {
                    Console.WriteLine("Enter the Name of product:");
                    product.ProductName = Console.ReadLine();
                    Console.WriteLine("Enter the Description:");
                    product.Description = Console.ReadLine();
                    Console.WriteLine("Enter the quantity:");
                    product.Quantity = Console.ReadLine();
                    Console.WriteLine("Enter the price:");
                    product.Price = Console.ReadLine();

                    bool updated = ECBL.UpdateProductBL(product);
                    if (updated)
                    {
                        Console.WriteLine("Product is updated");
                    }
                    else
                    {
                        Console.WriteLine("Product is not updated");
                    }
                }
                else
                {
                    Console.WriteLine("Product ID not found");
                }
            }
            catch (ECExceptions ex)
            {
                Console.WriteLine(ex.Message);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }