} //niepotrzebne protected void Button1_Click(object sender, EventArgs e) { if (LoginValidate(TextBox3.Text) && PassValidate(TextBox4.Text, TextBox5.Text) && EmailValidate(TextBox6.Text) && NameAndSurnameValidate(TextBox1.Text, TextBox2.Text)) { PasswordSaltAndHash SaltAndHash = new PasswordSaltAndHash(TextBox4.Text); Phone Phone = PhoneGen(TextBox7.Text, TextBox8.Text, TextBox9.Text, TextBox18.Text, TextBox12.Text); Address Address = AddressGen(TextBox13.Text, TextBox14.Text, TextBox15.Text, TextBox16.Text, TextBox17.Text); // wrzuta do bazy String query = GenerateQuery(Phone, Address, SaltAndHash, TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox6.Text); try { Label1.Text = ProcessQuery(query, "Konto założone pomyślnie!"); } catch (System.Data.SqlClient.SqlException ex) { Label1.Text = "Baza wygenerowała errora: " + ex.Message; } } else { Label1.Text = "Błąd walidacji danych"; } }
private String GenerateQuery(Phone Phone, Address Address, PasswordSaltAndHash SaltAndHash, String TextBox1, String TextBox2, String TextBox3, String TextBox6) { String PasswordSalt = SaltAndHash.getPasswordSalt(); String PasswordHash = SaltAndHash.getPasswordHash(); if (Phone == null && Address == null) { return("INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "');"); } else if ((Phone == null) && (Address != null)) { if (Address.FlatNumber == null) { return("INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, Street, StreetNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.PostCode + "', '" + Address.City + "');"); } else { return("INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, Street, StreetNumber, FlatNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.FlatNumber + ", '" + Address.PostCode + "', '" + Address.City + "');"); } } else if ((Phone != null) && (Address == null)) { if (Phone.AreaCode == null) { return("INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "');"); } else { return("INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode, PhoneAreaCode) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "', '" + Phone.AreaCode + "');"); } } else { if ((Phone.AreaCode == null) && (Address.FlatNumber == null)) { return("INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode, Street, StreetNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.PostCode + "', '" + Address.City + "');"); } else if (Address.FlatNumber == null) { return("INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode, PhoneAreaCode, Street, StreetNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "', '" + Phone.AreaCode + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.PostCode + "', '" + Address.City + "');"); } else if (Phone.AreaCode == null) { return("INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode, Street, StreetNumber, FlatNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.FlatNumber + ", '" + Address.PostCode + "', '" + Address.City + "');"); } else { return("INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode, PhoneAreaCode, Street, StreetNumber, FlatNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "', '" + Phone.AreaCode + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.FlatNumber + ", '" + Address.PostCode + "', '" + Address.City + "');"); } } }
private String GenerateQuery(Phone Phone, Address Address, PasswordSaltAndHash SaltAndHash, String TextBox1, String TextBox2, String TextBox3, String TextBox6) { String PasswordSalt = SaltAndHash.getPasswordSalt(); String PasswordHash = SaltAndHash.getPasswordHash(); if (Phone == null && Address == null) { return "INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "');"; } else if( ( Phone == null ) && ( Address != null ) ) { if (Address.FlatNumber == null) { return "INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, Street, StreetNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.PostCode + "', '" + Address.City + "');"; } else { return "INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, Street, StreetNumber, FlatNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.FlatNumber + ", '" + Address.PostCode + "', '" + Address.City + "');"; } } else if( ( Phone != null ) && (Address == null ) ) { if (Phone.AreaCode == null) { return "INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "');"; } else { return "INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode, PhoneAreaCode) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "', '" + Phone.AreaCode + "');"; } } else { if ( ( Phone.AreaCode == null ) && ( Address.FlatNumber == null ) ) { return "INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode, Street, StreetNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.PostCode + "', '" + Address.City + "');"; } else if ( Address.FlatNumber == null ) { return "INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode, PhoneAreaCode, Street, StreetNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "', '" + Phone.AreaCode + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.PostCode + "', '" + Address.City + "');"; } else if ( Phone.AreaCode == null ) { return "INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode, Street, StreetNumber, FlatNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.FlatNumber + ", '" + Address.PostCode + "', '" + Address.City + "');"; } else { return "INSERT INTO Users (CzyAdmin, Imie, Nazwisko, Login, \"E-mail\", PasswordSalt, PasswordHash, PhoneNumber, PhoneCountryCode, PhoneAreaCode, Street, StreetNumber, FlatNumber, PostCode, City) VALUES (3, '" + TextBox1 + "', '" + TextBox2 + "', '" + TextBox3 + "', '" + TextBox6 + "', '" + PasswordSalt + "', '" + PasswordHash + "', '" + Phone.Number + "', '" + Phone.CountryCode + "', '" + Phone.AreaCode + "', '" + Address.Street + "', " + Address.StreetNumber + ", " + Address.FlatNumber + ", '" + Address.PostCode + "', '" + Address.City + "');"; } } }
protected void Button1_Click(object sender, EventArgs e) { UserItemToRecover ValidationItem = LoginAndMailValidation(TextBox1.Text, TextBox2.Text); if( ValidationItem != null ) { String newPassword = StringGen.GenString(); PasswordSaltAndHash sah = new PasswordSaltAndHash(newPassword); String query = SendPasswordToDatabase(sah.getPasswordSalt(), sah.getPasswordHash(), ValidationItem); try { SQLConnector.ProcessQuery(query); Panel1.Visible = false; Panel2.Visible = true; Label1.Text = "<p class=\"center\">Hasło zostało zmienione pomyślnie. Nowe hasło brzmi: " + newPassword + "</p>"; } catch (System.Data.SqlClient.SqlException ex) { Panel1.Visible = false; Panel2.Visible = true; Label1.Text = "<p class=\"center\">Baza wygenerowała następującego errora: " + ex.Message + "</p>"; } } }
protected void RadioButton1_CheckedChanged(object sender, EventArgs e) { } //niepotrzebne protected void Button1_Click(object sender, EventArgs e) { if( LoginValidate(TextBox3.Text) && PassValidate(TextBox4.Text, TextBox5.Text) && EmailValidate(TextBox6.Text) && NameAndSurnameValidate(TextBox1.Text, TextBox2.Text) ) { PasswordSaltAndHash SaltAndHash = new PasswordSaltAndHash(TextBox4.Text); Phone Phone = PhoneGen(TextBox7.Text, TextBox8.Text, TextBox9.Text, TextBox18.Text, TextBox12.Text); Address Address = AddressGen(TextBox13.Text, TextBox14.Text, TextBox15.Text, TextBox16.Text, TextBox17.Text); // wrzuta do bazy String query = GenerateQuery(Phone, Address, SaltAndHash, TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox6.Text); try { Label1.Text = ProcessQuery(query, "Konto założone pomyślnie!"); } catch (System.Data.SqlClient.SqlException ex) { Label1.Text = "Baza wygenerowała errora: " + ex.Message; } } else { Label1.Text = "Błąd walidacji danych"; } }
protected void Button1_Click(object sender, EventArgs e) { UserItemToRecover ValidationItem = LoginAndMailValidation(TextBox1.Text, TextBox2.Text); if (ValidationItem != null) { String newPassword = StringGen.GenString(); PasswordSaltAndHash sah = new PasswordSaltAndHash(newPassword); String query = SendPasswordToDatabase(sah.getPasswordSalt(), sah.getPasswordHash(), ValidationItem); try { SQLConnector.ProcessQuery(query); Panel1.Visible = false; Panel2.Visible = true; Label1.Text = "<p class=\"center\">Hasło zostało zmienione pomyślnie. Nowe hasło brzmi: " + newPassword + "</p>"; } catch (System.Data.SqlClient.SqlException ex) { Panel1.Visible = false; Panel2.Visible = true; Label1.Text = "<p class=\"center\">Baza wygenerowała następującego errora: " + ex.Message + "</p>"; } } }