Пример #1
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("TaskDetailID");
            reader.GetInt("TaskID", this.TaskID);
            reader.GetString("TaskName", this.TaskName);                           /*Optional 3*/
            reader.GetString("Country", this.Country);                             /*Optional 4*/
            reader.GetString("Depositary", this.Depositary);                       /*Optional 5*/
            reader.GetString("Issue", this.Issue);                                 /*Optional 6*/
            reader.GetString("CUSIP", this.CUSIP);                                 /*Optional 7*/
            reader.GetDateTime("RecordDate", this.RecordDate);                     /*Optional 8*/
            reader.GetString("SourceTable", this.SourceTable);                     /*Optional 9*/
            reader.GetString("SourceID", this.SourceID);                           /*Optional 10*/
            reader.GetDateTime("StartDate", this.StartDate);                       /*Optional 11*/
            reader.GetDateTime("PriorityDate", this.PriorityDate);                 /*Optional 12*/
            reader.GetDateTime("EndDate", this.EndDate);                           /*Optional 13*/
            reader.GetString("Notes", this.Notes);                                 /*Optional 14*/
            reader.GetInt("Priority", this.Priority);                              /*Optional 15*/
            reader.GetBool("Completed", this.Completed);                           /*Optional 16*/
            reader.GetString("CreatedBy", this.CreatedBy);                         /*Optional 17*/
            reader.GetDateTime("CreatedDateTime", this.CreatedDateTime);           /*Optional 18*/
            reader.GetString("CompletedBy", this.CompletedBy);                     /*Optional 19*/
            reader.GetDateTime("CompletedDateTime", this.CompletedDateTime);       /*Optional 20*/
            reader.GetString("LastModifiedBy", this.LastModifiedBy);               /*Optional 21*/
            reader.GetDateTime("LastModifiedDateTime", this.LastModifiedDateTime); /*Optional 22*/

            this.SyncWithDB();
        }
Пример #2
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("id_SavedFilesCustodianBalance");
            reader.GetString("originalFileName", this.originalFileName);/*Optional 2*/
            this.SavedFiles_XML_CB = reader.GetBytes("SavedFiles_XML_CB");
            reader.GetString("AnnouncementName", this.AnnouncementName);
            reader.GetString("AnnouncementSender", this.AnnouncementSender);
            reader.GetString("AnnouncementIdentifier", this.AnnouncementIdentifier);
            reader.GetString("AnnouncementDate", this.AnnouncementDate);
            reader.GetString("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier);
            reader.GetString("SECURITY_IDENTIFIER_CUSIP", this.SECURITY_IDENTIFIER_CUSIP);
            reader.GetString("ISSUER_NAME", this.ISSUER_NAME);
            reader.GetString("ADR_RECORD_DATE", this.ADR_RECORD_DATE);
            reader.GetString("ADRBase", this.ADRBase);             /*Optional 12*/
            reader.GetString("OrdinaryShare", this.OrdinaryShare); /*Optional 13*/
            reader.GetString("source", this.source);
            reader.GetInt("processState", this.processState);
            reader.GetDateTime("WhenProcessed", this.WhenProcessed);     /*Optional 16*/
            reader.GetString("Processedby", this.Processedby);           /*Optional 17*/
            reader.GetBool("flgLock", this.flgLock);                     /*Optional 18*/
            reader.GetDateTime("WhenLocked_date", this.WhenLocked_date); /*Optional 19*/
            reader.GetString("LockedBy_userid", this.LockedBy_userid);   /*Optional 20*/
            reader.GetString("createdby", this.createdby);
            reader.GetDateTime("createddate", this.createddate);
            reader.GetInt("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs);/*Optional 23*/

            this.SyncWithDB();
        }
Пример #3
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("Dividend_PayID");
            reader.GetInt("DividendIndex", this.DividendIndex);
            reader.GetDateTime("PaymentReferenceDate", this.PaymentReferenceDate); /*Optional 3*/
            reader.GetString("Depositary", this.Depositary);                       /*Optional 4*/
            reader.GetDateTime("FXValueDate", this.FXValueDate);                   /*Optional 5*/
            reader.GetDecimal("DivFXRate", this.DivFXRate);                        /*Optional 6*/
            reader.GetString("LastModifiedBy", this.LastModifiedBy);               /*Optional 7*/
            reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime);         /*Optional 8*/
            reader.GetBool("Paid_And_Locked", this.Paid_And_Locked);               /*Optional 9*/
            reader.GetDateTime("Paid_And_Locked_Date", this.Paid_And_Locked_Date); /*Optional 10*/
            reader.GetDateTime("Billed_Date", this.Billed_Date);                   /*Optional 11*/
            reader.GetDateTime("Paid_Date_Actual", this.Paid_Date_Actual);         /*Optional 12*/
            reader.GetString("WriteOff", this.WriteOff);                           /*Optional 13*/
            reader.GetInt("FX_InputID", this.FX_InputID);                          /*Optional 14*/
            reader.GetInt("CustodianID", this.CustodianID);                        /*Optional 15*/

            this.SyncWithDB();
        }
