private void button1_Click(object sender, EventArgs e)
{
try
{
baza.OtvoriKonekciju();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = baza.Conn;
cmd.CommandText = "SELECT * FROM Racun";
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Racun r = new Racun();
r.Id_racun = int.Parse(reader["id_racun"].ToString());
r.Cena = int.Parse(reader["cena"].ToString());
r.Datum = DateTime.Parse(DateTime.Parse(reader["datum"].ToString()).ToShortDateString());
r.Vreme = DateTime.Parse(DateTime.Parse(reader["vreme"].ToString()).ToShortTimeString());
racuni.Add(r);
}
//AKO JE IZABRANO FILTRIRANJE PO DATUMU
if (radioButton1.Checked)
{
for (int i = 0; i < racuni.Count; i++)
{
if ((dateTimePicker1.Value.Date.Add(dateTimePicker3.Value.TimeOfDay) < racuni[i].Datum.Date.Add(racuni[i].Vreme.TimeOfDay) && (dateTimePicker2.Value.Date.Add(dateTimePicker4.Value.TimeOfDay) > racuni[i].Datum.Date.Add(racuni[i].Vreme.TimeOfDay))))
{
racuniRange.Add(racuni[i]);
}
}
}
//AKO JE IZABRANO FILTRIRANJE PO SMENAMA
if (radioButton2.Checked)
{
if (comboBox1.Text == "prva smena")
{
for (int i = 0; i < racuni.Count; i++)
{
if ((dateTimePicker5.Value.Date.Add(new TimeSpan(6, 00, 00)) < racuni[i].Vreme) && (dateTimePicker6.Value.Date.Add(new TimeSpan(15, 00, 00)) > racuni[i].Vreme))
{
racuniRange.Add(racuni[i]);
}
}
}
if (comboBox1.Text == "druga smena")
{
for (int i = 0; i < racuni.Count; i++)
{
if ((dateTimePicker5.Value.Date.Add(new TimeSpan(15, 00, 00)) < racuni[i].Vreme) && (dateTimePicker6.Value.Date.Add(new TimeSpan(23, 00, 00)) > racuni[i].Vreme))
{
racuniRange.Add(racuni[i]);
}
}
}
}
dataGridView1.DataSource = racuniRange;
dataGridView1.Columns["vreme"].DefaultCellStyle.Format = "HH:mm";
dataGridView1.Refresh();
this.RacuniPregled_Load(this, e);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally { baza.ZatvoriKonekciju(); }
}
