// 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(CrudeAircraftCompartmentMeasurementContract contract, SqlConnection connection, SqlTransaction transaction) { var data = new CrudeAircraftCompartmentMeasurementData(); ContractToData(contract, data); data.Update(connection, transaction); }
// 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); }
// 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(CrudeAircraftCompartmentMeasurementContract contract) { var data = new CrudeAircraftCompartmentMeasurementData(); ContractToData(contract, data); data.Update(); }
// copy all rows from a List of SOAP Contracts to a List of serialized data objects // links: // docLink: http://sql2x.org/documentationLink/1c6c6b9c-e201-4590-8c69-d38a0ad2a9f7 public static void ContractListToDataList(List <CrudeAircraftCompartmentMeasurementContract> contractList, List <CrudeAircraftCompartmentMeasurementData> dataList) { foreach (CrudeAircraftCompartmentMeasurementContract contract in contractList) { var data = new CrudeAircraftCompartmentMeasurementData(); CrudeAircraftCompartmentMeasurementService.ContractToData(contract, data); dataList.Add(data); } }
// transfer model list to data list // links: // crud definition: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete // docLink: http://sql2x.org/documentationLink/1d6a48d9-fe39-4397-b8fa-a332da164cbf // parameters: // CrudeAircraftCompartmentMeasurementData: key of table CrudeAircraftCompartmentMeasurementData public static void ModelListToDataList(List <CrudeAircraftCompartmentMeasurementModel> modelList, List <CrudeAircraftCompartmentMeasurementData> dataList) { foreach (CrudeAircraftCompartmentMeasurementModel model in modelList) { var data = new CrudeAircraftCompartmentMeasurementData(); ModelToData(model, data); dataList.Add(data); } }
// 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: // aircraftCompartmentMeasurementId: primary key of table aircraft_compartment_measurement public CrudeAircraftCompartmentMeasurementContract FetchByAircraftCompartmentMeasurementId(System.Guid aircraftCompartmentMeasurementId) { var dataAccessLayer = new CrudeAircraftCompartmentMeasurementData(); var contract = new CrudeAircraftCompartmentMeasurementContract(); dataAccessLayer.FetchByAircraftCompartmentMeasurementId(aircraftCompartmentMeasurementId); 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/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); }
// 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 <CrudeAircraftCompartmentMeasurementContract> FetchAllWithLimitAndOffset(int limit, int offset) { var list = new List <CrudeAircraftCompartmentMeasurementContract>(); List <CrudeAircraftCompartmentMeasurementData> dataList = CrudeAircraftCompartmentMeasurementData.FetchAllWithLimitAndOffset(limit, offset); foreach (CrudeAircraftCompartmentMeasurementData crudeAircraftCompartmentMeasurement in dataList) { var contract = new CrudeAircraftCompartmentMeasurementContract(); DataToContract(crudeAircraftCompartmentMeasurement, contract); list.Add(contract); } 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/9204c68e-93b8-4c77-af3c-3181985ff75f public List <CrudeAircraftCompartmentMeasurementContract> FetchAll() { var list = new List <CrudeAircraftCompartmentMeasurementContract>(); List <CrudeAircraftCompartmentMeasurementData> dataList = CrudeAircraftCompartmentMeasurementData.FetchAll(); foreach (CrudeAircraftCompartmentMeasurementData crudeAircraftCompartmentMeasurement in dataList) { var contract = new CrudeAircraftCompartmentMeasurementContract(); DataToContract(crudeAircraftCompartmentMeasurement, contract); list.Add(contract); } return(list); }
// 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; }
// 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(CrudeAircraftCompartmentMeasurementData data, CrudeAircraftCompartmentMeasurementContract contract) { contract.AircraftCompartmentMeasurementId = data.AircraftCompartmentMeasurementId; contract.Length = data.Length; contract.Height = data.Height; contract.Width = data.Width; contract.PayloadInKilo = data.PayloadInKilo; contract.UnitLoadDevicePositions = data.UnitLoadDevicePositions; contract.CarryOnBinCount = data.CarryOnBinCount; contract.CarryOnPiecesAllowedCount = data.CarryOnPiecesAllowedCount; contract.CarryOnPieceMaxWeightInKilo = data.CarryOnPieceMaxWeightInKilo; contract.InfantLimit = data.InfantLimit; contract.BookableLimit = data.BookableLimit; contract.PassengerLimit = data.PassengerLimit; contract.RowCount = data.RowCount; contract.ColumnCount = data.ColumnCount; contract.UserId = data.UserId; contract.DateTime = data.DateTime; }
// delete a row in table based on primary key // links: // docLink: http://sql2x.org/documentationLink/eb0597e0-8ea0-425c-88af-213a170bbd5e public void Delete(System.Guid aircraftCompartmentMeasurementId) { CrudeAircraftCompartmentMeasurementData.Delete(aircraftCompartmentMeasurementId); }
// fetch by Foreign key into new List of class instances // links: // docLink: http://sql2x.org/documentationLink/a7599485-4f00-4ebf-974d-53f69c43654e public List <CrudeAircraftCompartmentMeasurementContract> FetchByUserId(System.Guid userId) { return(DataListToContractList(CrudeAircraftCompartmentMeasurementData.FetchByUserId(userId))); }
// get a count of rows in table // links: // docLink: http://sql2x.org/documentationLink/7cd5e52c-b3d7-4566-a27a-408d0732dd88 public int FetchAllCount() { return(CrudeAircraftCompartmentMeasurementData.FetchAllCount()); }