Пример #4
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("primary_custodian_id");
            reader.GetInt("custodian_number", this.custodian_number);
            reader.GetString("name", this.name);
            reader.GetString("address1", this.address1); /*Optional 4*/
            reader.GetString("address2", this.address2); /*Optional 5*/
            reader.GetString("city", this.city);         /*Optional 6*/
            reader.GetString("state", this.state);       /*Optional 7*/
            reader.GetString("zip", this.zip);           /*Optional 8*/
            reader.GetString("country_code", this.country_code);
            reader.GetString("attn", this.attn);         /*Optional 10*/
            reader.GetString("phone", this.phone);       /*Optional 11*/
            reader.GetString("fax", this.fax);           /*Optional 12*/
            reader.GetString("email", this.email);       /*Optional 13*/
            reader.GetInt("event_id", this.event_id);
            reader.GetString("psafe", this.psafe);
            reader.GetString("safe_keeping_account_number", this.safe_keeping_account_number);/*Optional 16*/
            reader.GetString("depositary_name", this.depositary_name);

            this.SyncWithDB();
        }
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("Dividend_FeeID");
            reader.GetInt("DividendIndex", this.DividendIndex);
            reader.GetDecimal("WHRate", this.WHRate);
            reader.GetDecimal("LongFormFees", this.LongFormFees);
            reader.GetDecimal("MinLongFormFee", this.MinLongFormFee);
            reader.GetDecimal("Fee_Max", this.Fee_Max);
            reader.GetDecimal("Fee_Consularization", this.Fee_Consularization);
            reader.GetDecimal("FavAtSourceFee", this.FavAtSourceFee);
            reader.GetDecimal("MinAtSourceFee", this.MinAtSourceFee);
            reader.GetDecimal("ExemptAtSourceFee", this.ExemptAtSourceFee);
            reader.GetDecimal("ShortFormFees", this.ShortFormFees);
            reader.GetDecimal("Fee_AtSource", this.Fee_AtSource);
            reader.GetDecimal("MinQuickRefundFee", this.MinQuickRefundFee);
            reader.GetDecimal("FavTransparentEntityFee", this.FavTransparentEntityFee);
            reader.GetDecimal("MinShortFormFee", this.MinShortFormFee);
            reader.GetDecimal("Fee_QuickRefund", this.Fee_QuickRefund);
            reader.GetString("LastModifiedBy", this.LastModifiedBy);         /*Optional 17*/
            reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime);   /*Optional 18*/
            reader.GetDecimal("AdditionalDSCFee", this.AdditionalDSCFee);    /*Optional 19*/
            reader.GetInt("Source_FeeID", this.Source_FeeID);                /*Optional 20*/
            reader.GetDecimal("AdditionalDSCFee1", this.AdditionalDSCFee1);  /*Optional 21*/
            reader.GetString("AtSourceModifiedBy", this.AtSourceModifiedBy); /*Optional 22*/

            this.SyncWithDB();
        }
Пример #6
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("id_SavedFiles_CSV");
            reader.GetString("originalFileName", this.originalFileName);   /*Optional 2*/
            this.savedfile_csv = reader.GetBytes("SavedFiles_CSV");
            reader.GetDateTime("FileCreationDate", this.FileCreationDate); /*Optional 4*/
            reader.GetString("FTP_Source", this.FTP_Source);               /*Optional 5*/
            reader.GetString("Status", this.Status);                       /*Optional 6*/
            reader.GetString("DividendIndex", this.DividendIndex);         /*Optional 7*/
            reader.GetString("Depositary", this.Depositary);               /*Optional 8*/
            reader.GetInt("DTC", this.DTC);                                /*Optional 9*/
            reader.GetDateTime("ProcessTime", this.ProcessTime);           /*Optional 10*/
            reader.GetString("ProcessedBy", this.ProcessedBy);             /*Optional 11*/
            reader.GetString("cpuFileName", this.cpuFileName);             /*Optional 12*/
            this.cpu_savedfile_csv = reader.GetBytes("cpuSavedFiles_CSV"); /*Optional 13*/
            reader.GetString("cpuStatus", this.cpuStatus);                 /*Optional 14*/
            reader.GetDateTime("cpuProcessTime", this.cpuProcessTime);     /*Optional 15*/
            reader.GetString("cpuProcessedBy", this.cpuProcessedBy);       /*Optional 16*/
            reader.GetString("OriginalSchema", this.OriginalSchema);       /*Optional 17*/
            reader.GetString("OriginalData", this.OriginalData);           /*Optional 18*/
            reader.GetDateTime("RecordDate", this.RecordDate);             /*Optional 19*/
            reader.GetString("Sender", this.Sender);                       /*Optional 20*/
            reader.GetString("CUSIP", this.CUSIP);                         /*Optional 21*/

            this.SyncWithDB();
        }
