public ActionResult Edit([Bind(Include = "ID_LEVEL3,ID_LEVEL2,NAME_LEVEL3")] LEVEL3 lEVEL3)
{
if (ModelState.IsValid)
{
db.Entry(lEVEL3).State = EntityState.Modified;
db.SaveChanges();
var list = db.LEVEL4.Where(c => c.ID_LEVEL3 == lEVEL3.ID_LEVEL3);
foreach (var item in list)
{
LEVEL4 level4aux = db.LEVEL4.Find(item.ID_LEVEL4);
LEVEL2 level2aux = db.LEVEL2.Find(item.LEVEL3.ID_LEVEL2);
level4aux.TAG = level2aux.LEVEL1.NAME_LEVEL1 + " " +
level2aux.NAME_LEVEL2 + " " +
level4aux.LEVEL3.NAME_LEVEL3 + " " +
level4aux.NAME_LEVEL4;
db.Entry(level4aux).State = EntityState.Modified;
}
db.SaveChanges();
if (!Ordenador.GenerarMenuDinamico())
{
return(View("ErrorPage"));
}
return(RedirectToAction("Index"));
}
ViewBag.ID_LEVEL2 = new SelectList(db.LEVEL2, "ID_LEVEL2", "NAME_LEVEL2", lEVEL3.ID_LEVEL2);
return(View(lEVEL3));
}
// GET: LEVEL3/Details/5
public ActionResult Details(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LEVEL3 lEVEL3 = db.LEVEL3.Find(id);
if (lEVEL3 == null)
{
return(HttpNotFound());
}
return(View(lEVEL3));
}
// GET: LEVEL3/Edit/5
public ActionResult Edit(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LEVEL3 lEVEL3 = db.LEVEL3.Find(id);
if (lEVEL3 == null)
{
return(HttpNotFound());
}
ViewBag.ID_LEVEL2 = new SelectList(db.LEVEL2, "ID_LEVEL2", "NAME_LEVEL2", lEVEL3.ID_LEVEL2);
return(View(lEVEL3));
}
public ActionResult Create([Bind(Include = "ID_LEVEL3,ID_LEVEL2,NAME_LEVEL3")] LEVEL3 lEVEL3)
{
lEVEL3.ID_LEVEL3 = db.LEVEL3.Count() + 1;
if (ModelState.IsValid)
{
db.LEVEL3.Add(lEVEL3);
db.SaveChanges();
if (!Ordenador.GenerarMenuDinamico())
{
return(View("ErrorPage"));
}
return(RedirectToAction("Index"));
}
ViewBag.ID_LEVEL2 = new SelectList(db.LEVEL2, "ID_LEVEL2", "NAME_LEVEL2", lEVEL3.ID_LEVEL2);
return(View(lEVEL3));
}
public ActionResult DeleteAll(decimal id)
{
LEVEL3 lEVEL3 = db.LEVEL3.Find(id);
var lEVEL4 = db.LEVEL4.Where(c => c.LEVEL3.ID_LEVEL3 == lEVEL3.ID_LEVEL3);
List <LEVEL4> recorrido = lEVEL4.ToList();
foreach (var item in recorrido)
{
db.LEVEL4.Remove(item);
}
db.SaveChanges();
db.LEVEL3.Remove(lEVEL3);
db.SaveChanges();
if (!Ordenador.GenerarMenuDinamico())
{
return(View("ErrorPage"));
}
return(RedirectToAction("Index"));
}
//public async Task<ActionResult> Edit([Bind(Include = "ID_LEVEL4,ID_LEVEL3,NAME_LEVEL4,VINCULOPOWERBI,TAG")] LEVEL4 lEVEL4)
public ActionResult Edit([Bind(Include = "ID_LEVEL4,ID_LEVEL3,NAME_LEVEL4,VINCULOPOWERBI,TAG")] LEVEL4 lEVEL4)
{
if (ModelState.IsValid)
{
LEVEL3 level3aux = db.LEVEL3.Find(lEVEL4.ID_LEVEL3);
lEVEL4.TAG = level3aux.LEVEL2.LEVEL1.NAME_LEVEL1 + " " +
level3aux.LEVEL2.NAME_LEVEL2 + " " +
level3aux.NAME_LEVEL3 + " " +
lEVEL4.NAME_LEVEL4;
db.Entry(lEVEL4).State = EntityState.Modified;
db.SaveChanges();
if (!Ordenador.GenerarMenuDinamico())
{
return(View("ErrorPage"));
}
return(RedirectToAction("Index"));
}
ViewBag.ID_LEVEL3 = new SelectList(db.LEVEL3, "ID_LEVEL3", "NAME_LEVEL3", lEVEL4.ID_LEVEL3);
return(View(lEVEL4));
}
public ActionResult DeleteConfirmed(decimal id)
{
LEVEL3 lEVEL3 = db.LEVEL3.Find(id);
db.LEVEL3.Remove(lEVEL3);
try
{
db.SaveChanges();
}
catch (Exception)
{
var lEVEL4 = db.LEVEL4.Include(l => l.LEVEL3).Where(c => c.LEVEL3.ID_LEVEL3 == lEVEL3.ID_LEVEL3);
//return View( lEVEL4.ToListAsync());
ViewBag.Level3 = lEVEL3;
return(View("Level4PorBorrar", lEVEL4.ToList()));
}
if (!Ordenador.GenerarMenuDinamico())
{
return(View("ErrorPage"));
}
return(RedirectToAction("Index"));
}
//public async Task<ActionResult> Create([Bind(Include = "ID_LEVEL4,ID_LEVEL3,NAME_LEVEL4,VINCULOPOWERBI,TAG")] LEVEL4 lEVEL4)
public ActionResult Create([Bind(Include = "ID_LEVEL4,ID_LEVEL3,NAME_LEVEL4,VINCULOPOWERBI,TAG")] LEVEL4 lEVEL4)
{
//lEVEL4.ID_LEVEL4 = db.LEVEL4.Max(c => c.ID_LEVEL4) + 1;
lEVEL4.ID_LEVEL4 = db.LEVEL4.Count() + 1;
LEVEL3 level3aux = db.LEVEL3.Find(lEVEL4.ID_LEVEL3);
lEVEL4.TAG = level3aux.LEVEL2.LEVEL1.NAME_LEVEL1 + " " +
level3aux.LEVEL2.NAME_LEVEL2 + " " +
level3aux.NAME_LEVEL3 + " " +
lEVEL4.NAME_LEVEL4;
if (ModelState.IsValid)
{
db.LEVEL4.Add(lEVEL4);
if (!Ordenador.GenerarMenuDinamico())
{
return(View("ErrorPage"));
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_LEVEL3 = new SelectList(db.LEVEL3, "ID_LEVEL3", "NAME_LEVEL3", lEVEL4.ID_LEVEL3);
return(View(lEVEL4));
}
