private void AddNewClientButton(object sender, RoutedEventArgs e) { string clientName = String.IsNullOrEmpty(ClientName.Text) ? "" : ClientName.Text; string clientSurname = String.IsNullOrEmpty(ClientSurname.Text) ? "" : ClientSurname.Text; string clientPatronymic = String.IsNullOrEmpty(ClientPatronymic.Text) ? "" : ClientPatronymic.Text; int clientDeal; try { clientDeal = Convert.ToInt32(String.IsNullOrEmpty(Deal.Text) ? "" : Deal.Text); } catch { errorLabel.Content = "Ставка должна быть от 0 до 100."; return; } if (clientName == "" || clientSurname == "" || clientPatronymic == "") { errorLabel.Content = "Поля ФИО обязательны к заполнению."; return; } else if (Convert.ToInt32(clientDeal) > 100 || Convert.ToInt32(clientDeal) < 0) { errorLabel.Content = "Ставка должна быть от 0 до 100."; return; } PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter realtorsDataSetPersonTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter(); realtorsDataSetPersonTableAdapter.AddNewClient(clientName, clientSurname, clientPatronymic); var newPersonData = realtorsDataSetPersonTableAdapter.GetLastID(); PracticApp.RealtorsDataSetTableAdapters.RealtorsTableAdapter realtorsDataSetRealtorsTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.RealtorsTableAdapter(); realtorsDataSetRealtorsTableAdapter.AddNewRealtor(newPersonData.Last().ID, Convert.ToInt32(clientDeal)); Close(); }
private void personDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { clientID = Convert.ToInt32(((System.Data.DataRowView)((object[])e.AddedItems)[0]).Row.ItemArray[0]); var currentClient = new PracticApp.RealtorsDataSetTableAdapters.RealtorsTableAdapter().InitializeTextBox(clientID); phoneTextBox.Text = Convert.ToString(currentClient.First().Deal); var currentClientCopy = new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter().InitializeRealtorByID(currentClient.First().ID).First(); string clientName = String.IsNullOrEmpty(currentClientCopy.Name) ? "" : currentClientCopy.Name; string clientSurname = String.IsNullOrEmpty(currentClientCopy.Surname) ? "" : currentClientCopy.Surname; string clientPatronymic = String.IsNullOrEmpty(currentClientCopy.Patronymic) ? "" : currentClientCopy.Patronymic; ClientName.Text = clientName; ClientSurname.Text = clientSurname; ClientPatronymic.Text = clientPatronymic; } catch { } }
private void Window_Loaded(object sender, RoutedEventArgs e) { PracticApp.RealtorsDataSet realtorsDataSet = ((PracticApp.RealtorsDataSet)(this.FindResource("realtorsDataSet"))); // Загрузить данные в таблицу Realtors. Можно изменить этот код как требуется. PracticApp.RealtorsDataSetTableAdapters.RealtorsTableAdapter realtorsDataSetRealtorsTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.RealtorsTableAdapter(); realtorsDataSetRealtorsTableAdapter.Fill(realtorsDataSet.Realtors); System.Windows.Data.CollectionViewSource realtorsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("realtorsViewSource"))); realtorsViewSource.View.MoveCurrentToFirst(); // Загрузить данные в таблицу RealtyType. Можно изменить этот код как требуется. PracticApp.RealtorsDataSetTableAdapters.RealtyTypeTableAdapter realtorsDataSetRealtyTypeTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.RealtyTypeTableAdapter(); realtorsDataSetRealtyTypeTableAdapter.Fill(realtorsDataSet.RealtyType); System.Windows.Data.CollectionViewSource realtyTypeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("realtyTypeViewSource"))); realtyTypeViewSource.View.MoveCurrentToFirst(); // Загрузить данные в таблицу Demand. Можно изменить этот код как требуется. PracticApp.RealtorsDataSetTableAdapters.DemandTableAdapter realtorsDataSetDemandTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.DemandTableAdapter(); realtorsDataSetDemandTableAdapter.Fill(realtorsDataSet.Demand); System.Windows.Data.CollectionViewSource demandViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("demandViewSource"))); demandViewSource.View.MoveCurrentToFirst(); }
private void Window_Loaded(object sender, RoutedEventArgs e) { PracticApp.RealtorsDataSet realtorsDataSet = ((PracticApp.RealtorsDataSet)(this.FindResource("realtorsDataSet"))); // Загрузить данные в таблицу Person. Можно изменить этот код как требуется. PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter realtorsDataSetPersonTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter(); realtorsDataSetPersonTableAdapter.Fill(realtorsDataSet.Person); System.Windows.Data.CollectionViewSource personViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("personViewSource"))); personViewSource.View.MoveCurrentToFirst(); // Загрузить данные в таблицу Clients. Можно изменить этот код как требуется. PracticApp.RealtorsDataSetTableAdapters.ClientsTableAdapter realtorsDataSetClientsTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.ClientsTableAdapter(); realtorsDataSetClientsTableAdapter.Fill(realtorsDataSet.Clients); System.Windows.Data.CollectionViewSource personClientsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("personClientsViewSource"))); personClientsViewSource.View.MoveCurrentToFirst(); // Загрузить данные в таблицу Realtors. Можно изменить этот код как требуется. PracticApp.RealtorsDataSetTableAdapters.RealtorsTableAdapter realtorsDataSetRealtorsTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.RealtorsTableAdapter(); realtorsDataSetRealtorsTableAdapter.Fill(realtorsDataSet.Realtors); System.Windows.Data.CollectionViewSource realtorsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("realtorsViewSource"))); realtorsViewSource.View.MoveCurrentToFirst(); }