// 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(); }
// 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(); }
// transfer model to data and insert // links: // docLink: http://sql2x.org/documentationLink/17cd8423-3c78-459f-a45b-773fcfbc3b7d public void Insert(CrudeAirportModel model) { var data = new CrudeAirportData(); ModelToData(model, data); data.Insert(); }
// 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 <CrudeAirportModel> 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 <CrudeAirportModel>(); List <CrudeAirportData> dataList = CrudeAirportData.FetchWithFilter(airportId, airportName, airportTypeRcd, cityId, productId, utcOffset, elevationInMeters, runwayInMeters, latitude, longitude, timezoneId, variation, attendance, controlTowerFlag, activationDateTime, userId, dateTime); foreach (CrudeAirportData data in dataList) { var crudeAirportBusinessModel = new CrudeAirportModel(); DataToModel(data, crudeAirportBusinessModel); list.Add(crudeAirportBusinessModel); } return(list); }
// transfer model to data and update // links: // docLink: http://sql2x.org/documentationLink/658fda50-2ad3-414e-9299-2b399d17a057 public void Update(CrudeAirportModel model) { var data = new CrudeAirportData(); ModelToData(model, data); data.Update(); }
// transfer model to data and update, on a transaction // links: // docLink: http://sql2x.org/documentationLink/aa07e05b-edc8-4e09-bf93-bf2a40c93c09 public void Update(CrudeAirportModel model, SqlConnection connection, SqlTransaction transaction) { var data = new CrudeAirportData(); ModelToData(model, data); data.Update(connection, transaction); }
// 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); }
// 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 <CrudeAirportContract> contractList, List <CrudeAirportData> dataList) { foreach (CrudeAirportContract contract in contractList) { var data = new CrudeAirportData(); CrudeAirportService.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: // CrudeAirportData: key of table CrudeAirportData public static void ModelListToDataList(List <CrudeAirportModel> modelList, List <CrudeAirportData> dataList) { foreach (CrudeAirportModel model in modelList) { var data = new CrudeAirportData(); 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: // 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); }
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/fdcc33b4-08f1-43c3-ae28-95fbf029c3bd // parameters: // CrudeAirportData: primary key of table CrudeAirportData public CrudeAirportModel FetchByAirportId(System.Guid airportId) { var dataAccessLayer = new CrudeAirportData(); var model = new CrudeAirportModel(); dataAccessLayer.FetchByAirportId(airportId); DataToModel(dataAccessLayer, model); return(model); }
// fetch by Search key into current object // links: // crud definition: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete // docLink: http://sql2x.org/documentationLink/ad2dd952-e3ec-471a-9e34-f5fc965b8b37 // parameters: // AirportName: key of table CrudeAirportData public CrudeAirportModel FetchByAirportName(string airportName) { var dataAccessLayer = new CrudeAirportData(); var model = new CrudeAirportModel(); dataAccessLayer.FetchByAirportName(airportName); DataToModel(dataAccessLayer, model); return(model); }
// copy all rows from a List of serialized data objects in CrudeAirportData to a List of SOAP Contracts // links: // docLink: http://sql2x.org/documentationLink/3d3e60c3-69e4-43d6-8bd5-14a67a6ecf58 public List <CrudeAirportModel> FetchAll() { var list = new List <CrudeAirportModel>(); List <CrudeAirportData> dataList = CrudeAirportData.FetchAll(); foreach (CrudeAirportData crudeAirportBusiness in dataList) { var model = new CrudeAirportModel(); DataToModel(crudeAirportBusiness, model); list.Add(model); } return(list); }
// 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); }
// 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 <CrudeAirportModel> FetchAllWithLimitAndOffset(string limit, string offset) { var list = new List <CrudeAirportModel>(); List <CrudeAirportData> dataList = CrudeAirportData.FetchAllWithLimitAndOffset(int.Parse(limit), int.Parse(offset)); foreach (CrudeAirportData crudeAirportBusiness in dataList) { var model = new CrudeAirportModel(); DataToModel(crudeAirportBusiness, model); list.Add(model); } 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); }
// 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; }
// transfer data object to model object // links: // docLink: http://sql2x.org/documentationLink/43d57600-5ff5-4ef8-9330-123773d100d3 public static void DataToModel(CrudeAirportData data, CrudeAirportModel model) { model.AirportId = data.AirportId; model.AirportName = data.AirportName; model.AirportTypeRcd = data.AirportTypeRcd; model.CityId = data.CityId; model.ProductId = data.ProductId; model.UtcOffset = data.UtcOffset; model.ElevationInMeters = data.ElevationInMeters; model.RunwayInMeters = data.RunwayInMeters; model.Latitude = data.Latitude; model.Longitude = data.Longitude; model.TimezoneId = data.TimezoneId; model.Variation = data.Variation; model.Attendance = data.Attendance; model.ControlTowerFlag = data.ControlTowerFlag; model.ActivationDateTime = data.ActivationDateTime; 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(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; }
// transfer model object to data object // links: // docLink: http://sql2x.org/documentationLink/95875d99-b7f7-4a9e-baa4-3fbe9925d8a2 public static void ModelToData(CrudeAirportModel model, CrudeAirportData data) { data.AirportId = model.AirportId; data.AirportName = model.AirportName; data.AirportTypeRcd = model.AirportTypeRcd; data.CityId = model.CityId; data.ProductId = model.ProductId; data.UtcOffset = model.UtcOffset; data.ElevationInMeters = model.ElevationInMeters; data.RunwayInMeters = model.RunwayInMeters; data.Latitude = model.Latitude; data.Longitude = model.Longitude; data.TimezoneId = model.TimezoneId; data.Variation = model.Variation; data.Attendance = model.Attendance; data.ControlTowerFlag = model.ControlTowerFlag; data.ActivationDateTime = model.ActivationDateTime; data.UserId = model.UserId; data.DateTime = model.DateTime; }
// fetch by Search key into current object // links: // crud definition: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete // docLink: http://sql2x.org/documentationLink/87368fa6-b618-4f0c-acbb-1fc4e273bb2d // parameters: // CityId: key of table CrudeAirportData public List <CrudeAirportModel> FetchByCityId(System.Guid cityId) { return(DataListToModelList(CrudeAirportData.FetchByCityId(cityId))); }
// fetch by Search key into current object // links: // crud definition: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete // docLink: http://sql2x.org/documentationLink/87368fa6-b618-4f0c-acbb-1fc4e273bb2d // parameters: // AirportTypeRcd: key of table CrudeAirportData public List <CrudeAirportModel> FetchByAirportTypeRcd(string airportTypeRcd) { return(DataListToModelList(CrudeAirportData.FetchByAirportTypeRcd(airportTypeRcd))); }
// fetch by Search key into current object // links: // crud definition: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete // docLink: http://sql2x.org/documentationLink/87368fa6-b618-4f0c-acbb-1fc4e273bb2d // parameters: // ProductId: key of table CrudeAirportData public List <CrudeAirportModel> FetchByProductId(System.Guid productId) { return(DataListToModelList(CrudeAirportData.FetchByProductId(productId))); }
// fetch by Search key into current object // links: // crud definition: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete // docLink: http://sql2x.org/documentationLink/87368fa6-b618-4f0c-acbb-1fc4e273bb2d // parameters: // TimezoneId: key of table CrudeAirportData public List <CrudeAirportModel> FetchByTimezoneId(System.Guid timezoneId) { return(DataListToModelList(CrudeAirportData.FetchByTimezoneId(timezoneId))); }
// delete row // links: // docLink: http://sql2x.org/documentationLink/59823bf7-4ad8-4684-a48b-2abd49c607ee public void Delete(System.Guid airportId) { CrudeAirportData.Delete(airportId); }
// fetch by Foreign key into new List of class instances // links: // docLink: http://sql2x.org/documentationLink/a7599485-4f00-4ebf-974d-53f69c43654e public List <CrudeAirportContract> FetchByUserId(System.Guid userId) { return(DataListToContractList(CrudeAirportData.FetchByUserId(userId))); }
// fetch by Foreign key into new List of class instances // links: // docLink: http://sql2x.org/documentationLink/a7599485-4f00-4ebf-974d-53f69c43654e public List <CrudeAirportContract> FetchByAirportTypeRcd(string airportTypeRcd) { return(DataListToContractList(CrudeAirportData.FetchByAirportTypeRcd(airportTypeRcd))); }
// fetch by Search key into current object // links: // crud definition: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete // docLink: http://sql2x.org/documentationLink/87368fa6-b618-4f0c-acbb-1fc4e273bb2d // parameters: // UserId: key of table CrudeAirportData public List <CrudeAirportModel> FetchByUserId(System.Guid userId) { return(DataListToModelList(CrudeAirportData.FetchByUserId(userId))); }
// get a count of rows in table // links: // docLink: http://sql2x.org/documentationLink/39677f9e-daee-45c6-9527-da98a0d7958d public int FetchAllCount() { return(CrudeAirportData.FetchAllCount()); }