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