public ActionResult DeleteConfirmed(int id)
{
Municipalitys municipalitys = db.Municipalitys.Find(id);
db.Municipalitys.Remove(municipalitys);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "MunicipalityId,Name,State")] Municipalitys municipalitys)
{
if (ModelState.IsValid)
{
db.Municipalitys.Add(municipalitys);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(municipalitys));
}
// GET: Municipalitys/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Municipalitys municipalitys = db.Municipalitys.Find(id);
if (municipalitys == null)
{
return(HttpNotFound());
}
return(View(municipalitys));
}
public ActionResult Edit([Bind(Include = "MunicipalityId,Name,State")] Municipalitys municipalitys)
{
if (ModelState.IsValid)
{
db.Entry(municipalitys).State = EntityState.Modified;
db.SaveChanges();
// si el estado estado del municipio es distinto va y hace la consulta en la base de datos
if (!municipalitys.State)
{
//hace una consulta a la base de datos por id de la tabla intermedia
var regions = db.MunicipalityRegion.Where(r => r.MunicipalityId == municipalitys.MunicipalityId);
//El count da el número de registros que trae la consulta
if (regions.Count() > 0)
{
db.MunicipalityRegion.RemoveRange(regions);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
return(View(municipalitys));
}