Пример #7
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("Dividend_FilingID");
            reader.GetInt("DividendIndex", this.DividendIndex);
            reader.GetString("Custodian_Tax_Authority", this.Custodian_Tax_Authority);   /*Optional 3*/
            reader.GetDateTime("FiledDate", this.FiledDate);
            reader.GetInt("Num_ADRs_Filed", this.Num_ADRs_Filed);                        /*Optional 5*/
            reader.GetInt("Num_ORDs_Filed", this.Num_ORDs_Filed);                        /*Optional 6*/
            reader.GetString("FedEx_Number", this.FedEx_Number);                         /*Optional 7*/
            reader.GetString("Filing_Method", this.Filing_Method);                       /*Optional 8*/
            reader.GetString("Reference_Number", this.Reference_Number);                 /*Optional 9*/
            reader.GetString("Delivery_Status", this.Delivery_Status);                   /*Optional 10*/
            reader.GetBool("Accept", this.Accept);                                       /*Optional 11*/
            reader.GetString("LastModifiedBy", this.LastModifiedBy);                     /*Optional 12*/
            reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime);               /*Optional 13*/
            reader.GetDateTime("Custodial_Receipt_Date", this.Custodial_Receipt_Date);   /*Optional 14*/
            reader.GetInt("CustodianID", this.CustodianID);                              /*Optional 15*/
            reader.GetString("ReclaimFeesType", this.ReclaimFeesType);                   /*Optional 16*/
            reader.GetString("Master_Reference_Number", this.Master_Reference_Number);   /*Optional 17*/
            reader.GetString("FilingStatus", this.FilingStatus);                         /*Optional 18*/
            reader.GetString("Allowed_ReclaimFeesTypes", this.Allowed_ReclaimFeesTypes); /*Optional 19*/
            reader.GetString("FilingTo", this.FilingTo);                                 /*Optional 20*/

            this.SyncWithDB();
        }
Пример #8
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("FeesID");
            reader.GetString("Country", this.Country);
            reader.GetString("Security_Type", this.Security_Type);                      /*Optional 3*/
            reader.GetString("Depositary", this.Depositary);
            reader.GetDecimal("ShortFormFees", this.ShortFormFees);                     /*Optional 5*/
            reader.GetDecimal("LongFormFees", this.LongFormFees);                       /*Optional 6*/
            reader.GetDecimal("FavAtSourceFee", this.FavAtSourceFee);                   /*Optional 7*/
            reader.GetDecimal("ExemptAtSourceFee", this.ExemptAtSourceFee);             /*Optional 8*/
            reader.GetDecimal("FavTransparentEntityFee", this.FavTransparentEntityFee); /*Optional 9*/
            reader.GetDecimal("MinAtSourceFee", this.MinAtSourceFee);                   /*Optional 10*/
            reader.GetDecimal("MinLongFormFee", this.MinLongFormFee);                   /*Optional 11*/
            reader.GetDecimal("MinQuickRefundFee", this.MinQuickRefundFee);             /*Optional 12*/
            reader.GetDecimal("MinShortFormFee", this.MinShortFormFee);                 /*Optional 13*/
            reader.GetDateTime("EffectiveDate", this.EffectiveDate);
            reader.GetDateTime("CreatedDate", this.CreatedDate);                        /*Optional 15*/
            reader.GetString("ImportBy", this.ImportBy);                                /*Optional 16*/
            reader.GetString("Notes", this.Notes);                                      /*Optional 17*/
            reader.GetInt("SecurityTypeID", this.SecurityTypeID);
            reader.GetString("IncomeEventID", this.IncomeEventID);                      /*Optional 19*/
            reader.GetString("Issue", this.Issue);                                      /*Optional 20*/
            reader.GetString("CUSIP", this.CUSIP);                                      /*Optional 21*/
            reader.GetDecimal("AdditionalDSCFee", this.AdditionalDSCFee);               /*Optional 22*/

            this.SyncWithDB();
        }
