private void GetData() { FleetModels.Clear(); try { vmsLinqDataContext datacontext = new vmsLinqDataContext(); var query = from f in datacontext.Fleets select f; FleetModel model; foreach (var data in query) { model = new FleetModel(); model.ID = data.ID; model.Name = data.Name; FleetModels.Add(model); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void GetAllVehicle() { _vehilces.Clear(); try { vmsLinqDataContext datacontext = new vmsLinqDataContext(); var query = from v in datacontext.Vehicles select v; VehicleModel model; foreach (var data in query) { model = new VehicleModel(); model.NumPlate = data.NumPlate; model.EIN = data.EIN; model.VIN = data.VIN; _vehilces.Add(model); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void GetAllDriver() { _drivers.Clear(); try { vmsLinqDataContext datacontext = new vmsLinqDataContext(); var query = from d in datacontext.Drivers select d; DriverModel model; foreach (Driver data in query) { model = new DriverModel(); model.ID = data.ID; model.FirstName = data.FirstName; model.LastName = data.LastName; model.BirthDay = Convert.ToDateTime(data.BirthDay); _drivers.Add(model); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }