internal HssUtility.SQLserver.DB_insert Get_DBinsert() { this.LastModifiedBy.Value = Utility.CurrentUser; this.LastModifiedDateTime.Value = DateTime.Now; this.CreatedBy.Value = Utility.CurrentUser; this.CreatedDateTime.Value = DateTime.Now; HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Task_Detail.Get_cmdTP()); dbIns.AddValue("TaskID", this.TaskID.Value); dbIns.AddValue("TaskName", this.TaskName); /*Optional 3*/ dbIns.AddValue("Country", this.Country); /*Optional 4*/ dbIns.AddValue("Depositary", this.Depositary); /*Optional 5*/ dbIns.AddValue("Issue", this.Issue); /*Optional 6*/ dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 7*/ dbIns.AddValue("RecordDate", this.RecordDate); /*Optional 8*/ dbIns.AddValue("SourceTable", this.SourceTable); /*Optional 9*/ dbIns.AddValue("SourceID", this.SourceID); /*Optional 10*/ dbIns.AddValue("StartDate", this.StartDate); /*Optional 11*/ dbIns.AddValue("PriorityDate", this.PriorityDate); /*Optional 12*/ dbIns.AddValue("EndDate", this.EndDate); /*Optional 13*/ dbIns.AddValue("Notes", this.Notes); /*Optional 14*/ dbIns.AddValue("Priority", this.Priority); /*Optional 15*/ dbIns.AddValue("Completed", this.Completed); /*Optional 16*/ dbIns.AddValue("CreatedBy", this.CreatedBy); /*Optional 17*/ dbIns.AddValue("CreatedDateTime", this.CreatedDateTime); /*Optional 18*/ dbIns.AddValue("CompletedBy", this.CompletedBy); /*Optional 19*/ dbIns.AddValue("CompletedDateTime", this.CompletedDateTime); /*Optional 20*/ dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 21*/ dbIns.AddValue("LastModifiedDateTime", this.LastModifiedDateTime); /*Optional 22*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Schedule_Of_Fees_DSC.Get_cmdTP()); dbIns.AddValue("Country", this.Country); dbIns.AddValue("Security_Type", this.Security_Type); /*Optional 3*/ dbIns.AddValue("Depositary", this.Depositary); dbIns.AddValue("ShortFormFees", this.ShortFormFees); /*Optional 5*/ dbIns.AddValue("LongFormFees", this.LongFormFees); /*Optional 6*/ dbIns.AddValue("FavAtSourceFee", this.FavAtSourceFee); /*Optional 7*/ dbIns.AddValue("ExemptAtSourceFee", this.ExemptAtSourceFee); /*Optional 8*/ dbIns.AddValue("FavTransparentEntityFee", this.FavTransparentEntityFee); /*Optional 9*/ dbIns.AddValue("MinAtSourceFee", this.MinAtSourceFee); /*Optional 10*/ dbIns.AddValue("MinLongFormFee", this.MinLongFormFee); /*Optional 11*/ dbIns.AddValue("MinQuickRefundFee", this.MinQuickRefundFee); /*Optional 12*/ dbIns.AddValue("MinShortFormFee", this.MinShortFormFee); /*Optional 13*/ dbIns.AddValue("EffectiveDate", this.EffectiveDate); dbIns.AddValue("CreatedDate", this.CreatedDate); /*Optional 15*/ dbIns.AddValue("ImportBy", this.ImportBy); /*Optional 16*/ dbIns.AddValue("Notes", this.Notes); /*Optional 17*/ dbIns.AddValue("SecurityTypeID", this.SecurityTypeID); dbIns.AddValue("IncomeEventID", this.IncomeEventID); /*Optional 19*/ dbIns.AddValue("Issue", this.Issue); /*Optional 20*/ dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 21*/ dbIns.AddValue("AdditionalDSCFee", this.AdditionalDSCFee); /*Optional 22*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Filing.Get_cmdTP()); dbIns.AddValue("DividendIndex", this.DividendIndex); dbIns.AddValue("Custodian_Tax_Authority", this.Custodian_Tax_Authority); /*Optional 3*/ dbIns.AddValue("FiledDate", this.FiledDate); dbIns.AddValue("Num_ADRs_Filed", this.Num_ADRs_Filed); /*Optional 5*/ dbIns.AddValue("Num_ORDs_Filed", this.Num_ORDs_Filed); /*Optional 6*/ dbIns.AddValue("FedEx_Number", this.FedEx_Number); /*Optional 7*/ dbIns.AddValue("Filing_Method", this.Filing_Method); /*Optional 8*/ dbIns.AddValue("Reference_Number", this.Reference_Number); /*Optional 9*/ dbIns.AddValue("Delivery_Status", this.Delivery_Status); /*Optional 10*/ dbIns.AddValue("Accept", this.Accept); /*Optional 11*/ dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 12*/ dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 13*/ dbIns.AddValue("Custodial_Receipt_Date", this.Custodial_Receipt_Date); /*Optional 14*/ dbIns.AddValue("CustodianID", this.CustodianID); /*Optional 15*/ dbIns.AddValue("ReclaimFeesType", this.ReclaimFeesType); /*Optional 16*/ dbIns.AddValue("Master_Reference_Number", this.Master_Reference_Number); /*Optional 17*/ dbIns.AddValue("FilingStatus", this.FilingStatus); /*Optional 18*/ dbIns.AddValue("Allowed_ReclaimFeesTypes", this.Allowed_ReclaimFeesTypes); /*Optional 19*/ dbIns.AddValue("FilingTo", this.FilingTo); /*Optional 20*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(SavedFilesCustodianBalance.Get_cmdTP()); dbIns.AddValue("originalFileName", this.originalFileName);/*Optional 2*/ dbIns.AddValue("SavedFiles_XML_CB", this.SavedFiles_XML_CB); dbIns.AddValue("AnnouncementName", this.AnnouncementName.Value); dbIns.AddValue("AnnouncementSender", this.AnnouncementSender.Value); dbIns.AddValue("AnnouncementIdentifier", this.AnnouncementIdentifier.Value); dbIns.AddValue("AnnouncementDate", this.AnnouncementDate.Value); dbIns.AddValue("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier.Value); dbIns.AddValue("SECURITY_IDENTIFIER_CUSIP", this.SECURITY_IDENTIFIER_CUSIP.Value); dbIns.AddValue("ISSUER_NAME", this.ISSUER_NAME.Value); dbIns.AddValue("ADR_RECORD_DATE", this.ADR_RECORD_DATE.Value); dbIns.AddValue("ADRBase", this.ADRBase); /*Optional 12*/ dbIns.AddValue("OrdinaryShare", this.OrdinaryShare); /*Optional 13*/ dbIns.AddValue("source", this.source.Value); dbIns.AddValue("processState", this.processState.Value); dbIns.AddValue("WhenProcessed", this.WhenProcessed); /*Optional 16*/ dbIns.AddValue("Processedby", this.Processedby); /*Optional 17*/ dbIns.AddValue("flgLock", this.flgLock); /*Optional 18*/ dbIns.AddValue("WhenLocked_date", this.WhenLocked_date); /*Optional 19*/ dbIns.AddValue("LockedBy_userid", this.LockedBy_userid); /*Optional 20*/ dbIns.AddValue("createdby", this.createdby.Value); dbIns.AddValue("createddate", this.createddate.Value); dbIns.AddValue("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs);/*Optional 23*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Schedule_Of_Fees_DSC.Get_cmdTP()); dbIns.AddValue("DividendIndex", this.DividendIndex); dbIns.AddValue("WHRate", this.WHRate); dbIns.AddValue("LongFormFees", this.LongFormFees); dbIns.AddValue("MinLongFormFee", this.MinLongFormFee); dbIns.AddValue("Fee_Max", this.Fee_Max); dbIns.AddValue("Fee_Consularization", this.Fee_Consularization); dbIns.AddValue("FavAtSourceFee", this.FavAtSourceFee); dbIns.AddValue("MinAtSourceFee", this.MinAtSourceFee); dbIns.AddValue("ExemptAtSourceFee", this.ExemptAtSourceFee); dbIns.AddValue("ShortFormFees", this.ShortFormFees); dbIns.AddValue("Fee_AtSource", this.Fee_AtSource); dbIns.AddValue("MinQuickRefundFee", this.MinQuickRefundFee); dbIns.AddValue("FavTransparentEntityFee", this.FavTransparentEntityFee); dbIns.AddValue("MinShortFormFee", this.MinShortFormFee); dbIns.AddValue("Fee_QuickRefund", this.Fee_QuickRefund); dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 17*/ dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 18*/ dbIns.AddValue("AdditionalDSCFee", this.AdditionalDSCFee); /*Optional 19*/ dbIns.AddValue("Source_FeeID", this.Source_FeeID); /*Optional 20*/ dbIns.AddValue("AdditionalDSCFee1", this.AdditionalDSCFee1); /*Optional 21*/ dbIns.AddValue("AtSourceModifiedBy", this.AtSourceModifiedBy); /*Optional 22*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(SavedFiles_CSV.Get_cmdTP()); dbIns.AddValue("originalFileName", this.originalFileName); /*Optional 2*/ dbIns.AddValue("SavedFiles_CSV", this.savedfile_csv); dbIns.AddValue("FileCreationDate", this.FileCreationDate); /*Optional 4*/ dbIns.AddValue("FTP_Source", this.FTP_Source); /*Optional 5*/ dbIns.AddValue("Status", this.Status); /*Optional 6*/ dbIns.AddValue("DividendIndex", this.DividendIndex); /*Optional 7*/ dbIns.AddValue("Depositary", this.Depositary); /*Optional 8*/ dbIns.AddValue("DTC", this.DTC); /*Optional 9*/ dbIns.AddValue("ProcessTime", this.ProcessTime); /*Optional 10*/ dbIns.AddValue("ProcessedBy", this.ProcessedBy); /*Optional 11*/ dbIns.AddValue("cpuFileName", this.cpuFileName); /*Optional 12*/ dbIns.AddValue("cpuSavedFiles_CSV", this.cpu_savedfile_csv); /*Optional 13*/ dbIns.AddValue("cpuStatus", this.cpuStatus); /*Optional 14*/ dbIns.AddValue("cpuProcessTime", this.cpuProcessTime); /*Optional 15*/ dbIns.AddValue("cpuProcessedBy", this.cpuProcessedBy); /*Optional 16*/ dbIns.AddValue("OriginalSchema", this.OriginalSchema); /*Optional 17*/ dbIns.AddValue("OriginalData", this.OriginalData); /*Optional 18*/ dbIns.AddValue("RecordDate", this.RecordDate); /*Optional 19*/ dbIns.AddValue("Sender", this.Sender); /*Optional 20*/ dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 21*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Custodian.Get_cmdTP()); dbIns.AddValue("Custodian_ShortName", this.Custodian_ShortName); dbIns.AddValue("Custodian_FullName", this.Custodian_FullName); dbIns.AddValue("Account_Number", this.Account_Number); /*Optional 4*/ dbIns.AddValue("Safekeeping_Number", this.Safekeeping_Number); /*Optional 5*/ dbIns.AddValue("Language", this.Language); /*Optional 6*/ dbIns.AddValue("Country_Code", this.Country_Code); /*Optional 7*/ dbIns.AddValue("Title", this.Title); /*Optional 8*/ dbIns.AddValue("From_FirstName", this.From_FirstName); /*Optional 9*/ dbIns.AddValue("From_LastName", this.From_LastName); /*Optional 10*/ dbIns.AddValue("From_Company", this.From_Company); /*Optional 11*/ dbIns.AddValue("From_Address1", this.From_Address1); /*Optional 12*/ dbIns.AddValue("From_Address2", this.From_Address2); /*Optional 13*/ dbIns.AddValue("From_Address3", this.From_Address3); /*Optional 14*/ dbIns.AddValue("From_Address4", this.From_Address4); /*Optional 15*/ dbIns.AddValue("From_Address5", this.From_Address5); /*Optional 16*/ dbIns.AddValue("Telephone", this.Telephone); /*Optional 17*/ dbIns.AddValue("Fax", this.Fax); /*Optional 18*/ dbIns.AddValue("DefaultCustodianType", this.DefaultCustodianType); /*Optional 19*/ dbIns.AddValue("PrimaryAllowed", this.PrimaryAllowed); /*Optional 20*/ dbIns.AddValue("Tax_Authority", this.Tax_Authority); /*Optional 21*/ dbIns.AddValue("TA_ATTN", this.TA_ATTN); /*Optional 22*/ dbIns.AddValue("TA_Address1", this.TA_Address1); /*Optional 23*/ dbIns.AddValue("TA_Address2", this.TA_Address2); /*Optional 24*/ dbIns.AddValue("Custodian_Alias", this.Custodian_Alias); /*Optional 25*/ dbIns.AddValue("TA_Phone", this.TA_Phone); /*Optional 26*/ dbIns.AddValue("TA_FAX", this.TA_FAX); /*Optional 27*/ dbIns.AddValue("Custodian_Ref_Number", this.Custodian_Ref_Number); /*Optional 28*/ dbIns.AddValue("JPM_Custodian_Ref_Num", this.JPM_Custodian_Ref_Num); /*Optional 29*/ return(dbIns); }
public bool Insert_to_DB() { HssUtility.SQLserver.DB_insert ins = this.Get_DBinsert(); int count = ins.SaveToDB(Utility.Get_ESP2_hDB()); return(count > 0); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(ADR_Group_Member.Get_cmdTP()); dbIns.AddValue("GroupID", this.GroupID.Value); dbIns.AddValue("OwnerSID", this.OwnerSID.Value); return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(ADR_Member_Country.Get_cmdTP()); dbIns.AddValue("TaskOwner_SID", this.TaskOwner_SID.Value); dbIns.AddValue("ISO2CntryCode", this.ISO2CntryCode.Value); return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(ADR_Group.Get_cmdTP()); dbIns.AddValue("GroupName", this.GroupName.Value); dbIns.AddValue("Group_LeaderSID", this.Group_LeaderSID.Value); dbIns.AddValue("Group_Email", this.Group_Email);/*Optional 4*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { this.LastModifyAt.Value = DateTime.Now; HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Hss_UserConfig.Get_cmdTP()); dbIns.AddValue("UserName", this.UserName); /*Optional 2*/ dbIns.AddValue("ConfigXML", this.ConfigXML); /*Optional 3*/ dbIns.AddValue("LastModifyAt", this.LastModifyAt); /*Optional 4*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(EDI_country.Get_cmdTP()); dbIns.AddValue("name", this.name); /*Optional 2*/ dbIns.AddValue("currency_id", this.currency_id); /*Optional 3*/ dbIns.AddValue("iso2_cd", this.iso2_cd); /*Optional 4*/ dbIns.AddValue("iso3_cd", this.iso3_cd); /*Optional 5*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Country_ProcedureTypes.Get_cmdTP()); dbIns.AddValue("IsSponsored", this.IsSponsored);/*Optional 2*/ dbIns.AddValue("At_Source", this.At_Source.Value); dbIns.AddValue("Quick_Refund", this.Quick_Refund.Value); dbIns.AddValue("Long_Form", this.Long_Form.Value); return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Detail_full.Get_cmdTP()); dbIns.AddValue("DTC_Number", this.DTC_Number.Value); dbIns.AddValue("Status", this.Status); /*Optional 27*/ dbIns.AddValue("RecordDatePosition", this.RecordDatePosition); /*Optional 30*/ dbIns.AddValue("Dividend_FilingID", this.Dividend_FilingID); /*Optional 37*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(TestClass.Get_cmdTP()); dbIns.AddValue("Name", this.Name); /*Optional 2*/ dbIns.AddValue("Birthday", this.Birthday); /*Optional 3*/ dbIns.AddValue("Salary", this.Salary); /*Optional 4*/ dbIns.AddValue("IsMarried", this.IsMarried); /*Optional 5*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(DepositaryIdemnification.Get_cmdTP()); dbIns.AddValue("depositary_info_id", this.depositary_info_id.Value); dbIns.AddValue("language_id", this.language_id.Value); dbIns.AddValue("idemnification", this.idemnification.Value); dbIns.AddValue("idemnification2", this.idemnification2.Value); dbIns.AddValue("idemnification_di", this.idemnification_di.Value); dbIns.AddValue("idemnification2_di", this.idemnification2_di.Value); dbIns.AddValue("idemnification_russia", this.idemnification_russia.Value);/*Optional 8*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Country.Get_cmdTP()); dbIns.AddValue("cntry_cd", this.cntry_cd.Value); dbIns.AddValue("currency_id", this.currency_id); /*Optional 3*/ dbIns.AddValue("longform_coefficient", this.longform_coefficient); /*Optional 5*/ dbIns.AddValue("In_ESP", this.In_ESP); /*Optional 6*/ dbIns.AddValue("ISO3_cntry_cd", this.ISO3_cntry_cd); /*Optional 7*/ dbIns.AddValue("GlobeTaxEmail", this.GlobeTaxEmail); /*Optional 8*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Task21_security.Get_cmdTP()); dbIns.AddValue("SecurityID", this.SecurityID); /*Optional 2*/ dbIns.AddValue("TaskName", this.TaskName); /*Optional 3*/ dbIns.AddValue("Status", this.Status); /*Optional 4*/ dbIns.AddValue("ValueStr", this.ValueStr); /*Optional 5*/ dbIns.AddValue("CreateBy", this.CreateBy); /*Optional 6*/ dbIns.AddValue("CreateDate", this.CreateDate); /*Optional 7*/ return(dbIns); }
/// <summary> /// insert object to DB /// </summary> public bool Insert_to_DB() { HssUtility.SQLserver.DB_insert ins = this.Get_DBinsert(); int count = ins.SaveToDB(Utility.Get_DRWIN_hDB()); bool flag = count > 0; if (flag) { this.SyncWithDB(); } return(flag); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Schedule_Of_Fees_Per_Rate.Get_cmdTP()); dbIns.AddValue("Security_Type", this.Security_Type); /*Optional 2*/ dbIns.AddValue("Depositary", this.Depositary); dbIns.AddValue("WithholdingRate", this.WithholdingRate); /*Optional 4*/ dbIns.AddValue("ADSC", this.ADSC); /*Optional 5*/ dbIns.AddValue("RateWithADSC", this.RateWithADSC); /*Optional 6*/ dbIns.AddValue("EffectiveDate", this.EffectiveDate); /*Optional 7*/ dbIns.AddValue("CreatedDate", this.CreatedDate); /*Optional 8*/ dbIns.AddValue("ImportBy", this.ImportBy); /*Optional 9*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Hss_DailyJobs.Get_cmdTP()); dbIns.AddValue("Job_Class", this.Job_Class); /*Optional 2*/ dbIns.AddValue("Job_ID", this.Job_ID); /*Optional 3*/ dbIns.AddValue("LastRunAt", this.LastRunAt); /*Optional 4*/ dbIns.AddValue("LastRunBy", this.LastRunBy); /*Optional 5*/ dbIns.AddValue("Locked", this.Locked); /*Optional 6*/ dbIns.AddValue("Notes", this.Notes); /*Optional 7*/ dbIns.AddValue("LastLockAt", this.LastLockAt); /*Optional 8*/ dbIns.AddValue("LastLockBy", this.LastLockBy); /*Optional 9*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(DividendXBRL.Get_cmdTP()); dbIns.AddValue("DividendIndex", this.DividendIndex); dbIns.AddValue("Depositary", this.Depositary); /*Optional 3*/ dbIns.AddValue("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber); dbIns.AddValue("PSAFE", this.PSAFE); /*Optional 5*/ dbIns.AddValue("LastModifiedDate", this.LastModifiedDate); /*Optional 6*/ dbIns.AddValue("SourceType", this.SourceType); /*Optional 7*/ dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 8*/ dbIns.AddValue("Announcement Identifier", this.Announcement_Identifier); /*Optional 9*/ dbIns.AddValue("Event Completeness", this.Event_Completeness); /*Optional 10*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Depositary.Get_cmdTP()); dbIns.AddValue("DepositaryID", this.DepositaryID.Value); dbIns.AddValue("DepositaryName", this.DepositaryName.Value); dbIns.AddValue("DepositaryDisplayName", this.DepositaryDisplayName.Value); /*Optional 4*/ dbIns.AddValue("DepositaryShortName", this.DepositaryShortName.Value); /*Optional 5*/ dbIns.AddValue("DepositaryIndex", this.DepositaryIndex.Value); /*Optional 6*/ dbIns.AddValue("Depositary_Contact", this.Depositary_Contact.Value); /*Optional 7*/ dbIns.AddValue("Depositary_Phone", this.Depositary_Phone.Value); /*Optional 8*/ dbIns.AddValue("Depositary_Address1", this.Depositary_Address1.Value); /*Optional 9*/ dbIns.AddValue("Depositary_Address2", this.Depositary_Address2.Value); /*Optional 10*/ dbIns.AddValue("Depositary_City", this.Depositary_City.Value); /*Optional 11*/ dbIns.AddValue("Depositary_State", this.Depositary_State.Value); /*Optional 12*/ dbIns.AddValue("Active", this.Active.Value); /*Optional 13*/ dbIns.AddValue("UniqueDepositaryIndex", this.UniqueDepositaryIndex.Value); /*Optional 14*/ dbIns.AddValue("SecurityTypeID", this.SecurityTypeID.Value); /*Optional 15*/ dbIns.AddValue("ESP_DepositaryName", this.ESP_DepositaryName.Value); /*Optional 16*/ dbIns.AddValue("ESP_DepositaryAddress1", this.ESP_DepositaryAddress1.Value); /*Optional 17*/ dbIns.AddValue("ESP_DepositaryAddress2", this.ESP_DepositaryAddress2.Value); /*Optional 18*/ dbIns.AddValue("ESP_Phone", this.ESP_Phone.Value); /*Optional 19*/ dbIns.AddValue("ESP_Fax", this.ESP_Fax.Value); /*Optional 20*/ dbIns.AddValue("ESP_InternationalPhone", this.ESP_InternationalPhone.Value); /*Optional 21*/ dbIns.AddValue("ESP_DepositaryFullName", this.ESP_DepositaryFullName.Value); /*Optional 22*/ dbIns.AddValue("ESP_Idemnification", this.ESP_Idemnification.Value); /*Optional 23*/ dbIns.AddValue("ESP_Idemnification2", this.ESP_Idemnification2.Value); /*Optional 24*/ dbIns.AddValue("ESP_Idemnification_DI", this.ESP_Idemnification_DI.Value); /*Optional 25*/ dbIns.AddValue("ESP_Idemnification2_DI", this.ESP_Idemnification2_DI.Value); /*Optional 26*/ dbIns.AddValue("ESP_DepositaryAccount", this.ESP_DepositaryAccount.Value); /*Optional 27*/ dbIns.AddValue("ESP_DepositaryIBANCode", this.ESP_DepositaryIBANCode.Value); /*Optional 28*/ dbIns.AddValue("ESP_DepositaryBIC", this.ESP_DepositaryBIC.Value); /*Optional 29*/ dbIns.AddValue("ESP_DepositaryBank", this.ESP_DepositaryBank.Value); /*Optional 30*/ dbIns.AddValue("Nominee", this.Nominee.Value); /*Optional 31*/ dbIns.AddValue("Nominee_Address", this.Nominee_Address.Value); /*Optional 32*/ dbIns.AddValue("ESP_Idemnification_RUSSIA", this.ESP_Idemnification_RUSSIA.Value); /*Optional 33*/ dbIns.AddValue("ActiveFirstFiler", this.ActiveFirstFiler.Value); /*Optional 34*/ dbIns.AddValue("PaymentInvoiceCurrency", this.PaymentInvoiceCurrency.Value); dbIns.AddValue("ClearingSystem", this.ClearingSystem.Value); /*Optional 36*/ dbIns.AddValue("ACH_Enabled", this.ACH_Enabled.Value); /*Optional 37*/ dbIns.AddValue("Originated_ACH_Company_ID", this.Originated_ACH_Company_ID.Value); /*Optional 38*/ dbIns.AddValue("Originated_Account_Number", this.Originated_Account_Number.Value); /*Optional 39*/ dbIns.AddValue("ACH_ModifiedBy", this.ACH_ModifiedBy.Value); /*Optional 40*/ dbIns.AddValue("ACH_ModifiedDateTime", this.ACH_ModifiedDateTime.Value); /*Optional 41*/ dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime.Value); /*Optional 42*/ dbIns.AddValue("Unique_DepositaryName", this.Unique_DepositaryName.Value); /*Optional 43*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(ADR_TaskOwner.Get_cmdTP()); dbIns.AddValue("OwnerSID", this.OwnerSID.Value); dbIns.AddValue("OwnerName", this.OwnerName.Value); dbIns.AddValue("Owner_LastName", this.Owner_LastName); /*Optional 4*/ dbIns.AddValue("Owner_FirstName", this.Owner_FirstName); /*Optional 5*/ //dbIns.AddValue("AllProperties", this.AllProperties);/*Optional 6*/ dbIns.AddValue("Telephone", this.Telephone); /*Optional 7*/ dbIns.AddValue("Email", this.Email); /*Optional 8*/ dbIns.AddValue("Department", this.Department); /*Optional 9*/ dbIns.AddValue("Title", this.Title); /*Optional 10*/ //dbIns.AddValue("Signature", this.Signature);/*Optional 11*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(StatutoryRate_edi.Get_cmdTP()); dbIns.AddValue("coi", this.coi); /*Optional 2*/ dbIns.AddValue("cor", this.cor); /*Optional 3*/ dbIns.AddValue("statry_rt", this.statry_rt); /*Optional 4*/ dbIns.AddValue("int_rt", this.int_rt); /*Optional 5*/ dbIns.AddValue("effect_dt", this.effect_dt); /*Optional 6*/ dbIns.AddValue("created_dt", this.created_dt); /*Optional 7*/ dbIns.AddValue("modified_dt", this.modified_dt); /*Optional 8*/ dbIns.AddValue("migratedId", this.migratedId); /*Optional 9*/ dbIns.AddValue("sec_type", this.sec_type); /*Optional 10*/ dbIns.AddValue("bo_typ", this.bo_typ); /*Optional 11*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Detail_full.Get_cmdTP()); //dbIns.AddValue("DividendIndex", this.DividendIndex.Value); dbIns.AddValue("DTC_Number", this.DTC_Number.Value); //dbIns.AddValue("Depositary", this.Depositary);/*Optional 10*/ dbIns.AddValue("BO_COR", this.BO_COR); /*Optional 18*/ dbIns.AddValue("BO_EntityType", this.BO_EntityType); /*Optional 19*/ dbIns.AddValue("ReclaimRate", this.ReclaimRate); /*Optional 22*/ dbIns.AddValue("CustodianID", this.CustodianID); /*Optional 25*/ dbIns.AddValue("Status", this.Status); /*Optional 27*/ dbIns.AddValue("RecordDatePosition", this.RecordDatePosition); /*Optional 30*/ dbIns.AddValue("ReclaimFeesType", this.ReclaimFeesType); /*Optional 41*/ dbIns.AddValue("PaidViaDTCC", this.PaidViaDTCC); /*Optional 120*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(SPR_file.Get_cmdTP()); dbIns.AddValue("FileName", this.FileName); /*Optional 2*/ dbIns.AddValue("CreateTime", this.CreateTime); /*Optional 3*/ dbIns.AddValue("FileBinary", this.FileBinary); /*Optional 4*/ dbIns.AddValue("CreateBy", this.CreateBy); /*Optional 5*/ dbIns.AddValue("Status", this.Status); /*Optional 6*/ dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 7*/ dbIns.AddValue("RecordDate", this.RecordDate); /*Optional 8*/ dbIns.AddValue("SecurityName", this.SecurityName); /*Optional 9*/ dbIns.AddValue("LastModifyAt", this.LastModifyAt); /*Optional 10*/ dbIns.AddValue("LastModifyBy", this.LastModifyBy); /*Optional 11*/ dbIns.AddValue("LastModifyAction", this.LastModifyAction); /*Optional 12*/ return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(EDI_times.Get_cmdTP()); dbIns.AddValue("cntry_cd", this.cntry_cd); dbIns.AddValue("bo_cor", this.bo_cor); dbIns.AddValue("timebar", this.timebar); dbIns.AddValue("eoy", this.eoy); dbIns.AddValue("pay_dt", this.pay_dt); dbIns.AddValue("expect_dt", this.expect_dt); dbIns.AddValue("effect_dt", this.effect_dt); dbIns.AddValue("from_dt", this.from_dt); dbIns.AddValue("created_dt", this.created_dt); dbIns.AddValue("modified_dt", this.modified_dt); dbIns.AddValue("migratedId", this.migratedId); dbIns.AddValue("sec_type", this.sec_type); return(dbIns); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(RSH_log.Get_cmdTP()); dbIns.AddValue("DividendIndex", this.DividendIndex); dbIns.AddValue("DTC", this.DTC); dbIns.AddValue("Depositary", this.Depositary); dbIns.AddValue("AccountNumber", this.AccountNumber); /*Optional 5*/ dbIns.AddValue("TIN", this.TIN); /*Optional 6*/ dbIns.AddValue("Shares", this.Shares); /*Optional 7*/ dbIns.AddValue("RegisteredName", this.RegisteredName); /*Optional 8*/ dbIns.AddValue("Address", this.Address); /*Optional 9*/ dbIns.AddValue("CountryCode", this.CountryCode); /*Optional 10*/ dbIns.AddValue("TaxStatus", this.TaxStatus); /*Optional 11*/ dbIns.AddValue("ForeignTaxWH", this.ForeignTaxWH); /*Optional 12*/ dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 13*/ dbIns.AddValue("IssueNumber", this.IssueNumber); /*Optional 14*/ dbIns.AddValue("CitizenshipCode", this.CitizenshipCode); /*Optional 15*/ dbIns.AddValue("OwnerCode", this.OwnerCode); /*Optional 16*/ dbIns.AddValue("ZipCode", this.ZipCode); /*Optional 17*/ dbIns.AddValue("State", this.State); /*Optional 18*/ dbIns.AddValue("CityName", this.CityName); /*Optional 19*/ dbIns.AddValue("Agent", this.Agent); /*Optional 20*/ dbIns.AddValue("LOC", this.LOC); /*Optional 21*/ dbIns.AddValue("RecordDate", this.RecordDate); /*Optional 22*/ dbIns.AddValue("Comp_Num", this.Comp_Num); /*Optional 23*/ dbIns.AddValue("Class_CD", this.Class_CD); /*Optional 24*/ dbIns.AddValue("Tax_CD", this.Tax_CD); /*Optional 25*/ dbIns.AddValue("Shares2", this.Shares2); /*Optional 26*/ dbIns.AddValue("GlobeTax", this.GlobeTax); /*Optional 27*/ dbIns.AddValue("Dividend_Intention", this.Dividend_Intention); /*Optional 28*/ dbIns.AddValue("Holder_On_Date", this.Holder_On_Date); /*Optional 29*/ dbIns.AddValue("Tin_Status_1", this.Tin_Status_1); /*Optional 30*/ dbIns.AddValue("Tin_Status_Source", this.Tin_Status_Source); /*Optional 31*/ dbIns.AddValue("Tin_Exp_Date_1", this.Tin_Exp_Date_1); /*Optional 32*/ dbIns.AddValue("Tin_B_Count", this.Tin_B_Count); /*Optional 33*/ dbIns.AddValue("Holder_Type_Code", this.Holder_Type_Code); /*Optional 34*/ dbIns.AddValue("Last_Contact_Date", this.Last_Contact_Date); /*Optional 35*/ dbIns.AddValue("Last_Contact_Type", this.Last_Contact_Type); /*Optional 36*/ dbIns.AddValue("GlobeTax_Findings", this.GlobeTax_Findings); /*Optional 37*/ return(dbIns); }