// transfer model to data and update
// links:
// docLink: http://sql2x.org/documentationLink/658fda50-2ad3-414e-9299-2b399d17a057
public void Update(CrudeAircraftCompartmentMeasurementModel model)
{
var data = new CrudeAircraftCompartmentMeasurementData();
ModelToData(model, data);
data.Update();
}
// transfer model to data and insert, on transaction
// links:
// docLink: http://sql2x.org/documentationLink/fbeb7c34-b2d7-403b-a9fd-503ab705ef81
public void Insert(CrudeAircraftCompartmentMeasurementModel model, SqlConnection connection, SqlTransaction transaction)
{
var data = new CrudeAircraftCompartmentMeasurementData();
ModelToData(model, data);
data.Insert(connection, transaction);
}
// fetch all from table into new List of class instances, filtered by any column
// links:
// docLink: http://sql2x.org/documentationLink/db27658d-4d23-46d7-9970-7bbaef8634b0
public List <CrudeAircraftCompartmentMeasurementModel> FetchWithFilter(
System.Guid aircraftCompartmentMeasurementId,
decimal length,
decimal height,
decimal width,
decimal payloadInKilo,
int unitLoadDevicePositions,
int carryOnBinCount,
int carryOnPiecesAllowedCount,
int carryOnPieceMaxWeightInKilo,
int infantLimit,
int bookableLimit,
int passengerLimit,
int rowCount,
int columnCount,
System.Guid userId,
System.DateTime dateTime)
{
var list = new List <CrudeAircraftCompartmentMeasurementModel>();
List <CrudeAircraftCompartmentMeasurementData> dataList = CrudeAircraftCompartmentMeasurementData.FetchWithFilter(aircraftCompartmentMeasurementId, length, height, width, payloadInKilo, unitLoadDevicePositions, carryOnBinCount, carryOnPiecesAllowedCount, carryOnPieceMaxWeightInKilo, infantLimit, bookableLimit, passengerLimit, rowCount, columnCount, userId, dateTime);
foreach (CrudeAircraftCompartmentMeasurementData data in dataList)
{
var crudeAircraftCompartmentMeasurementBusinessModel = new CrudeAircraftCompartmentMeasurementModel();
DataToModel(data, crudeAircraftCompartmentMeasurementBusinessModel);
list.Add(crudeAircraftCompartmentMeasurementBusinessModel);
}
return(list);
}
// 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/fdcc33b4-08f1-43c3-ae28-95fbf029c3bd
// parameters:
// CrudeAircraftCompartmentMeasurementData: primary key of table CrudeAircraftCompartmentMeasurementData
public CrudeAircraftCompartmentMeasurementModel FetchByAircraftCompartmentMeasurementId(System.Guid aircraftCompartmentMeasurementId)
{
var dataAccessLayer = new CrudeAircraftCompartmentMeasurementData();
var model = new CrudeAircraftCompartmentMeasurementModel();
dataAccessLayer.FetchByAircraftCompartmentMeasurementId(aircraftCompartmentMeasurementId);
DataToModel(dataAccessLayer, model);
return(model);
}
// transfer data list to model list
// links:
// crud definition: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete
// docLink: http://sql2x.org/documentationLink/b8ab5693-f2f2-494f-883e-89b617113511
// parameters:
// CrudeAircraftCompartmentMeasurementData: key of table CrudeAircraftCompartmentMeasurementData
public static List <CrudeAircraftCompartmentMeasurementModel> DataListToModelList(List <CrudeAircraftCompartmentMeasurementData> dataList)
{
var modelList = new List <CrudeAircraftCompartmentMeasurementModel>();
foreach (CrudeAircraftCompartmentMeasurementData data in dataList)
{
var model = new CrudeAircraftCompartmentMeasurementModel();
DataToModel(data, model);
modelList.Add(model);
}
return(modelList);
}
// fetch all rows from table with an offset, and limit of rows
// links:
// docLink: http://sql2x.org/documentationLink/a87e5c54-b47e-4031-bc3b-837b4cf9f692
public List <CrudeAircraftCompartmentMeasurementModel> FetchAllWithLimitAndOffset(string limit, string offset)
{
var list = new List <CrudeAircraftCompartmentMeasurementModel>();
List <CrudeAircraftCompartmentMeasurementData> dataList = CrudeAircraftCompartmentMeasurementData.FetchAllWithLimitAndOffset(int.Parse(limit), int.Parse(offset));
foreach (CrudeAircraftCompartmentMeasurementData crudeAircraftCompartmentMeasurementBusiness in dataList)
{
var model = new CrudeAircraftCompartmentMeasurementModel();
DataToModel(crudeAircraftCompartmentMeasurementBusiness, model);
list.Add(model);
}
return(list);
}
// copy all rows from a List of serialized data objects in CrudeAircraftCompartmentMeasurementData to a List of SOAP Contracts
// links:
// docLink: http://sql2x.org/documentationLink/3d3e60c3-69e4-43d6-8bd5-14a67a6ecf58
public List <CrudeAircraftCompartmentMeasurementModel> FetchAll()
{
var list = new List <CrudeAircraftCompartmentMeasurementModel>();
List <CrudeAircraftCompartmentMeasurementData> dataList = CrudeAircraftCompartmentMeasurementData.FetchAll();
foreach (CrudeAircraftCompartmentMeasurementData crudeAircraftCompartmentMeasurementBusiness in dataList)
{
var model = new CrudeAircraftCompartmentMeasurementModel();
DataToModel(crudeAircraftCompartmentMeasurementBusiness, model);
list.Add(model);
}
return(list);
}
// transfer data object to model object
// links:
// docLink: http://sql2x.org/documentationLink/43d57600-5ff5-4ef8-9330-123773d100d3
public static void DataToModel(CrudeAircraftCompartmentMeasurementData data, CrudeAircraftCompartmentMeasurementModel model)
{
model.AircraftCompartmentMeasurementId = data.AircraftCompartmentMeasurementId;
model.Length = data.Length;
model.Height = data.Height;
model.Width = data.Width;
model.PayloadInKilo = data.PayloadInKilo;
model.UnitLoadDevicePositions = data.UnitLoadDevicePositions;
model.CarryOnBinCount = data.CarryOnBinCount;
model.CarryOnPiecesAllowedCount = data.CarryOnPiecesAllowedCount;
model.CarryOnPieceMaxWeightInKilo = data.CarryOnPieceMaxWeightInKilo;
model.InfantLimit = data.InfantLimit;
model.BookableLimit = data.BookableLimit;
model.PassengerLimit = data.PassengerLimit;
model.RowCount = data.RowCount;
model.ColumnCount = data.ColumnCount;
model.UserId = data.UserId;
model.DateTime = data.DateTime;
}
public CrudeAircraftCompartmentMeasurementModel CrudeAircraftCompartmentMeasurementUpdate([Bind()] CrudeAircraftCompartmentMeasurementModel aircraftCompartmentMeasurement)
{
new CrudeAircraftCompartmentMeasurementBusiness().Update(aircraftCompartmentMeasurement);
return(aircraftCompartmentMeasurement);
}
