예제 #1
0
        private void loginbutton_Click(object sender, EventArgs e) //next
        {
            if (firstname_click_check && lastname_click_check && phon_click_check && date)
            {
                string connectionString = "datasource=127.0.0.1;port=3306;username=root;password=;database=scorpio;";
                string query            = "UPDATE `user` SET `First_name`='" + usernameinput.Text + "',`last_name`='" + lastname.Text + "',`Phone_no`='" + phoneinput.Text + "' , `Birth_date`='" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "' WHERE User_name ='" + user_log_in.UserID + "'";

                MySqlConnection databaseConnection = new MySqlConnection(connectionString);
                MySqlCommand    commandDatabase    = new MySqlCommand(query, databaseConnection);
                commandDatabase.CommandTimeout = 60;
                MySqlDataReader reader;

                try
                {
                    databaseConnection.Open();
                    reader = commandDatabase.ExecuteReader();

                    databaseConnection.Close();
                    //MessageBox.Show(user_log_in.UserID);

                    this.Hide();
                    var home = new homepage();
                    home.Closed += (s, args) => this.Close();
                    home.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
예제 #2
0
        private void skip_Click(object sender, EventArgs e)
        {
            this.Hide();
            var home = new homepage();

            home.Closed += (s, args) => this.Close();
            home.Show();
            return;
        }
예제 #3
0
        private void button1_Click(object sender, EventArgs e)  //log in
        {
            usernameinput.ForeColor     = Color.FromArgb(233, 233, 233);
            passwordinput.ForeColor     = Color.FromArgb(233, 233, 233);
            panel1.BackColor            = Color.FromArgb(233, 233, 233);
            panel2.BackColor            = Color.FromArgb(233, 233, 233);
            pictureBox3.BackgroundImage = Properties.Resources.lock1;
            pictureBox2.BackgroundImage = Properties.Resources.user1;

            bool proced = true;

            if (string.IsNullOrEmpty(usernameinput.Text.ToString()) == true)
            {
                user_click_check   = false;
                usernameinput.Text = "User Name";
            }


            if (string.IsNullOrEmpty(passwordinput.Text.ToString()) == true)
            {
                pass_click_check           = false;
                passwordinput.PasswordChar = '\0';
                passwordinput.Text         = "Password";
            }

            if (user_click_check == false)
            {
                usernameinput.ForeColor = Color.FromArgb(100, 100, 100);
                panel1.BackColor        = Color.FromArgb(190, 40, 40);
                proced = false;
            }


            if (pass_click_check == false)
            {
                passwordinput.ForeColor = Color.FromArgb(100, 100, 100);
                panel2.BackColor        = Color.FromArgb(190, 40, 40);
                proced = false;
            }

            if (proced == true)
            {
                string connectionString = "datasource=127.0.0.1;port=3306;username=root;password=;database=scorpio;";

                // Select all
                string          query = "SELECT * FROM user";
                MySqlConnection databaseConnection = new MySqlConnection(connectionString);
                MySqlCommand    commandDatabase    = new MySqlCommand(query, databaseConnection);
                commandDatabase.CommandTimeout = 60;
                MySqlDataReader reader;

                try
                {
                    databaseConnection.Open();
                    reader = commandDatabase.ExecuteReader();
                    // Success, now list

                    // If there are available rows
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            string userName = (string)reader["User_name"];
                            string pass     = (string)reader["Password"];

                            if (string.Compare(userName, usernameinput.Text.ToString()) == 0 && string.Compare(pass, passwordinput.Text.ToString()) == 0)
                            {
                                // MessageBox.Show("you are loged in");

                                user_log_in.UserID = userName;

                                databaseConnection.Close();

                                this.Hide();
                                var home = new homepage();
                                home.Closed += (s, args) => this.Close();
                                home.Show();
                                return;
                                //MessageBox.Show("you are loged in");
                            }



                            incorrectpanel.Visible = true;
                        }
                    }
                    else
                    {
                        Console.WriteLine("No rows found.");
                    }

                    databaseConnection.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }