// GET: Tarefas/ObterListaDeTarefasComStatusPendenteNoBD
public JsonResult ObterListaDeTarefasComStatusPendenteNoBD()
{
using (var db = new SeletivoUCDBDbContext())
{
return(Json(db.Tarefas.ToList().Where(x => x.StatusTarefa.Equals("Pendente")), JsonRequestBehavior.AllowGet));
}
}
// GET: Tarefas/ObterListaDeTarefasDeHojeNoBD
public JsonResult ObterListaDeTarefasDeHojeNoBD()
{
using (var db = new SeletivoUCDBDbContext())
{
return(Json(db.Tarefas.ToList().Where(x => x.DataHora.Day.Equals(DateTime.Now.Day)), JsonRequestBehavior.AllowGet));
}
}
// GET: Tarefas/ObterListaDeTarefasArmazenadasNoBD
public JsonResult ObterListaDeTarefasArmazenadasNoBD()
{
using (var db = new SeletivoUCDBDbContext())
{
return(Json(db.Tarefas.ToList(), JsonRequestBehavior.AllowGet));
}
}
public JsonResult ExcluirRegistroDeTarefaNoBD(int id)
{
using (var db = new SeletivoUCDBDbContext())
{
var tarefaLocalizada = db.Tarefas.Find(id);
if (tarefaLocalizada != null)
{
db.Tarefas.Remove(tarefaLocalizada);
db.SaveChanges();
return(Json(new { success = true }));
}
return(Json(new { success = false }));
}
}
public JsonResult AdicionarTarefaNoBD(Tarefa tarefa)
{
if (tarefa != null)
{
using (var db = new SeletivoUCDBDbContext())
{
db.Tarefas.Add(tarefa);
db.SaveChanges();
return(Json(new { success = true }));
}
}
return(Json(new { success = false }));
}
public JsonResult AtualizarStatusDaTarefaNoBD(Tarefa tarefa)
{
if (tarefa != null)
{
using (var db = new SeletivoUCDBDbContext())
{
var tarefaLocalizada = db.Tarefas.Find(tarefa.Id);
tarefaLocalizada.StatusTarefa = tarefa.StatusTarefa;
db.SaveChanges();
return(Json(new { success = true }));
}
}
return(Json(new { success = false }));
}
