private void btnAddNewAirplaneToTracker_Click(object sender, EventArgs e) { if (lstTrackers.SelectedItems.Count == 1) { DatabaseDataContext dataContext = new DatabaseDataContext(DB_Path); t_Pilot f = new t_Pilot(); f.ID_Tracker = ((TrackerListEntry)lstTrackers.SelectedItems[0]).ID_Tracker; f.LastName = txtPilot.Text; f.SureName = txtAirplane.Text; dataContext.t_Pilots.InsertOnSubmit(f); dataContext.SubmitChanges(); RefreshTrackerList(); } }
/// <summary> /// /// </summary> /// <param name="LastName"></param> /// <param name="SureName"></param> /// <param name="Color"></param> /// <returns></returns> public int AddNewPilot(String LastName, String SureName, String Color, byte[] Picture, int Id_Flag) { try { LogManager.AddLog(DB_PATH, 4, "ANRLDataService.svc.cs:AddNewAirplane", LastName + SureName); DatabaseDataContext dataContext = new DatabaseDataContext(DB_PATH); t_Pilot f = new t_Pilot(); f.LastName = LastName; f.SureName = SureName; f.Color = Color; f.Picture = new System.Data.Linq.Binary(Picture); f.ID_Flag = Id_Flag; dataContext.t_Pilots.InsertOnSubmit(f); dataContext.SubmitChanges(); return f.ID; } catch (Exception ex) { LogManager.AddLog(DB_PATH, 0, "ANRLDataService.svc.cs:AddNewPilot", ex.ToString()); } return -1; }
partial void Deletet_Pilot(t_Pilot instance);
partial void Updatet_Pilot(t_Pilot instance);
partial void Insertt_Pilot(t_Pilot instance);
/// <summary> /// Return a list of all Airplanes /// </summary> /// <returns>List of Airplanes</returns> public List<t_Pilot> GetPilots() { try { LogManager.AddLog(DB_PATH, 4, "ANRLDataService.svc.cs:GetAirplanes", ""); DatabaseDataContext dataContext = new DatabaseDataContext(DB_PATH); List<t_Pilot> tmp = new List<t_Pilot>(); foreach (t_Pilot f in dataContext.t_Pilots) { t_Pilot pilo = new t_Pilot(); pilo.ID = f.ID; pilo.ID_Tracker = f.ID_Tracker; pilo.LastName = f.LastName; pilo.SureName = f.SureName; pilo.Color = f.Color; pilo.Picture = f.Picture; pilo.ID_Flag = f.ID_Flag; tmp.Add(pilo); } return tmp; } catch (Exception ex) { LogManager.AddLog(DB_PATH, 0, "ANRLDataService.svc.cs:GetPilots", ex.ToString()); } return null; }
/// <summary> /// Create a new AirplaneListEntry /// </summary> /// <param name="f">The Airplane to be displayed</param> public AirplaneListEntry(t_Pilot f) { ID = f.ID; LastName = f.LastName; SureName = f.SureName; }