/// <summary> /// Update /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param> /// ===================================================================================== /// Modification : Initial : 26/10/2018 |N.Wilcké (SESA474351) /// XX/XX/XXXX | X.XXX (SESAXXXXX) /// ===================================================================================== private void updateButton_Click(object sender, RoutedEventArgs e) { try { using (var db = new Model.Booking()) { ClientsSet client = new ClientsSet() { Id = this.client.Id }; db.ClientsSet.Attach(client); client.Nom = nomTextBox.Text; client.Prenom = prenomTextBox.Text; client.DateNaissance = dateNaissanceDatePicker.DisplayDate; db.SaveChanges(); } ((MainWindow)Window.GetWindow(this))._mainFrame.Navigate(new Clients()); } catch (Exception ex) { MessageBox.Show("Internal error :" + Environment.NewLine + ex, "Alert", MessageBoxButton.OK, MessageBoxImage.Information); } }
/// <summary> /// delete /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param> /// ===================================================================================== /// Modification : Initial : 25/10/2018 |N.Wilcké (SESA474351) /// XX/XX/XXXX | X.XXX (SESAXXXXX) /// ===================================================================================== private void MenuItem_Click(object sender, RoutedEventArgs e) { try { ClientsSet row = (ClientsSet)clientsSetDataGrid.SelectedItems[0]; using (var db = new Model.Booking()) { var client = new ClientsSet() { Id = row.Id }; db.ClientsSet.Attach(client); db.ClientsSet.Remove(client); db.SaveChanges(); } DisplayClients(); } catch (Exception ex) { MessageBox.Show("Internal error :" + Environment.NewLine + ex, "Alert", MessageBoxButton.OK, MessageBoxImage.Information); } }
private void buttonAdd_Click(object sender, EventArgs e) { ClientsSet clientSet = new ClientsSet(); clientSet.FirstName = FirstName.Text; clientSet.MiddleName = MiddleName.Text; clientSet.LastName = LastName.Text; clientSet.Phone = Phone.Text; Program.wftDb.ClientsSet.Add(clientSet); Program.wftDb.SaveChanges(); ShowClient(); }
/// <summary> /// Update /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param> /// ===================================================================================== /// Modification : Initial : 26/10/2018 |N.Wilcké (SESA474351) /// XX/XX/XXXX | X.XXX (SESAXXXXX) /// ===================================================================================== private void MenuItem_Click_1(object sender, RoutedEventArgs e) { try { ClientsSet row = (ClientsSet)clientsSetDataGrid.SelectedItems[0]; ((MainWindow)Window.GetWindow(this))._mainFrame.Navigate(new ClientsUpdate(row)); } catch (Exception ex) { MessageBox.Show("Internal error :" + Environment.NewLine + ex, "Alert", MessageBoxButton.OK, MessageBoxImage.Information); } }
private void buttonEdit_Click(object sender, EventArgs e) { if (listViewClient.SelectedItems.Count == 1) { ClientsSet clientsSet = listViewClient.SelectedItems[0].Tag as ClientsSet; clientsSet.FirstName = FirstName.Text; clientsSet.MiddleName = MiddleName.Text; clientsSet.LastName = LastName.Text; clientsSet.Phone = Phone.Text; Program.wftDb.SaveChanges(); ShowClient(); } }
public ClientsUpdate(ClientsSet row) { InitializeComponent(); try { client = row; nomTextBox.Text = client.Nom; prenomTextBox.Text = client.Prenom; dateNaissanceDatePicker.DisplayDate = client.DateNaissance; dateNaissanceDatePicker.Text = client.DateNaissance.ToString(); } catch (Exception ex) { MessageBox.Show("Internal error :" + Environment.NewLine + ex, "Alert", MessageBoxButton.OK, MessageBoxImage.Information); } }
private void listViewClients_SelectedIndexChanged(object sender, EventArgs e) { if (listViewClients.SelectedItems.Count == 1) { ClientsSet clients = listViewClients.SelectedItems[0].Tag as ClientsSet; textBoxName.Text = clients.Name; textBoxPhone.Text = clients.Phone; textBoxEmail.Text = clients.Email; } else { textBoxName.Text = ""; textBoxPhone.Text = ""; textBoxEmail.Text = ""; } }
private void buttonAdd_Click(object sender, EventArgs e) { if (textBoxName.Text != "" && textBoxPhone.Text != "" && textBoxEmail.Text != "") { ClientsSet clientsSet = new ClientsSet(); clientsSet.Name = textBoxName.Text; clientsSet.Phone = textBoxPhone.Text; clientsSet.Email = textBoxEmail.Text; Program.RBS_Project.ClientsSet.Add(clientsSet); Program.RBS_Project.SaveChanges(); ShowClients(); } else { MessageBox.Show("Заполнены не все поля!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void listViewClient_SelectedIndexChanged(object sender, EventArgs e) { if (listViewClient.SelectedItems.Count == 1) { ClientsSet clientsSet = listViewClient.SelectedItems[0].Tag as ClientsSet; clientsSet.FirstName = FirstName.Text; clientsSet.MiddleName = MiddleName.Text; clientsSet.LastName = LastName.Text; clientsSet.Phone = Phone.Text; } else { FirstName.Text = ""; MiddleName.Text = ""; LastName.Text = ""; Phone.Text = ""; } }
private void buttonEdit_Click(object sender, EventArgs e) { if (listViewClients.SelectedItems.Count == 1) { if (textBoxName.Text != "" && textBoxPhone.Text != "" && textBoxEmail.Text != "") { ClientsSet clientsSet = listViewClients.SelectedItems[0].Tag as ClientsSet; clientsSet.Name = textBoxName.Text; clientsSet.Phone = textBoxPhone.Text; clientsSet.Email = textBoxEmail.Text; Program.RBS_Project.SaveChanges(); ShowClients(); } else { MessageBox.Show("Заполнены не все поля!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private void buttonDelete_Click(object sender, EventArgs e) { try { if (listViewClients.SelectedItems.Count == 1) { ClientsSet clientsSet = listViewClients.SelectedItems[0].Tag as ClientsSet; Program.RBS_Project.ClientsSet.Remove(clientsSet); Program.RBS_Project.SaveChanges(); ShowClients(); } textBoxName.Text = ""; textBoxPhone.Text = ""; textBoxEmail.Text = ""; } catch { MessageBox.Show("Невозможно удалить, эта запись используется!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonDel_Click(object sender, EventArgs e) { try { if (listViewClient.SelectedItems.Count == 1) { ClientsSet clientsSet = listViewClient.SelectedItems[0].Tag as ClientsSet; Program.wftDb.ClientsSet.Remove(clientsSet); Program.wftDb.SaveChanges(); ShowClient(); } //очищаем textBoxt-ы FirstName.Text = ""; MiddleName.Text = ""; LastName.Text = ""; Phone.Text = ""; } catch { MessageBox.Show("Невозможно удалить, эта запись используется!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// add new record /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param> /// ===================================================================================== /// Modification : Initial : 25/10/2018 |N.Wilcké (SESA474351) /// XX/XX/XXXX | X.XXX (SESAXXXXX) /// ===================================================================================== private void validateClient_Click(object sender, RoutedEventArgs e) { try { using (var db = new Model.Booking()) { ClientsSet client = new ClientsSet(); client.Nom = nomTextBox.Text; client.Prenom = prenomTextBox.Text; client.DateNaissance = dateNaissanceDatePicker.DisplayDate; db.ClientsSet.Add(client); db.SaveChanges(); } DisplayClients(); } catch (Exception ex) { MessageBox.Show("Internal error :" + Environment.NewLine + ex, "Alert", MessageBoxButton.OK, MessageBoxImage.Information); } }