public StationWindow(Customer customer, List <BusStation> stations) { InitializeComponent(); _customer = customer; if (_customer.Mode == Mode.User) { btnAdd.Visibility = Visibility.Hidden; btnDelete.Visibility = Visibility.Hidden; } var routeRepository = new SqlRouteRepository(_connectionString); List <string> routes = routeRepository.GetAllNumbers(); routes.Insert(0, ""); cmbRoute.ItemsSource = routes; cmbRoute.SelectedItem = ""; var busRepository = new SqlBusRepository(_connectionString); List <string> buses = busRepository.GetAllNumbers(); buses.Insert(0, ""); cmbBus.ItemsSource = buses; cmbBus.SelectedItem = ""; dgrDataStations.ItemsSource = stations; }
private void btnBuses_Click(object sender, RoutedEventArgs e) { var busRepository = new SqlBusRepository(_connectionString); var busWindow = new BusWindow(_customer, busRepository.SelectAll()); wndMainWindow.IsEnabled = false; busWindow.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 busSqlRepository = new SqlBusRepository(_connectionString); dgrDataBuses.ItemsSource = busSqlRepository.SearchAll(routeNumber, stationName); }
private void btnAdd_Click(object sender, RoutedEventArgs e) { var addBusWindow = new AddBusWindow(_customer); wndBus.IsEnabled = false; addBusWindow.ShowDialog(); var busRepository = new SqlBusRepository(_connectionString); dgrDataBuses.ItemsSource = busRepository.SelectAll(); wndBus.IsEnabled = true; }
private void btnAdd_Click(object sender, RoutedEventArgs e) { if (String.IsNullOrEmpty(txtNumber.Text)) { MessageBox.Show("No bus number", "Empty field", MessageBoxButton.OK, MessageBoxImage.Error); return; } string busNumber = txtNumber.Text; if (String.IsNullOrEmpty(txtRouteNumner.Text)) { MessageBox.Show("No route number", "Empty field", MessageBoxButton.OK, MessageBoxImage.Error); return; } string routeNumber = txtRouteNumner.Text; if (String.IsNullOrEmpty(txtModel.Text)) { MessageBox.Show("No bus model", "Empty field", MessageBoxButton.OK, MessageBoxImage.Error); return; } string busModel = txtModel.Text; var busRepository = new SqlBusRepository(_connectionString); var bus = new Bus() { Number = busNumber, RouteNumber = routeNumber, Model = busModel }; try { int id = busRepository.Insert(_customer.Id, bus); txtNumber.Text = ""; txtRouteNumner.Text = ""; txtModel.Text = ""; MessageBox.Show(String.Format("Bus {0} added with id = {1}.", busNumber, id), "Success", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception exception) { MessageBox.Show(exception.Message, "Number error", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void btnBuses_Click(object sender, RoutedEventArgs e) { var busRepository = new SqlBusRepository(_connectionString); if (dgrDataRoutes.SelectedItem == null) { MessageBox.Show("Not selected route.", "Selection", MessageBoxButton.OK, MessageBoxImage.Error); return; } int routeId = ((Route)dgrDataRoutes.SelectedItem).Id; var busWindow = new BusWindow(_customer, busRepository.GetBusesByRoute(routeId)); wndRoute.Close(); busWindow.ShowDialog(); }
private void btnDelete_Click(object sender, RoutedEventArgs e) { var busRepository = new SqlBusRepository(_connectionString); if (dgrDataBuses.SelectedItem == null) { MessageBox.Show("Not selected bus.", "Selection", MessageBoxButton.OK, MessageBoxImage.Error); return; } int busId = ((Bus)dgrDataBuses.SelectedItem).Id; MessageBoxResult answer = MessageBox.Show(String.Format("You really want to delete bus {0} and all related objects?", ((Bus)dgrDataBuses.SelectedItem).Number), "Deleting", MessageBoxButton.YesNo, MessageBoxImage.Question); if (answer == MessageBoxResult.Yes) { busRepository.Delete(busId); dgrDataBuses.ItemsSource = busRepository.SelectAll(); } }