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