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