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 }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5CS_SCSS_1318 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new ORM_CMN_PER_CompulsorySocialSecurityStatus(); if (Parameter.CMN_PER_CompulsorySocialSecurityStatusID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_PER_CompulsorySocialSecurityStatusID); if (result.Status != FR_Status.Success || item.CMN_PER_CompulsorySocialSecurityStatusID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } else { 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(); ORM_CMN_Country_2_EconomicRegion.Query country2EconomicRegionQuery = new ORM_CMN_Country_2_EconomicRegion.Query(); country2EconomicRegionQuery.CMN_Country_RefID = country.CMN_CountryID; country2EconomicRegionQuery.IsDeleted = false; country2EconomicRegionQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_Country_2_EconomicRegion> country2EconomicRegion = ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, country2EconomicRegionQuery); Guid economicRegionID; if (country2EconomicRegion.Count == 0) { P_L3ER_SERAC_1621 param = new P_L3ER_SERAC_1621(); param.Country_ISO = Parameter.Country_ISO; economicRegionID = cls_Save_EconomicRegion_As_Country.Invoke(Connection, Transaction, param, securityTicket).Result; } else { economicRegionID = country2EconomicRegion.FirstOrDefault().CMN_EconomicRegion_RefID; } item.CMN_EconomicRegion_RefID = economicRegionID; } item.SocialSecurityStatus_Name = Parameter.SocialSecurityStatus_Name; item.SocialSecurityStatus_Description = Parameter.SocialSecurityStatus_Description; item.GlobalPropertyMatchingID = Parameter.GlobalPropertyMatchingID; item.SocialSecurityStatus_Code = Parameter.SocialSecurityStatus_Code; item.Tenant_RefID = securityTicket.TenantID; item.Save(Connection, Transaction); returnValue.Result = item.CMN_PER_CompulsorySocialSecurityStatusID; //Put your code here return(returnValue); #endregion UserCode }
protected static FR_L5TS_GTOSFC_1031 Execute(DbConnection Connection, DbTransaction Transaction, P_L5TS_GTOSFC_1031 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5TS_GTOSFC_1031(); returnValue.Result = new L5TS_GTOSFC_1031(); L5TS_GTOSFT_1419[] allTypes = cls_Get_TypesOfSalery_For_Tenant.Invoke(Connection, Transaction, securityTicket).Result; ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.Country_ISOCode_Alpha2 = Parameter.Country_ISO; countryQuery.IsDeleted = false; countryQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_Country country = ORM_CMN_Country.Query.Search(Connection, Transaction, countryQuery).FirstOrDefault(); ORM_CMN_Country_2_EconomicRegion.Query country2EconomicRegionQuery = new ORM_CMN_Country_2_EconomicRegion.Query(); country2EconomicRegionQuery.CMN_Country_RefID = country.CMN_CountryID; country2EconomicRegionQuery.IsDeleted = false; country2EconomicRegionQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_Country_2_EconomicRegion country2EconomicRegion = ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, country2EconomicRegionQuery).FirstOrDefault(); if (country2EconomicRegion == null) { return(returnValue); } ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query salaryType2EconomicRegionQuery = new ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query(); salaryType2EconomicRegionQuery.CMN_EconomicRegion_RefID = country2EconomicRegion.CMN_EconomicRegion_RefID; salaryType2EconomicRegionQuery.IsDeleted = false; salaryType2EconomicRegionQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion> listOfSalaryType2EconomicRegion = ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query.Search(Connection, Transaction, salaryType2EconomicRegionQuery); List <L5TS_GTOSFT_1419> resultTypes = new List <L5TS_GTOSFT_1419>(); if (allTypes != null) { foreach (var salaryType2EconomicRegion in listOfSalaryType2EconomicRegion) { resultTypes.Add(allTypes.FirstOrDefault(x => x.CMN_BPT_EMP_SalaryTypeID == salaryType2EconomicRegion.CMN_BPT_EMP_SalaryType_RefID)); } } else { return(returnValue); } returnValue.Result.TypesOfSalary = resultTypes.ToArray(); //Put your code here return(returnValue); #endregion UserCode }
protected static FR_L5RL_GRFC_1352 Execute(DbConnection Connection, DbTransaction Transaction, P_L5RL_GRFC_1352 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5RL_GRFC_1352(); returnValue.Result = new L5RL_GRFC_1352(); L5RL_GRFT_0942[] allReligions = cls_Get_Religions_For_Tenant.Invoke(Connection, Transaction, securityTicket).Result; ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.Country_ISOCode_Alpha2 = Parameter.Country_ISO; countryQuery.IsDeleted = false; countryQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_Country country = ORM_CMN_Country.Query.Search(Connection, Transaction, countryQuery).FirstOrDefault(); ORM_CMN_Country_2_EconomicRegion.Query country2EconomicRegionQuery = new ORM_CMN_Country_2_EconomicRegion.Query(); country2EconomicRegionQuery.CMN_Country_RefID = country.CMN_CountryID; country2EconomicRegionQuery.IsDeleted = false; country2EconomicRegionQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_Country_2_EconomicRegion country2EconomicRegion = ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, country2EconomicRegionQuery).FirstOrDefault(); if (country2EconomicRegion == null) { return(returnValue); } ORM_CMN_PER_Religion_2_EconomicRegion.Query religion2EconomicRegionQuery = new ORM_CMN_PER_Religion_2_EconomicRegion.Query(); religion2EconomicRegionQuery.CMN_EconomicRegion_RefID = country2EconomicRegion.CMN_EconomicRegion_RefID; religion2EconomicRegionQuery.IsDeleted = false; religion2EconomicRegionQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_PER_Religion_2_EconomicRegion> listOfReligion2EconomicRegion = ORM_CMN_PER_Religion_2_EconomicRegion.Query.Search(Connection, Transaction, religion2EconomicRegionQuery); List <L5RL_GRFT_0942> resultReligions = new List <L5RL_GRFT_0942>(); if (allReligions != null) { foreach (var religion2EconomicRegion in listOfReligion2EconomicRegion) { resultReligions.Add(allReligions.FirstOrDefault(x => x.CMN_PER_ReligionID == religion2EconomicRegion.CMN_PER_Religion_RefID)); } } else { return(returnValue); } returnValue.Result.Religion = resultReligions.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_L5CM_GCWRfT_0938_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5CM_GCWRfT_0938_Array(); //Put your code here ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.IsDeleted = false; countryQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_Country> countries = ORM_CMN_Country.Query.Search(Connection, Transaction, countryQuery); List <L5CM_GCWRfT_0938> countryList = new List <L5CM_GCWRfT_0938>(); foreach (var country in countries) { L5CM_GCWRfT_0938 item = new L5CM_GCWRfT_0938(); item.CMN_CountryID = country.CMN_CountryID; item.Country_ISOCode_Alpha2 = country.Country_ISOCode_Alpha2; item.Country_ISOCode_Alpha3 = country.Country_ISOCode_Alpha3; item.Country_ISOCode_Numeric = country.Country_ISOCode_Numeric; item.Country_Name = country.Country_Name; item.Default_Currency_RefID = country.Default_Currency_RefID; item.Default_Language_RefID = country.Default_Language_RefID; countryQuery = new ORM_CMN_Country.Query(); countryQuery.IsDeleted = false; countryQuery.Tenant_RefID = Guid.Empty; countryQuery.Country_ISOCode_Alpha2 = item.Country_ISOCode_Alpha2; countries = ORM_CMN_Country.Query.Search(Connection, Transaction, countryQuery); ORM_CMN_LOC_Region.Query regionsQuery = new ORM_CMN_LOC_Region.Query(); regionsQuery.IsDeleted = false; regionsQuery.Country_RefID = countries[0].CMN_CountryID; List <ORM_CMN_LOC_Region> regions = ORM_CMN_LOC_Region.Query.Search(Connection, Transaction, regionsQuery); List <L5CM_GCWRfT_0938_Region> regionList = new List <L5CM_GCWRfT_0938_Region>(); foreach (var region in regions) { L5CM_GCWRfT_0938_Region regionItem = new L5CM_GCWRfT_0938_Region(); regionItem.CMN_LOC_RegionID = region.CMN_LOC_RegionID; regionItem.Parent_RefID = region.Parent_RefID; regionItem.Region_Name = region.Region_Name; regionItem.RegionExternalID = region.RegionExternalID; regionList.Add(regionItem); } item.Regions = regionList.ToArray(); countryList.Add(item); } returnValue.Result = countryList.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5BK_SB_1320 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new ORM_ACC_BNK_Bank(); if (Parameter.ACC_BNK_BankID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.ACC_BNK_BankID); if (result.Status != FR_Status.Success || item.ACC_BNK_BankID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } item.BankName = Parameter.BankName; item.BankNumber = Parameter.BankNubmer; item.BICCode = Parameter.BICCode; item.RoutingNumber = Parameter.RoutingNumber; item.Tenant_RefID = securityTicket.TenantID; item.BankLocationComment = Parameter.BankLocationComment; ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.Country_ISOCode_Alpha2 = Parameter.Country_ISOCode_Alpha2; 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) { item.Country_RefID = countries[0].CMN_CountryID; } item.Save(Connection, Transaction); returnValue.Result = item.ACC_BNK_BankID; //Put your code here return(returnValue); #endregion UserCode }
protected static FR_L5BK_GBFBID_1447 Execute(DbConnection Connection, DbTransaction Transaction, P_L5BK_GBFBID_1447 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L5BK_GBFBID_1447(); returnValue.Result = new L5BK_GBFBID_1447(); ORM_ACC_BNK_Bank.Query bankQuery = new ORM_ACC_BNK_Bank.Query(); bankQuery.ACC_BNK_BankID = Parameter.ACC_BNK_BankID; bankQuery.Tenant_RefID = securityTicket.TenantID; bankQuery.IsDeleted = false; List <ORM_ACC_BNK_Bank> banks = ORM_ACC_BNK_Bank.Query.Search(Connection, Transaction, bankQuery); if (banks == null || banks.Count == 0) { returnValue.Result = null; } else { L5BK_GBFT_1318 bank = new L5BK_GBFT_1318(); bank.ACC_BNK_BankID = banks[0].ACC_BNK_BankID; bank.BankName = banks[0].BankName; bank.BankNumber = banks[0].BankNumber; bank.BICCode = banks[0].BICCode; bank.RoutingNumber = banks[0].RoutingNumber; bank.BankLocationComment = banks[0].BankLocationComment; returnValue.Result.Bank = bank; ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.CMN_CountryID = banks[0].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) { bank.Country_ISOCode_Alpha2 = countries[0].Country_ISOCode_Alpha2; } } //Put your code here return(returnValue); #endregion UserCode }
protected static FR_L5CS_GCSSFC_1544 Execute(DbConnection Connection,DbTransaction Transaction,P_L5CS_GCSSFC_1544 Parameter,CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null){ #region UserCode var returnValue = new FR_L5CS_GCSSFC_1544(); returnValue.Result = new L5CS_GCSSFC_1544(); L5CS_GCSSFT_1319[] allStatuses = cls_Get_CompulsorySocialSecurityStatuses_For_Tenant.Invoke(Connection, Transaction, securityTicket).Result; 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(); ORM_CMN_Country_2_EconomicRegion.Query country2EconomicRegionQuery = new ORM_CMN_Country_2_EconomicRegion.Query(); country2EconomicRegionQuery.CMN_Country_RefID = country.CMN_CountryID; country2EconomicRegionQuery.IsDeleted = false; country2EconomicRegionQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_Country_2_EconomicRegion country2EconomicRegion = ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, country2EconomicRegionQuery).FirstOrDefault(); if (country2EconomicRegion == null) return returnValue; List<L5CS_GCSSFT_1319> resultStatuses = new List<L5CS_GCSSFT_1319>(); foreach (var status in allStatuses) { if (status.CMN_EconomicRegion_RefID == country2EconomicRegion.CMN_EconomicRegion_RefID) resultStatuses.Add(status); } returnValue.Result.SocialSecurityStatuses = resultStatuses.ToArray(); return returnValue; #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5TS_STS_1503 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here var type = new ORM_CMN_BPT_EMP_SalaryType(); if (Parameter.CMN_BPT_EMP_SalaryTypeID != Guid.Empty) { var result = type.Load(Connection, Transaction, Parameter.CMN_BPT_EMP_SalaryTypeID); if (result.Status != FR_Status.Success || type.CMN_BPT_EMP_SalaryTypeID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } type.SalaryType_Name = Parameter.SalaryType_Name; type.GlobalPropertyMatchingID = Parameter.GlobalPropertyMatchingID; type.SalaryTypeStatus = Parameter.SalaryTypeStatus; type.Tenant_RefID = securityTicket.TenantID; type.Save(Connection, Transaction); returnValue.Result = type.CMN_BPT_EMP_SalaryTypeID; if (Parameter.Country_ISO != "") { 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(); ORM_CMN_Country_2_EconomicRegion.Query country2EconomicRegionQuery = new ORM_CMN_Country_2_EconomicRegion.Query(); country2EconomicRegionQuery.CMN_Country_RefID = country.CMN_CountryID; country2EconomicRegionQuery.IsDeleted = false; country2EconomicRegionQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_Country_2_EconomicRegion> country2EconomicRegion = ORM_CMN_Country_2_EconomicRegion.Query.Search(Connection, Transaction, country2EconomicRegionQuery); Guid economicRegionID; if (country2EconomicRegion.Count == 0) { P_L3ER_SERAC_1621 param = new P_L3ER_SERAC_1621(); param.Country_ISO = Parameter.Country_ISO; economicRegionID = cls_Save_EconomicRegion_As_Country.Invoke(Connection, Transaction, param, securityTicket).Result; } else { economicRegionID = country2EconomicRegion.FirstOrDefault().CMN_EconomicRegion_RefID; } if (Parameter.CMN_BPT_EMP_SalaryTypeID != Guid.Empty) { ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query salaryType2EconomicRegionQuery = new ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query(); salaryType2EconomicRegionQuery.CMN_BPT_EMP_SalaryType_RefID = type.CMN_BPT_EMP_SalaryTypeID; salaryType2EconomicRegionQuery.CMN_EconomicRegion_RefID = economicRegionID; salaryType2EconomicRegionQuery.IsDeleted = false; salaryType2EconomicRegionQuery.Tenant_RefID = securityTicket.TenantID; var existingSalaryType2EconomicRegion = ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query.Search(Connection, Transaction, salaryType2EconomicRegionQuery).FirstOrDefault(); if (existingSalaryType2EconomicRegion != null) { existingSalaryType2EconomicRegion.SalaryType_Code = Parameter.SalaryType_Code; existingSalaryType2EconomicRegion.Save(Connection, Transaction); } else { ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion salaryType2EconomicRegion = new ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion(); salaryType2EconomicRegion.CMN_BPT_EMP_SalaryType_RefID = type.CMN_BPT_EMP_SalaryTypeID; salaryType2EconomicRegion.CMN_EconomicRegion_RefID = economicRegionID; salaryType2EconomicRegion.SalaryType_Code = Parameter.SalaryType_Code; salaryType2EconomicRegion.Tenant_RefID = securityTicket.TenantID; salaryType2EconomicRegion.Save(Connection, Transaction); } } else { ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion salaryType2EconomicRegion = new ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion(); salaryType2EconomicRegion.CMN_BPT_EMP_SalaryType_RefID = type.CMN_BPT_EMP_SalaryTypeID; salaryType2EconomicRegion.CMN_EconomicRegion_RefID = economicRegionID; salaryType2EconomicRegion.SalaryType_Code = Parameter.SalaryType_Code; salaryType2EconomicRegion.Tenant_RefID = securityTicket.TenantID; salaryType2EconomicRegion.Save(Connection, Transaction); } } else if (Parameter.CMN_BPT_EMP_SalaryTypeID != Guid.Empty) { ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query salaryType2EconomicRegionQuery = new ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query(); salaryType2EconomicRegionQuery.CMN_BPT_EMP_SalaryType_RefID = type.CMN_BPT_EMP_SalaryTypeID; salaryType2EconomicRegionQuery.IsDeleted = false; salaryType2EconomicRegionQuery.Tenant_RefID = securityTicket.TenantID; var existingSalaryType2EconomicRegion = ORM_CMN_BPT_EMP_SalaryType_2_EconomicRegion.Query.Search(Connection, Transaction, salaryType2EconomicRegionQuery).FirstOrDefault(); if (existingSalaryType2EconomicRegion != null) { existingSalaryType2EconomicRegion.SalaryType_Code = Parameter.SalaryType_Code; existingSalaryType2EconomicRegion.Save(Connection, Transaction); } } return(returnValue); #endregion UserCode }
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 }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5TW_STW_1325 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new ORM_CMN_STR_Profession(); if (Parameter.CMN_STR_ProfessionID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_STR_ProfessionID); if (result.Status != FR_Status.Success || item.CMN_STR_ProfessionID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } item.GlobalPropertyMatchingID = Parameter.GlobalPropertyMatchingID; item.ProfessionName = Parameter.ProfessionName; item.Tenant_RefID = securityTicket.TenantID; item.Save(Connection, Transaction); ORM_CMN_STR_ProfessionKey.Query professionKeyQuery = new ORM_CMN_STR_ProfessionKey.Query(); professionKeyQuery.CMN_STR_Profession_RefID = item.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]; professionKey.SocialSecurityProfessionKey = Parameter.SocialSecurityProfessionKey; professionKey.Save(Connection, Transaction); } else { ORM_CMN_STR_ProfessionKey professionKey = new ORM_CMN_STR_ProfessionKey(); professionKey.SocialSecurityProfessionKey = Parameter.SocialSecurityProfessionKey; professionKey.CMN_STR_Profession_RefID = item.CMN_STR_ProfessionID; professionKey.Tenant_RefID = securityTicket.TenantID; ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.Country_ISOCode_Alpha2 = Parameter.Country_ISOCode_Alpha2; 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) { ORM_CMN_Country country = countries[0]; ORM_CMN_Country_2_EconomicRegion.Query economicRegionToCountryQuery = new ORM_CMN_Country_2_EconomicRegion.Query(); economicRegionToCountryQuery.CMN_Country_RefID = country.CMN_CountryID; 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_EconomicRegion.Query economicRegionQuery = new ORM_CMN_EconomicRegion.Query(); economicRegionQuery.CMN_EconomicRegionID = economicRegionToCountries[0].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) { professionKey.CMN_EconomicRegion_RefID = economicRegions[0].CMN_EconomicRegionID; } } else { ORM_CMN_Country_2_EconomicRegion economicRegionToCountry = new ORM_CMN_Country_2_EconomicRegion(); economicRegionToCountry.CMN_Country_RefID = country.CMN_CountryID; economicRegionToCountry.Tenant_RefID = securityTicket.TenantID; ORM_CMN_EconomicRegion economicRegion = new ORM_CMN_EconomicRegion(); economicRegion.IsEconomicRegionCountry = true; economicRegion.Tenant_RefID = securityTicket.TenantID; economicRegionToCountry.CMN_EconomicRegion_RefID = economicRegion.CMN_EconomicRegionID; economicRegion.Save(Connection, Transaction); economicRegionToCountry.Save(Connection, Transaction); professionKey.CMN_EconomicRegion_RefID = economicRegion.CMN_EconomicRegionID; } } professionKey.Save(Connection, Transaction); } returnValue.Result = item.CMN_STR_ProfessionID; return(returnValue); #endregion UserCode }
protected static FR_L5TN_STCL_1439 Execute(DbConnection Connection, DbTransaction Transaction, P_L5TN_STCL_1439 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5TN_STCL_1439(); returnValue.Result = new L5TN_STCL_1439(); List <L5CM_GCWRfT_0938> countriesResult = new List <L5CM_GCWRfT_0938>(); //Put your code here ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.IsDeleted = false; countryQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_Country> countryList = ORM_CMN_Country.Query.Search(Connection, Transaction, countryQuery); ORM_CMN_Country country; L5CM_GCWRfT_0938 countryResultItem; foreach (var countryWithoutTenant in Parameter.CountriesWithoutTenant) { bool isCountryWithoutTenantInNewList = Parameter.NewListOfCountries.Any(i => i.Country_ISOCode_Alpha2 == countryWithoutTenant.Country_ISOCode_Alpha2); country = countryList.FirstOrDefault(i => i.Country_ISOCode_Alpha2 == countryWithoutTenant.Country_ISOCode_Alpha2); if (country == null) { if (isCountryWithoutTenantInNewList) { country = new ORM_CMN_Country(); country.Tenant_RefID = securityTicket.TenantID; country.Country_ISOCode_Alpha2 = countryWithoutTenant.Country_ISOCode_Alpha2; country.Country_ISOCode_Alpha3 = countryWithoutTenant.Country_ISOCode_Alpha3; country.Country_ISOCode_Numeric = countryWithoutTenant.Country_ISOCode_Numeric; Dict countryName = new Dict(countryWithoutTenant.Country_Name.SourceTable); countryName.DictionaryID = Guid.NewGuid(); List <DictEntry> entryItems = new List <DictEntry>(); entryItems.AddRange(countryWithoutTenant.Country_Name.Contents.Select(entry => new DictEntry() { Content = entry.Content, LanguageID = entry.LanguageID, DictID = countryName.DictionaryID, EntityID = Guid.NewGuid() })); countryName.Contents = entryItems; country.Country_Name = countryName; country.Default_Currency_RefID = countryWithoutTenant.Default_Currency_RefID; country.Default_Language_RefID = countryWithoutTenant.Default_Language_RefID; country.Save(Connection, Transaction); } } else { country.IsDeleted = !isCountryWithoutTenantInNewList; country.Save(Connection, Transaction); } if (country != null && !country.IsDeleted) { countryResultItem = new L5CM_GCWRfT_0938(); countryResultItem.CMN_CountryID = country.CMN_CountryID; countryResultItem.Country_ISOCode_Alpha2 = country.Country_ISOCode_Alpha2; countryResultItem.Country_ISOCode_Alpha3 = country.Country_ISOCode_Alpha3; countryResultItem.Country_ISOCode_Numeric = country.Country_ISOCode_Numeric; countryResultItem.Country_Name = country.Country_Name; countryResultItem.Default_Currency_RefID = country.Default_Currency_RefID; countryResultItem.Default_Language_RefID = country.Default_Language_RefID; countriesResult.Add(countryResultItem); } } returnValue.Result.Countries = countriesResult.ToArray(); return(returnValue); #endregion UserCode }