// if the user exists and is valid, return the user, else return null
internal static PilotClassDefinition getPilotClassDefinition(Guid defid)
{
using (DBClassesDataContext dbc = new DBClassesDataContext())
{
PilotClassDefinition ach = (from u in dbc.PilotClassDefinitions
where u.PilotClassID == defid
select u).SingleOrDefault();
return(ach);
}
}
internal static void delete(Guid achID)
{
using (DBClassesDataContext dbc = new DBClassesDataContext())
{
PilotClassDefinition ach = (from u in dbc.PilotClassDefinitions
where u.PilotClassID == achID
select u).SingleOrDefault();
if (ach != null)
{
dbc.PilotClassDefinitions.DeleteOnSubmit(ach);
dbc.SubmitChanges();
}
}
}
// if the user exists and is valid, return the user, else return null
public static ArrayList getPilotClassesForPilot(String pilotid)
{
ArrayList classes = new ArrayList();
using (DBClassesDataContext dbc = new DBClassesDataContext())
{
IEnumerable <PilotClass> ach = (from u in dbc.PilotClasses
where u.PilotEmail == pilotid
select u);
foreach (PilotClass pc in ach)
{
PilotClassDefinition pcd = PilotClassDefinition.getPilotClassDefinition(pc.PilotClassID);
if (pcd != null)
{
classes.Add(pcd);
}
}
}
return(classes);
}