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