Пример #9
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("ID");
            this.DepositaryID.Value          = reader.GetString("DepositaryID");
            this.DepositaryName.Value        = reader.GetString("DepositaryName");
            this.DepositaryDisplayName.Value = reader.GetString("DepositaryDisplayName");                       /*Optional 4*/
            this.DepositaryShortName.Value   = reader.GetString("DepositaryShortName");                         /*Optional 5*/
            this.DepositaryIndex.Value       = reader.GetInt("DepositaryIndex");                                /*Optional 6*/
            this.Depositary_Contact.Value    = reader.GetString("Depositary_Contact");                          /*Optional 7*/
            this.Depositary_Phone.Value      = reader.GetString("Depositary_Phone");                            /*Optional 8*/
            this.Depositary_Address1.Value   = reader.GetString("Depositary_Address1");                         /*Optional 9*/
            this.Depositary_Address2.Value   = reader.GetString("Depositary_Address2");                         /*Optional 10*/
            this.Depositary_City.Value       = reader.GetString("Depositary_City");                             /*Optional 11*/
            this.Depositary_State.Value      = reader.GetString("Depositary_State");                            /*Optional 12*/
            this.Active.Value = reader.GetBool("Active");                                                       /*Optional 13*/
            this.UniqueDepositaryIndex.Value  = reader.GetString("UniqueDepositaryIndex");                      /*Optional 14*/
            this.SecurityTypeID.Value         = reader.GetInt("SecurityTypeID");                                /*Optional 15*/
            this.ESP_DepositaryName.Value     = reader.GetString("ESP_DepositaryName");                         /*Optional 16*/
            this.ESP_DepositaryAddress1.Value = reader.GetString("ESP_DepositaryAddress1");                     /*Optional 17*/
            this.ESP_DepositaryAddress2.Value = reader.GetString("ESP_DepositaryAddress2");                     /*Optional 18*/
            this.ESP_Phone.Value = reader.GetString("ESP_Phone");                                               /*Optional 19*/
            this.ESP_Fax.Value   = reader.GetString("ESP_Fax");                                                 /*Optional 20*/
            this.ESP_InternationalPhone.Value = reader.GetString("ESP_InternationalPhone");                     /*Optional 21*/
            this.ESP_DepositaryFullName.Value = reader.GetString("ESP_DepositaryFullName");                     /*Optional 22*/
            this.ESP_Idemnification.Value     = reader.GetString("ESP_Idemnification");                         /*Optional 23*/
            this.ESP_Idemnification2.Value    = reader.GetString("ESP_Idemnification2");                        /*Optional 24*/
            this.ESP_Idemnification_DI.Value  = reader.GetString("ESP_Idemnification_DI");                      /*Optional 25*/
            this.ESP_Idemnification2_DI.Value = reader.GetString("ESP_Idemnification2_DI");                     /*Optional 26*/
            this.ESP_DepositaryAccount.Value  = reader.GetString("ESP_DepositaryAccount");                      /*Optional 27*/
            this.ESP_DepositaryIBANCode.Value = reader.GetString("ESP_DepositaryIBANCode");                     /*Optional 28*/
            this.ESP_DepositaryBIC.Value      = reader.GetString("ESP_DepositaryBIC");                          /*Optional 29*/
            this.ESP_DepositaryBank.Value     = reader.GetString("ESP_DepositaryBank");                         /*Optional 30*/
            this.Nominee.Value                   = reader.GetString("Nominee");                                 /*Optional 31*/
            this.Nominee_Address.Value           = reader.GetString("Nominee_Address");                         /*Optional 32*/
            this.ESP_Idemnification_RUSSIA.Value = reader.GetString("ESP_Idemnification_RUSSIA");               /*Optional 33*/
            this.ActiveFirstFiler.Value          = reader.GetBool("ActiveFirstFiler");                          /*Optional 34*/
            this.PaymentInvoiceCurrency.Value    = reader.GetString("PaymentInvoiceCurrency");
            this.ClearingSystem.Value            = reader.GetString("ClearingSystem");                          /*Optional 36*/
            this.ACH_Enabled.Value               = reader.GetBool("ACH_Enabled");                               /*Optional 37*/
            this.Originated_ACH_Company_ID.Value = reader.GetString("Originated_ACH_Company_ID");               /*Optional 38*/
            this.Originated_Account_Number.Value = reader.GetString("Originated_Account_Number");               /*Optional 39*/
            this.ACH_ModifiedBy.Value            = reader.GetString("ACH_ModifiedBy");                          /*Optional 40*/
            this.ACH_ModifiedDateTime.Value      = reader.GetDateTime("ACH_ModifiedDateTime", Utility.MinDate); /*Optional 41*/
            this.ModifiedDateTime.Value          = reader.GetDateTime("ModifiedDateTime", Utility.MinDate);     /*Optional 42*/
            this.Unique_DepositaryName.Value     = reader.GetString("Unique_DepositaryName");                   /*Optional 43*/

            this.SyncWithDB();
        }
