예제 #1
0
        private void BtnDelete_Click(object sender, EventArgs e)
        {
            if (txtID.Text.Equals(""))
            {
                MessageBox.Show("Please select a user!");
            }
            else
            {
                var result = MessageBox.Show("Are you sure?", "Confirmation Message", MessageBoxButtons.YesNo);

                if (result == DialogResult.Yes)
                {
                    IndexForm fm1    = (IndexForm)MdiParent;
                    var       currID = fm1.getID();

                    var userID = txtID.Text;

                    var checkAdmin = (from Admin x in DB.conn
                                      select x).ToList();

                    if (checkAdmin.Count == 1)
                    {
                        MessageBox.Show("User delete failed! You are the only admin left!");
                    }
                    else
                    {
                        var deleteAdmin = (from Admin x in DB.conn
                                           where x.ID == userID
                                           select x).FirstOrDefault();

                        DB.conn.Delete(deleteAdmin);

                        MessageBox.Show("Admin has been removed!");

                        resetInitial();

                        if (currID.Equals(userID))
                        {
                            MessageBox.Show("Your account has been removed!");
                            fm1.logOut();
                        }
                    }
                }
            }
        }
        private void BtnChangePw_Click(object sender, EventArgs e)
        {
            var oldPw  = txtOld.Text;
            var newPw  = txtNew.Text;
            var confPw = txtConfirm.Text;

            IndexForm fm1    = (IndexForm)MdiParent;
            var       tempID = fm1.getID();

            if (oldPw.Equals(""))
            {
                MessageBox.Show("Old password can't be empty!");
            }
            else if (newPw.Equals(""))
            {
                MessageBox.Show("New password can't be empty!");
            }
            else if (newPw.Equals(oldPw))
            {
                MessageBox.Show("New password can't be the same as old password!");
            }
            else if (newPw.Length < 6 || newPw.Length > 15)
            {
                MessageBox.Show("Password must be between 6 and 15 characters!");
            }
            else if (!confPw.Equals(newPw))
            {
                MessageBox.Show("Confirm password doesn't match!");
            }
            else
            {
                if (tempID.Contains("CU"))
                {
                    var checkPassword = (from Customer x in DB.conn
                                         where x.password == oldPw
                                         select x.password).FirstOrDefault();

                    if (checkPassword == null)
                    {
                        MessageBox.Show("Incorrect old password!");
                        resetFields();
                    }
                    else
                    {
                        MessageBox.Show("Change Password Success!");

                        var userData = (from Customer x in DB.conn
                                        where x.ID == tempID
                                        select x).FirstOrDefault();

                        userData.password = newPw;

                        DB.conn.Store(userData);

                        MessageBox.Show("Please re-login to update your password!");
                        fm1.logOut();
                        this.Dispose();
                    }
                }
                else if (tempID.Contains("DR"))
                {
                    var checkPassword = (from Driver x in DB.conn
                                         where x.password == oldPw
                                         select x.password).FirstOrDefault();

                    if (checkPassword == null)
                    {
                        MessageBox.Show("Incorrect old password!");
                        resetFields();
                    }
                    else
                    {
                        MessageBox.Show("Change Password Success!");

                        var userData = (from Driver x in DB.conn
                                        where x.ID == tempID
                                        select x).FirstOrDefault();

                        userData.password = newPw;

                        DB.conn.Store(userData);

                        MessageBox.Show("Please re-login to update your password!");
                        fm1.logOut();
                        this.Dispose();
                    }
                }
                else if (tempID.Contains("AD"))
                {
                    var checkPassword = (from Admin x in DB.conn
                                         where x.password == oldPw
                                         select x.password).FirstOrDefault();

                    if (checkPassword == null)
                    {
                        MessageBox.Show("Incorrect old password!");
                        resetFields();
                    }
                    else
                    {
                        MessageBox.Show("Change Password Success!");

                        var userData = (from Admin x in DB.conn
                                        where x.ID == tempID
                                        select x).FirstOrDefault();

                        userData.password = newPw;

                        DB.conn.Store(userData);

                        MessageBox.Show("Please re-login to update your password!");
                        fm1.logOut();
                        this.Dispose();
                    }
                }
            }
        }