private void button2_Click(object sender, EventArgs e)
        {
            AuditorChoose auditorChoose = new AuditorChoose();

            this.Hide();
            auditorChoose.ShowDialog(this);
        }
Example #2
0
        private void button2_Click(object sender, EventArgs e)
        {
            AuditorChoose auditorChoose = new AuditorChoose();

            this.Hide();
            auditorChoose.ShowDialog(this);//Interface conversion function
        }
Example #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (check() && DBConnect())
            {
                if (VoterradioButton.Text == "Voter" && VoterradioButton.Checked)
                {
                    strsql  = string.Format("select count (*) from Voter where Name = '{0}' and Password = '******'", UserNametextBox.Text, PasswordBox.Text);
                    command = new SqlCommand(strsql, mycon);
                    try
                    {
                        int result = Convert.ToInt32(command.ExecuteScalar());
                        if (result > 0)
                        {
                            MessageBox.Show("successful login");



                            LoginInfo.CurrentUser.UserName = UserNametextBox.Text;
                            HomePage HomePage = new HomePage();
                            this.Hide();
                            HomePage.ShowDialog(this);
                        }
                        else
                        {
                            MessageBox.Show("Login failed");
                        }
                    }
                    catch
                    {
                        MessageBox.Show("Sql error");
                    }
                }

                else if (AuditorradioButton.Text == "Auditor" && AuditorradioButton.Checked)
                {
                    strsql  = string.Format("select count (*) from Auditor where Name = '{0}' and Password = '******'", UserNametextBox.Text, PasswordBox.Text);
                    command = new SqlCommand(strsql, mycon);
                    try
                    {
                        int result = Convert.ToInt32(command.ExecuteScalar());
                        if (result > 0)
                        {
                            MessageBox.Show("successful login");

                            LoginInfo.CurrentUser.UserName = UserNametextBox.Text;
                            AuditorChoose auditorMenu = new AuditorChoose();
                            this.Hide();
                            auditorMenu.ShowDialog(this);
                        }
                        else
                        {
                            MessageBox.Show("Login failed");
                        }
                    }
                    catch
                    {
                        MessageBox.Show("Sql error");
                    }
                }

                else if (AdminradioButton.Text == "Admin" && AdminradioButton.Checked)
                {
                    strsql  = string.Format("select count (*) from Admin where Name = '{0}' and Password = '******'", UserNametextBox.Text, PasswordBox.Text);
                    command = new SqlCommand(strsql, mycon);
                    try
                    {
                        int result = Convert.ToInt32(command.ExecuteScalar());
                        if (result > 0)
                        {
                            MessageBox.Show("successful login");

                            LoginInfo.CurrentUser.UserName = UserNametextBox.Text;
                            AdminMenu adminmenu = new AdminMenu();
                            this.Hide();
                            adminmenu.ShowDialog(this);
                        }
                        else
                        {
                            MessageBox.Show("Login failed");
                        }
                    }
                    catch
                    {
                        MessageBox.Show("Sql error");
                    }
                }
            }
        }
Example #4
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (check() && DBConnect())                                           //check the database connection
            {
                if (VoterradioButton.Text == "Voter" && VoterradioButton.Checked) //check the text is correct
                {
                    strsql  = string.Format("select count (*) from Voter where Name = '{0}' and Password = '******'", UserNametextBox.Text, PasswordBox.Text);
                    command = new SqlCommand(strsql, mycon);//Specify the SQL statement to execute
                    try
                    {
                        int result = Convert.ToInt32(command.ExecuteScalar());
                        if (result > 0)
                        {
                            MessageBox.Show("successful login");
                            //if username and password are correct, show successful login in the messagebox


                            LoginInfo.CurrentUser.UserName = UserNametextBox.Text;//check the text correct
                            HomePage HomePage = new HomePage();
                            this.Hide();
                            HomePage.ShowDialog(this);
                            //Interface conversion function
                        }
                        else
                        {
                            MessageBox.Show("Login failed");//show results
                        }
                    }
                    catch
                    {
                        MessageBox.Show("Sql error");//show results
                    }
                }

                else if (AuditorradioButton.Text == "Auditor" && AuditorradioButton.Checked)//check the text are correct
                {
                    strsql  = string.Format("select count (*) from Auditor where Name = '{0}' and Password = '******'", UserNametextBox.Text, PasswordBox.Text);
                    command = new SqlCommand(strsql, mycon);    //Specify the SQL statement to execute
                    try
                    {
                        int result = Convert.ToInt32(command.ExecuteScalar());
                        if (result > 0)
                        {
                            MessageBox.Show("successful login");

                            LoginInfo.CurrentUser.UserName = UserNametextBox.Text;
                            AuditorChoose auditorMenu = new AuditorChoose();
                            this.Hide();
                            auditorMenu.ShowDialog(this);
                        }
                        else
                        {
                            MessageBox.Show("Login failed");
                        }
                    }
                    catch
                    {
                        MessageBox.Show("Sql error");
                    }
                }

                else if (AdminradioButton.Text == "Admin" && AdminradioButton.Checked)
                {
                    strsql  = string.Format("select count (*) from Admin where Name = '{0}' and Password = '******'", UserNametextBox.Text, PasswordBox.Text);
                    command = new SqlCommand(strsql, mycon);    //Specify the SQL statement to execute
                    try
                    {
                        int result = Convert.ToInt32(command.ExecuteScalar());
                        if (result > 0)
                        {
                            MessageBox.Show("successful login");

                            LoginInfo.CurrentUser.UserName = UserNametextBox.Text;
                            AdminMenu adminmenu = new AdminMenu();
                            this.Hide();
                            adminmenu.ShowDialog(this);
                        }
                        else
                        {
                            MessageBox.Show("Login failed");
                        }
                    }
                    catch
                    {
                        MessageBox.Show("Sql error");
                    }
                }
            }
        }