public void TestarSalvarTarefaValida()
{
var conexao = new SqliteConnection("DataSource=:memory:");
conexao.Open();
var opcoes = new DbContextOptionsBuilder <TarefasContext>()
.UseSqlite(conexao)
.Options;
try
{
using (var contexto = new TarefasContext(opcoes))
{
contexto.Database.EnsureCreated();
}
using (var contexto = new TarefasContext(opcoes))
{
Tarefa tarefa = new Tarefa {
Descricao = "Descrição teste", Finalizado = false, Titulo = "Título teste"
};
TarefasDAO.SalvarTarefa(tarefa);
}
using (var contexto = new TarefasContext(opcoes))
{
Assert.AreEqual(1, contexto.Tarefas.Count());
Assert.AreEqual("Descrição teste", contexto.Tarefas.FirstOrDefault().Descricao);
Assert.AreEqual("Título teste", contexto.Tarefas.FirstOrDefault().Titulo);
}
}
finally
{
conexao.Close();
}
//Tarefa tarefa = new Tarefa {DataTarefa = DateTime.Now, Descricao = "Tarefa teste", Finalizado = false, Titulo="titulo teste"};
//TarefasDAO.SalvarTarefa(tarefa);
//using (var contexto = new TarefasContext())
//{
// Tarefa tarefaNoBanco = contexto.Tarefas.LastOrDefault();
// Assert.AreEqual(tarefaNoBanco.Descricao, tarefa.Descricao);
// Assert.AreEqual(tarefaNoBanco.Titulo, tarefa.Titulo);
//}
}
public TarefasController(TarefasContext tarefas)
{
_contexto = tarefas;
if (_contexto.Tarefas.Count() == 0)
{
_contexto.Tarefas.Add(new Tarefa()
{
Detalhes = "Encher o tanque!", Concluida = false, Importante = true, DataLimite = new DateTime(2018, 5, 20)
});
_contexto.Tarefas.Add(new Tarefa()
{
Detalhes = "Pagar VIVO", Concluida = false, Importante = false, DataLimite = new DateTime(2018, 5, 20)
});
_contexto.Tarefas.Add(new Tarefa()
{
Detalhes = "Buscar Livro com a Vó", Concluida = true, Importante = false
});
_contexto.SaveChanges();
}
}
public CriarTarefaCommand(TarefasContext context)
{
_context = context;
}
public TarefaEntityFrameworkRepository(TarefasContext dbContext)
{
_db = dbContext;
}
public AdicionarLembreteCommand(TarefasContext context)
{
_context = context;
}
public TarefaRepository(TarefasContext context) : base(context)
{
}
public ListarTarefaCommand(TarefasContext context)
{
_context = context;
}
public RepositoryUsuario(TarefasContext context, TarefaContextMongo contextMg)
{
_context = context;
_contextMg = contextMg;
}
public SubTarefasDAO(TarefasContext context)
{
this.Contexto = context;
}
//private readonly IHttpContextAccessor _accessor;
public TarefaRepositorio(TarefasContext context)
{
_context = context;
//accessor = _accessor;
}
public ConcluirTarefaCommand(TarefasContext context)
{
_context = context;
}
protected Repository(TarefasContext context)
{
Db = context;
DbSet = Db.Set <TEntity>();
}
public CriarUsuarioCommand(TarefasContext context)
{
_context = context;
}
public SqlTarefas(TarefasContext contexto)
{
_contexto = contexto;
}
public ListarUsuariosQuery(TarefasContext context)
{
_context = context;
}
public RepositoryLIstaDeTarefas(TarefasContext context)
{
_context = context;
}
public UnitOfWork(TarefasContext context)
{
_context = context;
}
public RepositoryTarefa(TarefasContext context)
{
_context = context;
}
