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>")); } }