Пример #10
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("ID");
            reader.GetInt("GroupID", this.GroupID);
            reader.GetString("OwnerSID", this.OwnerSID);

            this.SyncWithDB();
        }
Пример #11
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("SecurityID");
            reader.GetString("Name", this.Name);
            reader.GetString("CUSIP", this.CUSIP);                         /*Optional 3*/
            reader.GetString("Country", this.Country);
            reader.GetString("TickerSymbol", this.TickerSymbol);           /*Optional 5*/
            reader.GetString("ISIN", this.ISIN);                           /*Optional 6*/
            reader.GetString("Sedol", this.Sedol);                         /*Optional 7*/
            reader.GetString("Depositary", this.Depositary);               /*Optional 8*/
            reader.GetString("FirstFiler", this.FirstFiler);               /*Optional 9*/
            reader.GetString("ClearingSystem", this.ClearingSystem);       /*Optional 10*/
            reader.GetString("SecurityType", this.SecurityType);           /*Optional 11*/
            reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 12*/
            reader.GetString("LastModifiedBy", this.LastModifiedBy);       /*Optional 13*/
            reader.GetDateTime("EffectiveDate", this.EffectiveDate);
            reader.GetDecimal("ADR_RATIO_ADR", this.ADR_RATIO_ADR);        /*Optional 15*/
            reader.GetDecimal("ADR_RATIO_ORD", this.ADR_RATIO_ORD);        /*Optional 16*/
            reader.GetString("DutchName", this.DutchName);                 /*Optional 17*/

            this.SyncWithDB();
        }
Пример #12
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("DetailID");
            reader.GetString("DTC_Number", this.DTC_Number);
            reader.GetInt("CustodianID", this.CustodianID);                   /*Optional 25*/
            reader.GetString("Status", this.Status);                          /*Optional 27*/
            reader.GetDecimal("RecordDatePosition", this.RecordDatePosition); /*Optional 30*/
            reader.GetInt("Dividend_FilingID", this.Dividend_FilingID);       /*Optional 37*/

            this.SyncWithDB();
        }
Пример #13
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("FX_InputID");
            reader.GetString("CountryName", this.CountryName);                           /*Optional 2*/
            reader.GetString("Custodian", this.Custodian);                               /*Optional 3*/
            reader.GetString("AccountNumber", this.AccountNumber);                       /*Optional 4*/
            reader.GetString("Currency_Code", this.Currency_Code);                       /*Optional 5*/
            reader.GetDateTime("FX_NotificationDate", this.FX_NotificationDate);         /*Optional 6*/
            reader.GetDecimal("LocalAmountReceived", this.LocalAmountReceived);          /*Optional 7*/
            reader.GetDateTime("Depositary_ReceivedDate", this.Depositary_ReceivedDate); /*Optional 8*/
            reader.GetDateTime("FX_RequestedDate", this.FX_RequestedDate);               /*Optional 9*/
            reader.GetDateTime("FX_ReceivedDate", this.FX_ReceivedDate);                 /*Optional 10*/
            reader.GetString("Depositary", this.Depositary);                             /*Optional 11*/
            reader.GetDecimal("FX_Rate", this.FX_Rate);                                  /*Optional 12*/
            reader.GetDecimal("USDAmountReceived", this.USDAmountReceived);              /*Optional 13*/
            reader.GetDateTime("ActualCheckRequestDate", this.ActualCheckRequestDate);   /*Optional 14*/
            reader.GetDateTime("PayToBrokerDate", this.PayToBrokerDate);                 /*Optional 15*/
            reader.GetString("LastModifiedBy", this.LastModifiedBy);                     /*Optional 16*/
            reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime);               /*Optional 17*/
            reader.GetDecimal("Forex_Fee", this.Forex_Fee);                              /*Optional 18*/

            this.SyncWithDB();
        }
