private void button1_Click(object sender, EventArgs e)
{
Korisnici_ k = new Korisnici_();
k.backup();
Artikal a = new Artikal();
a.backup();
a.backup_knjizeno();
a.backup_mob_hover();
a.backup_mob_hover_knjizeno();
Racun r = new Racun();
r.backup();
r.backup_knjizeno();
r.backup_hover_mob();
Servis_ s = new Servis_();
s.backup();
Rezervacija_ rez = new Rezervacija_();
rez.backup();
Narudzbine_ n = new Narudzbine_();
n.backup();
Dug d = new Dug();
d.backup();
MessageBox.Show("Baza podataka je sacuvana!");
}
private void Lista_narudzbina_Load(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
Narudzbine_ n = new Narudzbine_();
List <Narudzbine_> ls = n.get_narudzbine();
foreach (Narudzbine_ i in ls)
{
dataGridView1.Rows.Add(i.id_narudzbine, i.ime_prezime, i.broj_telefona, i.opis_narudzbine);
}
}
private void button1_Click(object sender, EventArgs e)
{
Narudzbine_ n = new Narudzbine_();
n.ime_prezime = textBox1.Text;
n.broj_telefona = textBox2.Text;
n.opis_narudzbine = textBox3.Text;
if (n.unesi_narudzbinu())
{
MessageBox.Show("Narudzbina je uneta!");
this.Close();
}
else
{
MessageBox.Show("Narudzbina nije uneta!");
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == 4)
{
int i = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
Narudzbine_ n = new Narudzbine_();
if (MessageBox.Show("Zelite li da otkazete narudzbinu sa brojem: " + i + " ?", "Poruka", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (n.del_narudzbina(i))
{
MessageBox.Show("Artikal je izbrisan!");
}
else
{
MessageBox.Show("Artikal nije izbrisan!");
}
}
}
else if (e.ColumnIndex == 5)
{
int i = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
string ime_prezime = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
string br_mob = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
string narudzbina = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
Naplati_narudzbinu nn = new Naplati_narudzbinu(ime_prezime, br_mob, narudzbina);
nn.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Lista_narudzbina_Load(sender, e);
}
public List <Narudzbine_> get_narudzbine()
{
List <Narudzbine_> ls = new List <Narudzbine_>();
using (SqlConnection conn = new SqlConnection(connString))
{
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM Narudzbine", conn);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Narudzbine_ n = new Narudzbine_();
n.id_narudzbine = int.Parse(reader["id_narudzbine"].ToString());
n.ime_prezime = reader["ime_prezime"].ToString();
n.broj_telefona = reader["broj_telefona"].ToString();
n.opis_narudzbine = reader["opis_narudzbine"].ToString();
ls.Add(n);
}
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
conn.Close();
}
}
return(ls);
}
