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