protected static FR_L6DD_GRGFRG_1006 Execute(DbConnection Connection, DbTransaction Transaction, P_L6DD_GRGFRG_1006 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6DD_GRGFRG_1006();
returnValue.Result = new L6DD_GRGFRG_1006();
P_L5DD_GDDFDD_1402 param = new P_L5DD_GDDFDD_1402();
param.RevisionGroupID = Parameter.RevisionGroupID;
returnValue.Result.RevisionGroup = cls_Get_DueDiligence_For_DueDiligenceID.Invoke(Connection, Transaction, param, securityTicket).Result;
P_L6DD_GRFRG_1005 buildingsParam = new P_L6DD_GRFRG_1005();
buildingsParam.RevisionGroupID = Parameter.RevisionGroupID;
returnValue.Result.Revisions = cls_Get_Revisions_For_RevisionGroupID.Invoke(Connection, Transaction, buildingsParam, securityTicket).Result;
return(returnValue);
#endregion UserCode
}
protected static FR_L6DD_GRFRG_1005_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L6DD_GRFRG_1005 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6DD_GRFRG_1005_Array();
List <L6DD_GRFRG_1005> buildingList = new List <L6DD_GRFRG_1005>();
P_L5BD_GBFRG_1005 param = new P_L5BD_GBFRG_1005();
param.RevisionGroupID = Parameter.RevisionGroupID;
L5BD_GBFRG_1005[] buildings = cls_Get_Buildings_For_RevisionGroupID.Invoke(Connection, Transaction, param, securityTicket).Result;
foreach (var currentBuilding in buildings)
{
L6DD_GRFRG_1005 revision = new L6DD_GRFRG_1005();
revision.Building = currentBuilding;
P_L5QT_GDDQFQ_1507 questionnaireParam = new P_L5QT_GDDQFQ_1507();
questionnaireParam.QuestionnaireVersionID = currentBuilding.QuestionnaireVersion_RefID;
var result = cls_Get_DueDiligence_Questionnaire_For_QuestionnaireID.Invoke(Connection, Transaction, questionnaireParam, securityTicket);
if (result == null)
{
continue;
}
else
{
revision.Questionnaire = result.Result;
}
List <L5DD_GASIfRID_1007> appartments = new List <L5DD_GASIfRID_1007>();
foreach (var bldApartment in currentBuilding.Apartments)
{
P_L5DD_GASIfRID_1007 builidingPartParam = new P_L5DD_GASIfRID_1007();
builidingPartParam.BuildingPartID = bldApartment.RES_BLD_ApartmentID;
builidingPartParam.BuildingPartID_IsSpecified = true;
builidingPartParam.RevisionID = currentBuilding.RES_DUD_RevisionID;
L5DD_GASIfRID_1007[] apartment = cls_Get_ApartmentSubmisionInfo_For_RevisionID.Invoke(Connection, Transaction, builidingPartParam, securityTicket).Result;
if (apartment.Length != 0)
{
appartments.Add(apartment[0]);
}
}
List <L5DD_GATTSIFRID_1411> attics = new List <L5DD_GATTSIFRID_1411>();
foreach (var bldAttic in currentBuilding.Attics)
{
P_L5DD_GATTSIFRID_1411 builidingPartParam = new P_L5DD_GATTSIFRID_1411();
builidingPartParam.BuildingPartID = bldAttic.RES_BLD_AtticID;
builidingPartParam.BuildingPartID_IsSpecified = true;
builidingPartParam.RevisionID = currentBuilding.RES_DUD_RevisionID;
L5DD_GATTSIFRID_1411[] attic = cls_Get_AtticSubmisionInfo_For_RevisionID.Invoke(Connection, Transaction, builidingPartParam, securityTicket).Result;
if (attic.Length != 0)
{
attics.Add(attic[0]);
}
}
List <L5DD_GBSIfRID_1431> basements = new List <L5DD_GBSIfRID_1431>();
foreach (var bldBasement in currentBuilding.Basements)
{
P_L5DD_GBSIfRID_1431 builidingPartParam = new P_L5DD_GBSIfRID_1431();
builidingPartParam.BuildingPartID = bldBasement.RES_BLD_BasementID;
builidingPartParam.BuildingPartID_IsSpecified = true;
builidingPartParam.RevisionID = currentBuilding.RES_DUD_RevisionID;
L5DD_GBSIfRID_1431[] basement = cls_Get_BasementSubmisionInfo_For_RevisionID.Invoke(Connection, Transaction, builidingPartParam, securityTicket).Result;
if (basement.Length != 0)
{
basements.Add(basement[0]);
}
}
List <L5DD_GFSIfRID_1438> facades = new List <L5DD_GFSIfRID_1438>();
foreach (var bldFacade in currentBuilding.Facades)
{
P_L5DD_GFSIfRID_1438 builidingPartParam = new P_L5DD_GFSIfRID_1438();
builidingPartParam.BuildingPartID = bldFacade.RES_BLD_FacadeID;
builidingPartParam.BuildingPartID_IsSpecified = true;
builidingPartParam.RevisionID = currentBuilding.RES_DUD_RevisionID;
L5DD_GFSIfRID_1438[] facade = cls_Get_FacadeSubmisionInfo_For_RevisionID.Invoke(Connection, Transaction, builidingPartParam, securityTicket).Result;
if (facade.Length != 0)
{
facades.Add(facade[0]);
}
}
List <L5DD_GHSIfRID_1448> hvacrs = new List <L5DD_GHSIfRID_1448>();
foreach (var bldHVACR in currentBuilding.HVACRs)
{
P_L5DD_GHSIfRID_1448 builidingPartParam = new P_L5DD_GHSIfRID_1448();
builidingPartParam.BuildingPartID = bldHVACR.RES_BLD_HVACRID;
builidingPartParam.BuildingPartID_IsSpecified = true;
builidingPartParam.RevisionID = currentBuilding.RES_DUD_RevisionID;
L5DD_GHSIfRID_1448[] hvacr = cls_Get_HVACRSubmisionInfo_For_RevisionID.Invoke(Connection, Transaction, builidingPartParam, securityTicket).Result;
if (hvacr.Length != 0)
{
hvacrs.Add(hvacr[0]);
}
}
List <L5DD_GOFSIfRID_1454> outdoors = new List <L5DD_GOFSIfRID_1454>();
foreach (var bldOutdoor in currentBuilding.OutdoorFacilities)
{
P_L5DD_GOFSIfRID_1454 builidingPartParam = new P_L5DD_GOFSIfRID_1454();
builidingPartParam.BuildingPartID = bldOutdoor.RES_BLD_OutdoorFacilityID;
builidingPartParam.BuildingPartID_IsSpecified = true;
builidingPartParam.RevisionID = currentBuilding.RES_DUD_RevisionID;
L5DD_GOFSIfRID_1454[] outdoor = cls_Get_OutdoorFascilitySubmisionInfo_For_RevisionID.Invoke(Connection, Transaction, builidingPartParam, securityTicket).Result;
if (outdoor.Length != 0)
{
outdoors.Add(outdoor[0]);
}
}
List <L5DD_GRSIfRID_1213> roofs = new List <L5DD_GRSIfRID_1213>();
foreach (var bldRoof in currentBuilding.Roofs)
{
P_L5DD_GRSIfRID_1213 builidingPartParam = new P_L5DD_GRSIfRID_1213();
builidingPartParam.BuildingPartID = bldRoof.RES_BLD_RoofID;
builidingPartParam.BuildingPartID_IsSpecified = true;
builidingPartParam.RevisionID = currentBuilding.RES_DUD_RevisionID;
L5DD_GRSIfRID_1213[] roof = cls_Get_RoofSubmisionInfo_For_RevisionID.Invoke(Connection, Transaction, builidingPartParam, securityTicket).Result;
if (roof.Length != 0)
{
roofs.Add(roof[0]);
}
}
List <L5DD_GASIfRID_1507> staircases = new List <L5DD_GASIfRID_1507>();
foreach (var bldStaircase in currentBuilding.Staircases)
{
P_L5DD_GASIfRID_1507 builidingPartParam = new P_L5DD_GASIfRID_1507();
builidingPartParam.BuildingPartID = bldStaircase.RES_BLD_StaircaseID;
builidingPartParam.BuildingPartID_IsSpecified = true;
builidingPartParam.RevisionID = currentBuilding.RES_DUD_RevisionID;
L5DD_GASIfRID_1507[] staircase = cls_Get_StaircaseSubmisionInfo_For_RevisionID.Invoke(Connection, Transaction, builidingPartParam, securityTicket).Result;
if (staircase.Length != 0)
{
staircases.Add(staircase[0]);
}
}
revision.Properties = new L5BD_GCBIFR_1005_Properties();
revision.Properties.Apartments = appartments.ToArray();
revision.Properties.Attics = attics.ToArray();
revision.Properties.Basements = basements.ToArray();
revision.Properties.Facades = facades.ToArray();
revision.Properties.HVACRs = hvacrs.ToArray();
revision.Properties.Roofs = roofs.ToArray();
revision.Properties.OutdoorFacilities = outdoors.ToArray();
revision.Properties.Staircases = staircases.ToArray();
buildingList.Add(revision);
}
returnValue.Result = buildingList.ToArray();
return(returnValue);
#endregion UserCode
}
///<summary>
/// Invokes the method for the given Connection, and Transaction, leaving them open/not commited if no exceptions occured
///<summary>
public static FR_L6DD_GRFRG_1005_Array Invoke(DbConnection Connection, DbTransaction Transaction, P_L6DD_GRFRG_1005 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
return(Invoke(Connection, Transaction, null, Parameter, securityTicket));
}
///<summary>
/// Method Invocation of wrapper classes
///<summary>
protected static FR_L6DD_GRFRG_1005_Array Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L6DD_GRFRG_1005 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
bool cleanupConnection = Connection == null;
bool cleanupTransaction = Transaction == null;
FR_L6DD_GRFRG_1005_Array functionReturn = new FR_L6DD_GRFRG_1005_Array();
try
{
if (cleanupConnection == true)
{
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
if (cleanupTransaction == true)
{
Transaction = Connection.BeginTransaction();
}
functionReturn = Execute(Connection, Transaction, Parameter, 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 new Exception("Exception occured in method cls_Get_Revisions_For_RevisionGroupID", ex);
}
return(functionReturn);
}
///<summary>
/// Opens the connection/transaction for the given connectionString, and closes them when complete
///<summary>
public static FR_L6DD_GRFRG_1005_Array Invoke(string ConnectionString, P_L6DD_GRFRG_1005 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
return(Invoke(null, null, ConnectionString, Parameter, securityTicket));
}
