private void resetPass_Click(object sender, RoutedEventArgs e)
        {
            ATRSDataContext DC_Obj = new ATRSDataContext();
            var             query  =
                from psng in DC_Obj.Passengers
                where psng.passenger_id == PassengerID
                select psng;


            foreach (Passenger item in query)
            {
                if (newPass.Password.ToString() == re_entNewPass.Password.ToString())
                {
                    item.password = newPass.Password.ToString();
                }
            }

            // Submit the changes to the database.
            if (newPass.Password.ToString() == re_entNewPass.Password.ToString())
            {
                try
                {
                    DC_Obj.SubmitChanges();
                    MessageBox.Show("Password Changed");
                    this.Hide();
                    MainWindow reback = new MainWindow();
                    reback.Show();
                }


                catch (Exception exp)
                {
                    MessageBox.Show(exp.ToString());
                    // Provide for exceptions.
                }
            }
            else
            {
                MessageBox.Show("Password Didnot Match");
            }
        }
        private void Submiit_Click(object sender, RoutedEventArgs e)
        {
            string sexTxt = null;

            if (maletxt.IsChecked == true)
            {
                sexTxt = maletxt.Content.ToString();
            }

            else
            {
                sexTxt = femaleTxt.Content.ToString();
            }

            Passenger P_Obj = new Passenger();

            {
                P_Obj.first_name  = fname.Text.ToString();
                P_Obj.last_name   = lname.Text.ToString();
                P_Obj.sex         = sexTxt.ToString();
                P_Obj.age         = int.Parse(agetxt.Text.ToString());
                P_Obj.cell        = contact_txt.Text.ToString();
                P_Obj.telephone   = tel_txt.Text.ToString();
                P_Obj.password    = setPasstxt.Text.ToString();
                P_Obj.passport_no = passporttxt.Text.ToString();
                P_Obj.nationality = nationalityBox.Text.ToString();
                P_Obj.email       = emailTxt.Text.ToString();
                P_Obj.address     = addTXT.Text.ToString();
            };


            insertPsngr.Passengers.InsertOnSubmit(P_Obj);
            insertPsngr.SubmitChanges();
            MessageBox.Show("Account Created!!!");
            this.Hide();
            MainWindow logIn = new MainWindow();

            logIn.Show();
        }