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(); }