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);
}
