} //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>";
}
}
}
