private void button2_Click(object sender, EventArgs e)
{
this.Hide();
Civil otvori = new Civil(oib);
otvori.Show();
}
void popuni_obrada()
{
var con = Baza.konekcija();
con.Open();
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM Propusnica where napravio=" + oib + " and odobreno =0 ", con);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
Civil obrada = new Civil(oib);
obrada.oib = (string)reader["oib"];
obrada.ime = (string)reader["ime"];
obrada.prezime = (string)reader["prezime"];
obrada.mjestood = (string)reader["mjesto_od"];
obrada.mjestodo = (string)reader["mjesto_do"];
obrada.datumod = (string)reader["datumod"];
obrada.razlog = (string)reader["razlog"];
obrada.datumdo = (string)reader["datumdo"];
popis_odobreno.Add(obrada);
foreach (var s in popis_odobreno)
{
string[] red = { s.oib, s.ime, s.prezime, s.mjestood, s.mjestodo, s.datumod, s.datumdo, s.razlog };
var prenosioc = new ListViewItem(red);
listView2.Items.Add(prenosioc);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
var con = Baza.konekcija();
con.Open();
string zadatak = "INSERT INTO Propusnica (oib,ime,prezime,mjesto_od,mjesto_do,razlog,odobreno,datumod,datumdo,napravio) VALUES('" + this.textBox1.Text + "' ,'" + this.textBox2.Text + "' , ' " + this.textBox3.Text + "' , '" + this.textBox4.Text + "','" + this.textBox5.Text + "','" + this.textBox6.Text + "', 0,'" + this.dateTimePicker1.Text + "','" + this.dateTimePicker2.Text + "'," + oib + ");";
SqlCommand cmd = new SqlCommand(zadatak, con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Zahtjev poslan na obradu");
this.Hide();
Civil otvori = new Civil(oib);
otvori.Show();
}
private void button1_Click_1(object sender, EventArgs e)
{
oib = textBox1.Text;
var con = Baza.konekcija();
con.Open();
SqlDataAdapter c = new SqlDataAdapter("select count(*) from Osoba where OIB=" + this.textBox1.Text + "and prava='c'", con);
DataTable dt_c = new DataTable();
c.Fill(dt_c);
if (dt_c.Rows[0][0].ToString() == "1")
{
Civil otvori = new Civil(oib);
this.Hide();
otvori.Show();
}
else
{
SqlDataAdapter prijava_v = new SqlDataAdapter("select count(*) from Osoba where oib=" + textBox1.Text + " and prava = 'v'", con);
DataTable dt_v = new DataTable();
prijava_v.Fill(dt_v);
if (dt_v.Rows[0][0].ToString() == "1")
{
Vlasnik_poduzeca otvori = new Vlasnik_poduzeca(oib);
this.Hide();
otvori.Show();
}
}
SqlDataAdapter prijava_s = new SqlDataAdapter("select count(*) from Osoba where oib=" + textBox1.Text + " and prava= 's'", con);
DataTable dt_s = new DataTable();
prijava_s.Fill(dt_s);
if (dt_s.Rows[0][0].ToString() == "1")
{
Obradi otvori = new Obradi();
this.Hide();
otvori.Show();
}
}