public ActionResult SaveProduct(ProductModel loProductModel)
        {
            ProductDataContext db = new ProductDataContext();

            try
            {
                if (loProductModel.ProductID > 0)
                {
                    db.SP_UPDATEProduct(loProductModel.ProductID, loProductModel.CategoryID, loProductModel.ProductName);
                }
                else
                {
                    db.SP_InsertProduct(loProductModel.CategoryID, loProductModel.ProductName);
                }
            }
            catch (Exception ex)
            {
                return(View());
            }
            return(RedirectToAction("Product"));
        }