public ActionResult Edit(Project project, int[] prov) { try { if (ModelState.IsValid) { db.Entry(project).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //-------update project province-------// int Project_id = project.ProjectId; db.ProRel.RemoveRange(db.ProRel.Where(c => c.ProjectId == Project_id)); var PBObject = new ProjectProvRel(); //---adding the project_id to this object---// PBObject.ProjectId = Project_id; // TODO: Add insert logic here foreach (int P_id in prov) { PBObject.ProvinceIds = P_id; db.ProRel.Add(PBObject); db.SaveChanges(); } // TODO: Add update logic here return(RedirectToAction("Index")); } return(View()); } catch { return(View()); } }
public ActionResult Create(Project project, int[] ProvinceId) { try { if (ModelState.IsValid) { db.Projects.Add(project); db.SaveChanges(); int Project_id = project.ProjectId; var PBObject = new ProjectProvRel(); //---adding the project_id to this object---// PBObject.ProjectId = Project_id; // TODO: Add insert logic here foreach (int P_id in ProvinceId) { PBObject.ProvinceIds = P_id; db.ProRel.Add(PBObject); db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(project)); } catch { return(View()); } }