public ActionResult Showcategoryname(string id)
        {
            productDAL dal = new productDAL();
            var        d   = dal.getcategorynames(id);

            return(View(d));
        }
        public ActionResult viewproduct()
        {
            productDAL dal = new productDAL();
            var        d   = dal.Viewproduct();

            return(View(d));
        }
        public ActionResult Addproduct()
        {
            productDAL dal = new productDAL();
            var        cid = dal.getcategoryid().ToList();

            ViewData.Add("cid", cid);
            return(View());
        }
        public ActionResult Addproduct(tbl_product p)
        {
            productDAL dal = new productDAL();
            var        cid = dal.getcategoryid().ToList();

            ViewData.Add("cid", cid);
            if (ModelState.IsValid)
            {
                dal.addproduct(p);

                var message = "Record added successfully!";


                ViewData.Add("message", message);
            }

            return(View());
        }