public FormTimetableEdit(int timetable_id)
{
InitializeComponent();
VehiclesConnector vc = new VehiclesConnector();
DriversConnector dc = new DriversConnector();
TimetablesConnector tc = new TimetablesConnector();
allVehicles = vc.get();
allDrivers = dc.get();
availibleVehicles = new List <Vehicle>();
availibleDrivers = new List <Driver>();
timetables = tc.get();
timetable = timetables.Where(t => t.id == timetable_id).FirstOrDefault();
tbName.Text = timetable.name;
tbRoute.Text = timetable.route.start + " - " + timetable.route.finish;
dtDeparture.Text = timetable.departure.ToString("HH:mm");
drArrival.Text = timetable.arrival.ToString("HH:mm");
availibleVehicles.Add(timetable.vehicle);
availibleDrivers.Add(timetable.driver);
cbVehicle.DataSource = availibleVehicles;
cbVehicle.DisplayMember = "detail";
cbVehicle.ValueMember = "id";
cbDriver.DataSource = availibleDrivers;
cbDriver.DisplayMember = "fullName";
cbDriver.ValueMember = "id";
calculateAvailableResources();
cbVehicle.SelectedItem = timetable.vehicle;
cbDriver.SelectedItem = timetable.driver;
init = false;
}
public void LoadEmployees()
{
this.button2.Visible = false;
this.button3.Visible = false;
this.selectedIndex = 0;
this.Text = "Zamestnanci - Dopravný podnik";
this.Cursor = Cursors.WaitCursor;
this.listView1.Clear();
listView1.Columns.Add("Funkcia");
listView1.Columns.Add("Meno");
listView1.Columns.Add("Priezvisko");
listView1.Columns.Add("Telefon");
listView1.Columns.Add("Email");
this.listView1.AccessibleName = "employees";
listView1.Columns[0].Width = listView1.Width / 5 - 20;
listView1.Columns[1].Width = listView1.Width / 5;
listView1.Columns[2].Width = listView1.Width / 5;
listView1.Columns[3].Width = listView1.Width / 5;
listView1.Columns[4].Width = listView1.Width / 5;
try
{
DriversConnector driConn = new DriversConnector();
DispatchersConnector disConn = new DispatchersConnector();
ManagersConnector manConn = new ManagersConnector();
// var employees = EmployeeTable.Select();
var drivers = driConn.get();
var dispatchers = disConn.get();
foreach (var u in drivers)
{
ListViewItem item = new ListViewItem();
item.Text = "Vodič";
item.SubItems.Add(u.name.ToString());
item.SubItems.Add(u.surname.ToString());
item.SubItems.Add(u.phone);
item.SubItems.Add(u.email.ToString());
this.listView1.Items.Add(item);
}
foreach (var u in dispatchers)
{
ListViewItem item = new ListViewItem();
item.Text = "Dispečer";
item.SubItems.Add(u.name.ToString());
item.SubItems.Add(u.surname.ToString());
item.SubItems.Add(u.phone);
item.SubItems.Add(u.email.ToString());
this.listView1.Items.Add(item);
}
var datum = DateTime.Now.ToLongTimeString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Vyskytla sa chyba", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Cursor = Cursors.Default;
}
protected void Page_Load(object sender, EventArgs e)
{
CheckAccess();
DriversConnector dc = new DriversConnector();
var list = dc.get();
foreach (var item in list)
{
TableRow tr = new TableRow();
TableCell tc1 = new TableCell();
TableCell tc2 = new TableCell();
TableCell tc3 = new TableCell();
TableCell tc4 = new TableCell();
TableCell tc5 = new TableCell();
TableCell tc6 = new TableCell();
tc1.Text = "Vodič";
tc2.Text = item.name;
tc3.Text = item.surname;
tc4.Text = item.email;
tc5.Text = item.phone;
tc6.Text = item.salary.ToString();
tr.Cells.Add(tc1);
tr.Cells.Add(tc2);
tr.Cells.Add(tc3);
tr.Cells.Add(tc4);
tr.Cells.Add(tc5);
tr.Cells.Add(tc6);
tableEmployees.Rows.Add(tr);
}
DispatchersConnector disc = new DispatchersConnector();
var listDis = disc.get();
foreach (var item in listDis)
{
TableRow tr = new TableRow();
TableCell tc1 = new TableCell();
TableCell tc2 = new TableCell();
TableCell tc3 = new TableCell();
TableCell tc4 = new TableCell();
TableCell tc5 = new TableCell();
TableCell tc6 = new TableCell();
tc1.Text = "Dispečer";
tc2.Text = item.name;
tc3.Text = item.surname;
tc4.Text = item.email;
tc5.Text = item.phone;
tc6.Text = item.salary.ToString();
tr.Cells.Add(tc1);
tr.Cells.Add(tc2);
tr.Cells.Add(tc3);
tr.Cells.Add(tc4);
tr.Cells.Add(tc5);
tr.Cells.Add(tc6);
tableEmployees.Rows.Add(tr);
}
}
