private void Button_Click(object sender, RoutedEventArgs e)
{
if (loginTxt.Equals(""))
{
return;
}
if (passTxt.Equals(""))
{
return;
}
MySqlCommand cmd = new MySqlCommand($"SELECT * FROM customer WHERE e_mail = '{loginTxt.Text}' AND password = '******'", connection.Con);
connection.Con.Open();
DataTable dataTable = new DataTable();
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(cmd);
dataAdapter.Fill(dataTable);
int howManyRecords = Convert.ToInt32(dataTable.Rows.Count.ToString());
if (howManyRecords == 1)
{
DataRow row = dataTable.Rows[0];
CurrentUser.id = (int)row["customer_id"];
CurrentUser.name = (string)row["name"];
CurrentUser.last_name = (string)row["last_name"];
CurrentUser.e_mail = (string)row["e_mail"];
CurrentUser.password = (string)row["password"];
}
else
{
Console.WriteLine("Somethings wrang!");
connection.Con.Close();
return;
}
connection.Con.Close();
Sign mainWindow = new Sign();
mainWindow.Show();
this.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (nameTxt.Text.Equals(""))
{
return;
}
if (LastNTxt.Text.Equals(""))
{
return;
}
if (emailTxt.Text.Equals(""))
{
return;
}
if (passBx.Password.Equals(""))
{
return;
}
if (pass2Bx.Password.Equals(""))
{
return;
}
if (phoneTxt.Text.Equals(""))
{
return;
}
if (countryTxt.Text.Equals(""))
{
return;
}
if (cityTxt.Text.Equals(""))
{
return;
}
if (streetTxt.Text.Equals(""))
{
return;
}
if (buildingNrTxt.Text.Equals(""))
{
return;
}
if (apartamentTxt.Text.Equals(""))
{
return;
}
if (postalTxt.Text.Equals(""))
{
return;
}
if (!samePassword(passBx.Password, pass2Bx.Password))
{
return;
}
int customerId = -1;
try
{
customerId = insertCustomer(insertAdressRecords());
}
catch (MySqlException ex)
{
if (ex.Code == 1169)
{
MessageBox.Show("Credentials already in use!", "Try again!", MessageBoxButton.OK, MessageBoxImage.Error);
}
return;
}
CurrentUser.id = customerId;
CurrentUser.name = nameTxt.Text;
CurrentUser.last_name = LastNTxt.Text;
CurrentUser.e_mail = emailTxt.Text;
CurrentUser.password = passBx.Password;
Sign mainWindow = new Sign();
mainWindow.Show();
this.Close();
}