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 FormVehicleEdit(int id)
{
VehiclesConnector vc = new VehiclesConnector();
InitializeComponent();
//this.vehicleID = id;
this.vehicle = vc.get(id);
textBox7.Text = vehicle.name;
textBox2.Text = vehicle.year.ToString();
textBox3.Text = vehicle.capacity.ToString();
textBox4.Text = vehicle.consumption.ToString();
}
public void LoadVehicles()
{
this.button2.Enabled = false;
this.button3.Enabled = false;
this.button2.Visible = true;
this.button3.Visible = false;
this.selectedIndex = 1;
this.Text = "Vozidlá - Dopravný podnik";
this.Cursor = Cursors.WaitCursor;
this.listView1.Clear();
listView1.Columns.Add("Id");
listView1.Columns.Add("Názov");
listView1.Columns.Add("Rok výroby");
listView1.Columns.Add("Kapacita");
listView1.Columns[0].Width = listView1.Width / 4 - 20;
listView1.Columns[1].Width = listView1.Width / 4;
listView1.Columns[2].Width = listView1.Width / 4;
listView1.Columns[3].Width = listView1.Width / 4;
try
{
VehiclesConnector vc = new VehiclesConnector();
var vehicles = vc.get();
foreach (var v in vehicles)
{
ListViewItem item = new ListViewItem();
item.Text = v.id.ToString();
item.SubItems.Add(v.name.ToString());
item.SubItems.Add(v.year.ToString());
item.SubItems.Add(v.capacity.ToString());
this.listView1.Items.Add(item);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Vyskytla sa chyba", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Cursor = Cursors.Default;
}
private void button1_Click(object sender, EventArgs e)
{
VehiclesConnector vc = new VehiclesConnector();
Vehicle v = new Vehicle();
v.name = this.textBoxNazov.Text;
v.year = int.Parse(this.textBoxRok.Text);
v.consumption = decimal.Parse(this.textBoxSpotreba.Text);
v.capacity = int.Parse(this.textBoxKapacita.Text);
var str = vc.send(v);
if (str == "\"OK\"")
{
var dialogResult = MessageBox.Show("Záznam vložený!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (dialogResult == DialogResult.OK)
{
this.Close();
}
}
}
