Exemple #1
0
        /**
         * Checks Login creditials to determine if you can login
         */
        private void loginButton_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(passwordEntryTextBox.Text) && !string.IsNullOrEmpty(emailEntryTextBox.Text))
            {
                tooltip();
            }
            else
            {
                Engine.Login.logincomplete(emailEntryTextBox.Text, passwordEntryTextBox.Text);
                if (Engine.Login.success == true)
                {
                    MessageBox.Show("Login Successful");
                    this.Hide();
                    if (Engine.ActiveUser.usertype == "occupant" || Engine.ActiveUser.usertype == "office worker")
                    {
                        WorkOrderForm invoice = new WorkOrderForm();

                        invoice.Show();
                    }
                    else if (Engine.ActiveUser.usertype == "administrator")
                    {
                        AdminForm admin = new AdminForm();

                        admin.Show();
                    }
                    else if (Engine.ActiveUser.usertype == "contractor")
                    {
                        ContractorWorkOrderForm contractor = new ContractorWorkOrderForm();

                        contractor.Show();
                    }
                }
                else
                {
                    MessageBox.Show(Engine.Login.message);
                }
            }
        }
Exemple #2
0
        /**
         * Checks Login creditials to determine if you can login
         */
        private void loginButton_Click(object sender, EventArgs e)
        {
            string confirmed; // will be used to store the result when we check whether the user's account has been confirmed by the admin or not
            string usertype;  // will be used to hold the user's account type

            /**
             * If the email field is empty then a tooltip informs you that you need to enter an email address.
             */
            if (string.IsNullOrEmpty(emailEntryTextBox.Text))
            {
                ToolTip tip = new ToolTip();
                tip.Show("Please Enter An Email Address", emailEntryTextBox, 10000);
            }

            /**
             * If the password field is empty then a tooltip informs you that you need to enter a password.
             */
            if (string.IsNullOrEmpty(passwordEntryTextBox.Text))
            {
                ToolTip tip2 = new ToolTip();
                tip2.Show("Please Enter A Passwords", passwordEntryTextBox, 10000);
            }

            /**
             * If both fields are filled then a connection to the invoicelogin will be established.
             */
            else if (!string.IsNullOrEmpty(passwordEntryTextBox.Text) && !string.IsNullOrEmpty(emailEntryTextBox.Text))
            {
                OleDbConnection connection = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = ProjectDB.accdb; Persist Security Info = True");
                connection.Open();

                /**
                 * MySQLCommand that will be used to query the database using the entered email and password
                 */
                OleDbCommand command = new OleDbCommand("Select Email, Password, UserType, Confirmed from UserAccounts where Email='" + emailEntryTextBox.Text.ToLower() + "'and Password='******'", connection);

                /**
                 *  Fill the DataTable with results from the query.
                 *  If the table has at least one row then that means the login information entered was that of a registered user and login was successful.
                 *  In the future logging successfully will result in you being taken to another form. For now you are only informed of your successful login.
                 *  If the table has no rows, then either your email-password combination could not be found in our records and the login was unsuccessful.
                 * */
                OleDbDataAdapter data  = new OleDbDataAdapter(command);
                DataTable        table = new DataTable();
                data.Fill(table);
                if (table.Rows.Count > 0)
                {
                    usertype  = table.Rows[0]["usertype"].ToString();  // Store the usertype item from your dataTable into the usertype variable
                    confirmed = table.Rows[0]["confirmed"].ToString(); // store the confirmed item from your dataTable

                    /**
                     * Checks to see if the administrator has confirmed the account and if not then inform the user that it has yet to be confirmed/activated
                     */
                    if (confirmed == "False")
                    {
                        MessageBox.Show("Your account has not been confirmed by the adminstrator yet");
                    }

                    /**
                     * If the adminstrator has confirmed the user's account then next the usertype is checked to determine which form the user should see.
                     * For now the occupant, contractor and office worker all see the same form but eventually all three will have different level's of access.
                     */
                    else if (confirmed == "True")
                    {
                        if (usertype == "Occupant" || usertype == "Office Worker")
                        {
                            MessageBox.Show("Login Successful!");
                            WorkOrderForm invoice = new WorkOrderForm();
                            invoice.Show();
                        }
                        else if (usertype == "Administrator")
                        {
                            MessageBox.Show("Login Successful!");
                            AdminForm invoice = new AdminForm();
                            invoice.Show();
                        }
                        else if (usertype == "Contractor")
                        {
                            MessageBox.Show("Login Successful!");
                            ContractorWorkOrderForm workOrder = new ContractorWorkOrderForm();
                            workOrder.Show();
                        }
                    }
                }
                else
                {
                    MessageBox.Show("Invalid username or password");
                }
            }
        }