private void button4_Click(object sender, RoutedEventArgs e) { OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into [user] ([username],[pass],[weight]) values (?,?,?)"; cmd.Parameters.AddWithValue("@username", textBox.Text); cmd.Parameters.AddWithValue("@pass", textBox1.Text); cmd.Parameters.AddWithValue("@weight", textBox2.Text); cmd.Connection = conn; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Pages.instrumentsPage instruments = new instrumentsPage(); this.NavigationService.Navigate(instruments); }
private void button5_Click(object sender, RoutedEventArgs e) { if (gymGuestPage.current_user_id == null) { Pages.gymGuestPage gmGst = new gymGuestPage(); this.NavigationService.Navigate(gmGst); } else if (controlPage.employee) { Pages.instrumentsPage instr = new instrumentsPage(); this.NavigationService.Navigate(instr); } else { Pages.instrumentsPage instr = new instrumentsPage(); this.NavigationService.Navigate(instr); } }
private void button4_Click(object sender, RoutedEventArgs e) { conn.Open(); String query = "Select id,username from [user] where username='******' and pass='******'"; OleDbCommand cmd = new OleDbCommand(query, conn); OleDbDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { gymGuestPage.current_user_id = rdr.GetValue(1).ToString(); Pages.instrumentsPage instruments = new instrumentsPage(); this.NavigationService.Navigate(instruments); } else { MessageBox.Show("Δεν βρέθηκε χρήστης με αυτά τα στοιχεία !"); } conn.Close(); }
private void help(object sender, RoutedEventArgs e) { Pages.instrumentsPage instruments = new instrumentsPage(); this.NavigationService.Navigate(instruments); }