Пример #14
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("id_XBRLField");
            reader.GetString("xbrlElement", this.xbrlElement);
            reader.GetString("xbrlAttributeName", this.xbrlAttributeName);               /*Optional 3*/
            reader.GetString("xbrlContextRefValue", this.xbrlContextRefValue);           /*Optional 4*/
            reader.GetString("namespace", this.NameSpace);                               /*Optional 5*/
            reader.GetString("drwinFieldName", this.drwinFieldName);                     /*Optional 6*/
            reader.GetString("drwinControlType", this.drwinControlType);                 /*Optional 7*/
            reader.GetBool("multiple", this.multiple);                                   /*Optional 8*/
            reader.GetBool("active", this.active);                                       /*Optional 9*/
            reader.GetBool("chkCompleteness", this.chkCompleteness);                     /*Optional 10*/
            reader.GetString("drwinFieldNameIncomplete", this.drwinFieldNameIncomplete); /*Optional 11*/
            reader.GetString("drwinFieldNameComplete", this.drwinFieldNameComplete);     /*Optional 12*/
            reader.GetDateTime("createdDate", this.createdDate);
            reader.GetString("createdBy", this.createdBy);
            reader.GetBool("overridable", this.overridable);/*Optional 15*/

            this.SyncWithDB();
        }
Пример #15
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("RSHID");
            reader.GetInt("DividendIndex", this.DividendIndex);
            reader.GetInt("DTC", this.DTC);
            reader.GetString("Depositary", this.Depositary);
            reader.GetString("AccountNumber", this.AccountNumber);           /*Optional 5*/
            reader.GetString("TIN", this.TIN);                               /*Optional 6*/
            reader.GetDecimal("Shares", this.Shares);                        /*Optional 7*/
            reader.GetString("RegisteredName", this.RegisteredName);         /*Optional 8*/
            reader.GetString("Address", this.Address);                       /*Optional 9*/
            reader.GetString("CountryCode", this.CountryCode);               /*Optional 10*/
            reader.GetString("TaxStatus", this.TaxStatus);                   /*Optional 11*/
            reader.GetDecimal("ForeignTaxWH", this.ForeignTaxWH);            /*Optional 12*/
            reader.GetString("CUSIP", this.CUSIP);                           /*Optional 13*/
            reader.GetString("IssueNumber", this.IssueNumber);               /*Optional 14*/
            reader.GetString("CitizenshipCode", this.CitizenshipCode);       /*Optional 15*/
            reader.GetString("OwnerCode", this.OwnerCode);                   /*Optional 16*/
            reader.GetString("ZipCode", this.ZipCode);                       /*Optional 17*/
            reader.GetString("State", this.State);                           /*Optional 18*/
            reader.GetString("CityName", this.CityName);                     /*Optional 19*/
            reader.GetString("Agent", this.Agent);                           /*Optional 20*/
            reader.GetInt("LOC", this.LOC);                                  /*Optional 21*/
            reader.GetDateTime("RecordDate", this.RecordDate);               /*Optional 22*/
            reader.GetString("Comp_Num", this.Comp_Num);                     /*Optional 23*/
            reader.GetString("Class_CD", this.Class_CD);                     /*Optional 24*/
            reader.GetString("Tax_CD", this.Tax_CD);                         /*Optional 25*/
            reader.GetDecimal("Shares2", this.Shares2);                      /*Optional 26*/
            reader.GetString("GlobeTax", this.GlobeTax);                     /*Optional 27*/
            reader.GetString("Dividend_Intention", this.Dividend_Intention); /*Optional 28*/
            reader.GetDateTime("Holder_On_Date", this.Holder_On_Date);       /*Optional 29*/
            reader.GetString("Tin_Status_1", this.Tin_Status_1);             /*Optional 30*/
            reader.GetString("Tin_Status_Source", this.Tin_Status_Source);   /*Optional 31*/
            reader.GetDateTime("Tin_Exp_Date_1", this.Tin_Exp_Date_1);       /*Optional 32*/
            reader.GetInt("Tin_B_Count", this.Tin_B_Count);                  /*Optional 33*/
            reader.GetString("Holder_Type_Code", this.Holder_Type_Code);     /*Optional 34*/
            reader.GetDateTime("Last_Contact_Date", this.Last_Contact_Date); /*Optional 35*/
            reader.GetString("Last_Contact_Type", this.Last_Contact_Type);   /*Optional 36*/
            reader.GetString("GlobeTax_Findings", this.GlobeTax_Findings);   /*Optional 37*/

            this.SyncWithDB();
        }
Пример #16
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("ID");
            reader.GetInt("SecurityID", this.SecurityID);      /*Optional 2*/
            reader.GetString("TaskName", this.TaskName);       /*Optional 3*/
            reader.GetString("Status", this.Status);           /*Optional 4*/
            reader.GetString("ValueStr", this.ValueStr);       /*Optional 5*/
            reader.GetString("CreateBy", this.CreateBy);       /*Optional 6*/
            reader.GetDateTime("CreateDate", this.CreateDate); /*Optional 7*/

            this.SyncWithDB();
        }
