protected static FR_L2CN_GACCT_1519_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_L2CN_GACCT_1519_Array();

            #region Get Languages

            P_L2LN_GALFTID_1530 param = new P_L2LN_GALFTID_1530();
            param.Tenant_RefID = securityTicket.TenantID;
            var DBLanguages = cls_Get_All_Languages_ForTenantID.Invoke(Connection, Transaction, param, securityTicket).Result;

            var languages = DBLanguages.Select(i => new ISOLanguage()
            {
                ISO = i.ISO_639_1, LanguageID = i.CMN_LanguageID
            }).ToList();

            #endregion

            Assembly      asm      = Assembly.GetExecutingAssembly();
            XmlDocument   resource = new XmlDocument();
            XmlTextReader reader   = new XmlTextReader(asm.GetManifestResourceStream(DMComunactionContactTypes.ResourceFilePath));
            resource.Load(reader);

            var predefinedContactTypes = DMComunactionContactTypes.Get_PredefinedComunactionContactTypes(Connection, Transaction, securityTicket);

            var globalPropertyMatchingIDs = predefinedContactTypes.Select(i => i.GlobalPropertyMatchingID).ToList();

            var globalMatching2Dict = DBCommonsReader.Instance.GetDictObjectsFromResourceFile(globalPropertyMatchingIDs, resource,
                                                                                              ORM_CMN_PER_CommunicationContact_Type.TableName, languages);

            returnValue.Result = predefinedContactTypes.Select(item =>
                                                               new L2CN_GACCT_1519 {
                EnumType = item.Type, Type = item.GlobalPropertyMatchingID, Name = globalMatching2Dict[item.GlobalPropertyMatchingID]
            }).ToArray();

            return(returnValue);

            #endregion UserCode
        }
        protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2CN_SCCfPI_1409 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            //Leave UserCode region to enable user code saving
            #region UserCode
            var returnValue = new FR_Guid();

            var item = new ORM_CMN_PER_CommunicationContact();

            if (Parameter.CMN_PER_CommunicationContactID != Guid.Empty)
            {
                item.Load(Connection, Transaction, Parameter.CMN_PER_CommunicationContactID);
            }

            if (Parameter.IsDeleted == true)
            {
                item.IsDeleted = true;
                return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_PER_CommunicationContactID));
            }

            if (Parameter.CMN_PER_CommunicationContactID == Guid.Empty)
            {
                item.Tenant_RefID = securityTicket.TenantID;
            }

            //GetComunication ContatctTypeID or create it if not exist
            var comunicationContactTypes = cls_Get_AllComunicationContactTypes.Invoke(Connection, Transaction, securityTicket).Result;

            var comunicationContactTypeID = DMComunactionContactTypes.Get_CommunactionContactType_for_GlobalPropertyMatchingID(Connection, Transaction, Parameter.ContactType, securityTicket);

            item.PersonInfo_RefID = Parameter.PersonInfo_RefID;
            item.Contact_Type     = comunicationContactTypeID;
            item.Content          = Parameter.ContactValue;

            return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_PER_CommunicationContactID));

            #endregion UserCode
        }