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(); }
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(); }
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_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(); }
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(); }
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(); }
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(); }
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(); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB(bool ignore_binary, bool ignore_SchemaData) { if (this.id_SavedFiles_CSV < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(SavedFiles_CSV.Get_cmdTP()); db_sel.tableName = "SavedFiles_CSV"; if (ignore_binary) { db_sel.IgnoreColumn("SavedFiles_CSV"); db_sel.IgnoreColumn("cpuSavedFiles_CSV"); } if (ignore_SchemaData) { db_sel.IgnoreColumn("OriginalSchema"); db_sel.IgnoreColumn("OriginalData"); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedFiles_CSV", HssUtility.General.RelationalOperator.Equals, this.id_SavedFiles_CSV); db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_XBRL_hDB()); if (reader.Read()) { this.Init_from_reader(reader); res_flag = true; } reader.Close(); return(res_flag); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { HssUtility.SQLserver.SQL_relation rela = null; if (this.pk_ID > 0) { rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.ID); } else { if (UserName.IsValueEmpty) { return(false); } else { rela = new HssUtility.SQLserver.SQL_relation("UserName", HssUtility.General.RelationalOperator.Equals, this.UserName.Value); } } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Hss_UserConfig.Get_cmdTP()); db_sel.tableName = "Hss_UserConfig"; db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_DRWIN_hDB()); if (reader.Read()) { this.Init_from_reader(reader); res_flag = true; } reader.Close(); return(res_flag); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB(bool ignore_savedfile) { if (this.id_SavedfilesRcvd < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(XBRL_SavedFile.Get_cmdTP()); if (ignore_savedfile) { db_sel.IgnoreColumn("savedfile"); } db_sel.tableName = "SavedFiles"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedfilesRcvd", HssUtility.General.RelationalOperator.Equals, this.id_SavedfilesRcvd); db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_XBRL_hDB()); if (reader.Read()) { this.Init_from_reader(reader); res_flag = true; } reader.Close(); return(res_flag); }
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(); }
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(); }
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(); }
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(); }
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(); }
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(); }
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(); }
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(); }
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(); }
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader) { if (reader == null || reader.IsClosed) { return; } this.pk_ID = reader.GetString("Country"); reader.GetBool("IsSponsored", this.IsSponsored);/*Optional 2*/ reader.GetBool("At_Source", this.At_Source); reader.GetBool("Quick_Refund", this.Quick_Refund); reader.GetBool("Long_Form", this.Long_Form); this.SyncWithDB(); }
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(); }
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(); }
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(); }
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader) { if (reader == null || reader.IsClosed) { return; } this.pk_ID = reader.GetInt("id_SavedfilesRcvd"); this.savedfile = reader.GetBytes("savedfile"); reader.GetString("EventType", this.EventType); reader.GetString("DRWINIncomeEventID", this.DRWINIncomeEventID); /*Optional 4*/ reader.GetString("cusip", this.cusip); /*Optional 5*/ reader.GetString("ISIN", this.ISIN); /*Optional 6*/ reader.GetString("originalFileName", this.originalFileName); /*Optional 7*/ reader.GetString("DepositaryName", this.DepositaryName); /*Optional 8*/ reader.GetDateTime("AnnouncementDate", this.AnnouncementDate); /*Optional 9*/ reader.GetString("EventCompleteness", this.EventCompleteness); /*Optional 10*/ reader.GetString("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier); /*Optional 11*/ reader.GetBool("DepositoryReceiptSponsorIndicator", this.DepositoryReceiptSponsorIndicator); /*Optional 12*/ reader.GetDateTime("PaymentDate", this.PaymentDate); /*Optional 13*/ reader.GetDateTime("RecordDate", this.RecordDate); /*Optional 14*/ reader.GetString("CountryOfIssue", this.CountryOfIssue); /*Optional 15*/ reader.GetString("ContextRefBase", this.ContextRefBase); /*Optional 16*/ reader.GetString("Source", this.Source); /*Optional 17*/ reader.GetInt("processState", this.processState); reader.GetDateTime("WhenProcessed", this.WhenProcessed); /*Optional 19*/ reader.GetString("Processedby", this.Processedby); /*Optional 20*/ reader.GetBool("flgLock", this.flgLock); /*Optional 21*/ reader.GetDateTime("WhenLocked_date", this.WhenLocked_date); /*Optional 22*/ reader.GetString("LockedBy_userid", this.LockedBy_userid); /*Optional 23*/ reader.GetString("createdby", this.createdby); reader.GetDateTime("createddate", this.createddate); reader.GetInt("AnnouncementIdentifier", this.AnnouncementIdentifier); /*Optional 26*/ reader.GetBool("FirstFilerFlag", this.FirstFilerFlag); /*Optional 27*/ reader.GetString("UnderlyingSecurityIssuerCountryofIncorporation", this.UnderlyingSecurityIssuerCountryofIncorporation); /*Optional 28*/ reader.GetInt("id_SavedFiles_CSV", this.id_SavedFiles_CSV); /*Optional 29*/ reader.GetInt("DividendIndex", this.DividendIndex); /*Optional 30*/ reader.GetString("AnnouncementType", this.AnnouncementType); /*Optional 31*/ reader.GetInt("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs); /*Optional 32*/ reader.GetInt("recNum", this.recNum); /*Optional 33*/ reader.GetBool("flgEmailSent", this.flgEmailSent); /*Optional 34*/ reader.GetDateTime("EmailSentDate", this.EmailSentDate); /*Optional 35*/ this.SyncWithDB(); }
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader) { if (reader == null || reader.IsClosed) { return; } this.pk_ID = reader.GetString("name"); reader.GetString("cntry_cd", this.cntry_cd); reader.GetInt("currency_id", this.currency_id); /*Optional 3*/ reader.GetDecimal("longform_coefficient", this.longform_coefficient); /*Optional 5*/ reader.GetBool("In_ESP", this.In_ESP); /*Optional 6*/ reader.GetString("ISO3_cntry_cd", this.ISO3_cntry_cd); /*Optional 7*/ reader.GetString("GlobeTaxEmail", this.GlobeTaxEmail); /*Optional 8*/ this.SyncWithDB(); }
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(); }
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(); }
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader) { if (reader == null || reader.IsClosed) { return; } this.pk_ID = reader.GetInt("DTC"); reader.GetString("DTC_Number", this.DTC_Number); reader.GetString("Company_Name", this.Company_Name); reader.GetString("ATTN", this.ATTN); /*Optional 4*/ reader.GetString("Address1", this.Address1); /*Optional 5*/ reader.GetString("Address2", this.Address2); /*Optional 6*/ reader.GetString("City", this.City); /*Optional 7*/ reader.GetString("State", this.State); /*Optional 8*/ reader.GetString("Country", this.Country); /*Optional 9*/ reader.GetString("Zip_Postal_Code", this.Zip_Postal_Code); /*Optional 10*/ reader.GetString("Phone", this.Phone); /*Optional 11*/ reader.GetString("Fax", this.Fax); /*Optional 12*/ reader.GetString("WebsiteUrl", this.WebsiteUrl); /*Optional 13*/ reader.GetString("Email", this.Email); /*Optional 14*/ reader.GetString("Fixed_Payment_ATTN", this.Fixed_Payment_ATTN); /*Optional 15*/ reader.GetString("Type", this.Type); /*Optional 16*/ reader.GetString("Depositary", this.Depositary); /*Optional 17*/ reader.GetString("RejectEmail", this.RejectEmail); /*Optional 18*/ reader.GetString("PaymentEmail", this.PaymentEmail); /*Optional 19*/ reader.GetString("DocInventoryEmail", this.DocInventoryEmail); /*Optional 20*/ reader.GetString("SecurityTypeID", this.SecurityTypeID); reader.GetString("AccountNumber", this.AccountNumber); reader.GetString("IssuerCSD", this.IssuerCSD); /*Optional 23*/ reader.GetBool("ACH_Override", this.ACH_Override); /*Optional 24*/ reader.GetString("ACH_Bank", this.ACH_Bank); /*Optional 25*/ reader.GetString("ACH_ABA", this.ACH_ABA); /*Optional 26*/ reader.GetString("ACH_Account", this.ACH_Account); /*Optional 27*/ reader.GetString("ClearingSystem", this.ClearingSystem); reader.GetString("CustomWireMemo", this.CustomWireMemo); /*Optional 29*/ reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 30*/ reader.GetString("Email_backup", this.Email_backup); /*Optional 31*/ reader.GetString("PaymentEmail_backup", this.PaymentEmail_backup); /*Optional 32*/ reader.GetString("RejectEmail_backup", this.RejectEmail_backup); /*Optional 33*/ reader.GetString("DocInventoryEmail_backup", this.DocInventoryEmail_backup); /*Optional 34*/ this.SyncWithDB(); }
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(); }