Пример #17
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("depositary_idemnification_id");
            this.depositary_info_id.Value    = reader.GetInt("depositary_info_id");
            this.language_id.Value           = reader.GetInt("language_id");
            this.idemnification.Value        = reader.GetString("idemnification");
            this.idemnification2.Value       = reader.GetString("idemnification2");
            this.idemnification_di.Value     = reader.GetString("idemnification_di");
            this.idemnification2_di.Value    = reader.GetString("idemnification2_di");
            this.idemnification_russia.Value = reader.GetString("idemnification_russia");/*Optional 8*/

            this.SyncWithDB();
        }
Пример #18
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("ID");
            reader.GetString("Job_Class", this.Job_Class);     /*Optional 2*/
            reader.GetInt("Job_ID", this.Job_ID);              /*Optional 3*/
            reader.GetDateTime("LastRunAt", this.LastRunAt);   /*Optional 4*/
            reader.GetString("LastRunBy", this.LastRunBy);     /*Optional 5*/
            reader.GetBool("Locked", this.Locked);             /*Optional 6*/
            reader.GetString("Notes", this.Notes);             /*Optional 7*/
            reader.GetDateTime("LastLockAt", this.LastLockAt); /*Optional 8*/
            reader.GetString("LastLockBy", this.LastLockBy);   /*Optional 9*/

            this.SyncWithDB();
        }
Пример #19
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("XBRL_ID");
            reader.GetInt("DividendIndex", this.DividendIndex);
            reader.GetString("Depositary", this.Depositary);                           /*Optional 3*/
            reader.GetString("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber);
            reader.GetString("PSAFE", this.PSAFE);                                     /*Optional 5*/
            reader.GetDateTime("LastModifiedDate", this.LastModifiedDate);             /*Optional 6*/
            reader.GetString("SourceType", this.SourceType);                           /*Optional 7*/
            reader.GetString("LastModifiedBy", this.LastModifiedBy);                   /*Optional 8*/
            reader.GetString("Announcement Identifier", this.Announcement_Identifier); /*Optional 9*/
            reader.GetString("Event Completeness", this.Event_Completeness);           /*Optional 10*/

            this.SyncWithDB();
        }
Пример #20
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("id");
            reader.GetString("coi", this.coi);                   /*Optional 2*/
            reader.GetString("cor", this.cor);                   /*Optional 3*/
            reader.GetDecimal("statry_rt", this.statry_rt);      /*Optional 4*/
            reader.GetDecimal("int_rt", this.int_rt);            /*Optional 5*/
            reader.GetDateTime("effect_dt", this.effect_dt);     /*Optional 6*/
            reader.GetDateTime("created_dt", this.created_dt);   /*Optional 7*/
            reader.GetDateTime("modified_dt", this.modified_dt); /*Optional 8*/
            reader.GetInt("migratedId", this.migratedId);        /*Optional 9*/
            reader.GetInt("sec_type", this.sec_type);            /*Optional 10*/
            reader.GetString("bo_typ", this.bo_typ);             /*Optional 11*/

            this.SyncWithDB();
        }
Пример #21
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("ID");
            reader.GetString("TaskOwner_SID", this.TaskOwner_SID);
            reader.GetString("ISO2CntryCode", this.ISO2CntryCode);

            this.SyncWithDB();
        }
Пример #22
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("DetailID");
            //reader.GetInt("DividendIndex", this.DividendIndex);
            reader.GetString("DTC_Number", this.DTC_Number);
            //reader.GetString("Depositary", this.Depositary);/*Optional 10*/
            reader.GetString("BO_COR", this.BO_COR);                          /*Optional 18*/
            reader.GetString("BO_EntityType", this.BO_EntityType);            /*Optional 19*/
            reader.GetDecimal("ReclaimRate", this.ReclaimRate);               /*Optional 22*/
            reader.GetInt("CustodianID", this.CustodianID);                   /*Optional 25*/
            reader.GetString("Status", this.Status);                          /*Optional 27*/
            reader.GetDecimal("RecordDatePosition", this.RecordDatePosition); /*Optional 30*/
            reader.GetString("ReclaimFeesType", this.ReclaimFeesType);        /*Optional 41*/
            reader.GetBool("PaidViaDTCC", this.PaidViaDTCC);                  /*Optional 120*/

            this.SyncWithDB();
        }
Пример #23
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("ID");
            reader.GetString("FileName", this.FileName);                 /*Optional 2*/
            reader.GetDateTime("CreateTime", this.CreateTime);           /*Optional 3*/
            this.FileBinary = reader.GetBytes("FileBinary");             /*Optional 4*/
            reader.GetString("CreateBy", this.CreateBy);                 /*Optional 5*/
            reader.GetInt("Status", this.Status);                        /*Optional 6*/
            reader.GetString("CUSIP", this.CUSIP);                       /*Optional 7*/
            reader.GetDateTime("RecordDate", this.RecordDate);           /*Optional 8*/
            reader.GetString("SecurityName", this.SecurityName);         /*Optional 9*/
            reader.GetDateTime("LastModifyAt", this.LastModifyAt);       /*Optional 10*/
            reader.GetString("LastModifyBy", this.LastModifyBy);         /*Optional 11*/
            reader.GetString("LastModifyAction", this.LastModifyAction); /*Optional 12*/

            this.SyncWithDB();
        }
