private void Sign_In(object sender, RoutedEventArgs e) { if (userName.Text.ToString() != "" || userPassword.Text.ToString() != "") { string emailToCheck = userName.Text.ToString(); string passwordToCheck = userPassword.Text.ToString(); using (SqlConnection connection = new SqlConnection("Data Source=localhost:1521:xe;Initial Catalog=vidigo;User ID=SYSTEM;Password=school10;")) using (SqlCommand signInCheck = new SqlCommand("Select USERNAME, PASSWORD FROM VIGICLIENT WHERE " + emailToCheck + "=USERNAME and " + passwordToCheck + "=PASSWORD", connection)) { connection.Open(); using (SqlDataReader reader = signInCheck.ExecuteReader()) { if (reader.HasRows) { connection.Close(); this.Hide(); searchPage searchPage = new searchPage(); searchPage.Show(); } else { signInError(); connection.Close(); } } } } }
private void Button_Click(object sender, RoutedEventArgs e) { this.Hide(); searchPage searchPage = new searchPage(); searchPage.Show(); }
private void Sign_In(object sender, RoutedEventArgs e) { if (userName.Text.ToString() != "" || userPassword.Text.ToString() !="") { string emailToCheck = userName.Text.ToString(); string passwordToCheck = userPassword.Text.ToString(); using (SqlConnection connection = new SqlConnection("Data Source=localhost:1521:xe;Initial Catalog=vidigo;User ID=SYSTEM;Password=school10;")) using (SqlCommand signInCheck = new SqlCommand("Select USERNAME, PASSWORD FROM VIGICLIENT WHERE "+emailToCheck+"=USERNAME and "+passwordToCheck+"=PASSWORD",connection)) { connection.Open(); using(SqlDataReader reader = signInCheck.ExecuteReader()) { if(reader.HasRows) { connection.Close(); this.Hide(); searchPage searchPage = new searchPage(); searchPage.Show(); } else{signInError(); connection.Close(); } } } } }