public ActionResult ViewCategory()
        {
            EFDALLib           dal = new EFDALLib();
            List <tbl_product> lsp = dal.GetAllProducts();

            return(View(lsp));
        }
        public ActionResult AddProduct()
        {
            EFDALLib dal   = new EFDALLib();
            var      catid = dal.GetAllCategoryById().ToList();

            ViewData.Add("cid", catid);
            return(View());
        }
        public ActionResult ViewCategoryName(int ID, string cid)
        {
            EFDALLib dal     = new EFDALLib();
            var      record  = dal.ViewProduct(ID);
            var      catname = dal.ViewCategoryNane(cid);

            ViewData.Add("cname", catname);
            return(View(record));
        }
        public ActionResult AddProduct(tbl_product pd)
        {
            EFDALLib dal = new EFDALLib();

            dal.AddProducts(pd);
            var catid = dal.GetAllCategoryById().ToList();

            ViewData.Add("cid", catid);
            ViewData.Add("Message", "Product Added Successfully");

            return(View());
        }