private void BtnDelete_Click(object sender, RoutedEventArgs e)
{
var CurrentBroker = brokerViewSource.View.CurrentItem as Broker;
var broker = (from b in db.Brokers
where b.BrokerID == CurrentBroker.BrokerID
select b).SingleOrDefault();
if (broker != null)
{
string message = "Etes-vous sûr de vouloir supprimer ce courtier?";
string title = "Supprimer un courtier";
MessageBoxButton buttons = MessageBoxButton.YesNo;
MessageBoxResult result = MessageBox.Show(message, title, buttons);
if (result == MessageBoxResult.Yes)
{
db.Entry(broker).State = EntityState.Deleted;
db.SaveChanges();
MessageBox.Show("Suppression terminé");
}
else if (result == MessageBoxResult.No)
{
this.NavigationService.Navigate(new CustomersList());
}
}
}
private void BtnModify_Click(object sender, RoutedEventArgs e)
{
//On recupère l'objet avec l'ID actuel
Appointment appointment = db.Appointments.Find(Convert.ToInt32(TxtAppointmentID.Text));
//Si l'objet est non nul, on créé un autre objet où on insère les modifications
//puis on insère les modifications dans l'objet.
if (appointment != null)
{
//Création de l'objet avec les infos modifiés
var newAppointment = new Appointment()
{
AppointmentID = appointment.AppointmentID,
BrokerID = Convert.ToInt32(BrokerComboBox.SelectedValue),
CustomerID = Convert.ToInt32(CustomerComboBox.SelectedValue),
Subject = TxtSubject.Text,
DateHour = Convert.ToDateTime(dateHourDatePicker.Text)
};
//On insere les données du nouvel objet dans l'ancien
db.Entry(appointment).CurrentValues.SetValues(newAppointment);
db.SaveChanges();
//On rafraichit le dataGrid.
AppointmentsListDataGrid.ItemsSource = db.Appointments.ToList();
//On affiche une alerte afin d'informer la modification.
MessageBox.Show("Le RDV a été modifié");
}
}
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 void Save(object sender, RoutedEventArgs e)
{
bool fail = false;
appointments appointments = new appointments();
appointments appointment = appointments;
appointment.customers = (customers)cbClients.SelectedItem;
appointment.brokers = (brokers)cbBrokers.SelectedItem;
DateTime dt = (DateTime)date.SelectedDate;
DateTime datehour = new DateTime(dt.Year, dt.Month, dt.Day, Convert.ToInt32(hour.Text), Convert.ToInt32(minute.Text), 0);
appointment.dateHour = datehour;
appointment.subject = subject.Text;
db.appointments.Add(appointment);
try
{
db.SaveChanges();
}
catch (DbEntityValidationException)
{
fail = true;
db.appointments.Remove(appointment);
AddLabel.Content = "Erreur d'enregistrement";
}
if (!fail)
{
AddLabel.Content = "Enregistrement reussi";
}
}
private void Save(object sender, RoutedEventArgs e)
{
bool fail = false;
brokers brokers = new brokers();
brokers broker = brokers;
broker.lastname = lastnameBox.Text;
broker.firstname = firstnameBox.Text;
broker.mail = mailBox.Text;
broker.phonenumber = phonenumberBox.Text;
db.brokers.Add(broker);
try
{
db.SaveChanges();
}
catch (DbEntityValidationException)
{
fail = true;
db.brokers.Remove(broker);
AddLabel.Content = "Erreur d'enregistrement";
}
if (!fail)
{
AddLabel.Content = "Enregistrement reussi";
}
}
private void Save(object sender, RoutedEventArgs e)
{
bool fail = false;
customers customers = new customers();
customers customer = customers;
customer.lastname = lastnameBox.Text;
customer.firstname = firstnameBox.Text;
customer.mail = mailBox.Text;
customer.phonenumber = phonenumberBox.Text;
Int32.TryParse(budgetBox.Text, out int budget);
customer.budget = budget;
db.customers.Add(customer);
try
{
db.SaveChanges();
}
catch (DbEntityValidationException)
{
fail = true;
db.customers.Remove(customer);
AddLabel.Content = "Erreur d'enregistrement";
}
if (!fail)
{
AddLabel.Content = "Enregistrement reussi";
}
}
private void Save(object sender, RoutedEventArgs e)
{
bool fail = false;
try
{
db.SaveChanges();
}
catch (DbEntityValidationException)
{
fail = true;
statusLabel.Content = "Erreur d'enregistrement";
}
if (!fail)
{
statusLabel.Content = "Enregistrement reussi";
}
}
static void Main(string[] args)
{
AgendaContext context = new AgendaContext();
Contato contato = new Contato();
contato.Nome = "Teste";
contato.Sobrenome = "Testenildo";
contato.Nasc = new DateTime(2017, 07, 07);
contato.Telefone = "6666-6666";
context.Contatos.Add(contato);
context.SaveChanges();
}
private void BtnSend_Click(object sender, RoutedEventArgs e)
{
Broker broker = new Broker()
{
Firstname = firstnameTextBox.Text,
Lastname = lastnameTextBox.Text,
Mail = mailTextBox.Text,
PhoneNumber = phoneNumberTextBox.Text
};
db.Brokers.Add(broker);
db.SaveChanges();
MessageBox.Show("Vous avez bien ajouté un nouveau Courtier");
}
private void BtnSend_Click(object sender, RoutedEventArgs e)
{
Appointment appointment = new Appointment()
{
DateHour = DateTime.Parse(dtpStartTime.Text),
BrokerID = Convert.ToInt32(BrokersComboBox.SelectedValue),
CustomerID = Convert.ToInt32(CustomersComboBox.SelectedValue),
Subject = subjectTextBox.Text
};
db.Appointments.Add(appointment);
db.SaveChanges();
MessageBox.Show("Vous avez bien ajouté un nouveau Rendez-Vous");
}
private void BtnEnregistrerCustomer_Click(object sender, RoutedEventArgs e)
{
Customer customer = new Customer()
{
LastName = lastNameTextBox.Text,
Firstname = firstnameTextBox.Text,
PhoneNumber = phoneNumberTextBox.Text,
Mail = mailTextBox.Text,
Budget = decimal.Parse(budgetTextBox.Text)
};
db.Entry(customer).State = EntityState.Added;
db.SaveChanges();
}
private void BtnSend_Click(object sender, RoutedEventArgs e)
{
Customer customer = new Customer()
{
Firstname = Firstname.Text,
Lastname = Lastname.Text,
Mail = Mail.Text,
PhoneNumber = PhoneNumber.Text,
Budget = Convert.ToDecimal(Budget.Text)
};
db.Customers.Add(customer);
db.SaveChanges();
MessageBox.Show("Vous avez bien ajouté un nouveau Courtier");
}
