private void btn_UpdateInfo_Click(object sender, EventArgs e) { string newUserName = txt_NameHome.Text; string newUserEmail = txt_EmailHome.Text; string newUserPassword = txt_PasswordHome.Text; string newUserCountry = txt_CountryHome.Text; if (newUserName.Equals("")) { MessageBox.Show("Please fill user name."); } else if (newUserEmail.Equals("")) { MessageBox.Show("Please fill user Email."); } else if (newUserPassword.Equals("")) { MessageBox.Show("Please fill user Password."); } else if (newUserCountry.Equals("")) { MessageBox.Show("Please fill user County."); } else { string qurey = "Update Users SET Name='" + @newUserName + "',Email='" + @newUserEmail + "',Password='******',Country='" + @newUserCountry + "'where ID='" + SignIn.id + "'"; SqlCommand updateCommand = new SqlCommand(qurey); 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 sign = new SignIn(); sign.Show(); } else { MessageBox.Show("Error Occured..Try Again"); } } }
private void btn_SignUp_Click(object sender, EventArgs e) { string userName = txt_Name.Text; string userEmail = txt_Email.Text; string userPassword = txt_Password.Text; string userCountry = txt_Country.Text; if (userName.Equals("")) { MessageBox.Show("Write your user name."); } else if (userEmail.Equals("")) { MessageBox.Show("Write your Email."); } else if (userPassword.Equals("")) { MessageBox.Show("Write your Password."); } else if (userCountry.Equals("")) { MessageBox.Show("Write your 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,Please login now."); this.Hide(); SignIn sign = new SignIn(); sign.Show(); } else { MessageBox.Show("Error Occured..Try Again"); } } }
private void btn_Delete_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 information deleted successfully"); this.Hide(); SignIn sign = new SignIn(); sign.Show(); } else { MessageBox.Show("Error Occured..Try Again"); } } }