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