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); } }