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