Exemplos de TicketsProblema PanelMenu.Show em C# (CSharp)

Exemplo n.º 1

Arquivo: MainWindow.xaml.cs Projeto: ernestoseve/FacturacionUhuuh

 private void button_Click(object sender, RoutedEventArgs e)
 {
     SqlCommand cmd = new SqlCommand("SELECT USER_GSI FROM gsi_user WHERE USER_GSI=@user and PASS_GSI=@pass and POSICION_GSI=@admin", con);
     cmd.Parameters.AddWithValue("user", textBox.Text);
     //string pas = passwordBox.SecurePassword();
     cmd.Parameters.AddWithValue("pass", passwordBox.Password);
     cmd.Parameters.AddWithValue("admin", comboBox.Text);
     con.Open();
     SqlDataReader leer = cmd.ExecuteReader();
     if (leer.Read() == true)
     {
         if(comboBox.Text == "Administrator") {
             PanelMenu login = new PanelMenu();
             login.Show();
             Close();
         }
         else
         {
             Window1 lote = new Window1();
             lote.Show();
             Close();
         }
     }
     else
     {
         MessageBox.Show("Usuario y Contraseña no son validos", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
     }
     con.Close();
 }

Exemplo n.º 2

        private void button_Click(object sender, RoutedEventArgs e)
        {
            SqlCommand cmd = new SqlCommand("SELECT USER_GSI FROM gsi_user WHERE USER_GSI=@user and PASS_GSI=@pass and POSICION_GSI=@admin", con);

            cmd.Parameters.AddWithValue("user", textBox.Text);
            //string pas = passwordBox.SecurePassword();
            cmd.Parameters.AddWithValue("pass", passwordBox.Password);
            cmd.Parameters.AddWithValue("admin", comboBox.Text);
            con.Open();
            SqlDataReader leer = cmd.ExecuteReader();

            if (leer.Read() == true)
            {
                if (comboBox.Text == "Administrator")
                {
                    PanelMenu login = new PanelMenu();
                    login.Show();
                    Close();
                }
                else
                {
                    Window1 lote = new Window1();
                    lote.Show();
                    Close();
                }
            }
            else
            {
                MessageBox.Show("Usuario y Contraseña no son validos", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
            }
            con.Close();
        }

Exemplo n.º 3

Arquivo: RegistroUsuario.xaml.cs Projeto: ernestoseve/FacturacionUhuuh

        private void button_Click(object sender, RoutedEventArgs e)
        {
            SqlCommand cmd = new SqlCommand("INSERT INTO gsi_user(USER_GSI, PASS_GSI, POSICION_GSI, NAME_GSI, APP_GSI) VALUES (@user, @pass, @Posi, @Nom, @Ape)", con);
            cmd.CommandType = System.Data.CommandType.Text;
            cmd.Parameters.AddWithValue("@user", textBox.Text);
            cmd.Parameters.AddWithValue("@pass", passwordBox.Password);
            cmd.Parameters.AddWithValue("@Posi", comboBox.Text);
            cmd.Parameters.AddWithValue("@Nom", textBox3.Text);
            cmd.Parameters.AddWithValue("@Ape", textBox4.Text);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();

            PanelMenu menu = new PanelMenu();
            menu.Show();
            Close();
        }

Exemplo n.º 4

Arquivo: RegistroUsuario.xaml.cs Projeto: ernestoseve/FacturacionUhuuh

        private void button_Click(object sender, RoutedEventArgs e)
        {
            SqlCommand cmd = new SqlCommand("INSERT INTO gsi_user(USER_GSI, PASS_GSI, POSICION_GSI, NAME_GSI, APP_GSI) VALUES (@user, @pass, @Posi, @Nom, @Ape)", con);

            cmd.CommandType = System.Data.CommandType.Text;
            cmd.Parameters.AddWithValue("@user", textBox.Text);
            cmd.Parameters.AddWithValue("@pass", passwordBox.Password);
            cmd.Parameters.AddWithValue("@Posi", comboBox.Text);
            cmd.Parameters.AddWithValue("@Nom", textBox3.Text);
            cmd.Parameters.AddWithValue("@Ape", textBox4.Text);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();

            PanelMenu menu = new PanelMenu();

            menu.Show();
            Close();
        }