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