private void button1_Click_1(object sender, EventArgs e)
        {
            frmAddStationsToRoute frm = new frmAddStationsToRoute(emp);

            this.Hide();
            frm.Show();
        }
        private void btnSubmitRoute_Click(object sender, EventArgs e)
        {
            int      id = 0;
            Database db = new Database();

            if (!txtPrice.Text.Equals("") || !txtRouteName.Text.Equals(""))
            {
                Route route = new Route();
                id = int.Parse(txtRouteID.Text);
                route.setRouteId(id);
                route.setName(txtRouteName.Text);
                route.setPrice(int.Parse(txtPrice.Text));
                if (db.addRoute(route))
                {
                    MessageBox.Show("Route added continuing to add stations");
                    this.Hide();
                    frmAddStationsToRoute frm = new frmAddStationsToRoute(route, emp);
                    frm.Show();
                }
                else
                {
                    MessageBox.Show("Error unable to add route!");
                }
            }
        }
        private void btnConfirmChanges_Click(object sender, EventArgs e)
        {
            route.setRouteId(int.Parse(txtRouteID.Text));
            route.setName(txtRouteName.Text);
            route.setPrice(int.Parse(txtPrice.Text));
            Database db = new Database();

            if (db.updateRoute(route))
            {
                MessageBox.Show("Route successfully updated! Moving on to stations");
                frmAddStationsToRoute frm = new frmAddStationsToRoute(route, emp);
                this.Hide();
                frm.Show();
            }
            else
            {
                MessageBox.Show("Unable to update Route!");
            }
        }