コード例 #1
0
        private void backButton_Click(object sender, EventArgs e)
        {
            Passenger_Login pl = new Passenger_Login();

            pl.Show();
            this.Hide();
        }
コード例 #2
0
        private void passengerButton_Click(object sender, EventArgs e)
        {
            Passenger_Login pl = new Passenger_Login();         // open the new passenger login form

            pl.Show();
            this.Hide();
        }
コード例 #3
0
        private void backButton_Click(object sender, EventArgs e)
        {
            // Open the new passenger login form
            Passenger_Login pl = new Passenger_Login();

            pl.Show();
            this.Hide();
        }
コード例 #4
0
        private void update()
        {
            string email           = emailBox.Text;
            string password        = passwordBox.Text;
            string confirmPassword = confirmPasswordBox.Text;

            sql.Open();
            SqlDataAdapter sda = new SqlDataAdapter("SELECT COUNT(*) from passenger_signup where pEmail='" + emailBox.Text + "'", sql);
            DataTable      dt  = new DataTable();

            sda.Fill(dt);
            if (dt.Rows[0][0].ToString() == "1")
            {
                if (password == confirmPassword)
                {
                    try
                    {
                        SqlCommand cmd = new SqlCommand("update passenger_signup set pPassword=@password", sql);
                        cmd.Parameters.AddWithValue("@password", password);
                        cmd.ExecuteNonQuery();
                        MessageBox.Show("Password Updated Successfully :)");
                        Passenger_Login pl = new Passenger_Login();
                        pl.Show();
                        this.Hide();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
                else
                {
                    MessageBox.Show("Password Does Not Match !!!....");
                }
            }
            else
            {
                MessageBox.Show("Your Email is incorrect !..");
            }
            sql.Close();
        }
コード例 #5
0
        private void SignUpButton_Click(object sender, EventArgs e)
        {
            string firstName = firstNameBox.Text;
            string lastName  = lastNameBox.Text;
            string cnic      = cnicBox.Text;
            string email     = emailBox.Text;
            string contact   = contactBox.Text;
            string age       = ageBox.Text;
            string gender;

            if (maleRadioBttn.Checked == true)
            {
                gender = "Male";
            }
            else if (femaleRadioBttn.Checked == true)
            {
                gender = "Female";
            }
            else
            {
                gender = "Other";
            }
            string city     = cityBox.Text;
            string password = passwordBox.Text;

            try
            {
                sql.Open();
                int        userID = RandomNumber(1, 1000);
                SqlCommand sc     = new SqlCommand("select pId from passenger_signup where pId=@a", sql);
                sc.Parameters.AddWithValue("@a", userID);

                SqlCommand cmd = new SqlCommand("insert into passenger_signup(pId,pFirstName,pLastName,pCnic,pEmail,pContact,age,pGender,pCity,pPassword) values(@userID,@firstName,@lastName,@cnic,@email,@contact,@age,@gender,@city,@password)", sql);
                cmd.Parameters.AddWithValue("@userID", userID);
                cmd.Parameters.AddWithValue("@firstName", firstName);
                cmd.Parameters.AddWithValue("@lastName", lastName);
                cmd.Parameters.AddWithValue("@cnic", cnic);
                cmd.Parameters.AddWithValue("@email", email);
                cmd.Parameters.AddWithValue("@contact", contact);
                cmd.Parameters.AddWithValue("@age", age);
                cmd.Parameters.AddWithValue("@gender", gender);
                cmd.Parameters.AddWithValue("@city", city);
                cmd.Parameters.AddWithValue("@password", password);
                cmd.ExecuteNonQuery();
                sql.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            if (passwordBox.Text == confirmPasswordBox.Text)
            {
                MessageBox.Show("User Registered Successfully :)");
                firstNameBox.Text       = "";
                lastNameBox.Text        = "";
                cnicBox.Text            = "";
                emailBox.Text           = "";
                ageBox.Text             = "";
                contactBox.Text         = "";
                cityBox.Text            = "";
                passwordBox.Text        = "";
                confirmPasswordBox.Text = "";
                firstNameBox.Focus();


                Passenger_Login pl = new Passenger_Login();
                pl.Show();
                this.Hide();
            }
            else
            {
                MessageBox.Show("Password does not Match ");
            }
        }