private void btnDrivers_Click(object sender, RoutedEventArgs e)
{
var driverRepository = new SqlDriverRepository(_connectionString);
var driverWindow = new DriverWindow(_customer, driverRepository.SelectAll());
wndMainWindow.IsEnabled = false;
driverWindow.ShowDialog();
wndMainWindow.IsEnabled = true;
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
string stationName = String.IsNullOrEmpty((string)cmbStation.SelectedItem) ? null : (string)cmbStation.SelectedItem;
string routeNumber = String.IsNullOrEmpty((string)cmbRoute.SelectedItem) ? null : (string)cmbRoute.SelectedItem;
var driverSqlRepository = new SqlDriverRepository(_connectionString);
dgrDataDrivers.ItemsSource = driverSqlRepository.SearchAll(routeNumber, stationName);
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
var addDriverWindow = new AddDriverWindow(_customer);
wndDriver.IsEnabled = false;
addDriverWindow.ShowDialog();
var driverRepository = new SqlDriverRepository(_connectionString);
dgrDataDrivers.ItemsSource = driverRepository.SelectAll();
wndDriver.IsEnabled = true;
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(txtName.Text))
{
MessageBox.Show("No driver name", "Empty field", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
string driverName = txtName.Text;
if (String.IsNullOrEmpty(txtSurname.Text))
{
MessageBox.Show("No driver surrname", "Empty field", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
string driverSurname = txtSurname.Text;
if (String.IsNullOrEmpty(txtBusNumber.Text))
{
MessageBox.Show("No bus number", "Empty field", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
string busNumber = txtBusNumber.Text;
var driverRepository = new SqlDriverRepository(_connectionString);
var driver = new Driver()
{
Name = driverName,
Surname = driverSurname,
BusNumber = busNumber
};
try
{
int id = driverRepository.Insert(_customer.Id, driver);
txtName.Text = "";
txtSurname.Text = "";
txtBusNumber.Text = "";
MessageBox.Show(String.Format("Driver {0} {1} added with id = {1}.", driverName, driverSurname, id), "Success", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "Number error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void btnDriver_Click(object sender, RoutedEventArgs e)
{
var driverRepository = new SqlDriverRepository(_connectionString);
if (dgrDataSchedule.SelectedItem == null)
{
MessageBox.Show("Not selected schedule.", "Selection", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
int scheduleId = ((TimeTable)dgrDataSchedule.SelectedItem).Id;
var driverWindow = new DriverWindow(_customer, driverRepository.GetDriversBySchedule(scheduleId));
wndSchedule.Close();
driverWindow.ShowDialog();
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
var driverRepository = new SqlDriverRepository(_connectionString);
if (dgrDataDrivers.SelectedItem == null)
{
MessageBox.Show("Not selected driver.", "Selection", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
Driver driver = (Driver)dgrDataDrivers.SelectedItem;
MessageBoxResult answer = MessageBox.Show(String.Format("You really want to delete driver {0}?",
String.Format("{0} {1}", driver.Name, driver.Surname)), "Deleting", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (answer == MessageBoxResult.Yes)
{
driverRepository.Delete(driver.Id);
dgrDataDrivers.ItemsSource = driverRepository.SelectAll();
}
}