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); }