private void AnulujAction(object sender, RoutedEventArgs e) { Zalogowany zalogowany = new Zalogowany(this.UserId); zalogowany.Show(); Close(); }
private void ZalogujAction(object sender, RoutedEventArgs e) { if (textBoxEmail.Text.Length == 0) { errormessage.Text = "Podaj adres e-mail."; textBoxEmail.Focus(); } else if (!Regex.IsMatch(textBoxEmail.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$")) { errormessage.Text = "Podaj prawidłowy adres e-mail."; textBoxEmail.Select(0, textBoxEmail.Text.Length); textBoxEmail.Focus(); } if (passwordBox1.Password.Length == 0) { errormessage.Text = "Podaj hasło."; textBoxEmail.Focus(); } else { string email = textBoxEmail.Text; string password = passwordBox1.Password; password = DB.HasloDoBase64(password); try { SqlConnection con = DB.GetConnection(); SqlCommand cmd = new SqlCommand("Select * from [dbo].[PZUsers] where email='" + email + "' and password='******'", con); cmd.CommandType = CommandType.Text; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataSet dataSet = new DataSet(); adapter.Fill(dataSet); // if (dataSet.Tables[0].Rows.Count > 0) { string userId = dataSet.Tables[0].Rows[0]["userid"].ToString(); Zalogowany zalogowany = new Zalogowany(userId); zalogowany.Show(); Close(); } else { errormessage.Text = "Podano nieprawidłowe dane do logowania"; } con.Close(); } catch (SqlException ex) { for (int i = 0; i < ex.Errors.Count; i++) { MessageBox.Show("Index #" + i + "\n" + "Message: " + ex.Errors[i].Message + "\n" + "LineNumber: " + ex.Errors[i].LineNumber + "\n" + "Source: " + ex.Errors[i].Source + "\n" + "Procedure: " + ex.Errors[i].Procedure + "\n"); } } } }