///<summary>
/// Method Invocation of wrapper classes
///<summary>
protected static FR_L6DD_GRGIfRPI_1752_Array Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L6DD_GRGIfRPI_1752 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
bool cleanupConnection = Connection == null;
bool cleanupTransaction = Transaction == null;
FR_L6DD_GRGIfRPI_1752_Array functionReturn = new FR_L6DD_GRGIfRPI_1752_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_RevisionGroupInformation_for_RealestatePropertyID", ex);
}
return(functionReturn);
}
protected static FR_L6DD_GRGIfRPI_1752_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L6DD_GRGIfRPI_1752 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6DD_GRGIfRPI_1752_Array();
//Put your code here
var revisionGroupList = new List <L6DD_GRGIfRPI_1752>();
var ormRevisionGroups = ORM_RES_DUD_RevisionGroup.Query.Search(Connection, Transaction, new ORM_RES_DUD_RevisionGroup.Query()
{
IsDeleted = false,
RealestateProperty_RefID = Parameter.RealestatePropertyID,
Tenant_RefID = securityTicket.TenantID
});
foreach (var revGroup in ormRevisionGroups)
{
var revisionGroup = new L6DD_GRGIfRPI_1752();
revisionGroup.Comment = revGroup.RevisionGroup_Comment;
revisionGroup.CreationTimestamp = revGroup.Creation_Timestamp;
revisionGroup.Name = revGroup.RevisionGroup_Name;
revisionGroup.SubmittedByAccount = revisionGroup.SubmittedByAccount;
revisionGroup.RealestatePropertyID = Parameter.RealestatePropertyID;
revisionGroup.RevisionGroupID = revGroup.RES_DUD_Revision_GroupID;
//Find address information
ORM_RES_RealestateProperty ormRealestateProperty = new ORM_RES_RealestateProperty();
ormRealestateProperty.Load(Connection, Transaction, revGroup.RealestateProperty_RefID);
ORM_CMN_LOC_Location ormLocation = new ORM_CMN_LOC_Location();
ormLocation.Load(Connection, Transaction, ormRealestateProperty.RealestateProperty_Location_RefID);
ORM_CMN_Address ormAddress = new ORM_CMN_Address();
ormAddress.Load(Connection, Transaction, ormLocation.Address_RefID);
revisionGroup.Street_Name = ormAddress.Street_Name;
revisionGroup.Street_Number = ormAddress.Street_Number;
revisionGroup.Country_Name = ormAddress.Country_Name;
revisionGroup.City_Name = ormAddress.City_Name;
revisionGroup.City_PostalCode = ormAddress.City_PostalCode;
revisionGroup.City_Region = ormAddress.City_Region;
var accountInformation = cls_Get_Account_PersonalInformation_for_AccountID.Invoke(Connection, Transaction, new P_L2AI_GAPIfAI_1627()
{
AccountRefID = revGroup.RevisionGroup_SubmittedBy_Account_RefID
}, securityTicket).Result;
revisionGroup.SubmittedByAccount_LastName = accountInformation.LastName;
revisionGroup.SubmittedByAccount_FirstName = accountInformation.FirstName;
var revisionList = new List <L6DD_GRGIfRPI_1752_Revision>();
var omrRevisions = ORM_RES_DUD_Revision.Query.Search(Connection, Transaction, new ORM_RES_DUD_Revision.Query()
{
IsDeleted = false,
RevisionGroup_RefID = revGroup.RES_DUD_Revision_GroupID,
Tenant_RefID = securityTicket.TenantID
});
foreach (var rev in omrRevisions)
{
var ormBuildings = ORM_RES_BLD_Building.Query.Search(Connection, Transaction, new ORM_RES_BLD_Building.Query()
{
IsDeleted = false,
RES_BLD_BuildingID = rev.RES_BLD_Building_RefID,
Tenant_RefID = securityTicket.TenantID
});
var revision = new L6DD_GRGIfRPI_1752_Revision();
revision.BuildingID = rev.RES_BLD_Building_RefID;
revision.RevisionID = rev.RES_DUD_RevisionID;
revision.RevisionTitle = rev.Revision_Title;
revision.BuildingName = ormBuildings[0].Building_Name;
revisionList.Add(revision);
}
revisionGroup.Revisions = revisionList.ToArray();
revisionGroupList.Add(revisionGroup);
}
returnValue.Result = revisionGroupList.ToArray();
return(returnValue);
#endregion UserCode
}
