private void Btn_addTime_Click(object sender, EventArgs e)
{
string iDate = DateTimePickerShift.Value.ToString("yyyy-MM-dd");
int Shift = Convert.ToInt32(Txt_minutes.Text);
string[] words = CmbBx_worker.SelectedItem.ToString().Split(' ');
string worker_name = words[0];
string worke_surname = words[1];
string worker_id = api.getWorkerId(api.getAllWorkers(), worker_name, worke_surname);
string construction_site_name = CmbBx_construction.SelectedItem.ToString();
string construction_id = api.getConstructionsId(api.getAllConstructions(), construction_site_name);
api.addTime(admin_id, worker_id, construction_id, Shift, iDate);
}
private void Cmb_constructions_SelectedIndexChanged(object sender, EventArgs e)
{
dt.Columns.Clear();
dt.Rows.Clear();
DataRow dr = dt.NewRow();
string words = Cmb_constructions.SelectedItem.ToString();
string construction_id = api.getConstructionsId(api.getAllConstructions(), words);
List <Time> listek = api.returnListTime(api.getAllTime(), construction_id);
for (int x = 0; x < listek.Count; x++)
{
if (dt.Rows.Count <= 0)
{
if (listek[x].construction_id == construction_id && Convert.ToDateTime(listek[x].Timestamp_date) >= Convert.ToDateTime(Date_begin_interval.Value) && Convert.ToDateTime(listek[x].Timestamp_date) <= Convert.ToDateTime(Date_end_interval.Value))
{
DataColumn dc1 = new DataColumn("Ime gradbišča", typeof(string));
DataColumn dc2 = new DataColumn("Ime delavca", typeof(string));
DataColumn dc3 = new DataColumn("Priimek delavca", typeof(string));
DataColumn dc4 = new DataColumn("Datum", typeof(string));
DataColumn dc5 = new DataColumn("Število opravljenih minut", typeof(string));
dt.Columns.Add(dc1);
dt.Columns.Add(dc2);
dt.Columns.Add(dc3);
dt.Columns.Add(dc4);
dt.Columns.Add(dc5);
dt.Rows.Add(words, api.getWorkerName(api.getAllWorkers(), listek[x].worker_id), api.getWorkerSurname(api.getAllWorkers(), listek[x].worker_id), listek[x].Timestamp_date, listek[x].Shift);
dataGridView1.DataSource = dt;
}
}
else
{
if (listek[x].construction_id == construction_id && Convert.ToDateTime(listek[x].Timestamp_date) > Convert.ToDateTime(Date_begin_interval.Value) && Convert.ToDateTime(listek[x].Timestamp_date) < Convert.ToDateTime(Date_end_interval.Value))
{
dt.Rows.Add(words, api.getWorkerName(api.getAllWorkers(), listek[x].worker_id), api.getWorkerSurname(api.getAllWorkers(), listek[x].worker_id), listek[x].Timestamp_date, listek[x].Shift);
dataGridView1.DataSource = dt;
}
}
}
}
