/// <summary>Get Aircraft</summary>
/// <cardinality>Many</cardinality>
public List <AircraftMaintenanceIndexWithFilterData> AircraftMaintenanceIndexWithFilter()
{
var ret = new List <AircraftMaintenanceIndexWithFilterData>();
string sql = @"
SELECT
a.aircraft_name
,a.aircraft_configuration_rcd
,acr.aircraft_configuration_name
,a.aircraft_body_rcd
,abr.aircraft_body_name
,a.aircraft_type_rcd
,atr.aircraft_type_name
,a.engine_type
,a.operational_date_time
,a.first_flight_date_time
,a.passenger_capacity
,a.user_id
,du.default_user_name
,a.date_time
,a.aircraft_id
,a.product_id
FROM aircraft AS a
LEFT JOIN aircraft_configuration_ref AS acr
ON acr.aircraft_configuration_rcd = a.aircraft_configuration_rcd
INNER JOIN aircraft_body_ref AS abr
ON abr.aircraft_body_rcd = a.aircraft_body_rcd
INNER JOIN aircraft_type_ref AS atr
ON atr.aircraft_type_rcd = a.aircraft_type_rcd
INNER JOIN default_user AS du
ON du.default_user_id = a.user_id
WHERE 1 = 1
";
using (var conn = new SqlConnection(Conn.ConnectionString)) {
conn.Open();
using (var command = new SqlCommand(sql, conn)) {
command.CommandText = sql;
Logging log = Logging.PerformanceTimeStart("AircraftMaintenanceIndexWithFilter");
IDataReader reader = command.ExecuteReader(CommandBehavior.SingleResult);
log.PerformanceTimeStop(sql, command);
var ordinals = new AircraftMaintenanceIndexWithFilterDataOrdinals(reader);
while (reader.Read())
{
var data = new AircraftMaintenanceIndexWithFilterData();
data.Populate(reader, ordinals);
ret.Add(data);
}
reader.Close();
}
return(ret);
}
}
// use ordinals to speed up access to DataReader
// links:
// crud definition: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete
// docLink: http://sql2x.org/documentationLink/327451c3-64a8-4de8-b359-76742d634497
// parameters:
// reader: IDataReader from SQLClient
public void Populate(IDataReader reader, AircraftMaintenanceIndexWithFilterDataOrdinals ordinals)
{
if (!reader.IsDBNull(ordinals.AircraftName))
{
AircraftName = reader.GetString(ordinals.AircraftName);
}
if (!reader.IsDBNull(ordinals.AircraftConfigurationRcd))
{
AircraftConfigurationRcd = reader.GetString(ordinals.AircraftConfigurationRcd);
}
if (!reader.IsDBNull(ordinals.AircraftConfigurationName))
{
AircraftConfigurationName = reader.GetString(ordinals.AircraftConfigurationName);
}
if (!reader.IsDBNull(ordinals.AircraftBodyRcd))
{
AircraftBodyRcd = reader.GetString(ordinals.AircraftBodyRcd);
}
if (!reader.IsDBNull(ordinals.AircraftBodyName))
{
AircraftBodyName = reader.GetString(ordinals.AircraftBodyName);
}
if (!reader.IsDBNull(ordinals.AircraftTypeRcd))
{
AircraftTypeRcd = reader.GetString(ordinals.AircraftTypeRcd);
}
if (!reader.IsDBNull(ordinals.AircraftTypeName))
{
AircraftTypeName = reader.GetString(ordinals.AircraftTypeName);
}
if (!reader.IsDBNull(ordinals.EngineType))
{
EngineType = reader.GetString(ordinals.EngineType);
}
if (!reader.IsDBNull(ordinals.OperationalDateTime))
{
OperationalDateTime = reader.GetDateTime(ordinals.OperationalDateTime);
}
if (!reader.IsDBNull(ordinals.FirstFlightDateTime))
{
FirstFlightDateTime = reader.GetDateTime(ordinals.FirstFlightDateTime);
}
if (!reader.IsDBNull(ordinals.PassengerCapacity))
{
PassengerCapacity = reader.GetInt32(ordinals.PassengerCapacity);
}
if (!reader.IsDBNull(ordinals.UserId))
{
UserId = reader.GetGuid(ordinals.UserId);
}
if (!reader.IsDBNull(ordinals.DefaultUserName))
{
DefaultUserName = reader.GetString(ordinals.DefaultUserName);
}
if (!reader.IsDBNull(ordinals.DateTime))
{
DateTime = reader.GetDateTime(ordinals.DateTime);
}
if (!reader.IsDBNull(ordinals.AircraftId))
{
AircraftId = reader.GetGuid(ordinals.AircraftId);
}
if (!reader.IsDBNull(ordinals.ProductId))
{
ProductId = reader.GetGuid(ordinals.ProductId);
}
}
