コード例 #1
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            int counter = 0;

            db = new db_MiletecDataContext();
            if (txtUsername.Text != "Username" && txtNewPassword.Text != "" && txtConfirm.Text != "" &&
                cmbSecretQuestion.Text != null && txtSecretAnswer.Text != "Secret_Answer")
            {
                if (counter == 0)
                {
                    var result = (from row in db.tblUsers where row.Username == txtUsername.Text.ToString() select row).ToList();
                    if (result.Count() != 0)
                    {
                        MessageBox.Show("Username already existed!!", "NOTE", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    }
                    else if (txtConfirm.Text != txtNewPassword.Text)
                    {
                        MessageBox.Show("Password do not match!!", "NOTE", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    else
                    {
                        db.sp_Update_User(Form1.UserID.ToString(), txtUsername.Text, txtNewPassword.Text, cmbSecretQuestion.Text,
                                          txtSecretAnswer.Text);
                        db.SubmitChanges();
                        MessageBox.Show("Succesfuly Updated!");
                        this.Close();
                        if (Form1.Status.ToString() == "Administrator")
                        {
                            wndw_Main_Admin admin = new wndw_Main_Admin();
                            admin.Show();
                        }
                        else
                        {
                            wndw_Main_Staff staff = new wndw_Main_Staff();
                            staff.Show();
                        }
                    }
                }
            }
            else
            {
                MessageBox.Show("Please fill up everything!!", "NOTE", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }