// 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);
}
// 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 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 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);
}
// 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);
}
// 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:
// CrudeAirportData: key of table CrudeAirportData
public static List <CrudeAirportModel> DataListToModelList(List <CrudeAirportData> dataList)
{
var modelList = new List <CrudeAirportModel>();
foreach (CrudeAirportData data in dataList)
{
var model = new CrudeAirportModel();
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 <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/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);
}
// 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;
}
// 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;
}
public CrudeAirportModel CrudeAirportUpdate([Bind()] CrudeAirportModel airport)
{
new CrudeAirportBusiness().Update(airport);
return(airport);
}
public CrudeAirportModel CrudeAirportCreate([Bind()] CrudeAirportModel airport)
{
new CrudeAirportBusiness().Insert(airport);
return(airport);
}
