public ActionResult Create([Bind(Include = "ID_Context,ID_Project,ContextName,CreationDate")] Tb_Contexts tb_Contexts, int ID_Project) { if (ModelState.IsValid) { using (DbContextTransaction transaction = db.Database.BeginTransaction()) { try { db.Tb_Contexts.Add(tb_Contexts); tb_Contexts.ID_Project = ID_Project; tb_Contexts.CreationDate = DateTime.Now.Date; db.SaveChanges(); transaction.Commit(); return(RedirectToAction("Index", new { ID_Project = ID_Project })); } catch (Exception ex) { transaction.Rollback(); MessageBox.Show("Error: " + ex.Message); } } db.Tb_Contexts.Add(tb_Contexts); tb_Contexts.CreationDate = DateTime.Now.Date; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ID_Project = new SelectList(db.Tb_Projects, "ID_Project", "ProjectName", tb_Contexts.ID_Project); return(View(tb_Contexts)); }
// GET: Object/Create public ActionResult Create(int idContext, int idProject) { ViewBag.idContext = idContext; Tb_Contexts tb = db.Tb_Contexts.Find(idContext); ViewBag.CxtName = tb.ContextName; ViewBag.idProject = idProject; return(View()); }
// GET: Object public ActionResult Index(int idContext, int idProject) { ViewBag.idContext = idContext; Tb_Contexts tbC = db.Tb_Contexts.Find(idContext); ViewBag.CxtName = tbC.ContextName; ViewBag.idProject = idProject; var tb_Objects = db.Tb_Objects.Include(t => t.Tb_Contexts); return(View(tb_Objects.Where(x => x.ID_Context == idContext).ToList())); }
// GET: Context/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Tb_Contexts tb_Contexts = db.Tb_Contexts.Find(id); if (tb_Contexts == null) { return(HttpNotFound()); } ViewBag.id_Project = tb_Contexts.Tb_Projects.ID_Project; ViewBag.CurrentName = tb_Contexts.Tb_Projects.ProjectName; return(View(tb_Contexts)); }
// GET: Object/Delete/5 public ActionResult Delete(int?id, int idContext, int idProject) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Tb_Objects tb_Objects = db.Tb_Objects.Find(id); if (tb_Objects == null) { return(HttpNotFound()); } Tb_Contexts tb = db.Tb_Contexts.Find(idContext); ViewBag.CxtName = tb.ContextName; ViewBag.idProject = idProject; ViewBag.idContext = idContext; return(View(tb_Objects)); }
public ActionResult DeleteConfirmed(int id) { Tb_Contexts tb_Contexts = db.Tb_Contexts.Find(id); if (ModelState.IsValid) { using (DbContextTransaction transaction = db.Database.BeginTransaction()) { try { db.Tb_Contexts.Remove(tb_Contexts); db.SaveChanges(); transaction.Commit(); return(RedirectToAction("Index", new { ID_Project = tb_Contexts.ID_Project })); } catch (Exception ex) { transaction.Rollback(); MessageBox.Show("Error: " + ex.Message); } } } return(View(tb_Contexts)); }