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