public ActionResult New()
        {
            List <SelectListItem> Products = new List <SelectListItem>()
            {
                new SelectListItem()
                {
                    Value = "0", Text = "-- Select Products --"
                },
            };

            List <SelectListItem> categories = new List <SelectListItem>();

            var MyItem = new ItemViewModel2();

            var catgs = (
                from c in DBcontext.Categories
                select c).ToList();

            foreach (var item in catgs)
            {
                categories.Add(new SelectListItem()
                {
                    Value = (item.ID).ToString(), Text = item.Name
                });
            }

            MyItem.Products   = Products;
            MyItem.Categories = categories;
            // return View(MyItem);
            return(PartialView(MyItem));
        }
        public ActionResult New(ItemViewModel2 i)
        {
            //initial model
            List <SelectListItem> Products = new List <SelectListItem>()
            {
                new SelectListItem()
                {
                    Value = "0", Text = "-- Select Products --"
                },
            };

            List <SelectListItem> categories = new List <SelectListItem>();
            var MyItem = new ItemViewModel2();
            var catgs  = (
                from c in DBcontext.Categories
                select c).ToList();

            foreach (var item in catgs)
            {
                categories.Add(new SelectListItem()
                {
                    Value = (item.ID).ToString(), Text = item.Name
                });
            }

            MyItem.Products   = Products;
            MyItem.Categories = categories;
            //////////////////////////////////
            if (ModelState.IsValid)
            {
                Item newI = new Item();

                //coping Product
                var cat = DBcontext.Categories.FirstOrDefault(c => c.ID == i.CategoryID);
                //if (cat != null)
                //{
                var prod = DBcontext.Products.FirstOrDefault
                               (p => p.ID == i.ProductID && p.CategoryID == cat.ID);

                newI.Product   = prod;
                newI.ProductID = prod.ID;

                //coping Item
                newI.Size         = i.Size;
                newI.Color        = i.Color;
                newI.Discount     = i.Discount;
                newI.Price        = i.Price;
                newI.UnitsInStock = i.UnitsInStock;
                newI.Picture      = i.Picture;
                newI.Rank         = i.Rank;
                newI.Note         = i.Note;

                DBcontext.Items.Add(newI);
                DBcontext.SaveChanges();
                // return View(MyItem);
                return(Content("<script>alert('Added successfully');</script>"));
                //}
                //return View(MyItem);
            }
            else
            {
                ModelState.AddModelError("", "plz check that your data is valid");
                i.Categories = categories;
                i.Products   = Products;
                // return View(i);
                return(Content("<script>alert('plz check that your data is valid');</script>"));
            }
        }