///<summary>
/// Method Invocation of wrapper classes
///<summary>
protected static FR_L5SP_GABPTFT_1244 Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
bool cleanupConnection = Connection == null;
bool cleanupTransaction = Transaction == null;
FR_L5SP_GABPTFT_1244 functionReturn = new FR_L5SP_GABPTFT_1244();
try
{
if (cleanupConnection == true)
{
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
if (cleanupTransaction == true)
{
Transaction = Connection.BeginTransaction();
}
functionReturn = Execute(Connection, Transaction, securityTicket);
#region Cleanup Connection/Transaction
//Commit the transaction
if (cleanupTransaction == true)
{
Transaction.Commit();
}
//Close the connection
if (cleanupConnection == true)
{
Connection.Close();
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw ex;
}
return(functionReturn);
}
protected static FR_L5SP_GABPTFT_1244 Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5SP_GABPTFT_1244();
//Put your code here
returnValue.Result = new L5SP_GABPTFT_1244();
#region Apartment_Types
//Apartment_Types
ORM_RES_BLD_Apartment_Type.Query apartment_TypeQuery = new ORM_RES_BLD_Apartment_Type.Query();
apartment_TypeQuery.Tenant_RefID = securityTicket.TenantID;
apartment_TypeQuery.IsDeleted = false;
List <ORM_RES_BLD_Apartment_Type> apartment_TypeList = ORM_RES_BLD_Apartment_Type.Query.Search(Connection, Transaction, apartment_TypeQuery);
List <L5SP_GABPTFT_1244_Apartment_Types> apartment_Types = new List <L5SP_GABPTFT_1244_Apartment_Types>();
foreach (var apartment_Type in apartment_TypeList)
{
L5SP_GABPTFT_1244_Apartment_Types item = new L5SP_GABPTFT_1244_Apartment_Types();
item.RES_BLD_Apartment_TypeID = apartment_Type.RES_BLD_Apartment_TypeID;
item.Name = apartment_Type.ApartmentType_Name;
item.Description = apartment_Type.ApartmentType_Description;
apartment_Types.Add(item);
}
returnValue.Result.Apartment_Types = apartment_Types.ToArray();
#endregion
#region Appartment_HeatingTypes
//Appartment_HeatingTypes
ORM_RES_BLD_Appartment_HeatingType.Query apartment_HeatingTypeQuery = new ORM_RES_BLD_Appartment_HeatingType.Query();
apartment_HeatingTypeQuery.Tenant_RefID = securityTicket.TenantID;
apartment_HeatingTypeQuery.IsDeleted = false;
List <ORM_RES_BLD_Appartment_HeatingType> apartment_HeatingTypeList = ORM_RES_BLD_Appartment_HeatingType.Query.Search(Connection, Transaction, apartment_HeatingTypeQuery);
List <L5SP_GABPTFT_1244_Appartment_HeatingTypes> apartment_HeatingTypes = new List <L5SP_GABPTFT_1244_Appartment_HeatingTypes>();
foreach (var apartment_HeatingType in apartment_HeatingTypeList)
{
L5SP_GABPTFT_1244_Appartment_HeatingTypes item = new L5SP_GABPTFT_1244_Appartment_HeatingTypes();
item.RES_BLD_Appartment_HeatingTypeID = apartment_HeatingType.RES_BLD_Appartment_HeatingTypeID;
item.Name = apartment_HeatingType.HeatingType_Name;
item.GlobalPropertyMatchingID = apartment_HeatingType.GlobalPropertyMatchingID;
apartment_HeatingTypes.Add(item);
}
returnValue.Result.Appartment_HeatingTypes = apartment_HeatingTypes.ToArray();
#endregion
#region Appartment_FlooringTypes
//Appartment_FlooringTypes
ORM_RES_BLD_Appartment_FlooringType.Query apartment_FlooringTypeQuery = new ORM_RES_BLD_Appartment_FlooringType.Query();
apartment_FlooringTypeQuery.Tenant_RefID = securityTicket.TenantID;
apartment_FlooringTypeQuery.IsDeleted = false;
List <ORM_RES_BLD_Appartment_FlooringType> apartment_FlooringTypeList = ORM_RES_BLD_Appartment_FlooringType.Query.Search(Connection, Transaction, apartment_FlooringTypeQuery);
List <L5SP_GABPTFT_1244_Appartment_FlooringTypes> apartment_FlooringTypes = new List <L5SP_GABPTFT_1244_Appartment_FlooringTypes>();
foreach (var apartment_FlooringType in apartment_FlooringTypeList)
{
L5SP_GABPTFT_1244_Appartment_FlooringTypes item = new L5SP_GABPTFT_1244_Appartment_FlooringTypes();
item.RES_BLD_Appartment_FlooringTypesID = apartment_FlooringType.RES_BLD_Appartment_FlooringTypesID;
item.Name = apartment_FlooringType.FlooringType_Name;
item.GlobalPropertyMatchingID = apartment_FlooringType.GlobalPropertyMatchingID;
apartment_FlooringTypes.Add(item);
}
returnValue.Result.Appartment_FlooringTypes = apartment_FlooringTypes.ToArray();
#endregion
#region Appartment_WallCoveringTypes
//Appartment_WallCoveringTypes
ORM_RES_BLD_Appartment_WallCoveringType.Query apartment_WallCoveringTypeQuery = new ORM_RES_BLD_Appartment_WallCoveringType.Query();
apartment_WallCoveringTypeQuery.Tenant_RefID = securityTicket.TenantID;
apartment_WallCoveringTypeQuery.IsDeleted = false;
List <ORM_RES_BLD_Appartment_WallCoveringType> apartment_WallCoveringTypeList = ORM_RES_BLD_Appartment_WallCoveringType.Query.Search(Connection, Transaction, apartment_WallCoveringTypeQuery);
List <L5SP_GABPTFT_1244_Appartment_WallCoveringTypes> apartment_WallCoveringTypes = new List <L5SP_GABPTFT_1244_Appartment_WallCoveringTypes>();
foreach (var apartment_WallCoveringType in apartment_WallCoveringTypeList)
{
L5SP_GABPTFT_1244_Appartment_WallCoveringTypes item = new L5SP_GABPTFT_1244_Appartment_WallCoveringTypes();
item.RES_BLD_Appartment_WallCoveringTypeID = apartment_WallCoveringType.RES_BLD_Appartment_WallCoveringTypeID;
item.Name = apartment_WallCoveringType.WallCoveringType_Name;
item.GlobalPropertyMatchingID = apartment_WallCoveringType.GlobalPropertyMatchingID;
apartment_WallCoveringTypes.Add(item);
}
returnValue.Result.Appartment_WallCoveringTypes = apartment_WallCoveringTypes.ToArray();
#endregion
#region OutdoorFacility_Types
//OutdoorFacility_Types
ORM_RES_BLD_OutdoorFacility_Type.Query outdoorFacility_TypeQuery = new ORM_RES_BLD_OutdoorFacility_Type.Query();
outdoorFacility_TypeQuery.Tenant_RefID = securityTicket.TenantID;
outdoorFacility_TypeQuery.IsDeleted = false;
List <ORM_RES_BLD_OutdoorFacility_Type> outdoorFacility_TypeList = ORM_RES_BLD_OutdoorFacility_Type.Query.Search(Connection, Transaction, outdoorFacility_TypeQuery);
List <L5SP_GABPTFT_1244_OutdoorFacility_Types> outdoorFacility_Types = new List <L5SP_GABPTFT_1244_OutdoorFacility_Types>();
foreach (var outdoorFacility_Type in outdoorFacility_TypeList)
{
L5SP_GABPTFT_1244_OutdoorFacility_Types item = new L5SP_GABPTFT_1244_OutdoorFacility_Types();
item.RES_BLD_OutdoorFacility_TypeID = outdoorFacility_Type.RES_BLD_OutdoorFacility_TypeID;
item.Name = outdoorFacility_Type.OutdoorFacilityType_Name;
item.Description = outdoorFacility_Type.OutdoorFacilityType_Description;
outdoorFacility_Types.Add(item);
}
returnValue.Result.OutdoorFacility_Types = outdoorFacility_Types.ToArray();
#endregion
#region OutdoorFacility_AccessRoadTypes
//OutdoorFacility_AccessRoadTypes
ORM_RES_BLD_OutdoorFacility_AccessRoadType.Query outdoorFacility_AccessRoadTypeQuery = new ORM_RES_BLD_OutdoorFacility_AccessRoadType.Query();
outdoorFacility_AccessRoadTypeQuery.Tenant_RefID = securityTicket.TenantID;
outdoorFacility_AccessRoadTypeQuery.IsDeleted = false;
List <ORM_RES_BLD_OutdoorFacility_AccessRoadType> outdoorFacility_AccessRoadTypeList = ORM_RES_BLD_OutdoorFacility_AccessRoadType.Query.Search(Connection, Transaction, outdoorFacility_AccessRoadTypeQuery);
List <L5SP_GABPTFT_1244_OutdoorFacility_AccessRoadTypes> outdoorFacility_AccessRoadTypes = new List <L5SP_GABPTFT_1244_OutdoorFacility_AccessRoadTypes>();
foreach (var outdoorFacility_AccessRoadType in outdoorFacility_AccessRoadTypeList)
{
L5SP_GABPTFT_1244_OutdoorFacility_AccessRoadTypes item = new L5SP_GABPTFT_1244_OutdoorFacility_AccessRoadTypes();
item.RES_BLD_OutdoorFacility_AccessRoadTypeID = outdoorFacility_AccessRoadType.RES_BLD_OutdoorFacility_AccessRoadTypeID;
item.Name = outdoorFacility_AccessRoadType.AccessRoadType_Name;
item.GlobalPropertyMatchingID = outdoorFacility_AccessRoadType.GlobalPropertyMatchingID;
outdoorFacility_AccessRoadTypes.Add(item);
}
returnValue.Result.OutdoorFacility_AccessRoadTypes = outdoorFacility_AccessRoadTypes.ToArray();
#endregion
#region OutdoorFacility_FenceTypes
//OutdoorFacility_FenceTypes
ORM_RES_BLD_OutdoorFacility_FenceType.Query outdoorFacility_FenceTypeQuery = new ORM_RES_BLD_OutdoorFacility_FenceType.Query();
outdoorFacility_FenceTypeQuery.Tenant_RefID = securityTicket.TenantID;
outdoorFacility_FenceTypeQuery.IsDeleted = false;
List <ORM_RES_BLD_OutdoorFacility_FenceType> outdoorFacility_FenceTypeList = ORM_RES_BLD_OutdoorFacility_FenceType.Query.Search(Connection, Transaction, outdoorFacility_FenceTypeQuery);
List <L5SP_GABPTFT_1244_OutdoorFacility_FenceTypes> outdoorFacility_FenceTypes = new List <L5SP_GABPTFT_1244_OutdoorFacility_FenceTypes>();
foreach (var outdoorFacility_FenceType in outdoorFacility_FenceTypeList)
{
L5SP_GABPTFT_1244_OutdoorFacility_FenceTypes item = new L5SP_GABPTFT_1244_OutdoorFacility_FenceTypes();
item.RES_BLD_OutdoorFacility_FenceTypeID = outdoorFacility_FenceType.RES_BLD_OutdoorFacility_FenceTypeID;
item.Name = outdoorFacility_FenceType.FenceType_Name;
item.GlobalPropertyMatchingID = outdoorFacility_FenceType.GlobalPropertyMatchingID;
outdoorFacility_FenceTypes.Add(item);
}
returnValue.Result.OutdoorFacility_FenceTypes = outdoorFacility_FenceTypes.ToArray();
#endregion
#region Basement_Types
//Basement_Types
ORM_RES_BLD_Basement_Type.Query basement_TypeQuery = new ORM_RES_BLD_Basement_Type.Query();
basement_TypeQuery.Tenant_RefID = securityTicket.TenantID;
basement_TypeQuery.IsDeleted = false;
List <ORM_RES_BLD_Basement_Type> basement_TypeList = ORM_RES_BLD_Basement_Type.Query.Search(Connection, Transaction, basement_TypeQuery);
List <L5SP_GABPTFT_1244_Basement_Types> basement_Types = new List <L5SP_GABPTFT_1244_Basement_Types>();
foreach (var basement_Type in basement_TypeList)
{
L5SP_GABPTFT_1244_Basement_Types item = new L5SP_GABPTFT_1244_Basement_Types();
item.RES_BLD_Basement_TypeID = basement_Type.RES_BLD_Basement_TypeID;
item.Name = basement_Type.BasementType_Name;
item.Description = basement_Type.BasementType_Description;
basement_Types.Add(item);
}
returnValue.Result.Basement_Types = basement_Types.ToArray();
#endregion
#region Basement_FloorTypes
//Basement_FloorTypes
ORM_RES_BLD_Basement_FloorType.Query basement_FloorTypeQuery = new ORM_RES_BLD_Basement_FloorType.Query();
basement_FloorTypeQuery.Tenant_RefID = securityTicket.TenantID;
basement_FloorTypeQuery.IsDeleted = false;
List <ORM_RES_BLD_Basement_FloorType> basement_FloorTypeList = ORM_RES_BLD_Basement_FloorType.Query.Search(Connection, Transaction, basement_FloorTypeQuery);
List <L5SP_GABPTFT_1244_Basement_FloorTypes> basement_FloorTypes = new List <L5SP_GABPTFT_1244_Basement_FloorTypes>();
foreach (var basement_FloorType in basement_FloorTypeList)
{
L5SP_GABPTFT_1244_Basement_FloorTypes item = new L5SP_GABPTFT_1244_Basement_FloorTypes();
item.RES_BLD_Basement_FloorTypeID = basement_FloorType.RES_BLD_Basement_FloorTypeID;
item.Name = basement_FloorType.FloorType_Name;
item.GlobalPropertyMatchingID = basement_FloorType.GlobalPropertyMatchingID;
basement_FloorTypes.Add(item);
}
returnValue.Result.Basement_FloorTypes = basement_FloorTypes.ToArray();
#endregion
#region Attic_Types
//Attic_Types
ORM_RES_BLD_Attic_Type.Query attic_TypeQuery = new ORM_RES_BLD_Attic_Type.Query();
attic_TypeQuery.Tenant_RefID = securityTicket.TenantID;
attic_TypeQuery.IsDeleted = false;
List <ORM_RES_BLD_Attic_Type> attic_TypeList = ORM_RES_BLD_Attic_Type.Query.Search(Connection, Transaction, attic_TypeQuery);
List <L5SP_GABPTFT_1244_Attic_Types> attic_Types = new List <L5SP_GABPTFT_1244_Attic_Types>();
foreach (var attic_Type in attic_TypeList)
{
L5SP_GABPTFT_1244_Attic_Types item = new L5SP_GABPTFT_1244_Attic_Types();
item.RES_BLD_Attic_TypeID = attic_Type.RES_BLD_Attic_TypeID;
item.Name = attic_Type.AtticType_Name;
item.Description = attic_Type.AtticType_Description;
attic_Types.Add(item);
}
returnValue.Result.Attic_Types = attic_Types.ToArray();
#endregion
#region Facade_Types
//Facade_Types
ORM_RES_BLD_Facade_Type.Query facade_TypeQuery = new ORM_RES_BLD_Facade_Type.Query();
facade_TypeQuery.Tenant_RefID = securityTicket.TenantID;
facade_TypeQuery.IsDeleted = false;
List <ORM_RES_BLD_Facade_Type> facade_TypeList = ORM_RES_BLD_Facade_Type.Query.Search(Connection, Transaction, facade_TypeQuery);
List <L5SP_GABPTFT_1244_Facade_Types> facade_Types = new List <L5SP_GABPTFT_1244_Facade_Types>();
foreach (var facade_Type in facade_TypeList)
{
L5SP_GABPTFT_1244_Facade_Types item = new L5SP_GABPTFT_1244_Facade_Types();
item.RES_BLD_Facade_TypeID = facade_Type.RES_BLD_Facade_TypeID;
item.Name = facade_Type.FacadeType_Name;
item.Description = facade_Type.FacadeType_Description;
facade_Types.Add(item);
}
returnValue.Result.Facade_Types = facade_Types.ToArray();
#endregion
#region RoofType
//RoofType
ORM_RES_BLD_RoofType.Query roof_TypeQuery = new ORM_RES_BLD_RoofType.Query();
roof_TypeQuery.Tenant_RefID = securityTicket.TenantID;
roof_TypeQuery.IsDeleted = false;
List <ORM_RES_BLD_RoofType> roof_TypeList = ORM_RES_BLD_RoofType.Query.Search(Connection, Transaction, roof_TypeQuery);
List <L5SP_GABPTFT_1244_RoofType> roof_Types = new List <L5SP_GABPTFT_1244_RoofType>();
foreach (var roof_Type in roof_TypeList)
{
L5SP_GABPTFT_1244_RoofType item = new L5SP_GABPTFT_1244_RoofType();
item.RES_BLD_RoofTypeID = roof_Type.RES_BLD_RoofTypeID;
item.Name = roof_Type.RoofType_Name;
item.Description = roof_Type.RoofType_Dictionary;
roof_Types.Add(item);
}
returnValue.Result.RoofType = roof_Types.ToArray();
#endregion
#region Staircase_Types
//Staircase_Types
ORM_RES_BLD_Staircase_Type.Query staircase_TypeQuery = new ORM_RES_BLD_Staircase_Type.Query();
staircase_TypeQuery.Tenant_RefID = securityTicket.TenantID;
staircase_TypeQuery.IsDeleted = false;
List <ORM_RES_BLD_Staircase_Type> staircase_TypeList = ORM_RES_BLD_Staircase_Type.Query.Search(Connection, Transaction, staircase_TypeQuery);
List <L5SP_GABPTFT_1244_Staircase_Types> staircase_Types = new List <L5SP_GABPTFT_1244_Staircase_Types>();
foreach (var staircase_Type in staircase_TypeList)
{
L5SP_GABPTFT_1244_Staircase_Types item = new L5SP_GABPTFT_1244_Staircase_Types();
item.RES_BLD_Staircase_TypeID = staircase_Type.RES_BLD_Staircase_TypeID;
item.Name = staircase_Type.StaircaseType_Name;
item.Description = staircase_Type.StaircaseType_Description;
staircase_Types.Add(item);
}
returnValue.Result.Staircase_Types = staircase_Types.ToArray();
#endregion
#region HVACR_Types
//HVACR_Types
ORM_RES_BLD_HVACR_Type.Query hvacr_TypeQuery = new ORM_RES_BLD_HVACR_Type.Query();
hvacr_TypeQuery.Tenant_RefID = securityTicket.TenantID;
hvacr_TypeQuery.IsDeleted = false;
List <ORM_RES_BLD_HVACR_Type> hvacr_TypeList = ORM_RES_BLD_HVACR_Type.Query.Search(Connection, Transaction, hvacr_TypeQuery);
List <L5SP_GABPTFT_1244_HVACR_Types> hvacr_Types = new List <L5SP_GABPTFT_1244_HVACR_Types>();
foreach (var hvacr_Type in hvacr_TypeList)
{
L5SP_GABPTFT_1244_HVACR_Types item = new L5SP_GABPTFT_1244_HVACR_Types();
item.RES_BLD_HVACR_TypeID = hvacr_Type.RES_BLD_HVACR_TypeID;
item.Name = hvacr_Type.HVACRType_Name;
item.Description = hvacr_Type.HVACRType_Description;
hvacr_Types.Add(item);
}
returnValue.Result.HVACR_Types = hvacr_Types.ToArray();
#endregion
return(returnValue);
#endregion UserCode
}