// GET: Tarefas/Details/5 public ActionResult Details(int?id) { Tarefas Tarefas = new Tarefas(); using (ISession session = NHibernateSession.OpenSession(hibernatePath)) { Tarefas = session.Query <Tarefas>().Where(b => b.Id == id).FirstOrDefault(); } TarefasStatus tarefasStatus = new TarefasStatus(); using (ISession session2 = NHibernateSession.OpenSession(hibernatePath2)) { Tarefas.TarefasStatus = session2.Query <TarefasStatus>().Where(b => b.Id == Tarefas.TarefasStatusId).FirstOrDefault(); } TarefasUrgencia TarefasUrgencia = new TarefasUrgencia(); using (ISession session3 = NHibernateSession.OpenSession(hibernatePath3)) { Tarefas.TarefasUrgencia = session3.Query <TarefasUrgencia>().Where(b => b.Id == Tarefas.TarefasUrgenciaId).FirstOrDefault(); } return(View(Tarefas)); }
public ActionResult Edit(int id, FormCollection collection) { try { TarefasStatus TarefasStatus = new TarefasStatus(); TarefasStatus.Id = id; TarefasStatus.Status = collection["Status"].ToString(); if (TarefasStatus.Status.Trim() == string.Empty) { ViewBag.SaveUnsucess = "Preencha o campo Status"; return(View()); } else { // TODO: Add insert logic here using (ISession session = NHibernateSession.OpenSession(hibernatePath)) { using (ITransaction transaction = session.BeginTransaction()) { session.SaveOrUpdate(TarefasStatus); transaction.Commit(); } } return(RedirectToAction("Index")); } } catch { return(View()); } }
// GET: Tarefas public ActionResult Index() { List <Tarefas> listTarefas; using (ISession session = NHibernateSession.OpenSession(hibernatePath)) // Open a session to conect to the database { listTarefas = session.Query <Tarefas>().ToList(); // Querying to get all the Tarefas foreach (Tarefas item in listTarefas) { TarefasStatus tarefasStatus = new TarefasStatus(); using (ISession session2 = NHibernateSession.OpenSession(hibernatePath2)) { tarefasStatus = session2.Query <TarefasStatus>().Where(b => b.Id == item.TarefasStatusId).FirstOrDefault(); item.TarefasStatus = tarefasStatus; //Limita quantidade characters item.DesTarefa = item.DesTarefa.Length > 20 ? item.DesTarefa.Substring(0, 15) : item.DesTarefa; item.TituloTarefa = item.TituloTarefa.Length > 20 ? item.TituloTarefa.Substring(0, 15) : item.TituloTarefa; } TarefasUrgencia tarefasUrgencia = new TarefasUrgencia(); using (ISession session3 = NHibernateSession.OpenSession(hibernatePath3)) { DateTime date = new DateTime(1900, 01, 01); tarefasUrgencia = session3.Query <TarefasUrgencia>().Where(b => b.Id == item.TarefasUrgenciaId).FirstOrDefault(); item.TarefasUrgencia = tarefasUrgencia; item.DataEdicaoStr = item.DataEdicao == null? "" : item.DataEdicao.ToString(); } } } return(View(listTarefas)); }
public ActionResult Create(FormCollection collection) { try { TarefasStatus TarefasStatus = new TarefasStatus(); // Creating a new instance of the TarefasStatus TarefasStatus.Status = collection["Status"].ToString(); if (TarefasStatus.Status.Trim() == string.Empty) { ViewBag.SaveUnsucess = "Preencha o campo Status"; return(View()); } else { // TODO: Add insert logic here using (ISession session = NHibernateSession.OpenSession(hibernatePath)) { using (ITransaction transaction = session.BeginTransaction()) // Begin a transaction { session.Save(TarefasStatus); // Save the TarefasStatus in session transaction.Commit(); // Commit the changes to the database } } return(RedirectToAction("Index")); } } catch (Exception e) { ViewBag.SaveUnsucess = "Não foi possível Cadastrar"; return(View()); } }
// GET: TarefasStatus/Details/5 public ActionResult Details(int?id) { TarefasStatus TarefasStatus = new TarefasStatus(); using (ISession session = NHibernateSession.OpenSession(hibernatePath)) { TarefasStatus = session.Query <TarefasStatus>().Where(b => b.Id == id).FirstOrDefault(); } return(View(TarefasStatus)); }
// GET: TarefasStatus/Edit/5 public ActionResult Edit(int id) { TarefasStatus TarefasStatus = new TarefasStatus(); using (ISession session = NHibernateSession.OpenSession(hibernatePath)) { TarefasStatus = session.Query <TarefasStatus>().Where(b => b.Id == id).FirstOrDefault(); } ViewBag.SubmitAction = "Save"; return(View(TarefasStatus)); }
// GET: TarefasStatus/Delete/5 public ActionResult Delete(int Id) { // Delete the TarefasStatus TarefasStatus TarefasStatus = new TarefasStatus(); using (ISession session = NHibernateSession.OpenSession(hibernatePath)) { TarefasStatus = session.Query <TarefasStatus>().Where(b => b.Id == Id).FirstOrDefault(); } ViewBag.SubmitAction = "Confirm delete"; return(View("Delete", TarefasStatus)); }
public ActionResult Delete(int id, FormCollection collection) { try { // TODO: Add delete logic here using (ISession session = NHibernateSession.OpenSession(hibernatePath)) { TarefasStatus TarefasStatus = session.Get <TarefasStatus>(id); using (ITransaction trans = session.BeginTransaction()) { session.Delete(TarefasStatus); trans.Commit(); } } return(RedirectToAction("Index")); } catch (Exception e) { ViewBag.DeleteError = "Não foi possível realizar a Exclusão"; return(View()); } }