private void button1_Click(object sender, EventArgs e) { DialogResult dialog = MessageBox.Show("Are you sure?", "Delete Account", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dialog == DialogResult.Yes) { string query = "DELETE from Users Where ID = '" + Signin.id + "' "; SqlCommand deleteCommand = new SqlCommand(query); int row = objDBAccess.executeQuery(deleteCommand); if (row == 1) { MessageBox.Show("Account Deleted Successfully."); this.Hide(); Signin login = new Signin(); login.Show(); } else { MessageBox.Show("Error Occured. Try Again."); } } }
private void btnUpdateInfo_Click(object sender, EventArgs e) { string newUserName = txtNameHome.Text; string newUserEmail = txtEmailHome.Text; string newUserPassword = txtPasswordHome.Text; string newUserCountry = txtCountryHome.Text; if (newUserName.Equals("")) { MessageBox.Show("please write your name."); } else if (newUserEmail.Equals("")) { MessageBox.Show("please write your email."); } else if (newUserPassword.Equals("")) { MessageBox.Show("please write your password."); } else if (newUserCountry.Equals("")) { MessageBox.Show("please write your country."); } else { string query = "Update Users SET " + "Name = '" + @newUserName + "', " + "Email = '" + @newUserEmail + "', " + "Password = '******', " + "Country = '" + @newUserCountry + "' " + "where ID = '" + Signin.id + "' "; // la @ serve a criptare SqlCommand updateCommand = new SqlCommand(query); updateCommand.Parameters.AddWithValue("@userName", @newUserName); updateCommand.Parameters.AddWithValue("@userEmail", @newUserEmail); updateCommand.Parameters.AddWithValue("@userPassword", @newUserPassword); updateCommand.Parameters.AddWithValue("@userCountry", @newUserCountry); int row = objDBAccess.executeQuery(updateCommand); if (row == 1) { MessageBox.Show("Account Information Updated Successfully."); this.Hide(); Signin login = new Signin(); login.Show(); } else { MessageBox.Show("Error Occured. Try Again."); } } }
private void btnSignUp_Click(object sender, EventArgs e) { string userName = txtName.Text; string userEmail = txtEmail.Text; string userPassword = txtPassword.Text; string userCountry = txtCountry.Text; if (userName.Equals("")) { MessageBox.Show("Please enter your user name."); } else if (userEmail.Equals("")) { MessageBox.Show("Please enter your user email."); } else if (userPassword.Equals("")) { MessageBox.Show("Please enter your user password."); } else if (userCountry.Equals("")) { MessageBox.Show("Please enter your user country."); } else { SqlCommand insertCommand = new SqlCommand("insert into Users(Name,Email,Password,Country) values (@userName, @userEmail, @userPassword, @userCountry)"); insertCommand.Parameters.AddWithValue("@userName", userName); insertCommand.Parameters.AddWithValue("@userEmail", userEmail); insertCommand.Parameters.AddWithValue("@userPassword", userPassword); insertCommand.Parameters.AddWithValue("@userCountry", userCountry); int row = objDBAccess.executeQuery(insertCommand); if (row == 1) { MessageBox.Show("Account Created Successfully."); this.Hide(); Signin login = new Signin(); login.Show(); } else { MessageBox.Show("Error Occured. Try Again."); } } }