public Guid Inserir(Contato contato)
{
_context.Add(contato);
_context.SaveChanges();
return(contato.Id);
}
public Guid Inserir(Usuario usuario)
{
_context.Add(usuario);
_context.SaveChanges();
return(usuario.Id);
}
public ActionResult Cadastrar(Contato contato)
{
//Cadastra no Banco de Dados
_context.Contatos.Add(contato);
_context.SaveChanges();
//Mensagem de sucesso
TempData["msg"] = "Contato registrado!";
return(View());
}
public ActionResult AddBroker([Bind(Include = "LastName, FirstName, Mail, PhoneNumber")] Broker broker)
{
if (ModelState.IsValid)
{
db.Brokers.Add(broker);
db.SaveChanges();
return(RedirectToAction("ListBrokers"));
}
return(View());
}
public ActionResult Create([Bind(Include = "Id,Numero,Nombre,ContactoId")] Telefono telefono)
{
if (ModelState.IsValid)
{
db.Telefonos.Add(telefono);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Contactos = db.Contactos.ToList();
return(View(telefono));
}
public ActionResult Create([Bind(Include = "Id,Nombre")] Contacto contacto)
{
if (ModelState.IsValid)
{
db.Contactos.Add(contacto);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contacto));
}
public ActionResult Create([Bind(Include = "ID,Name,LastName,Email,Number,NType")] Register register)
{
if (ModelState.IsValid)
{
db.Register.Add(register);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(register));
}
public ActionResult Create([Bind(Include = "Id,Nombre,Telefono,Correo")] Agenda agenda)
{
if (ModelState.IsValid)
{
db.Agenda.Add(agenda);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(agenda));
}
public ActionResult Create([Bind(Include = "Id,Nome,Email,IdConsultor, Telefones")] Cliente cliente)
{
if (ModelState.IsValid)
{
db.Clientes.Add(cliente);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IdConsultor = new SelectList(db.Consultores, "Id", "Nome", cliente.IdConsultor);
return(View(cliente));
}
public void Insert(Contact obj)
{
try
{
_context.Add(obj);
_context.SaveChanges();
}
catch (DbConcurrencyException e)
{
throw new DbConcurrencyException(e.Message);
}
}
public ActionResult Create([Bind(Include = "ID,PessoaID,Numero,Tipo")] Telefone telefone)
{
if (ModelState.IsValid)
{
db.Telefones.Add(telefone);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PessoaID = new SelectList(db.Pessoas, "ID", "Nome", telefone.PessoaID);
return(View(telefone));
}
public ObjectResult Post([FromForm] APIAppointment apiAppt)
{
var newAppt = (AgendaAppointment)apiAppt;
_context.Appointments.Add(newAppt);
_context.SaveChanges();
return(Ok(new
{
tid = newAppt.Id,
action = "inserted"
}));
}
public IActionResult Post([FromBody] Turma turma)
{
if (ModelState.IsValid)
{
_contexto.Turmas.Add(turma);
_contexto.SaveChanges();
return(Ok(turma));
}
else
{
return(BadRequest(ModelState.Values.SelectMany(e => e.Errors.Select(er => er.ErrorMessage))));
}
}
public bool Add(Persona persona)
{
try
{
db.Personas.Add(persona);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
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();
}
}
public Contact InsertContact(Contact contato)
{
_context.Contatos.Add(contato);
_context.SaveChanges();
return(contato);
}
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();
}
public void commit()
{
agendaContext.SaveChanges();
if (agendaContext.Database.CurrentTransaction != null)
{
agendaContext.Database.CurrentTransaction.Commit();
}
}
public void Commit()
{
var rowsAffected = _ctx.SaveChanges();
if (rowsAffected == 0)
{
_notifications.SetNotification(new DomainNotification("Commit", "Ocorreu um erro ao salvar os dados no banco"));
}
}
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());
}
}
private void Delete_Button(object sender, RoutedEventArgs e)
{
af458_brokers customer = (af458_brokers)dgBrokers.SelectedItem;
af458_brokers af458_brokers = db.af458_brokers.Find(customer.id);
try
{
db.af458_brokers.Remove(af458_brokers);
db.SaveChanges();
MainWindow main = Application.Current.MainWindow as MainWindow;
ListBroker ListBrokerPage = new ListBroker();
main.MainFrame.Navigate(ListBrokerPage);
error_message.Text = "Le client a bien été supprimé";
}
catch (DbEntityValidationException)
{
error_message.Text = "Le client n'a pas pu être supprimé";
}
}
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 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());
}
}
private void Delete_Button(object sender, RoutedEventArgs e)
{
af458_appointments appointment = (af458_appointments)dgAppointments.SelectedItem;
af458_appointments af458_appointments = db.af458_appointments.Find(appointment.id);
try
{
db.af458_appointments.Remove(af458_appointments);
db.SaveChanges();
MainWindow main = Application.Current.MainWindow as MainWindow;
ListAppointment ListAppointmentPage = new ListAppointment();
main.MainFrame.Navigate(ListAppointmentPage);
error_message.Text = "Le rendez-vous a bien été supprimé";
}
catch (DbEntityValidationException)
{
error_message.Text = "Le rendez-vous n'a pas pu être supprimé";
}
}
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 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 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 RemUrgent(int tsk_i)
{
using (var db = new AgendaContext())
{
var ur = (from t in db.Urgent
where t.Id == tsk_i
select t).FirstOrDefault();
if (ur == null)
{
db.SaveChanges();
Console.WriteLine("Nothing happened");
return(Ok());
}
else
{
db.Urgent.Remove(ur);
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 IActionResult RemColl(int coll_i)
{
using (var db = new AgendaContext())
{
var co = (from t in db.Tascoll
where t.Id == coll_i
select t).FirstOrDefault();
if (co == null)
{
db.SaveChanges();
Console.WriteLine("Nothing happened");
return(Ok());
}
else
{
db.Tascoll.Remove(co);
db.SaveChanges();
return(Ok());
}
}
}
