Dropdown list cascade in mvc3.0 : The Official Microsoft ASP.NET Forums

Reply

rlondonboy

Member

2 Points

Dropdown list cascade in mvc3.0

Oct 26, 2012 03:47 PM|LINK

I am working on a project where i have three tables ProductType , ProductSubType and Product . what i want to do is when i select productType in product createview then it populates the ProductSubType accordingly. I want to apply this functionality in the Create and Edit view of Product Table . I have tried to look for the solution but didnt find any , Please if someone can help me Many Thanks

My Tables

Product Type :

 public class ProductTypeModels
    {
       
        [Key]
        public int TypeID { get; set; }
   
        public string TypeName { get; set; }
     
    }

ProductSubType Table ;

 public class ProductSubTypeModels
    {
        
        [Key]
        public int SubTypeID { get; set; }

        public int TypeID { get; set; }
       
        public string SubTypeName { get; set; }
    
        public List<ProductModels> Products { get; set; }

        public virtual ProductTypeModels ProductTypes { get; set; }

    }

Product Table :

public class ProductModels
    {
        
        [Key]

        public int ProductID { get; set; }

        public int TypeID { get; set; }

        public int SubTypeID { get; set; }

        public string Title { get; set; }
         public string Description { get; set; }
         public string SKU { get; set; }
        public decimal UnitPrice { get; set; }
       public int UnitsInStock { get; set; }
     
        public virtual ProductTypeModels ProductTypes { get; set; }
        public virtual ProductSubTypeModels ProductSubTypes { get; set; }
      
        public List<ProductTypeModels> productTypes { get; set; }
        public List<ProductSubTypeModels> productSubTypes { get; set; }
    }

Controller for Product

public class ProductsController : Controller
    {
        private DataContext db = new DataContext();
           
        //
        // GET: /Products/Create

        public ActionResult Create()
        {
         

        ViewBag.TypeID = new SelectList(db.ProductTypes, "TypeID", "TypeName");
          ViewBag.SubTypeID = new SelectList(db.ProductSubTypes, "SubTypeID", "SubTypeName");
           
            return View();
        }

      
        //
        // POST: /Products/Create

        [HttpPost]
        public ActionResult Create(ProductModels productmodels, HttpPostedFileBase file)
        {
            if (ModelState.IsValid)
            {
                db.Products.Add(productmodels);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            ViewBag.TypeID = new SelectList(db.ProductTypes, "TypeID", "TypeName", productmodels.TypeID);
            ViewBag.SubTypeID = new SelectList(db.ProductSubTypes, "SubTypeID", "SubTypeName", productmodels.SubTypeID);
             return View(productmodels);
        }

        //
        // GET: /Products/Edit/5

        public ActionResult Edit(int id = 0)
        {
            ProductModels productmodels = db.Products.Find(id);
            if (productmodels == null)
            {
                return HttpNotFound();
            }
            ViewBag.TypeID = new SelectList(db.ProductTypes, "TypeID", "TypeName", productmodels.TypeID);
            ViewBag.SubTypeID = new SelectList(db.ProductSubTypes, "SubTypeID", "SubTypeName", productmodels.SubTypeID);
          
            return View(productmodels);
        }

        //
        // POST: /Products/Edit/5

        [HttpPost]
        public ActionResult Edit(ProductModels productmodels)
        {
            if (ModelState.IsValid)
            {
                db.Entry(productmodels).State = EntityState.Modified;
                db.SaveChanges();
                return RedirectToAction("Index");
            }
            ViewBag.TypeID = new SelectList(db.ProductTypes, "TypeID", "TypeName", productmodels.TypeID);
            ViewBag.SubTypeID = new SelectList(db.ProductSubTypes, "SubTypeID", "SubTypeName", productmodels.SubTypeID);
         
            return View(productmodels);
        }

        //
        // GET: /Products/Delete/5

        public ActionResult Delete(int id = 0)
        {
            ProductModels productmodels = db.Products.Find(id);
            if (productmodels == null)
            {
                return HttpNotFound();
            }
            return View(productmodels);
        }

        //
        // POST: /Products/Delete/5

        [HttpPost, ActionName("Delete")]
        public ActionResult DeleteConfirmed(int id)
        {
            ProductModels productmodels = db.Products.Find(id);
            db.Products.Remove(productmodels);
            db.SaveChanges();
            return RedirectToAction("Index");
        }

        protected override void Dispose(bool disposing)
        {
            db.Dispose();
            base.Dispose(disposing);
        }
    }