private void odjavaBtn_Click(object sender, EventArgs e) { Prijava prijava = new Prijava(); prijava.Show(); this.Hide(); }
private void regRegistracijaBtn_Click(object sender, EventArgs e) { int idKraja = kraji[regKrajiCombobox.SelectedIndex].ID; using (NpgsqlConnection con = new NpgsqlConnection(connect)) { con.Open(); NpgsqlCommand com = new NpgsqlCommand("SELECT registracijaavtosole('" + regImeTextbox.Text + "','" + regEmailTextbox.Text + "','" + regTelTextbox.Text + "', '" + idKraja + "')", con); NpgsqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { if (reader.GetString(0) == "USPESNO") { MessageBox.Show("Registracija uspela!"); Prijava prijava = new Prijava(); prijava.Show(); this.Hide(); } else { MessageBox.Show("Avtosola s tem emailom že obstaja!"); } } con.Close(); } }
private void dodajIzpitBtn_Click(object sender, EventArgs e) { int idK = kraji[regKrajiCombobox.SelectedIndex].ID; using (NpgsqlConnection con = new NpgsqlConnection(connect)) { con.Open(); NpgsqlCommand com = new NpgsqlCommand("SELECT dodajDveTabeli ('" + regEmailTextbox.Text + "', '" + regImeTextbox.Text + "', '" + idK + "', '" + regTelTextbox.Text + "', '" + tipIzpitaTxt.Text + "', '" + Convert.ToInt32(minStarostIzpitTxt.Text) + "' )", con); NpgsqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { if (reader.GetString(0) == "USPESNO") { MessageBox.Show("Registracija avtosole + dodan izpit Uspelo!"); Prijava prijava = new Prijava(); prijava.Show(); this.Hide(); } else if (reader.GetString(0) == "NEUSPESNO") { MessageBox.Show("Registracija avtosole + dodajanje izpita Neuspelo!"); tipIzpitaTxt.Clear(); minStarostIzpitTxt.Clear(); } } con.Close(); } }
private void deleteUserBtn_Click(object sender, EventArgs e) { int idU = neki.ID; using (NpgsqlConnection conS = new NpgsqlConnection(connect)) { conS.Open(); NpgsqlCommand comS = new NpgsqlCommand("SELECT izbrisiUporabnika('" + idU + "')", conS); NpgsqlDataReader readerS = comS.ExecuteReader(); while (readerS.Read()) { if (readerS.GetString(0) == "USPESNO") { MessageBox.Show("Uporabnik je bil izbrisan"); Prijava prijava = new Prijava(); prijava.Show(); this.Hide(); } } conS.Close(); } }