public ActionResult Edit([Bind(Include = "ID_LEVEL1,NAME_LEVEL1")] LEVEL1 lEVEL1)
{
if (ModelState.IsValid)
{
db.Entry(lEVEL1).State = EntityState.Modified;
var list = db.LEVEL4.Where(c => c.LEVEL3.LEVEL2.LEVEL1.ID_LEVEL1 == lEVEL1.ID_LEVEL1);
foreach (var item in list)
{
LEVEL4 level4aux = db.LEVEL4.Find(item.ID_LEVEL4);
LEVEL2 level2aux = db.LEVEL2.Find(item.LEVEL3.ID_LEVEL2);
LEVEL1 level1aux = db.LEVEL1.Find(level2aux.ID_LEVEL1);
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"));
}
return(View(lEVEL1));
}
//public async Task<ActionResult> DeleteConfirmed(decimal id)
public ActionResult DeleteConfirmed(decimal id)
{
LEVEL4 lEVEL4 = db.LEVEL4.Find(id);
db.LEVEL4.Remove(lEVEL4);
db.SaveChanges();
if (!Ordenador.GenerarMenuDinamico())
{
return(View("ErrorPage"));
}
return(RedirectToAction("Index"));
}
// GET: LEVEL4/Details/5
public async Task <ActionResult> Details(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LEVEL4 lEVEL4 = await db.LEVEL4.FindAsync(id);
if (lEVEL4 == null)
{
return(HttpNotFound());
}
return(View(lEVEL4));
}
// GET: LEVEL4/Edit/5
public async Task <ActionResult> Edit(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LEVEL4 lEVEL4 = await db.LEVEL4.FindAsync(id);
if (lEVEL4 == null)
{
return(HttpNotFound());
}
ViewBag.ID_LEVEL3 = new SelectList(db.LEVEL3, "ID_LEVEL3", "NAME_LEVEL3", lEVEL4.ID_LEVEL3);
return(View(lEVEL4));
}
//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 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));
}
