protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3ER_SERAC_1621 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here ORM_CMN_EconomicRegion economicRegion = new ORM_CMN_EconomicRegion(); if (Parameter.CMN_EconomicRegionID != Guid.Empty) { var result = economicRegion.Load(Connection, Transaction, Parameter.CMN_EconomicRegionID); if (result.Status != FR_Status.Success || economicRegion.CMN_EconomicRegionID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.Country_ISOCode_Alpha2 = Parameter.Country_ISO; countryQuery.Tenant_RefID = securityTicket.TenantID; countryQuery.IsDeleted = false; ORM_CMN_Country country = ORM_CMN_Country.Query.Search(Connection, Transaction, countryQuery).FirstOrDefault(); if (Parameter.CMN_EconomicRegionID != Guid.Empty) { ORM_CMN_Country_2_EconomicRegion.Query country2EconomicRegionQuery = new ORM_CMN_Country_2_EconomicRegion.Query(); country2EconomicRegionQuery.CMN_EconomicRegion_RefID = Parameter.CMN_EconomicRegionID; country2EconomicRegionQuery.CMN_Country_RefID = country.CMN_CountryID; country2EconomicRegionQuery.IsDeleted = false; country2EconomicRegionQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, country2EconomicRegionQuery).Count != 0) { returnValue = new FR_Guid(Parameter.CMN_EconomicRegionID); return(returnValue); } } foreach (var content in country.Country_Name.Contents) { economicRegion.EconomicRegion_Description.UpdateEntry(content.LanguageID, content.Content); economicRegion.EconomicRegion_Name.UpdateEntry(content.LanguageID, content.Content); } economicRegion.IsEconomicRegionCountry = true; economicRegion.Tenant_RefID = securityTicket.TenantID; economicRegion.Save(Connection, Transaction); ORM_CMN_Country_2_EconomicRegion country2EconomicRegion = new ORM_CMN_Country_2_EconomicRegion(); country2EconomicRegion.CMN_Country_RefID = country.CMN_CountryID; country2EconomicRegion.CMN_EconomicRegion_RefID = economicRegion.CMN_EconomicRegionID; country2EconomicRegion.Tenant_RefID = securityTicket.TenantID; country2EconomicRegion.Save(Connection, Transaction); returnValue = new FR_Guid(economicRegion.CMN_EconomicRegionID); return(returnValue); #endregion UserCode }
private static string Get_CountryISO_For_SalaryType(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket, ORM_CMN_BPT_EMP_SalaryType salaryType) { string ISO = ""; ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion salaryEconomicRegion; ORM_CMN_EconomicRegion economicRegion; FR_Base economicRegionRes; ORM_CMN_Country_2_EconomicRegion countryEconomicRegion; ORM_CMN_Country country; FR_Base countryRes; salaryEconomicRegion = ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query.Search(Connection, Transaction, new ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, CMN_BPT_EMP_SalaryType_RefID = salaryType.CMN_BPT_EMP_SalaryTypeID }).FirstOrDefault(); if (salaryEconomicRegion == null) { return(""); } economicRegion = new ORM_CMN_EconomicRegion(); economicRegionRes = economicRegion.Load(Connection, Transaction, salaryEconomicRegion.CMN_EconomicRegion_RefID); if (economicRegionRes.Status != FR_Status.Success || economicRegion.CMN_EconomicRegionID == Guid.Empty) { return(""); } countryEconomicRegion = ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, new ORM_CMN_Country_2_EconomicRegion.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, CMN_EconomicRegion_RefID = economicRegion.CMN_EconomicRegionID }).FirstOrDefault(); if (countryEconomicRegion == null) { return(""); } country = new ORM_CMN_Country(); countryRes = country.Load(Connection, Transaction, countryEconomicRegion.CMN_Country_RefID); if (countryRes.Status != FR_Status.Success || country.CMN_CountryID == Guid.Empty) { return(""); } ISO = country.Country_ISOCode_Alpha2; return(ISO); }
protected static FR_L5RL_GRFT_0942_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5RL_GRFT_0942_Array(); List <L5RL_GRFT_0942> retValList = new List <L5RL_GRFT_0942>(); //Put your code here ORM_CMN_PER_Religion.Query religionQuery = new ORM_CMN_PER_Religion.Query(); religionQuery.Tenant_RefID = securityTicket.TenantID; religionQuery.IsDeleted = false; List <ORM_CMN_PER_Religion> religionList = ORM_CMN_PER_Religion.Query.Search(Connection, Transaction, religionQuery); ORM_CMN_PER_Religion_2_EconomicRegion religionEconomicRegion; ORM_CMN_EconomicRegion economicRegion; FR_Base economicRegionRes; ORM_CMN_Country_2_EconomicRegion countryEconomicRegion; ORM_CMN_Country country; FR_Base countryRes; L5RL_GRFT_0942 retValItem; foreach (var religion in religionList) { religionEconomicRegion = ORM_CMN_PER_Religion_2_EconomicRegion.Query.Search(Connection, Transaction, new ORM_CMN_PER_Religion_2_EconomicRegion.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, CMN_PER_Religion_RefID = religion.CMN_PER_ReligionID }).FirstOrDefault(); retValItem = new L5RL_GRFT_0942(); retValItem.CMN_PER_ReligionID = religion.CMN_PER_ReligionID; retValItem.GlobalPropertyMatchingID = religion.GlobalPropertyMatchingID; retValItem.Religion_Name = religion.Religion_Name; retValItem.Religion_Code = religionEconomicRegion != null ? religionEconomicRegion.Religion_Code : ""; if (religionEconomicRegion == null) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } economicRegion = new ORM_CMN_EconomicRegion(); economicRegionRes = economicRegion.Load(Connection, Transaction, religionEconomicRegion.CMN_EconomicRegion_RefID); if (economicRegionRes.Status != FR_Status.Success || economicRegion.CMN_EconomicRegionID == Guid.Empty) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } countryEconomicRegion = ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, new ORM_CMN_Country_2_EconomicRegion.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, CMN_EconomicRegion_RefID = economicRegion.CMN_EconomicRegionID }).FirstOrDefault(); if (countryEconomicRegion == null) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } country = new ORM_CMN_Country(); countryRes = country.Load(Connection, Transaction, countryEconomicRegion.CMN_Country_RefID); if (countryRes.Status != FR_Status.Success || country.CMN_CountryID == Guid.Empty) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } retValItem.Country_ISOCode_Alpha2 = country.Country_ISOCode_Alpha2; retValList.Add(retValItem); } returnValue.Result = retValList.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_L5CS_GCSSFT_1319_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L5CS_GCSSFT_1319_Array(); //Put your code here List <L5CS_GCSSFT_1319> retValList = new List <L5CS_GCSSFT_1319>(); ORM_CMN_PER_CompulsorySocialSecurityStatus.Query socialSecurityQuery = new ORM_CMN_PER_CompulsorySocialSecurityStatus.Query(); socialSecurityQuery.Tenant_RefID = securityTicket.TenantID; socialSecurityQuery.IsDeleted = false; List <ORM_CMN_PER_CompulsorySocialSecurityStatus> socialSecurityList = ORM_CMN_PER_CompulsorySocialSecurityStatus.Query.Search(Connection, Transaction, socialSecurityQuery); ORM_CMN_EconomicRegion economicRegion; FR_Base economicRegionRes; ORM_CMN_Country_2_EconomicRegion countryEconomicRegion; ORM_CMN_Country country; FR_Base countryRes; L5CS_GCSSFT_1319 retValItem; foreach (var socialSecurity in socialSecurityList) { retValItem = new L5CS_GCSSFT_1319(); retValItem.CMN_EconomicRegion_RefID = socialSecurity.CMN_EconomicRegion_RefID; retValItem.CMN_PER_CompulsorySocialSecurityStatusID = socialSecurity.CMN_PER_CompulsorySocialSecurityStatusID; retValItem.GlobalPropertyMatchingID = socialSecurity.GlobalPropertyMatchingID; retValItem.SocialSecurityStatus_Code = socialSecurity.SocialSecurityStatus_Code; retValItem.SocialSecurityStatus_Description = socialSecurity.SocialSecurityStatus_Description; retValItem.SocialSecurityStatus_Name = socialSecurity.SocialSecurityStatus_Name; economicRegion = new ORM_CMN_EconomicRegion(); economicRegionRes = economicRegion.Load(Connection, Transaction, socialSecurity.CMN_EconomicRegion_RefID); if (economicRegionRes.Status != FR_Status.Success || economicRegion.CMN_EconomicRegionID == Guid.Empty) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } countryEconomicRegion = ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, new ORM_CMN_Country_2_EconomicRegion.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, CMN_EconomicRegion_RefID = economicRegion.CMN_EconomicRegionID }).FirstOrDefault(); if (countryEconomicRegion == null) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } country = new ORM_CMN_Country(); countryRes = country.Load(Connection, Transaction, countryEconomicRegion.CMN_Country_RefID); if (countryRes.Status != FR_Status.Success || country.CMN_CountryID == Guid.Empty) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } retValItem.Country_ISOCode_Alpha2 = country.Country_ISOCode_Alpha2; retValList.Add(retValItem); } returnValue.Result = retValList.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_L5TS_GTOSFT_1419_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L5TS_GTOSFT_1419_Array(); //Put your code here List <L5TS_GTOSFT_1419> retValList = new List <L5TS_GTOSFT_1419>(); ORM_CMN_BPT_EMP_SalaryType.Query salaryTypeQuery = new ORM_CMN_BPT_EMP_SalaryType.Query(); salaryTypeQuery.Tenant_RefID = securityTicket.TenantID; salaryTypeQuery.IsDeleted = false; List <ORM_CMN_BPT_EMP_SalaryType> salaryTypeList = ORM_CMN_BPT_EMP_SalaryType.Query.Search(Connection, Transaction, salaryTypeQuery); ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion salaryEconomicRegion; ORM_CMN_EconomicRegion economicRegion; FR_Base economicRegionRes; ORM_CMN_Country_2_EconomicRegion countryEconomicRegion; ORM_CMN_Country country; FR_Base countryRes; L5TS_GTOSFT_1419 retValItem; foreach (var salaryType in salaryTypeList) { salaryEconomicRegion = ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query.Search(Connection, Transaction, new ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, CMN_BPT_EMP_SalaryType_RefID = salaryType.CMN_BPT_EMP_SalaryTypeID }).FirstOrDefault(); retValItem = new L5TS_GTOSFT_1419(); retValItem.CMN_BPT_EMP_SalaryTypeID = salaryType.CMN_BPT_EMP_SalaryTypeID; retValItem.GlobalPropertyMatchingID = salaryType.GlobalPropertyMatchingID; retValItem.SalaryType_Code = salaryEconomicRegion != null ? salaryEconomicRegion.SalaryType_Code : ""; retValItem.SalaryType_Name = salaryType.SalaryType_Name; retValItem.SalaryTypeStatus = salaryType.SalaryTypeStatus; if (salaryEconomicRegion == null) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } economicRegion = new ORM_CMN_EconomicRegion(); economicRegionRes = economicRegion.Load(Connection, Transaction, salaryEconomicRegion.CMN_EconomicRegion_RefID); if (economicRegionRes.Status != FR_Status.Success || economicRegion.CMN_EconomicRegionID == Guid.Empty) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } countryEconomicRegion = ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, new ORM_CMN_Country_2_EconomicRegion.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, CMN_EconomicRegion_RefID = economicRegion.CMN_EconomicRegionID }).FirstOrDefault(); if (countryEconomicRegion == null) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } country = new ORM_CMN_Country(); countryRes = country.Load(Connection, Transaction, countryEconomicRegion.CMN_Country_RefID); if (countryRes.Status != FR_Status.Success || country.CMN_CountryID == Guid.Empty) { retValItem.Country_ISOCode_Alpha2 = ""; retValList.Add(retValItem); continue; } retValItem.Country_ISOCode_Alpha2 = country.Country_ISOCode_Alpha2; retValList.Add(retValItem); } returnValue.Result = retValList.ToArray(); return(returnValue); #endregion UserCode }