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 DeleteClient(object sender, RoutedEventArgs e)
{
new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter().DeleteClient(clientID);
PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter realtorsDataSetPersonTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter();
personDataGrid1.ItemsSource = realtorsDataSetPersonTableAdapter.InitializeRealtor();
MessageBox.Show("Риэлтор удалён");
}
private void AddNewClient(object sender, RoutedEventArgs e)
{
Window addNewClient = new AddNewRealtor();
addNewClient.ShowDialog();
PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter realtorsDataSetPersonTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter();
personDataGrid1.ItemsSource = realtorsDataSetPersonTableAdapter.InitializeRealtor();
}
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();
}
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 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;
string clientEmail = String.IsNullOrEmpty(Email.Text) ? "" : Email.Text;
string clientPhone = String.IsNullOrEmpty(Phone.Text) ? "" : Phone.Text;
if (clientEmail == "" && clientPhone == "")
{
errorLabel.Content = "Одно из полей Email или Телефон должны быть заполнены";
return;
}
PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter realtorsDataSetPersonTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter();
realtorsDataSetPersonTableAdapter.AddNewClient(clientName, clientSurname, clientPatronymic);
var newPersonData = realtorsDataSetPersonTableAdapter.GetLastID();
PracticApp.RealtorsDataSetTableAdapters.ClientsTableAdapter realtorsDataSetClientsTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.ClientsTableAdapter();
realtorsDataSetClientsTableAdapter.AddNewClient(newPersonData.Last().ID, clientPhone, clientEmail);
Close();
}
private void SaveDataGridChanges(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 = Convert.ToInt32(String.IsNullOrEmpty(phoneTextBox.Text) ? "" : phoneTextBox.Text);
if (clientDeal <= 100 || clientDeal >= 0)
{
new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter().SaveChangesRealtor(clientName, clientSurname, clientPatronymic, clientID);
new PracticApp.RealtorsDataSetTableAdapters.RealtorsTableAdapter().SaveChangesRealtors(Convert.ToInt32(clientDeal), clientID);
}
else
{
return;
}
PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter realtorsDataSetPersonTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter();
personDataGrid1.ItemsSource = realtorsDataSetPersonTableAdapter.InitializeRealtor();
MessageBox.Show("Данные сохранены");
}
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
try
{
var currentClient = new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter().InitializeRealtor();
int i = 0;
while (i < currentClient.Rows.Count && currentClient.Rows.Count > 0)
{
string dbName = String.IsNullOrEmpty(currentClient.Rows[i].ItemArray[1] as string) ? "" : currentClient.Rows[i].ItemArray[1] as string;
string dbSurname = String.IsNullOrEmpty(currentClient.Rows[i].ItemArray[2] as string) ? "" : currentClient.Rows[i].ItemArray[2] as string;
string dbPatronymic = String.IsNullOrEmpty(currentClient.Rows[i].ItemArray[3] as string) ? "" : currentClient.Rows[i].ItemArray[3] as string;
if (((LevenshteinDistance(dbName, searchTextBox.Text) >= 3) && (LevenshteinDistance(dbSurname, searchTextBox.Text) >= 3) && (LevenshteinDistance(dbPatronymic, searchTextBox.Text) >= 3)))
{
currentClient.Rows.Remove(currentClient.Rows[i]);
i = 0;
}
else
{
i++;
}
}
if (searchTextBox.Text == "")
{
personDataGrid1.ItemsSource = new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter().InitializeRealtor();
}
else
{
personDataGrid1.ItemsSource = currentClient;
}
}
catch
{
}
}
