///<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 }