// update all object members on a row in table based on primary key
// links:
// docLink: http://sql2x.org/documentationLink/ce75e72e-fb16-4f4e-a2e6-dbd079dfa206
public void Update(CrudeAirportContract contract)
{
var data = new CrudeAirportData();
ContractToData(contract, data);
data.Update();
}
// update all object members on a row in table based on primary key, on a transaction
// the transaction and or connection state is not changed in any way other than what SqlClient does to it.
// it is the callers responsibility to commit or rollback the transaction
// links:
// docLink: http://sql2x.org/documentationLink/b798ad6b-f4b8-466a-9086-6588a814fcf3
public void Update(CrudeAirportContract contract, SqlConnection connection, SqlTransaction transaction)
{
var data = new CrudeAirportData();
ContractToData(contract, data);
data.Update(connection, transaction);
}
// insert all object members as a new row in table
// links:
// docLink: http://sql2x.org/documentationLink/75aad010-e6aa-4f19-a6e5-597456aa20d8
public void Insert(CrudeAirportContract contract)
{
var data = new CrudeAirportData();
ContractToData(contract, data);
data.Insert();
}
public CrudeAirportContract FetchByAirportName(string airportName)
{
var dataAccessLayer = new CrudeAirportData();
var contract = new CrudeAirportContract();
dataAccessLayer.FetchByAirportName(airportName);
DataToContract(dataAccessLayer, contract);
return(contract);
}
// fetch by Primary key into current object
// links:
// crud definition: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete
// docLink: http://sql2x.org/documentationLink/bbab4791-c9e7-49bf-90d5-fca19b1fedaa
// parameters:
// airportId: primary key of table airport
public CrudeAirportContract FetchByAirportId(System.Guid airportId)
{
var dataAccessLayer = new CrudeAirportData();
var contract = new CrudeAirportContract();
dataAccessLayer.FetchByAirportId(airportId);
DataToContract(dataAccessLayer, contract);
return(contract);
}
// copy all rows from a List of serialized data objects to a List of SOAP Contracts
// links:
// docLink: http://sql2x.org/documentationLink/7467f97d-14e5-4ccf-9282-ef8df4f63088
public static List <CrudeAirportContract> DataListToContractList(List <CrudeAirportData> dataList)
{
var contractList = new List <CrudeAirportContract>();
foreach (CrudeAirportData data in dataList)
{
var contract = new CrudeAirportContract();
DataToContract(data, contract);
contractList.Add(contract);
}
return(contractList);
}
// copy all rows from a List of serialized data objects to a List of SOAP Contracts,
// with a limit on number of returned rows and order by columns, starting at a specific row
// links:
// docLink: http://sql2x.org/documentationLink/3fe9f1b3-97b6-4f58-a0f2-adfcbd973bfc
public List <CrudeAirportContract> FetchAllWithLimitAndOffset(int limit, int offset)
{
var list = new List <CrudeAirportContract>();
List <CrudeAirportData> dataList = CrudeAirportData.FetchAllWithLimitAndOffset(limit, offset);
foreach (CrudeAirportData crudeAirport in dataList)
{
var contract = new CrudeAirportContract();
DataToContract(crudeAirport, contract);
list.Add(contract);
}
return(list);
}
// copy all rows from a List of serialized data objects in CrudeAirportData to a List of SOAP Contracts
// links:
// docLink: http://sql2x.org/documentationLink/9204c68e-93b8-4c77-af3c-3181985ff75f
public List <CrudeAirportContract> FetchAll()
{
var list = new List <CrudeAirportContract>();
List <CrudeAirportData> dataList = CrudeAirportData.FetchAll();
foreach (CrudeAirportData crudeAirport in dataList)
{
var contract = new CrudeAirportContract();
DataToContract(crudeAirport, contract);
list.Add(contract);
}
return(list);
}
// fetch all rows from table into new List of Contracts, filtered by any column
// links:
// docLink: http://sql2x.org/documentationLink/ce01ef4a-5cd0-4e51-b211-9c0a15b791a0
public List <CrudeAirportContract> FetchWithFilter(
System.Guid airportId,
string airportName,
string airportTypeRcd,
System.Guid cityId,
System.Guid productId,
decimal utcOffset,
decimal elevationInMeters,
decimal runwayInMeters,
string latitude,
string longitude,
System.Guid timezoneId,
string variation,
string attendance,
bool controlTowerFlag,
System.DateTime activationDateTime,
System.Guid userId,
System.DateTime dateTime)
{
var list = new List <CrudeAirportContract>();
List <CrudeAirportData> dataList = CrudeAirportData.FetchWithFilter(
airportId: airportId,
airportName: airportName,
airportTypeRcd: airportTypeRcd,
cityId: cityId,
productId: productId,
utcOffset: utcOffset,
elevationInMeters: elevationInMeters,
runwayInMeters: runwayInMeters,
latitude: latitude,
longitude: longitude,
timezoneId: timezoneId,
variation: variation,
attendance: attendance,
controlTowerFlag: controlTowerFlag,
activationDateTime: activationDateTime,
userId: userId,
dateTime: dateTime
);
foreach (CrudeAirportData data in dataList)
{
var crudeAirportContract = new CrudeAirportContract();
DataToContract(data, crudeAirportContract);
list.Add(crudeAirportContract);
}
return(list);
}
// copy all columns from a serialized data object to a SOAP Contract
// links:
// docLink: http://sql2x.org/documentationLink/7553d6dd-da65-4a72-84c8-81f2f99ef4f5
public static void DataToContract(CrudeAirportData data, CrudeAirportContract contract)
{
contract.AirportId = data.AirportId;
contract.AirportName = data.AirportName;
contract.AirportTypeRcd = data.AirportTypeRcd;
contract.CityId = data.CityId;
contract.ProductId = data.ProductId;
contract.UtcOffset = data.UtcOffset;
contract.ElevationInMeters = data.ElevationInMeters;
contract.RunwayInMeters = data.RunwayInMeters;
contract.Latitude = data.Latitude;
contract.Longitude = data.Longitude;
contract.TimezoneId = data.TimezoneId;
contract.Variation = data.Variation;
contract.Attendance = data.Attendance;
contract.ControlTowerFlag = data.ControlTowerFlag;
contract.ActivationDateTime = data.ActivationDateTime;
contract.UserId = data.UserId;
contract.DateTime = data.DateTime;
}
// copy all columns from a SOAP Contract to a serialized data object
// links:
// docLink: http://sql2x.org/documentationLink/10700d38-2227-4021-be12-2f4f206f5dd9
public static void ContractToData(CrudeAirportContract contract, CrudeAirportData data)
{
data.AirportId = contract.AirportId;
data.AirportName = contract.AirportName;
data.AirportTypeRcd = contract.AirportTypeRcd;
data.CityId = contract.CityId;
data.ProductId = contract.ProductId;
data.UtcOffset = contract.UtcOffset;
data.ElevationInMeters = contract.ElevationInMeters;
data.RunwayInMeters = contract.RunwayInMeters;
data.Latitude = contract.Latitude;
data.Longitude = contract.Longitude;
data.TimezoneId = contract.TimezoneId;
data.Variation = contract.Variation;
data.Attendance = contract.Attendance;
data.ControlTowerFlag = contract.ControlTowerFlag;
data.ActivationDateTime = contract.ActivationDateTime;
data.UserId = contract.UserId;
data.DateTime = contract.DateTime;
}
