public ActionResult Create([Bind(Include = "ID,country_id,id_institution,population,year")] CatPopulationInstitution catPopulationInstitution, int[] Pop_PobFem, int[] Pop_PobMas, int[] Pop_PobTot, int[] Pop_id_conf_country) { if (ModelState.IsValid) { var CatPop = new CatPopulationInstitution() { country_id = catPopulationInstitution.country_id, id_institution = catPopulationInstitution.id_institution, population = catPopulationInstitution.population, year = catPopulationInstitution.year, CatPopulationDetails = new List <CatPopulationInstitutionDetail>() }; db.Entry(CatPop).State = EntityState.Added; for (int i = 0; i < Pop_id_conf_country.Length; i++) { CatPop.CatPopulationDetails.Add( new CatPopulationInstitutionDetail() { AgeGroup = Pop_id_conf_country[i], PopulationFem = Pop_PobFem[i], PopulationMaso = Pop_PobMas[i], PopulationT = Pop_PobTot[i] } ); } db.SaveChanges(); return(RedirectToAction("Index")); } PopulationDepartmentsDropDownList(); return(View(catPopulationInstitution)); }
public ActionResult DeleteConfirmed(int id) { CatPopulationInstitution catPopulationInstitution = db.CatPopulationInstitutions.Find(id); db.CatPopulationInstitutions.Remove(catPopulationInstitution); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: CatPopulationInstitutions/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CatPopulationInstitution catPopulationInstitution = db.CatPopulationInstitutions.Find(id); if (catPopulationInstitution == null) { return(HttpNotFound()); } return(View(catPopulationInstitution)); }
// GET: CatPopulationInstitutions/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CatPopulationInstitution catPopulationInstitution = db.CatPopulationInstitutions.Find(id); if (catPopulationInstitution == null) { return(HttpNotFound()); } PopulationDepartmentsDropDownList(catPopulationInstitution.country_id, catPopulationInstitution.id_institution, id); return(View(catPopulationInstitution)); }
public ActionResult Edit([Bind(Include = "ID,country_id,id_institution,population,year")] CatPopulationInstitution catPopulationInstitution, int[] Pop_PobFem, int[] Pop_PobMas, int[] Pop_PobTot, int[] Pop_id_conf_country) { if (ModelState.IsValid) { var CatPop = new CatPopulationInstitution() { id = catPopulationInstitution.id, country_id = catPopulationInstitution.country_id, id_institution = catPopulationInstitution.id_institution, population = catPopulationInstitution.population, year = catPopulationInstitution.year //CatPopulationDetails = new List<CatPopulationInstitutionDetail>() }; db.Entry(CatPop).State = EntityState.Modified; //foreach (object Pop_Det_Age in Pop_id_conf_country) for (int i = 0; i < Pop_id_conf_country.Length; i++) { var valor = Pop_id_conf_country[i]; var CatPopDetail = db.CatPopulationInstitutionsDetails.FirstOrDefault(j => j.CatPobInstId == catPopulationInstitution.id && j.AgeGroup == valor); CatPopDetail.PopulationFem = Pop_PobFem[i]; CatPopDetail.PopulationMaso = Pop_PobMas[i]; CatPopDetail.PopulationT = Pop_PobTot[i]; db.Entry(CatPopDetail).State = EntityState.Modified; } //db.Entry(catPopulationInstitution).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } PopulationDepartmentsDropDownList(catPopulationInstitution.country_id, catPopulationInstitution.id_institution); return(View(catPopulationInstitution)); }