protected static FR_L5TW_GTWFP_1326 Execute(DbConnection Connection, DbTransaction Transaction, P_L5TW_GTWFP_1326 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L5TW_GTWFP_1326(); ORM_CMN_STR_Profession.Query professionQuery = new ORM_CMN_STR_Profession.Query(); professionQuery.CMN_STR_ProfessionID = Parameter.CMN_STR_ProfessionID; professionQuery.IsDeleted = false; professionQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_STR_Profession> professions = ORM_CMN_STR_Profession.Query.Search(Connection, Transaction, professionQuery); if (professions != null && professions.Count != 0) { L5TW_GTWFT_1327 professionItem = new L5TW_GTWFT_1327(); ORM_CMN_STR_Profession profession = professions[0]; professionItem.CMN_STR_ProfessionID = profession.CMN_STR_ProfessionID; professionItem.ProfessionName = profession.ProfessionName; professionItem.GlobalPropertyMatchingID = profession.GlobalPropertyMatchingID; ORM_CMN_STR_ProfessionKey.Query professionKeyQuery = new ORM_CMN_STR_ProfessionKey.Query(); professionKeyQuery.CMN_STR_Profession_RefID = Parameter.CMN_STR_ProfessionID; professionKeyQuery.IsDeleted = false; professionKeyQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_STR_ProfessionKey> professionKeys = ORM_CMN_STR_ProfessionKey.Query.Search(Connection, Transaction, professionKeyQuery); if (professionKeys.Count != 0) { ORM_CMN_STR_ProfessionKey professionKey = professionKeys[0]; professionItem.SocialSecurityProfessionKey = professionKey.SocialSecurityProfessionKey; ORM_CMN_EconomicRegion.Query economicRegionQuery = new ORM_CMN_EconomicRegion.Query(); economicRegionQuery.CMN_EconomicRegionID = professionKey.CMN_EconomicRegion_RefID; economicRegionQuery.IsDeleted = false; economicRegionQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_EconomicRegion> economicRegions = ORM_CMN_EconomicRegion.Query.Search(Connection, Transaction, economicRegionQuery); if (economicRegions.Count != 0) { ORM_CMN_EconomicRegion economicRegion = economicRegions[0]; ORM_CMN_Country_2_EconomicRegion.Query economicRegionToCountryQuery = new ORM_CMN_Country_2_EconomicRegion.Query(); economicRegionToCountryQuery.CMN_EconomicRegion_RefID = economicRegion.CMN_EconomicRegionID; economicRegionToCountryQuery.IsDeleted = false; economicRegionToCountryQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_Country_2_EconomicRegion> economicRegionToCountries = ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, economicRegionToCountryQuery); if (economicRegionToCountries.Count != 0) { ORM_CMN_Country_2_EconomicRegion economicRegionToCountry = economicRegionToCountries[0]; ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.CMN_CountryID = economicRegionToCountry.CMN_Country_RefID; countryQuery.IsDeleted = false; countryQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_Country> countries = ORM_CMN_Country.Query.Search(Connection, Transaction, countryQuery); if (countries.Count != 0) { professionItem.Country_ISOCode_Alpha2 = countries[0].Country_ISOCode_Alpha2; } } } } returnValue.Result = new L5TW_GTWFP_1326(); returnValue.Result.TypeOfWork = professionItem; } //Put your code here 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_L5TW_GTWFP_1326 Invoke(DbConnection Connection, DbTransaction Transaction, P_L5TW_GTWFP_1326 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(Connection, Transaction, null, Parameter, securityTicket)); }
///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_L5TW_GTWFP_1326 Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L5TW_GTWFP_1326 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_L5TW_GTWFP_1326 functionReturn = new FR_L5TW_GTWFP_1326(); 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 { } Guid errorID = Guid.NewGuid(); ServerLog.Instance.Fatal("Application error occured. ErrorID = " + errorID, ex); throw new Exception("Exception occured in method cls_Get_TypeOfWork_For_ProfessionID", ex); } return(functionReturn); }
///<summary> /// Opens the connection/transaction for the given connectionString, and closes them when complete ///<summary> public static FR_L5TW_GTWFP_1326 Invoke(string ConnectionString, P_L5TW_GTWFP_1326 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(null, null, ConnectionString, Parameter, securityTicket)); }