private void loginButton_Click(object sender, EventArgs e)
        {
            string          myConnectionString = "server=localhost;database=csharp;uid=root;pwd=password@";
            MySqlConnection conn = new MySqlConnection(myConnectionString);

            try
            {
                conn.Open();

                string email    = textBox1.Text.ToString();
                string password = textBox2.Text.ToString();

                int    error    = 0;
                string errorMsg = "";

                if (!IsValidEmail(email))
                {
                    error++;
                    errorMsg += "Invalid email address!\n";
                }

                MySqlCommand cmd   = new MySqlCommand("SELECT * FROM users WHERE email = '" + email + "'", conn);
                int          count = Convert.ToInt32(cmd.ExecuteScalar());
                if (count > 0)
                {
                    MySqlDataReader rdr = cmd.ExecuteReader();
                    while (rdr.Read())
                    {
                        if (rdr.GetString(2) == password)
                        {
                            DialogResult res = MessageBox.Show("Logged in successfully!");
                            if (res == DialogResult.OK)
                            {
                                uid = rdr.GetInt16(0);
                                this.Hide();
                                homescreen hs = new homescreen();
                                hs.ShowDialog();
                                this.Show();
                            }
                        }
                        else
                        {
                            MessageBox.Show("Incorrect credentials!");
                        }
                    }
                }
                else
                {
                    MessageBox.Show("Account does not exist!");
                    this.Hide();
                    RegisterForm registerForm = new RegisterForm();
                    registerForm.ShowDialog();
                    this.Show();
                }
            }
            catch (Exception ex)
            {
                Debug.Write("DB cannot be connected!");
            }
        }
        private void AddItemButton_Click(object sender, EventArgs e)
        {
            string          myConnectionString = "server=localhost;database=csharp;uid=root;pwd=password@";
            MySqlConnection conn = new MySqlConnection(myConnectionString);

            try
            {
                conn.Open();

                int    uid  = LoginForm.uid;
                string item = textBox1.Text.ToString();

                MySqlCommand cmd = new MySqlCommand("INSERT INTO items(uid, item) VALUES('" + uid + "', '" + item + "')", conn);

                cmd.ExecuteNonQuery();

                DialogResult res = MessageBox.Show("Successfully Added!");

                if (res == DialogResult.OK)
                {
                    this.Hide();
                    homescreen hs = new homescreen();
                    hs.ShowDialog();
                    this.Show();
                }
            }
            catch (Exception ex)
            {
                Debug.Write("DB cannot be connected!", ex.ToString());
            }
        }
Example #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            this.Hide();
            homescreen hs = new homescreen();

            hs.ShowDialog();
            this.Show();
        }