Пример #24
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("ID");
            reader.GetString("UserName", this.UserName);           /*Optional 2*/
            reader.GetString("ConfigXML", this.ConfigXML);         /*Optional 3*/
            reader.GetDateTime("LastModifyAt", this.LastModifyAt); /*Optional 4*/

            this.SyncWithDB();
        }
Пример #25
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("id");
            reader.GetString("cntry_cd", this.cntry_cd);
            reader.GetString("bo_cor", this.bo_cor);
            reader.GetInt("timebar", this.timebar);
            reader.GetBool("eoy", this.eoy);
            reader.GetBool("pay_dt", this.pay_dt);
            reader.GetInt("expect_dt", this.expect_dt);
            reader.GetDateTime("effect_dt", this.effect_dt);
            reader.GetDateTime("from_dt", this.from_dt);
            reader.GetDateTime("created_dt", this.created_dt);
            reader.GetDateTime("modified_dt", this.modified_dt);
            reader.GetInt("migratedId", this.migratedId);
            reader.GetInt("sec_type", this.sec_type);

            this.SyncWithDB();
        }
Пример #26
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("event_contact_info_id");
            reader.GetInt("event_id", this.event_id);
            reader.GetString("contact_company_name", this.contact_company_name); /*Optional 3*/
            reader.GetString("contact_address1", this.contact_address1);         /*Optional 4*/
            reader.GetString("contact_address2", this.contact_address2);         /*Optional 5*/
            reader.GetString("contact_country_code", this.contact_country_code); /*Optional 6*/
            reader.GetString("contact_attn", this.contact_attn);                 /*Optional 7*/
            reader.GetString("contact_phone", this.contact_phone);               /*Optional 8*/
            reader.GetString("contact_fax", this.contact_fax);                   /*Optional 9*/
            reader.GetString("contact_email", this.contact_email);               /*Optional 10*/
            reader.GetString("contact_city", this.contact_city);                 /*Optional 11*/
            reader.GetString("contact_state", this.contact_state);               /*Optional 12*/
            reader.GetString("contact_zip", this.contact_zip);                   /*Optional 13*/

            this.SyncWithDB();
        }
Пример #27
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("GroupID");
            reader.GetString("GroupName", this.GroupName);
            reader.GetString("Group_LeaderSID", this.Group_LeaderSID);
            reader.GetString("Group_Email", this.Group_Email);/*Optional 4*/

            this.SyncWithDB();
        }
Пример #28
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetString("cntry_cd");
            reader.GetString("name", this.name);            /*Optional 2*/
            reader.GetInt("currency_id", this.currency_id); /*Optional 3*/
            reader.GetString("iso2_cd", this.iso2_cd);      /*Optional 4*/
            reader.GetString("iso3_cd", this.iso3_cd);      /*Optional 5*/

            this.SyncWithDB();
        }
Пример #29
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("ID");
            reader.GetString("Name", this.Name);           /*Optional 2*/
            reader.GetDateTime("Birthday", this.Birthday); /*Optional 3*/
            reader.GetDecimal("Salary", this.Salary);      /*Optional 4*/
            reader.GetBool("IsMarried", this.IsMarried);   /*Optional 5*/

            this.SyncWithDB();
        }
Пример #30
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("ID");
            reader.GetInt("ModelNumber", this.ModelNumber);
            reader.GetString("Country", this.Country);
            reader.GetString("Column_Header_Name", this.Column_Header_Name);
            reader.GetString("Table_Column", this.Table_Column);
            reader.GetString("Rate_Desc", this.Rate_Desc);     /*Optional 6*/
            reader.GetDecimal("WHRate", this.WHRate);          /*Optional 7*/
            reader.GetString("ArmorColumn", this.ArmorColumn); /*Optional 8*/
            reader.GetString("Category", this.Category);
            reader.GetString("DiscloseType", this.DiscloseType);
            reader.GetInt("SortOrder", this.SortOrder);
            reader.GetDecimal("ChargeBackFrom", this.ChargeBackFrom);      /*Optional 12*/
            reader.GetString("LastModifiedBy", this.LastModifiedBy);       /*Optional 13*/
            reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 14*/

            this.SyncWithDB();
        }