public async Task Add_Contato_Database() { var mockRepository = new Mock <IContatoRepository>(); var options = new DbContextOptionsBuilder <AgendaContext>() .UseInMemoryDatabase(databaseName: "agendadb_test") .Options; using (var context = new AgendaContext(options)) { var service = new ContatoService(mockRepository.Object); _ = await service.Create(new ContatoCreateOrUpdateDto { Canal = "telefone", Nome = "Fulano", Observacoes = "Teste", Valor = "21979075829" }); } using (var context = new AgendaContext(options)) { Assert.Equal(1, await context.Contatos.CountAsync()); Assert.Equal("telefone", context.Contatos.SingleAsync().Result.Canal); } }
public static void AddContacto() { Write("Introduzca un nombre: "); string nombre = ReadLine(); Write("Introduzca un apellido: "); string apellido = ReadLine(); Write("Introduzca un teléfono: "); int telefono = ToInt32(ReadLine()); Write("Introduzca una localidad: "); string localidad = ReadLine(); using (var context = new AgendaContext()) { var contacto = new Contacto() { Nombre = nombre, Apellidos = apellido, Telefono = telefono, Localidad = localidad }; context.Add <Contacto>(contacto); context.SaveChanges(); } }
private static void AddTestData(AgendaContext agendaContext) { agendaContext.Professores.Add(new Professor { Nome = "Ericson Fonseca", EMail = "*****@*****.**" }); agendaContext.Professores.Add(new Professor { Nome = "Robson Araújo", EMail = "*****@*****.**" }); agendaContext.Professores.Add(new Professor { Nome = "Renato Groffe", EMail = "*****@*****.**" }); agendaContext.Professores.Add(new Professor { Nome = "Adriano Maringolo", EMail = "*****@*****.**" }); agendaContext.Cursos.Add(new Curso { Nome = "Quick Start: ASP.NET Core Fundamentals", CargaHorariaHoras = 4, Descricao = "Aprenda os primeiros passos do ASP.NET Core na prática!" }); agendaContext.Cursos.Add(new Curso { Nome = "Quick Start: Entity Framework Core Fundamentals", CargaHorariaHoras = 4, Descricao = "Aprenda os primeiros passos do Entity Framework Core na prática!" }); agendaContext.Cursos.Add(new Curso { Nome = "Quick Start: Azure Fundamentals", CargaHorariaHoras = 4, Descricao = "Aprenda os primeiros passos do Azure na prática!" }); agendaContext.SaveChanges(); }
private static IEnumerable <object> GetUtenti() { using (var context = new AgendaContext()) { return(context.Set <Utenti>().ToList()); } }
private static IEnumerable<object> GetUtenti() { using (var context = new AgendaContext()) { return context.Set<Utenti>().ToList(); } }
/// <summary> /// Construtor da classe Sugestao /// </summary> /// <param name="context_r">Contexto das receitas</param> /// <param name="context_u">Contexto dos utilizadores</param> /// <param name="context_ip">Contexto dos ingredientes passo</param> /// <param name="context_a">Contexto da agenda</param> public Sugestao(ReceitaContext context_r, UtilizadorContext context_u, IngredientesPassoContext context_ip, AgendaContext context_a) { _context_r = context_r; _context_u = context_u; _context_ip = context_ip; _context_a = context_a; }
public List <Contato> RecuperarTodos() { using (var context = new AgendaContext()) { return(context.Contatos.OrderBy(x => x.Nome).ToList()); } }
public EventSourcingRepository(AgendaContext agendaContext) { _agendaContext = agendaContext; setCollectionName(); setConnectAndCollection(); _connectionString = _agendaContext.Database.GetDbConnection().ConnectionString; }
static void Main() { AgendaContext _context = new AgendaContext(); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new EntryPoint()); }
/// <summary> /// Construtor do objecto da classe Selecao /// </summary> /// <param name="context_r">Contexto das receitas</param> /// <param name="context_ing">Contexto dos ingredientes</param> /// <param name="context_ip">Contexto dos IngredientesPasso</param> /// <param name="context_u">Contexto do utilizador</param> /// <param name="context_a">Contexto da agenda</param> public Selecao(ReceitaContext context_r, IngredienteContext context_ing, IngredientesPassoContext context_ip, UtilizadorContext context_u, AgendaContext context_a) { _context_r = context_r; _context_ing = context_ing; _context_ip = context_ip; _context_u = context_u; _context_a = context_a; }
public UnityOfWork( AgendaContext ctx, IDomainNotificationHandler notifications) { _ctx = ctx; _notifications = notifications; _disposed = false; }
/// <summary> /// Constructor of the class /// </summary> /// <param name="context"></param> public ContatoController(AgendaContext context) { _context = context; DatabaseSeeder databaseSeeder = new DatabaseSeeder(_context); databaseSeeder.SeedDatabase(); }
public ContatosViewModel() { Context = new AgendaContext(); this.Contatos = new ObservableCollection <Contato>( Context.Contatos.Include("Compromissos").ToList()); this.ContatoSelecionado = Context .Contatos.FirstOrDefault(); }
public EventoService(IEventoRepository repo, IMapper mapper, AgendaService agendaService, AgendaContext agendaContext) { _agendaService = agendaService; _agendaContext = agendaContext; _mapper = mapper; _repo = repo; }
public List <Contato> Alterar(Contato contato) { using (var context = new AgendaContext()) { context.Contatos.Update(contato); context.SaveChanges(); Console.WriteLine("Contato Alterado!"); return(context.Contatos.OrderBy(x => x.Nome).ToList()); } }
public List <Contato> Inserir(Contato contato) { using (var context = new AgendaContext()) { context.Contatos.Add(contato); context.SaveChanges(); Console.WriteLine("Contato inserido!"); return(context.Contatos.OrderBy(x => x.Nome).ToList()); } }
public ActionResult AlterarNome(int id) { using (var contexto = new AgendaContext()) { NomeDAO dao = new NomeDAO(); ViewBag.Nome = dao.BuscaPorId(id); } return(View()); }
public List <Contato> Excluir(Contato contato) { using (var context = new AgendaContext()) { context.Contatos.Remove(contato); context.SaveChanges(); Console.WriteLine("Contato excluído!"); return(context.Contatos.OrderBy(x => x.Nome).ToList()); } }
// GET: /Home/ public ActionResult Index(int page = 1) { using (var context = new AgendaContext()) { var utenti = context.AGE_UTENTI.Where(u => u.Nome.Contains("FABIO")) .OrderBy(u => u.Cognome) .ToPagedList(page, PageSize); return(this.View(utenti)); } }
// GET: /Home/ public ActionResult Index(int page = 1) { using (var context = new AgendaContext()) { var utenti = context.AGE_UTENTI.Where(u => u.Nome.Contains("FABIO")) .OrderBy(u => u.Cognome) .ToPagedList(page, PageSize); return this.View(utenti); } }
public void Configure(IApplicationBuilder app, IHostingEnvironment env, AgendaContext context) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } AddTesteData(context); app.UseMvc(); }
public IActionResult AddColl() { using (var db = new AgendaContext()) { db.Tascoll.Add(new Tascoll { Title = "New Collection", Inner = new List <MyTask>(), UrgInner = new List <Urgent>() }); db.SaveChanges(); } return(Ok()); }
public IActionResult AddTask(int coll_i) { using (var db = new AgendaContext()) { db.MyTask.Add(new MyTask { Title = "new task", TascollId = coll_i }); db.SaveChanges(); } return(Ok()); }
public IActionResult AddUrgent(int coll_i) { using (var db = new AgendaContext()) { db.Urgent.Add(new Urgent { Title = "urgent task", TascollId = coll_i }); db.SaveChanges(); } return(Ok()); }
public IActionResult GetEverything() { using (var db = new AgendaContext()) { var priority = db.Urgent.ToList(); var colls = db.Tascoll.ToList(); db.SaveChanges(); return(Ok(new Everything { Priority = priority, MyCollections = colls })); } }
public static string GetContacto(int id) { string frase = string.Empty; var context = new AgendaContext(); var listaContactos = context.Contactos.Where(x => x.ContactoID == id).ToList(); foreach (var item in listaContactos) { frase = ($"Nombre: {item.Nombre} {item.Apellidos}."); } return(frase); }
public IActionResult GetMinimal() { using (var db = new AgendaContext()) { var priority = db.Urgent.ToList(); var colls = db.Tascoll.Select(coll => new SimpleColl { Id = coll.Id, Title = coll.Title }).ToList(); db.SaveChanges(); return(Ok(new Minimal { Priority = priority, SimpleCollections = colls })); } }
public ActionResult AlterarTelefone(int id) { using (var contexto = new AgendaContext()) { TelefoneDAO dao = new TelefoneDAO(); ViewBag.Telefone = dao.BuscaPorId(id); NomeDAO nomeDao = new NomeDAO(); IList <Nome> nomes = nomeDao.Lista(); ViewBag.Nomes = nomes; } return(View()); }
public CompromissoViewModel() { Context = new AgendaContext(); IList <Contato> parts = new List <Contato>(); this.Compromissos = new ObservableCollection <Compromisso>( Context.Compromissos.Include("Participantes").ToList()); this.CompromissoSelecionado = Context .Compromissos.FirstOrDefault(); this.CompromissoSelecionado.Participantes = parts; this.Contatos = new ObservableCollection <Contato>( Context.Contatos.ToList()); this.ContatoSelecionado = Context.Contatos.FirstOrDefault(); }
public void CriarBanco() { using (var context = new AgendaContext()) { Console.WriteLine("Verificando banco de dados."); if (!context.Database.CanConnect()) { Console.WriteLine("Criando banco de dados."); Stopwatch sw = new Stopwatch(); sw.Start(); context.Database.Migrate(); sw.Stop(); Console.WriteLine("Criado com sucesso em: " + sw.Elapsed.ToString(@"mm\:ss")); Utilidades.LimparTela(); } Console.Clear(); } }
private bool Accept(IExecutionContext context, Activation activation) { var agendaContext = new AgendaContext(context.Session, context.EventAggregator); try { return(AcceptActivation(agendaContext, activation)); } catch (ExpressionEvaluationException e) { if (!e.IsHandled) { throw new AgendaExpressionEvaluationException("Failed to evaluate agenda filter expression", activation.Rule.Name, e.Expression.ToString(), e.InnerException); } return(false); } }
public ActionResult Excluir(int id = 0) { if (id != 0) { using (var contexto = new AgendaContext()) { var telefones = contexto.Telefones.Where(t => t.Id == id); foreach (Telefone item in telefones) { contexto.Telefones.Remove(item); } contexto.SaveChanges(); } } return(RedirectToAction("Menu", "Telefone")); }