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