Esempio n. 1
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            //Gets result of validation false = incorrect inputs, true = program may procceed
            var result = ValidationExistingUser(tb_Username.Text, tb_Password.Text);

            if (result)
            {
                //Checks if there is a matching username and password in tbl_Login
                using (connection = new SqlConnection(GlobalVariablesClass.connectionString))
                    using (SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM tbl_Login WHERE username = '******' AND password = '******'", connection))
                    {
                        DataTable loginTable = new DataTable();
                        adapter.Fill(loginTable);
                        //No match found, error message shown
                        if (loginTable.Rows.Count == 0)
                        {
                            MessageBox.Show("Login Incorrect, Please try again.");
                        }
                        //Match found and program proceeds to post login screen using this login
                        else if (loginTable.Rows.Count >= 1)
                        {
                            GlobalVariablesClass.customerID = loginTable.Rows[0][3].ToString();
                            PostLoginScreen frm = new PostLoginScreen();
                            this.Hide();
                            frm.ShowDialog();
                            this.Close();
                        }
                    }
            }
            else
            {
                MessageBox.Show(masterMessage);
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            PostLoginScreen frm = new PostLoginScreen();

            this.Hide();
            frm.ShowDialog();
            this.Close();
        }
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            //Gets result of validation false = incorrect inputs, true = program may procceed
            var result1 = ValidationLoginDetails(tb_Username.Text, tb_Password.Text);
            var result2 = ValidationCustomerDetails(tb_FName.Text, tb_LName.Text, tb_Dob.Text, tb_HomeAddress.Text);

            if (result1 && result2)
            {
                using (connection = new SqlConnection(GlobalVariablesClass.connectionString))
                {
                    //Inserts the customer details into tbl_Customer and returns the customerID for use in forming the tbl_Login part of the record
                    using (SqlDataAdapter adapter = new SqlDataAdapter("INSERT INTO tbl_Customer ([First Name],[Last Name],[Gender],[Date Of Birth],[House Address]) VALUES (@FName,@LName,@Gender,@Dob,@HAddress); SELECT SCOPE_IDENTITY()", connection))
                    {
                        adapter.SelectCommand.Parameters.AddWithValue("@FName", tb_FName.Text.ToLower());
                        adapter.SelectCommand.Parameters.AddWithValue("@LName", tb_LName.Text.ToLower());
                        adapter.SelectCommand.Parameters.AddWithValue("@Gender", drpbx_Gender.SelectedItem);
                        adapter.SelectCommand.Parameters.AddWithValue("@Dob", tb_Dob.Text);
                        adapter.SelectCommand.Parameters.AddWithValue("@HAddress", tb_HomeAddress.Text.ToLower());
                        DataTable customerID = new DataTable();
                        adapter.Fill(customerID);
                        GlobalVariablesClass.customerID = customerID.Rows[0][0].ToString();
                    }

                    //Inserts the login details into tbl_Login where the code above provides the customerID foreign key link.
                    using (SqlCommand command = new SqlCommand("INSERT INTO tbl_Login ([username],[password],[customerID]) VALUES (@username,@password,@customerID)", connection))
                    {
                        command.Parameters.AddWithValue("@username", tb_Username.Text.ToLower());
                        command.Parameters.AddWithValue("@password", tb_Password.Text.ToLower());
                        command.Parameters.AddWithValue("@customerID", Convert.ToInt32(GlobalVariablesClass.customerID));
                        connection.Open();
                        command.ExecuteNonQuery();
                        connection.Close();
                    }

                    //Loads the post login screen upon successful database addition
                    PostLoginScreen frm = new PostLoginScreen();
                    this.Hide();
                    frm.ShowDialog();
                    this.Close();
                }
            }
            else
            {
                MessageBox.Show(masterMessage);
            }
        }