public StartingFlight(string szUser, RepresentativeAircraft ra) : base() { if (ra == null) { throw new ArgumentNullException("ra"); } this.RepresentativeAircraft = ra; this.AircraftID = ra.ExampleAircraft.AircraftID; this.User = szUser; this.Comment = Resources.LogbookEntry.StartingFlightComment; }
public static List <RepresentativeAircraft> RepresentativeAircraftForUser(string szUser, RepresentativeTypeMode mode) { List <RepresentativeAircraft> l = new List <RepresentativeAircraft>(); UserAircraft ua = new UserAircraft(szUser); DBHelper dbh = new DBHelper(); switch (mode) { case RepresentativeTypeMode.ByModel: dbh.CommandText = sqlAircraftModels; break; case RepresentativeTypeMode.CatClassCapabilities: dbh.CommandText = sqlAircraftCatClassCapabilities; break; default: case RepresentativeTypeMode.CatClassType: dbh.CommandText = sqlAircraftCatClassType; break; } dbh.ReadRows((comm) => { comm.Parameters.AddWithValue("?uName", szUser); }, (dr) => { try { RepresentativeAircraft ra = new RepresentativeAircraft(); string aircraftIDs = (string)dr["AircraftIDs"]; string[] rgIDs = aircraftIDs.Split(','); ra.ExampleAircraft = ua.GetUserAircraftByID(Convert.ToInt32(rgIDs[0])); ra.IsComplex = Convert.ToBoolean(dr["fComplex"]); ra.IsConstantProp = Convert.ToBoolean(dr["fConstantProp"]); ra.IsHighPerf = Convert.ToBoolean(dr["fHighPerf"]); ra.IsRetract = Convert.ToBoolean(dr["fRetract"]); ra.IsTailwheel = Convert.ToBoolean(dr["fTailwheel"]); ra.IsTurbine = Convert.ToBoolean(dr["fTurbine"]); switch (mode) { case RepresentativeTypeMode.ByModel: ra.Name = ra.ExampleAircraft.ModelCommonName; break; default: case RepresentativeTypeMode.CatClassCapabilities: case RepresentativeTypeMode.CatClassType: ra.Name = (string)dr["catclasstype"]; break; } l.Add(ra); } catch { } } ); return(l); }