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;
}
