public ActionResult variantEdit(variant_vm vm) { variant v = new variant(); variant_unit vu = new variant_unit(); if (ModelState.IsValid) { v.varient_id = vm.varient_id; v.varient_name = vm.variant_name; v.type = Convert.ToString(vm.type); db.Entry(v).State = EntityState.Modified; db.SaveChanges(); //delete the variant unit var de = db.variant_unit.Where(i => i.variant_id == vm.varient_id).ToList(); if (de != null) { foreach (var s in de) { var f = db.variant_unit.Find(s.variant_unit_id); db.variant_unit.Remove(f); db.SaveChanges(); } } if (vm.unit_name != null) { foreach (var s in vm.unit_name) { vu.variant_id = Convert.ToInt32(vm.varient_id); vu.unit_name = s; db.variant_unit.Add(vu); db.SaveChanges(); } } message = "Variant updated Successfully"; status = true; } else { message = "There Have Some Problems"; } TempData["Message"] = message; TempData["Status"] = status; return(RedirectToAction("variants")); }
public ActionResult variants(variant_vm VM) { variant v = new variant(); variant_unit vu = new variant_unit(); if (ModelState.IsValid) { v.varient_name = VM.variant_name; v.type = Convert.ToString(VM.type); db.variants.Add(v); db.SaveChanges(); var id = db.variants.Find(v.varient_id); if (VM.unit_name != null) { foreach (var s in VM.unit_name) { vu.variant_id = Convert.ToInt32(id.varient_id); vu.unit_name = s; db.variant_unit.Add(vu); db.SaveChanges(); } } message = "Variant setup successfully"; status = true; } else { message = "There are some problems"; } TempData["Message"] = message; TempData["Status"] = status; return(RedirectToAction("variants")); }