private void Window_Loaded(object sender, RoutedEventArgs e)
{
PracticApp.RealtorsDataSet realtorsDataSet = ((PracticApp.RealtorsDataSet)(this.FindResource("realtorsDataSet")));
// Загрузить данные в таблицу Deal. Можно изменить этот код как требуется.
PracticApp.RealtorsDataSetTableAdapters.DealTableAdapter realtorsDataSetDealTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.DealTableAdapter();
realtorsDataSetDealTableAdapter.Fill(realtorsDataSet.Deal);
System.Windows.Data.CollectionViewSource dealViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("dealViewSource")));
dealViewSource.View.MoveCurrentToFirst();
// Загрузить данные в таблицу Clients. Можно изменить этот код как требуется.
PracticApp.RealtorsDataSetTableAdapters.ClientsTableAdapter realtorsDataSetClientsTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.ClientsTableAdapter();
realtorsDataSetClientsTableAdapter.Fill(realtorsDataSet.Clients);
System.Windows.Data.CollectionViewSource clientsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("clientsViewSource")));
clientsViewSource.View.MoveCurrentToFirst();
// Загрузить данные в таблицу Offer. Можно изменить этот код как требуется.
PracticApp.RealtorsDataSetTableAdapters.OfferTableAdapter realtorsDataSetOfferTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.OfferTableAdapter();
realtorsDataSetOfferTableAdapter.Fill(realtorsDataSet.Offer);
System.Windows.Data.CollectionViewSource offerViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("offerViewSource")));
offerViewSource.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();
dealDataGrid.ItemsSource = new Deal().GetData();
}
private void DeleteClient(object sender, RoutedEventArgs e)
{
var clientID = ((PracticApp.RealtorsDataSet.ClientsRow)((System.Data.DataRowView)personDataGrid1.SelectedItem).Row).ID;
new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter().DeleteClient(clientID);
PracticApp.RealtorsDataSetTableAdapters.ClientsTableAdapter realtorsDataSetClientsTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.ClientsTableAdapter();
personDataGrid1.ItemsSource = realtorsDataSetClientsTableAdapter.InitializeClients();
MessageBox.Show("Клиент удалён");
}
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();
}
public DatabaseRouter(string type)
{
this.type = type;
switch (type)
{
case "Clients":
this.ClientsTableAdapter = new RealtorsDataSetTableAdapters.ClientsTableAdapter();
break;
case "Realty":
this.RealtyTableAdapter = new RealtorsDataSetTableAdapters.RealtyTableAdapter();
this.RealtyAddressesTableAdapter = new RealtorsDataSetTableAdapters.RealtyAddressesTableAdapter();
this.ApartmentTableAdapter = new RealtorsDataSetTableAdapters.ApartmentTableAdapter();
this.HouseTableAdapter = new RealtorsDataSetTableAdapters.HouseTableAdapter();
this.LandTableAdapter = new RealtorsDataSetTableAdapters.LandTableAdapter();
this.RealtyTypesTableAdapter = new RealtorsDataSetTableAdapters.RealtyTypesTableAdapter();
break;
case "Offer":
this.OfferTableAdapter = new RealtorsDataSetTableAdapters.OfferTableAdapter();
break;
case "Demand":
this.ApartmentFilterTableAdapter = new RealtorsDataSetTableAdapters.ApartmentFilterTableAdapter();
this.HouseFilterTableAdapter = new RealtorsDataSetTableAdapters.HouseFilterTableAdapter();
this.LandFilterTableAdapter = new RealtorsDataSetTableAdapters.LandFilterTableAdapter();
this.DemandTableAdapter = new RealtorsDataSetTableAdapters.DemandTableAdapter();
break;
case "Deal":
this.RealtyTableAdapter = new RealtorsDataSetTableAdapters.RealtyTableAdapter();
this.RealtyAddressesTableAdapter = new RealtorsDataSetTableAdapters.RealtyAddressesTableAdapter();
this.ApartmentTableAdapter = new RealtorsDataSetTableAdapters.ApartmentTableAdapter();
this.HouseTableAdapter = new RealtorsDataSetTableAdapters.HouseTableAdapter();
this.LandTableAdapter = new RealtorsDataSetTableAdapters.LandTableAdapter();
this.RealtyTypesTableAdapter = new RealtorsDataSetTableAdapters.RealtyTypesTableAdapter();
this.DealTableAdapter = new RealtorsDataSetTableAdapters.DealTableAdapter();
this.DemandTableAdapter = new RealtorsDataSetTableAdapters.DemandTableAdapter();
this.OfferTableAdapter = new RealtorsDataSetTableAdapters.OfferTableAdapter();
break;
}
}
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.ClientsTableAdapter().InitializeTextBox(clientID);
phoneTextBox.Text = currentClient.First().Phone;
emailTextBox.Text = currentClient.First().Email;
var currentClientCopy = new PracticApp.RealtorsDataSetTableAdapters.PersonTableAdapter().InitializeClient((clientID)).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 Window_Loaded(object sender, RoutedEventArgs e)
{
PracticApp.RealtorsDataSet realtorsDataSet = ((PracticApp.RealtorsDataSet)(this.FindResource("realtorsDataSet")));
// Загрузить данные в таблицу Clients. Можно изменить этот код как требуется.
PracticApp.RealtorsDataSetTableAdapters.ClientsTableAdapter realtorsDataSetClientsTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.ClientsTableAdapter();
realtorsDataSetClientsTableAdapter.Fill(realtorsDataSet.Clients);
System.Windows.Data.CollectionViewSource clientsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("clientsViewSource")));
clientsViewSource.View.MoveCurrentToFirst();
// Загрузить данные в таблицу Offer. Можно изменить этот код как требуется.
PracticApp.RealtorsDataSetTableAdapters.OfferTableAdapter realtorsDataSetOfferTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.OfferTableAdapter();
realtorsDataSetOfferTableAdapter.Fill(realtorsDataSet.Offer);
System.Windows.Data.CollectionViewSource offerViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("offerViewSource")));
offerViewSource.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();
// Загрузить данные в таблицу Realty. Можно изменить этот код как требуется.
PracticApp.RealtorsDataSetTableAdapters.RealtyTableAdapter realtorsDataSetRealtyTableAdapter = new PracticApp.RealtorsDataSetTableAdapters.RealtyTableAdapter();
realtorsDataSetRealtyTableAdapter.Fill(realtorsDataSet.Realty);
System.Windows.Data.CollectionViewSource realtyViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("realtyViewSource")));
realtyViewSource.View.MoveCurrentToFirst();
}
