private void Generisi_Click(object sender, EventArgs e) { baza.OtvoriKonekciju(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = baza.Conn; cmd.CommandText = "SELECT * FROM Racun"; OleDbDataReader reader = cmd.ExecuteReader(); lista_racuna.Clear(); while (reader.Read()) { lista_racuna.Add(new Racun(int.Parse(reader["id_racun"].ToString()), double.Parse(reader["cena"].ToString()), DateTime.Parse(reader["datum"].ToString()), reader["vreme"].ToString())); } foreach (var item in lista_racuna) { if (DateTime.Compare(item.Datum, dateTimePicker1.Value.Date) >= 0 && DateTime.Compare(item.Datum, dateTimePicker2.Value.Date) <= 0) { //MessageBox.Show("asdfas"); listBox1.Items.Add("Racun" + item.Id + "Vreme" + item.Vreme); } } baza.ZatvoriKonekciju(); }
private void Form1_Load(object sender, EventArgs e) { baza.OtvoriKonekciju(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = baza.Conn; cmd.CommandText = "SELECT * FROM Artikal"; OleDbDataReader reader = cmd.ExecuteReader(); lista_artikla.Clear(); while (reader.Read()) { lista_artikla.Add(new Artikal(int.Parse(reader["id_artikla"].ToString()), int.Parse(reader["Popust"].ToString()), reader["Naziv"].ToString(), double.Parse(reader["cena"].ToString()))); } comboBox1.DataSource = lista_artikla; comboBox1.DisplayMember = "Naziv"; comboBox1.ValueMember = "Id"; baza.ZatvoriKonekciju(); }
private void button1_Click(object sender, EventArgs e) { int id_artikla22 = 0, id_grupa2 = 0; try { baza.OtvoriKonekciju(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = baza.Conn; /*string query1 = @"INSERT INTO Artikal(Naziv,cena,popust) * VALUES(@naziv,@cena,@popust)"; * string query2= "Select * from Artikal"; * string query3 = @"INSERT INTO Grupa(id_grupa,id_artikla) * VALUES(@id_grupa,@id_artikla)"; * cmd.CommandText = string.Join(";", query1, query2, query3);*/ cmd.CommandText = @"INSERT INTO Artikal(Naziv,cena,popust) VALUES(@naziv,@cena,@popust)"; cmd.Parameters.AddWithValue("Naziv", textBox1.Text); cmd.Parameters.AddWithValue("Cena", double.Parse(textBox2.Text)); cmd.Parameters.AddWithValue("Popust", int.Parse(textBox3.Text)); int c = cmd.ExecuteNonQuery(); if (comboBox1.Text.Equals("Voce i Povrce")) { id_grupa2 = 1; } if (comboBox1.Text.Equals("Meso i Sirevi")) { id_grupa2 = 2; } if (comboBox1.Text.Equals("Slatkisi")) { id_grupa2 = 3; } if (comboBox1.Text.Equals("Hemikalije")) { id_grupa2 = 4; } cmd.CommandText = @"Select * from Artikal"; c = cmd.ExecuteNonQuery(); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string naziv = reader["Naziv"].ToString(); if (textBox1.Text == naziv) { id_artikla22 = int.Parse(reader["id_artikla"].ToString()); } } reader.Close(); cmd.Dispose(); cmd.Connection = baza.Conn; cmd.CommandText = @"INSERT INTO Grupa(id_grupa,id_artikla2) VALUES(@id_grupa,@id_artikla2)"; //MessageBox.Show("" + cmd.CommandText); Grupa g = new Grupa(id_grupa2, id_artikla22); cmd.Parameters.AddWithValue("id_grupa", id_grupa2.ToString()); cmd.Parameters.AddWithValue("id_artikla2", id_artikla22.ToString()); c = cmd.ExecuteNonQuery(); if (c > 0) { MessageBox.Show("Uspesno!"); } else { MessageBox.Show("Neuspesno!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { baza.ZatvoriKonekciju(); } }