internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Task21_security.Get_cmdTP()); if (this.SecurityID.ValueChanged) { upd.AddValue("SecurityID", this.SecurityID); } if (this.TaskName.ValueChanged) { upd.AddValue("TaskName", this.TaskName); } if (this.Status.ValueChanged) { upd.AddValue("Status", this.Status); } if (this.ValueStr.ValueChanged) { upd.AddValue("ValueStr", this.ValueStr); } if (this.CreateBy.ValueChanged) { upd.AddValue("CreateBy", this.CreateBy); } if (this.CreateDate.ValueChanged) { upd.AddValue("CreateDate", this.CreateDate); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Country.Get_cmdTP()); if (this.cntry_cd.ValueChanged) { upd.AddValue("cntry_cd", this.cntry_cd); } if (this.currency_id.ValueChanged) { upd.AddValue("currency_id", this.currency_id); } if (this.longform_coefficient.ValueChanged) { upd.AddValue("longform_coefficient", this.longform_coefficient); } if (this.In_ESP.ValueChanged) { upd.AddValue("In_ESP", this.In_ESP); } if (this.ISO3_cntry_cd.ValueChanged) { upd.AddValue("ISO3_cntry_cd", this.ISO3_cntry_cd); } if (this.GlobeTaxEmail.ValueChanged) { upd.AddValue("GlobeTaxEmail", this.GlobeTaxEmail); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("name", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (this.event_contact_info_id < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(EventContactInfo.Get_cmdTP()); db_sel.tableName = "EventContactInfo"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("event_contact_info_id", HssUtility.General.RelationalOperator.Equals, this.event_contact_info_id); db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_ESP2_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() { if (this.id_SavedFilesCustodianBalance < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(SavedFilesCustodianBalance.Get_cmdTP()); db_sel.tableName = "SavedFilesCustodianBalance"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedFilesCustodianBalance", HssUtility.General.RelationalOperator.Equals, this.id_SavedFilesCustodianBalance); 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() { if (this.SecurityID < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Security.Get_cmdTP()); db_sel.tableName = "Securities"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("SecurityID", HssUtility.General.RelationalOperator.Equals, this.SecurityID); 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() { if (this.primary_custodian_id < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(PrimaryCustodian.Get_cmdTP()); db_sel.tableName = "PrimaryCustodian"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("primary_custodian_id", HssUtility.General.RelationalOperator.Equals, this.primary_custodian_id); db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_ESP2_hDB()); if (reader.Read()) { this.Init_from_reader(reader); res_flag = true; } reader.Close(); return(res_flag); }
public bool Init_from_DB() { if (this.depositary_idemnification_id < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(DepositaryIdemnification.Get_cmdTP()); db_sel.tableName = "DepositaryIdemnification"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("depositary_idemnification_id", HssUtility.General.RelationalOperator.Equals, this.depositary_idemnification_id); 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() { if (string.IsNullOrEmpty(this.name)) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Country.Get_cmdTP()); db_sel.tableName = "Countries"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("name", HssUtility.General.RelationalOperator.Equals, this.name); 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); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(RSH_log.Get_cmdTP()); if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); } if (this.DTC.ValueChanged) { upd.AddValue("DTC", this.DTC); } if (this.Depositary.ValueChanged) { upd.AddValue("Depositary", this.Depositary); } if (this.AccountNumber.ValueChanged) { upd.AddValue("AccountNumber", this.AccountNumber); /*Optional 5*/ } if (this.TIN.ValueChanged) { upd.AddValue("TIN", this.TIN); /*Optional 6*/ } if (this.Shares.ValueChanged) { upd.AddValue("Shares", this.Shares); /*Optional 7*/ } if (this.RegisteredName.ValueChanged) { upd.AddValue("RegisteredName", this.RegisteredName); /*Optional 8*/ } if (this.Address.ValueChanged) { upd.AddValue("Address", this.Address); /*Optional 9*/ } if (this.CountryCode.ValueChanged) { upd.AddValue("CountryCode", this.CountryCode); /*Optional 10*/ } if (this.TaxStatus.ValueChanged) { upd.AddValue("TaxStatus", this.TaxStatus); /*Optional 11*/ } if (this.ForeignTaxWH.ValueChanged) { upd.AddValue("ForeignTaxWH", this.ForeignTaxWH); /*Optional 12*/ } if (this.CUSIP.ValueChanged) { upd.AddValue("CUSIP", this.CUSIP); /*Optional 13*/ } if (this.IssueNumber.ValueChanged) { upd.AddValue("IssueNumber", this.IssueNumber); /*Optional 14*/ } if (this.CitizenshipCode.ValueChanged) { upd.AddValue("CitizenshipCode", this.CitizenshipCode); /*Optional 15*/ } if (this.OwnerCode.ValueChanged) { upd.AddValue("OwnerCode", this.OwnerCode); /*Optional 16*/ } if (this.ZipCode.ValueChanged) { upd.AddValue("ZipCode", this.ZipCode); /*Optional 17*/ } if (this.State.ValueChanged) { upd.AddValue("State", this.State); /*Optional 18*/ } if (this.CityName.ValueChanged) { upd.AddValue("CityName", this.CityName); /*Optional 19*/ } if (this.Agent.ValueChanged) { upd.AddValue("Agent", this.Agent); /*Optional 20*/ } if (this.LOC.ValueChanged) { upd.AddValue("LOC", this.LOC); /*Optional 21*/ } if (this.RecordDate.ValueChanged) { upd.AddValue("RecordDate", this.RecordDate); /*Optional 22*/ } if (this.Comp_Num.ValueChanged) { upd.AddValue("Comp_Num", this.Comp_Num); /*Optional 23*/ } if (this.Class_CD.ValueChanged) { upd.AddValue("Class_CD", this.Class_CD); /*Optional 24*/ } if (this.Tax_CD.ValueChanged) { upd.AddValue("Tax_CD", this.Tax_CD); /*Optional 25*/ } if (this.Shares2.ValueChanged) { upd.AddValue("Shares2", this.Shares2); /*Optional 26*/ } if (this.GlobeTax.ValueChanged) { upd.AddValue("GlobeTax", this.GlobeTax); /*Optional 27*/ } if (this.Dividend_Intention.ValueChanged) { upd.AddValue("Dividend_Intention", this.Dividend_Intention); /*Optional 28*/ } if (this.Holder_On_Date.ValueChanged) { upd.AddValue("Holder_On_Date", this.Holder_On_Date); /*Optional 29*/ } if (this.Tin_Status_1.ValueChanged) { upd.AddValue("Tin_Status_1", this.Tin_Status_1); /*Optional 30*/ } if (this.Tin_Status_Source.ValueChanged) { upd.AddValue("Tin_Status_Source", this.Tin_Status_Source); /*Optional 31*/ } if (this.Tin_Exp_Date_1.ValueChanged) { upd.AddValue("Tin_Exp_Date_1", this.Tin_Exp_Date_1); /*Optional 32*/ } if (this.Tin_B_Count.ValueChanged) { upd.AddValue("Tin_B_Count", this.Tin_B_Count); /*Optional 33*/ } if (this.Holder_Type_Code.ValueChanged) { upd.AddValue("Holder_Type_Code", this.Holder_Type_Code); /*Optional 34*/ } if (this.Last_Contact_Date.ValueChanged) { upd.AddValue("Last_Contact_Date", this.Last_Contact_Date); /*Optional 35*/ } if (this.Last_Contact_Type.ValueChanged) { upd.AddValue("Last_Contact_Type", this.Last_Contact_Type); /*Optional 36*/ } if (this.GlobeTax_Findings.ValueChanged) { upd.AddValue("GlobeTax_Findings", this.GlobeTax_Findings); /*Optional 37*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("RSHID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(DTC_Participants.Get_cmdTP()); if (this.DTC_Number.ValueChanged) { upd.AddValue("DTC_Number", this.DTC_Number); } if (this.Company_Name.ValueChanged) { upd.AddValue("Company_Name", this.Company_Name); } if (this.ATTN.ValueChanged) { upd.AddValue("ATTN", this.ATTN); /*Optional 4*/ } if (this.Address1.ValueChanged) { upd.AddValue("Address1", this.Address1); /*Optional 5*/ } if (this.Address2.ValueChanged) { upd.AddValue("Address2", this.Address2); /*Optional 6*/ } if (this.City.ValueChanged) { upd.AddValue("City", this.City); /*Optional 7*/ } if (this.State.ValueChanged) { upd.AddValue("State", this.State); /*Optional 8*/ } if (this.Country.ValueChanged) { upd.AddValue("Country", this.Country); /*Optional 9*/ } if (this.Zip_Postal_Code.ValueChanged) { upd.AddValue("Zip_Postal_Code", this.Zip_Postal_Code); /*Optional 10*/ } if (this.Phone.ValueChanged) { upd.AddValue("Phone", this.Phone); /*Optional 11*/ } if (this.Fax.ValueChanged) { upd.AddValue("Fax", this.Fax); /*Optional 12*/ } if (this.WebsiteUrl.ValueChanged) { upd.AddValue("WebsiteUrl", this.WebsiteUrl); /*Optional 13*/ } if (this.Email.ValueChanged) { upd.AddValue("Email", this.Email); /*Optional 14*/ } if (this.Fixed_Payment_ATTN.ValueChanged) { upd.AddValue("Fixed_Payment_ATTN", this.Fixed_Payment_ATTN); /*Optional 15*/ } if (this.Type.ValueChanged) { upd.AddValue("Type", this.Type); /*Optional 16*/ } if (this.Depositary.ValueChanged) { upd.AddValue("Depositary", this.Depositary); /*Optional 17*/ } if (this.RejectEmail.ValueChanged) { upd.AddValue("RejectEmail", this.RejectEmail); /*Optional 18*/ } if (this.PaymentEmail.ValueChanged) { upd.AddValue("PaymentEmail", this.PaymentEmail); /*Optional 19*/ } if (this.DocInventoryEmail.ValueChanged) { upd.AddValue("DocInventoryEmail", this.DocInventoryEmail); /*Optional 20*/ } if (this.SecurityTypeID.ValueChanged) { upd.AddValue("SecurityTypeID", this.SecurityTypeID); } if (this.AccountNumber.ValueChanged) { upd.AddValue("AccountNumber", this.AccountNumber); } if (this.IssuerCSD.ValueChanged) { upd.AddValue("IssuerCSD", this.IssuerCSD); /*Optional 23*/ } if (this.ACH_Override.ValueChanged) { upd.AddValue("ACH_Override", this.ACH_Override); /*Optional 24*/ } if (this.ACH_Bank.ValueChanged) { upd.AddValue("ACH_Bank", this.ACH_Bank); /*Optional 25*/ } if (this.ACH_ABA.ValueChanged) { upd.AddValue("ACH_ABA", this.ACH_ABA); /*Optional 26*/ } if (this.ACH_Account.ValueChanged) { upd.AddValue("ACH_Account", this.ACH_Account); /*Optional 27*/ } if (this.ClearingSystem.ValueChanged) { upd.AddValue("ClearingSystem", this.ClearingSystem); } if (this.CustomWireMemo.ValueChanged) { upd.AddValue("CustomWireMemo", this.CustomWireMemo); /*Optional 29*/ } if (this.ModifiedDateTime.ValueChanged) { upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 30*/ } if (this.Email_backup.ValueChanged) { upd.AddValue("Email_backup", this.Email_backup); /*Optional 31*/ } if (this.PaymentEmail_backup.ValueChanged) { upd.AddValue("PaymentEmail_backup", this.PaymentEmail_backup); /*Optional 32*/ } if (this.RejectEmail_backup.ValueChanged) { upd.AddValue("RejectEmail_backup", this.RejectEmail_backup); /*Optional 33*/ } if (this.DocInventoryEmail_backup.ValueChanged) { upd.AddValue("DocInventoryEmail_backup", this.DocInventoryEmail_backup); /*Optional 34*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("DTC", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(EventContactInfo.Get_cmdTP()); if (this.event_id.ValueChanged) { upd.AddValue("event_id", this.event_id); } if (this.contact_company_name.ValueChanged) { upd.AddValue("contact_company_name", this.contact_company_name); } if (this.contact_address1.ValueChanged) { upd.AddValue("contact_address1", this.contact_address1); } if (this.contact_address2.ValueChanged) { upd.AddValue("contact_address2", this.contact_address2); } if (this.contact_country_code.ValueChanged) { upd.AddValue("contact_country_code", this.contact_country_code); } if (this.contact_attn.ValueChanged) { upd.AddValue("contact_attn", this.contact_attn); } if (this.contact_phone.ValueChanged) { upd.AddValue("contact_phone", this.contact_phone); } if (this.contact_fax.ValueChanged) { upd.AddValue("contact_fax", this.contact_fax); } if (this.contact_email.ValueChanged) { upd.AddValue("contact_email", this.contact_email); } if (this.contact_city.ValueChanged) { upd.AddValue("contact_city", this.contact_city); } if (this.contact_state.ValueChanged) { upd.AddValue("contact_state", this.contact_state); } if (this.contact_zip.ValueChanged) { upd.AddValue("contact_zip", this.contact_zip); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("event_contact_info_id", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(DTC_Position_Headers.Get_cmdTP()); if (this.ModelNumber.ValueChanged) { upd.AddValue("ModelNumber", this.ModelNumber); } if (this.Country.ValueChanged) { upd.AddValue("Country", this.Country); } if (this.Column_Header_Name.ValueChanged) { upd.AddValue("Column_Header_Name", this.Column_Header_Name); } if (this.Table_Column.ValueChanged) { upd.AddValue("Table_Column", this.Table_Column); } if (this.Rate_Desc.ValueChanged) { upd.AddValue("Rate_Desc", this.Rate_Desc); } if (this.WHRate.ValueChanged) { upd.AddValue("WHRate", this.WHRate); } if (this.ArmorColumn.ValueChanged) { upd.AddValue("ArmorColumn", this.ArmorColumn); } if (this.Category.ValueChanged) { upd.AddValue("Category", this.Category); } if (this.DiscloseType.ValueChanged) { upd.AddValue("DiscloseType", this.DiscloseType); } if (this.SortOrder.ValueChanged) { upd.AddValue("SortOrder", this.SortOrder); } if (this.ChargeBackFrom.ValueChanged) { upd.AddValue("ChargeBackFrom", this.ChargeBackFrom); } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); } if (this.ModifiedDateTime.ValueChanged) { upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Dividend_Schedule_Of_Fees_DSC.Get_cmdTP()); if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); } if (this.WHRate.ValueChanged) { upd.AddValue("WHRate", this.WHRate); } if (this.LongFormFees.ValueChanged) { upd.AddValue("LongFormFees", this.LongFormFees); } if (this.MinLongFormFee.ValueChanged) { upd.AddValue("MinLongFormFee", this.MinLongFormFee); } if (this.Fee_Max.ValueChanged) { upd.AddValue("Fee_Max", this.Fee_Max); } if (this.Fee_Consularization.ValueChanged) { upd.AddValue("Fee_Consularization", this.Fee_Consularization); } if (this.FavAtSourceFee.ValueChanged) { upd.AddValue("FavAtSourceFee", this.FavAtSourceFee); } if (this.MinAtSourceFee.ValueChanged) { upd.AddValue("MinAtSourceFee", this.MinAtSourceFee); } if (this.ExemptAtSourceFee.ValueChanged) { upd.AddValue("ExemptAtSourceFee", this.ExemptAtSourceFee); } if (this.ShortFormFees.ValueChanged) { upd.AddValue("ShortFormFees", this.ShortFormFees); } if (this.Fee_AtSource.ValueChanged) { upd.AddValue("Fee_AtSource", this.Fee_AtSource); } if (this.MinQuickRefundFee.ValueChanged) { upd.AddValue("MinQuickRefundFee", this.MinQuickRefundFee); } if (this.FavTransparentEntityFee.ValueChanged) { upd.AddValue("FavTransparentEntityFee", this.FavTransparentEntityFee); } if (this.MinShortFormFee.ValueChanged) { upd.AddValue("MinShortFormFee", this.MinShortFormFee); } if (this.Fee_QuickRefund.ValueChanged) { upd.AddValue("Fee_QuickRefund", this.Fee_QuickRefund); } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 17*/ } if (this.ModifiedDateTime.ValueChanged) { upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 18*/ } if (this.AdditionalDSCFee.ValueChanged) { upd.AddValue("AdditionalDSCFee", this.AdditionalDSCFee); /*Optional 19*/ } if (this.Source_FeeID.ValueChanged) { upd.AddValue("Source_FeeID", this.Source_FeeID); /*Optional 20*/ } if (this.AdditionalDSCFee1.ValueChanged) { upd.AddValue("AdditionalDSCFee1", this.AdditionalDSCFee1); /*Optional 21*/ } if (this.AtSourceModifiedBy.ValueChanged) { upd.AddValue("AtSourceModifiedBy", this.AtSourceModifiedBy); /*Optional 22*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Dividend_FeeID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(PrimaryCustodian.Get_cmdTP()); if (this.custodian_number.ValueChanged) { upd.AddValue("custodian_number", this.custodian_number); } if (this.name.ValueChanged) { upd.AddValue("name", this.name); } if (this.address1.ValueChanged) { upd.AddValue("address1", this.address1); } if (this.address2.ValueChanged) { upd.AddValue("address2", this.address2); } if (this.city.ValueChanged) { upd.AddValue("city", this.city); } if (this.state.ValueChanged) { upd.AddValue("state", this.state); } if (this.zip.ValueChanged) { upd.AddValue("zip", this.zip); } if (this.country_code.ValueChanged) { upd.AddValue("country_code", this.country_code); } if (this.attn.ValueChanged) { upd.AddValue("attn", this.attn); } if (this.phone.ValueChanged) { upd.AddValue("phone", this.phone); } if (this.fax.ValueChanged) { upd.AddValue("fax", this.fax); } if (this.email.ValueChanged) { upd.AddValue("email", this.email); } if (this.event_id.ValueChanged) { upd.AddValue("event_id", this.event_id); } if (this.psafe.ValueChanged) { upd.AddValue("psafe", this.psafe); } if (this.safe_keeping_account_number.ValueChanged) { upd.AddValue("safe_keeping_account_number", this.safe_keeping_account_number); } if (this.depositary_name.ValueChanged) { upd.AddValue("depositary_name", this.depositary_name); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("primary_custodian_id", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(EDI_times.Get_cmdTP()); if (this.cntry_cd.ValueChanged) { upd.AddValue("cntry_cd", this.cntry_cd); } if (this.bo_cor.ValueChanged) { upd.AddValue("bo_cor", this.bo_cor); } if (this.timebar.ValueChanged) { upd.AddValue("timebar", this.timebar); } if (this.eoy.ValueChanged) { upd.AddValue("eoy", this.eoy); } if (this.pay_dt.ValueChanged) { upd.AddValue("pay_dt", this.pay_dt); } if (this.expect_dt.ValueChanged) { upd.AddValue("expect_dt", this.expect_dt); } if (this.effect_dt.ValueChanged) { upd.AddValue("effect_dt", this.effect_dt); } if (this.from_dt.ValueChanged) { upd.AddValue("from_dt", this.from_dt); } if (this.created_dt.ValueChanged) { upd.AddValue("created_dt", this.created_dt); } if (this.modified_dt.ValueChanged) { upd.AddValue("modified_dt", this.modified_dt); } if (this.migratedId.ValueChanged) { upd.AddValue("migratedId", this.migratedId); } if (this.sec_type.ValueChanged) { upd.AddValue("sec_type", this.sec_type); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(FX_Input.Get_cmdTP()); if (this.CountryName.ValueChanged) { upd.AddValue("CountryName", this.CountryName); } if (this.Custodian.ValueChanged) { upd.AddValue("Custodian", this.Custodian); } if (this.AccountNumber.ValueChanged) { upd.AddValue("AccountNumber", this.AccountNumber); } if (this.Currency_Code.ValueChanged) { upd.AddValue("Currency_Code", this.Currency_Code); } if (this.FX_NotificationDate.ValueChanged) { upd.AddValue("FX_NotificationDate", this.FX_NotificationDate); } if (this.LocalAmountReceived.ValueChanged) { upd.AddValue("LocalAmountReceived", this.LocalAmountReceived); } if (this.Depositary_ReceivedDate.ValueChanged) { upd.AddValue("Depositary_ReceivedDate", this.Depositary_ReceivedDate); } if (this.FX_RequestedDate.ValueChanged) { upd.AddValue("FX_RequestedDate", this.FX_RequestedDate); } if (this.FX_ReceivedDate.ValueChanged) { upd.AddValue("FX_ReceivedDate", this.FX_ReceivedDate); } if (this.Depositary.ValueChanged) { upd.AddValue("Depositary", this.Depositary); } if (this.FX_Rate.ValueChanged) { upd.AddValue("FX_Rate", this.FX_Rate); } if (this.USDAmountReceived.ValueChanged) { upd.AddValue("USDAmountReceived", this.USDAmountReceived); } if (this.ActualCheckRequestDate.ValueChanged) { upd.AddValue("ActualCheckRequestDate", this.ActualCheckRequestDate); } if (this.PayToBrokerDate.ValueChanged) { upd.AddValue("PayToBrokerDate", this.PayToBrokerDate); } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); } if (this.ModifiedDateTime.ValueChanged) { upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); } if (this.Forex_Fee.ValueChanged) { upd.AddValue("Forex_Fee", this.Forex_Fee); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("FX_InputID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(XBRLfield.Get_cmdTP()); if (this.xbrlElement.ValueChanged) { upd.AddValue("xbrlElement", this.xbrlElement); } if (this.xbrlAttributeName.ValueChanged) { upd.AddValue("xbrlAttributeName", this.xbrlAttributeName); } if (this.xbrlContextRefValue.ValueChanged) { upd.AddValue("xbrlContextRefValue", this.xbrlContextRefValue); } if (this.NameSpace.ValueChanged) { upd.AddValue("namespace", this.NameSpace); } if (this.drwinFieldName.ValueChanged) { upd.AddValue("drwinFieldName", this.drwinFieldName); } if (this.drwinControlType.ValueChanged) { upd.AddValue("drwinControlType", this.drwinControlType); } if (this.multiple.ValueChanged) { upd.AddValue("multiple", this.multiple); } if (this.active.ValueChanged) { upd.AddValue("active", this.active); } if (this.chkCompleteness.ValueChanged) { upd.AddValue("chkCompleteness", this.chkCompleteness); } if (this.drwinFieldNameIncomplete.ValueChanged) { upd.AddValue("drwinFieldNameIncomplete", this.drwinFieldNameIncomplete); } if (this.drwinFieldNameComplete.ValueChanged) { upd.AddValue("drwinFieldNameComplete", this.drwinFieldNameComplete); } if (this.createdDate.ValueChanged) { upd.AddValue("createdDate", this.createdDate); } if (this.createdBy.ValueChanged) { upd.AddValue("createdBy", this.createdBy); } if (this.overridable.ValueChanged) { upd.AddValue("overridable", this.overridable); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_XBRLField", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(DividendCustodian.Get_cmdTP()); if (this.Custodian_Number.ValueChanged) { upd.AddValue("Custodian_Number", this.Custodian_Number); } if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); } if (this.Custodian.ValueChanged) { upd.AddValue("Custodian", this.Custodian); } if (this.Custodian_Reported.ValueChanged) { upd.AddValue("Custodian_Reported", this.Custodian_Reported); } if (this.Custodian_Paid.ValueChanged) { upd.AddValue("Custodian_Paid", this.Custodian_Paid); } if (this.FavAtSourceADRs.ValueChanged) { upd.AddValue("FavAtSourceADRs", this.FavAtSourceADRs); } if (this.ExemptAtSourceADRs.ValueChanged) { upd.AddValue("ExemptAtSourceADRs", this.ExemptAtSourceADRs); } if (this.FavTransparentEntityADRs.ValueChanged) { upd.AddValue("FavTransparentEntityADRs", this.FavTransparentEntityADRs); } if (this.Custodian_Chargeback.ValueChanged) { upd.AddValue("Custodian_Chargeback", this.Custodian_Chargeback); } if (this.SafeKeeping_AccountNum.ValueChanged) { upd.AddValue("SafeKeeping_AccountNum", this.SafeKeeping_AccountNum); } if (this.Cash_Account_Number.ValueChanged) { upd.AddValue("Cash_Account_Number", this.Cash_Account_Number); } if (this.Custodial_Fees.ValueChanged) { upd.AddValue("Custodial_Fees", this.Custodial_Fees); } if (this.AtSourceFeePerShare.ValueChanged) { upd.AddValue("AtSourceFeePerShare", this.AtSourceFeePerShare); } if (this.Custodian_Type.ValueChanged) { upd.AddValue("Custodian_Type", this.Custodian_Type); } if (this.Depositary.ValueChanged) { upd.AddValue("Depositary", this.Depositary); } if (this.Currency.ValueChanged) { upd.AddValue("Currency", this.Currency); } if (this.Base.ValueChanged) { upd.AddValue("Base", this.Base); } if (this.Custodial_Percent.ValueChanged) { upd.AddValue("Custodial_Percent", this.Custodial_Percent); } if (this.Maximum_Fees.ValueChanged) { upd.AddValue("Maximum_Fees", this.Maximum_Fees); } if (this.Minimum_Fees.ValueChanged) { upd.AddValue("Minimum_Fees", this.Minimum_Fees); } if (this.Contact_Name.ValueChanged) { upd.AddValue("Contact_Name", this.Contact_Name); } if (this.Reference_Number.ValueChanged) { upd.AddValue("Reference_Number", this.Reference_Number); } if (this.Address1.ValueChanged) { upd.AddValue("Address1", this.Address1); } if (this.Address2.ValueChanged) { upd.AddValue("Address2", this.Address2); } if (this.State.ValueChanged) { upd.AddValue("State", this.State); } if (this.City.ValueChanged) { upd.AddValue("City", this.City); } if (this.Zip.ValueChanged) { upd.AddValue("Zip", this.Zip); } if (this.Comments.ValueChanged) { upd.AddValue("Comments", this.Comments); } if (this.Email.ValueChanged) { upd.AddValue("Email", this.Email); } if (this.Fax.ValueChanged) { upd.AddValue("Fax", this.Fax); } if (this.Phone.ValueChanged) { upd.AddValue("Phone", this.Phone); } if (this.Country.ValueChanged) { upd.AddValue("Country", this.Country); } if (this.Primary_Contact.ValueChanged) { upd.AddValue("Primary_Contact", this.Primary_Contact); } if (this.MasterFile.ValueChanged) { upd.AddValue("MasterFile", this.MasterFile); } if (this.PDFFile.ValueChanged) { upd.AddValue("PDFFile", this.PDFFile); } if (this.Paid_And_Locked.ValueChanged) { upd.AddValue("Paid_And_Locked", this.Paid_And_Locked); } if (this.Paid_And_Locked_DateTime.ValueChanged) { upd.AddValue("Paid_And_Locked_DateTime", this.Paid_And_Locked_DateTime); } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); } if (this.Billed_Date.ValueChanged) { upd.AddValue("Billed_Date", this.Billed_Date); } if (this.Paid_Date_Actual.ValueChanged) { upd.AddValue("Paid_Date_Actual", this.Paid_Date_Actual); } if (this.JPResidenceAtSourceADRs.ValueChanged) { upd.AddValue("JPResidenceAtSourceADRs", this.JPResidenceAtSourceADRs); } if (this.PSAFE.ValueChanged) { upd.AddValue("PSAFE", this.PSAFE); } if (this.Election_Version.ValueChanged) { upd.AddValue("Election_Version", this.Election_Version); } if (this.FavAtSourceADRs_RSH_Exclude.ValueChanged) { upd.AddValue("FavAtSourceADRs_RSH_Exclude", this.FavAtSourceADRs_RSH_Exclude); } if (this.WriteOff.ValueChanged) { upd.AddValue("WriteOff", this.WriteOff); } if (this.AffiliateRebate.ValueChanged) { upd.AddValue("AffiliateRebate", this.AffiliateRebate); } if (this.ModifiedDateTime.ValueChanged) { upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); } if (this.Custodial_FeeID.ValueChanged) { upd.AddValue("Custodial_FeeID", this.Custodial_FeeID); } if (this.FeeType.ValueChanged) { upd.AddValue("FeeType", this.FeeType); } if (this.FavAtSourceADRs_Detail.ValueChanged) { upd.AddValue("FavAtSourceADRs_Detail", this.FavAtSourceADRs_Detail); } if (this.RSH_Email_TimeStamp.ValueChanged) { upd.AddValue("RSH_Email_TimeStamp", this.RSH_Email_TimeStamp); } if (this.Bal_Email_TimeStamp.ValueChanged) { upd.AddValue("Bal_Email_TimeStamp", this.Bal_Email_TimeStamp); } if (this.CreatedDateTime.ValueChanged) { upd.AddValue("CreatedDateTime", this.CreatedDateTime); } if (this.XBRL_ReferenceNumber.ValueChanged) { upd.AddValue("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("CustodianID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } else { this.LastModifiedBy.Value = Utility.CurrentUser; this.LastModifiedDateTime.Value = DateTime.Now; } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Task_Detail.Get_cmdTP()); if (this.TaskID.ValueChanged) { upd.AddValue("TaskID", this.TaskID); } if (this.TaskName.ValueChanged) { upd.AddValue("TaskName", this.TaskName); } if (this.Country.ValueChanged) { upd.AddValue("Country", this.Country); } if (this.Depositary.ValueChanged) { upd.AddValue("Depositary", this.Depositary); } if (this.Issue.ValueChanged) { upd.AddValue("Issue", this.Issue); } if (this.CUSIP.ValueChanged) { upd.AddValue("CUSIP", this.CUSIP); } if (this.RecordDate.ValueChanged) { upd.AddValue("RecordDate", this.RecordDate); } if (this.SourceTable.ValueChanged) { upd.AddValue("SourceTable", this.SourceTable); } if (this.SourceID.ValueChanged) { upd.AddValue("SourceID", this.SourceID); } if (this.StartDate.ValueChanged) { upd.AddValue("StartDate", this.StartDate); } if (this.PriorityDate.ValueChanged) { upd.AddValue("PriorityDate", this.PriorityDate); } if (this.EndDate.ValueChanged) { upd.AddValue("EndDate", this.EndDate); } if (this.Notes.ValueChanged) { upd.AddValue("Notes", this.Notes); } if (this.Priority.ValueChanged) { upd.AddValue("Priority", this.Priority); } if (this.Completed.ValueChanged) { upd.AddValue("Completed", this.Completed); } if (this.CreatedBy.ValueChanged) { upd.AddValue("CreatedBy", this.CreatedBy); } if (this.CreatedDateTime.ValueChanged) { upd.AddValue("CreatedDateTime", this.CreatedDateTime); } if (this.CompletedBy.ValueChanged) { upd.AddValue("CompletedBy", this.CompletedBy); } if (this.CompletedDateTime.ValueChanged) { upd.AddValue("CompletedDateTime", this.CompletedDateTime); } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); } if (this.LastModifiedDateTime.ValueChanged) { upd.AddValue("LastModifiedDateTime", this.LastModifiedDateTime); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("TaskDetailID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Dividend_Filing.Get_cmdTP()); if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); } if (this.Custodian_Tax_Authority.ValueChanged) { upd.AddValue("Custodian_Tax_Authority", this.Custodian_Tax_Authority); /*Optional 3*/ } if (this.FiledDate.ValueChanged) { upd.AddValue("FiledDate", this.FiledDate); } if (this.Num_ADRs_Filed.ValueChanged) { upd.AddValue("Num_ADRs_Filed", this.Num_ADRs_Filed); /*Optional 5*/ } if (this.Num_ORDs_Filed.ValueChanged) { upd.AddValue("Num_ORDs_Filed", this.Num_ORDs_Filed); /*Optional 6*/ } if (this.FedEx_Number.ValueChanged) { upd.AddValue("FedEx_Number", this.FedEx_Number); /*Optional 7*/ } if (this.Filing_Method.ValueChanged) { upd.AddValue("Filing_Method", this.Filing_Method); /*Optional 8*/ } if (this.Reference_Number.ValueChanged) { upd.AddValue("Reference_Number", this.Reference_Number); /*Optional 9*/ } if (this.Delivery_Status.ValueChanged) { upd.AddValue("Delivery_Status", this.Delivery_Status); /*Optional 10*/ } if (this.Accept.ValueChanged) { upd.AddValue("Accept", this.Accept); /*Optional 11*/ } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 12*/ } if (this.ModifiedDateTime.ValueChanged) { upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 13*/ } if (this.Custodial_Receipt_Date.ValueChanged) { upd.AddValue("Custodial_Receipt_Date", this.Custodial_Receipt_Date); /*Optional 14*/ } if (this.CustodianID.ValueChanged) { upd.AddValue("CustodianID", this.CustodianID); /*Optional 15*/ } if (this.ReclaimFeesType.ValueChanged) { upd.AddValue("ReclaimFeesType", this.ReclaimFeesType); /*Optional 16*/ } if (this.Master_Reference_Number.ValueChanged) { upd.AddValue("Master_Reference_Number", this.Master_Reference_Number); /*Optional 17*/ } if (this.FilingStatus.ValueChanged) { upd.AddValue("FilingStatus", this.FilingStatus); /*Optional 18*/ } if (this.Allowed_ReclaimFeesTypes.ValueChanged) { upd.AddValue("Allowed_ReclaimFeesTypes", this.Allowed_ReclaimFeesTypes); /*Optional 19*/ } if (this.FilingTo.ValueChanged) { upd.AddValue("FilingTo", this.FilingTo); /*Optional 20*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Dividend_FilingID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Dividend_Control_Queue.Get_cmdTP()); if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); } if (this.TabName.ValueChanged) { upd.AddValue("TabName", this.TabName); } if (this.FieldName.ValueChanged) { upd.AddValue("FieldName", this.FieldName); } if (this.ColumnName.ValueChanged) { upd.AddValue("ColumnName", this.ColumnName); } if (this.PreviousValue.ValueChanged) { upd.AddValue("PreviousValue", this.PreviousValue); /*Optional 6*/ } if (this.NewValue.ValueChanged) { upd.AddValue("NewValue", this.NewValue); /*Optional 7*/ } if (this.DataType.ValueChanged) { upd.AddValue("DataType", this.DataType); } if (this.UserID.ValueChanged) { upd.AddValue("UserID", this.UserID); } if (this.QueueDateTime.ValueChanged) { upd.AddValue("QueueDateTime", this.QueueDateTime); } if (this.Status.ValueChanged) { upd.AddValue("Status", this.Status); } if (this.ApprovedBy.ValueChanged) { upd.AddValue("ApprovedBy", this.ApprovedBy); } if (this.Event.ValueChanged) { upd.AddValue("Event", this.Event); /*Optional 13*/ } if (this.Active.ValueChanged) { upd.AddValue("Active", this.Active); /*Optional 14*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Queue_ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } this.Processedby.Value = Utility.CurrentUser; this.WhenProcessed.Value = DateTime.Now; HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(XBRL_SavedFile.Get_cmdTP()); //if (this.savedfile.ValueChanged) upd.AddValue("savedfile", this.savedfile); //no update for binary for now if (this.EventType.ValueChanged) { upd.AddValue("EventType", this.EventType); } if (this.DRWINIncomeEventID.ValueChanged) { upd.AddValue("DRWINIncomeEventID", this.DRWINIncomeEventID); } if (this.cusip.ValueChanged) { upd.AddValue("cusip", this.cusip); } if (this.ISIN.ValueChanged) { upd.AddValue("ISIN", this.ISIN); } if (this.originalFileName.ValueChanged) { upd.AddValue("originalFileName", this.originalFileName); } if (this.DepositaryName.ValueChanged) { upd.AddValue("DepositaryName", this.DepositaryName); } if (this.AnnouncementDate.ValueChanged) { upd.AddValue("AnnouncementDate", this.AnnouncementDate); } if (this.EventCompleteness.ValueChanged) { upd.AddValue("EventCompleteness", this.EventCompleteness); } if (this.UniqueUniversalEventIdentifier.ValueChanged) { upd.AddValue("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier); } if (this.DepositoryReceiptSponsorIndicator.ValueChanged) { upd.AddValue("DepositoryReceiptSponsorIndicator", this.DepositoryReceiptSponsorIndicator); } if (this.PaymentDate.ValueChanged) { upd.AddValue("PaymentDate", this.PaymentDate); } if (this.RecordDate.ValueChanged) { upd.AddValue("RecordDate", this.RecordDate); } if (this.CountryOfIssue.ValueChanged) { upd.AddValue("CountryOfIssue", this.CountryOfIssue); } if (this.ContextRefBase.ValueChanged) { upd.AddValue("ContextRefBase", this.ContextRefBase); } if (this.Source.ValueChanged) { upd.AddValue("Source", this.Source); } if (this.processState.ValueChanged) { upd.AddValue("processState", this.processState); } if (this.WhenProcessed.ValueChanged) { upd.AddValue("WhenProcessed", this.WhenProcessed); } if (this.Processedby.ValueChanged) { upd.AddValue("Processedby", this.Processedby); } if (this.flgLock.ValueChanged) { upd.AddValue("flgLock", this.flgLock); } if (this.WhenLocked_date.ValueChanged) { upd.AddValue("WhenLocked_date", this.WhenLocked_date); } if (this.LockedBy_userid.ValueChanged) { upd.AddValue("LockedBy_userid", this.LockedBy_userid); } if (this.createdby.ValueChanged) { upd.AddValue("createdby", this.createdby); } if (this.createddate.ValueChanged) { upd.AddValue("createddate", this.createddate); } if (this.AnnouncementIdentifier.ValueChanged) { upd.AddValue("AnnouncementIdentifier", this.AnnouncementIdentifier); } if (this.FirstFilerFlag.ValueChanged) { upd.AddValue("FirstFilerFlag", this.FirstFilerFlag); } if (this.UnderlyingSecurityIssuerCountryofIncorporation.ValueChanged) { upd.AddValue("UnderlyingSecurityIssuerCountryofIncorporation", this.UnderlyingSecurityIssuerCountryofIncorporation); } if (this.id_SavedFiles_CSV.ValueChanged) { upd.AddValue("id_SavedFiles_CSV", this.id_SavedFiles_CSV); } if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); } if (this.AnnouncementType.ValueChanged) { upd.AddValue("AnnouncementType", this.AnnouncementType); } if (this.ID_GTS_SFTP_InputSITEs.ValueChanged) { upd.AddValue("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs); } if (this.recNum.ValueChanged) { upd.AddValue("recNum", this.recNum); } if (this.flgEmailSent.ValueChanged) { upd.AddValue("flgEmailSent", this.flgEmailSent); } if (this.EmailSentDate.ValueChanged) { upd.AddValue("EmailSentDate", this.EmailSentDate); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedfilesRcvd", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } this.LastModifiedBy.Value = Utility.CurrentUser; this.ModifiedDateTime.Value = DateTime.Now; HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Dividend_Payment.Get_cmdTP()); if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); } if (this.PaymentReferenceDate.ValueChanged) { upd.AddValue("PaymentReferenceDate", this.PaymentReferenceDate); } if (this.Depositary.ValueChanged) { upd.AddValue("Depositary", this.Depositary); } if (this.FXValueDate.ValueChanged) { upd.AddValue("FXValueDate", this.FXValueDate); } if (this.DivFXRate.ValueChanged) { upd.AddValue("DivFXRate", this.DivFXRate); } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); } if (this.ModifiedDateTime.ValueChanged) { upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); } if (this.Paid_And_Locked.ValueChanged) { upd.AddValue("Paid_And_Locked", this.Paid_And_Locked); } if (this.Paid_And_Locked_Date.ValueChanged) { upd.AddValue("Paid_And_Locked_Date", this.Paid_And_Locked_Date); } if (this.Billed_Date.ValueChanged) { upd.AddValue("Billed_Date", this.Billed_Date); } if (this.Paid_Date_Actual.ValueChanged) { upd.AddValue("Paid_Date_Actual", this.Paid_Date_Actual); } if (this.WriteOff.ValueChanged) { upd.AddValue("WriteOff", this.WriteOff); } if (this.FX_InputID.ValueChanged) { upd.AddValue("FX_InputID", this.FX_InputID); } if (this.CustodianID.ValueChanged) { upd.AddValue("CustodianID", this.CustodianID); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Dividend_PayID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Custodian.Get_cmdTP()); if (this.Custodian_ShortName.ValueChanged) { upd.AddValue("Custodian_ShortName", this.Custodian_ShortName); } if (this.Custodian_FullName.ValueChanged) { upd.AddValue("Custodian_FullName", this.Custodian_FullName); } if (this.Account_Number.ValueChanged) { upd.AddValue("Account_Number", this.Account_Number); /*Optional 4*/ } if (this.Safekeeping_Number.ValueChanged) { upd.AddValue("Safekeeping_Number", this.Safekeeping_Number); /*Optional 5*/ } if (this.Language.ValueChanged) { upd.AddValue("Language", this.Language); /*Optional 6*/ } if (this.Country_Code.ValueChanged) { upd.AddValue("Country_Code", this.Country_Code); /*Optional 7*/ } if (this.Title.ValueChanged) { upd.AddValue("Title", this.Title); /*Optional 8*/ } if (this.From_FirstName.ValueChanged) { upd.AddValue("From_FirstName", this.From_FirstName); /*Optional 9*/ } if (this.From_LastName.ValueChanged) { upd.AddValue("From_LastName", this.From_LastName); /*Optional 10*/ } if (this.From_Company.ValueChanged) { upd.AddValue("From_Company", this.From_Company); /*Optional 11*/ } if (this.From_Address1.ValueChanged) { upd.AddValue("From_Address1", this.From_Address1); /*Optional 12*/ } if (this.From_Address2.ValueChanged) { upd.AddValue("From_Address2", this.From_Address2); /*Optional 13*/ } if (this.From_Address3.ValueChanged) { upd.AddValue("From_Address3", this.From_Address3); /*Optional 14*/ } if (this.From_Address4.ValueChanged) { upd.AddValue("From_Address4", this.From_Address4); /*Optional 15*/ } if (this.From_Address5.ValueChanged) { upd.AddValue("From_Address5", this.From_Address5); /*Optional 16*/ } if (this.Telephone.ValueChanged) { upd.AddValue("Telephone", this.Telephone); /*Optional 17*/ } if (this.Fax.ValueChanged) { upd.AddValue("Fax", this.Fax); /*Optional 18*/ } if (this.DefaultCustodianType.ValueChanged) { upd.AddValue("DefaultCustodianType", this.DefaultCustodianType); /*Optional 19*/ } if (this.PrimaryAllowed.ValueChanged) { upd.AddValue("PrimaryAllowed", this.PrimaryAllowed); /*Optional 20*/ } if (this.Tax_Authority.ValueChanged) { upd.AddValue("Tax_Authority", this.Tax_Authority); /*Optional 21*/ } if (this.TA_ATTN.ValueChanged) { upd.AddValue("TA_ATTN", this.TA_ATTN); /*Optional 22*/ } if (this.TA_Address1.ValueChanged) { upd.AddValue("TA_Address1", this.TA_Address1); /*Optional 23*/ } if (this.TA_Address2.ValueChanged) { upd.AddValue("TA_Address2", this.TA_Address2); /*Optional 24*/ } if (this.Custodian_Alias.ValueChanged) { upd.AddValue("Custodian_Alias", this.Custodian_Alias); /*Optional 25*/ } if (this.TA_Phone.ValueChanged) { upd.AddValue("TA_Phone", this.TA_Phone); /*Optional 26*/ } if (this.TA_FAX.ValueChanged) { upd.AddValue("TA_FAX", this.TA_FAX); /*Optional 27*/ } if (this.Custodian_Ref_Number.ValueChanged) { upd.AddValue("Custodian_Ref_Number", this.Custodian_Ref_Number); /*Optional 28*/ } if (this.JPM_Custodian_Ref_Num.ValueChanged) { upd.AddValue("JPM_Custodian_Ref_Num", this.JPM_Custodian_Ref_Num); /*Optional 29*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Custodian_Number", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(SavedFiles_CSV.Get_cmdTP()); if (this.originalFileName.ValueChanged) { upd.AddValue("originalFileName", this.originalFileName); /*Optional 2*/ } //if (this.SavedFiles_CSV.ValueChanged) upd.AddValue("SavedFiles_CSV", this.SavedFiles_CSV);//no update for binary for now if (this.FileCreationDate.ValueChanged) { upd.AddValue("FileCreationDate", this.FileCreationDate); /*Optional 4*/ } if (this.FTP_Source.ValueChanged) { upd.AddValue("FTP_Source", this.FTP_Source); /*Optional 5*/ } if (this.Status.ValueChanged) { upd.AddValue("Status", this.Status); /*Optional 6*/ } if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); /*Optional 7*/ } if (this.Depositary.ValueChanged) { upd.AddValue("Depositary", this.Depositary); /*Optional 8*/ } if (this.DTC.ValueChanged) { upd.AddValue("DTC", this.DTC); /*Optional 9*/ } if (this.ProcessTime.ValueChanged) { upd.AddValue("ProcessTime", this.ProcessTime); /*Optional 10*/ } if (this.ProcessedBy.ValueChanged) { upd.AddValue("ProcessedBy", this.ProcessedBy); /*Optional 11*/ } if (this.cpuFileName.ValueChanged) { upd.AddValue("cpuFileName", this.cpuFileName); /*Optional 12*/ } //if (this.cpuSavedFiles_CSV.ValueChanged) upd.AddValue("cpuSavedFiles_CSV", this.cpuSavedFiles_CSV);//no update for binary for now if (this.cpuStatus.ValueChanged) { upd.AddValue("cpuStatus", this.cpuStatus); /*Optional 14*/ } if (this.cpuProcessTime.ValueChanged) { upd.AddValue("cpuProcessTime", this.cpuProcessTime); /*Optional 15*/ } if (this.cpuProcessedBy.ValueChanged) { upd.AddValue("cpuProcessedBy", this.cpuProcessedBy); /*Optional 16*/ } if (this.OriginalSchema.ValueChanged) { upd.AddValue("OriginalSchema", this.OriginalSchema); /*Optional 17*/ } if (this.OriginalData.ValueChanged) { upd.AddValue("OriginalData", this.OriginalData); /*Optional 18*/ } if (this.RecordDate.ValueChanged) { upd.AddValue("RecordDate", this.RecordDate); /*Optional 19*/ } if (this.Sender.ValueChanged) { upd.AddValue("Sender", this.Sender); /*Optional 20*/ } if (this.CUSIP.ValueChanged) { upd.AddValue("CUSIP", this.CUSIP); /*Optional 21*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedFiles_CSV", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(SavedFilesCustodianBalance.Get_cmdTP()); if (this.originalFileName.ValueChanged) { upd.AddValue("originalFileName", this.originalFileName); } //if (this.SavedFiles_XML_CB.ValueChanged) upd.AddValue("SavedFiles_XML_CB", this.SavedFiles_XML_CB); if (this.AnnouncementName.ValueChanged) { upd.AddValue("AnnouncementName", this.AnnouncementName); } if (this.AnnouncementSender.ValueChanged) { upd.AddValue("AnnouncementSender", this.AnnouncementSender); } if (this.AnnouncementIdentifier.ValueChanged) { upd.AddValue("AnnouncementIdentifier", this.AnnouncementIdentifier); } if (this.AnnouncementDate.ValueChanged) { upd.AddValue("AnnouncementDate", this.AnnouncementDate); } if (this.UniqueUniversalEventIdentifier.ValueChanged) { upd.AddValue("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier); } if (this.SECURITY_IDENTIFIER_CUSIP.ValueChanged) { upd.AddValue("SECURITY_IDENTIFIER_CUSIP", this.SECURITY_IDENTIFIER_CUSIP); } if (this.ISSUER_NAME.ValueChanged) { upd.AddValue("ISSUER_NAME", this.ISSUER_NAME); } if (this.ADR_RECORD_DATE.ValueChanged) { upd.AddValue("ADR_RECORD_DATE", this.ADR_RECORD_DATE); } if (this.ADRBase.ValueChanged) { upd.AddValue("ADRBase", this.ADRBase); } if (this.OrdinaryShare.ValueChanged) { upd.AddValue("OrdinaryShare", this.OrdinaryShare); } if (this.source.ValueChanged) { upd.AddValue("source", this.source); } if (this.processState.ValueChanged) { upd.AddValue("processState", this.processState); } if (this.WhenProcessed.ValueChanged) { upd.AddValue("WhenProcessed", this.WhenProcessed); } if (this.Processedby.ValueChanged) { upd.AddValue("Processedby", this.Processedby); } if (this.flgLock.ValueChanged) { upd.AddValue("flgLock", this.flgLock); } if (this.WhenLocked_date.ValueChanged) { upd.AddValue("WhenLocked_date", this.WhenLocked_date); } if (this.LockedBy_userid.ValueChanged) { upd.AddValue("LockedBy_userid", this.LockedBy_userid); } if (this.createdby.ValueChanged) { upd.AddValue("createdby", this.createdby); } if (this.createddate.ValueChanged) { upd.AddValue("createddate", this.createddate); } if (this.ID_GTS_SFTP_InputSITEs.ValueChanged) { upd.AddValue("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedFilesCustodianBalance", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Security.Get_cmdTP()); if (this.Name.ValueChanged) { upd.AddValue("Name", this.Name); } if (this.CUSIP.ValueChanged) { upd.AddValue("CUSIP", this.CUSIP); } if (this.Country.ValueChanged) { upd.AddValue("Country", this.Country); } if (this.TickerSymbol.ValueChanged) { upd.AddValue("TickerSymbol", this.TickerSymbol); } if (this.ISIN.ValueChanged) { upd.AddValue("ISIN", this.ISIN); } if (this.Sedol.ValueChanged) { upd.AddValue("Sedol", this.Sedol); } if (this.Depositary.ValueChanged) { upd.AddValue("Depositary", this.Depositary); } if (this.FirstFiler.ValueChanged) { upd.AddValue("FirstFiler", this.FirstFiler); } if (this.ClearingSystem.ValueChanged) { upd.AddValue("ClearingSystem", this.ClearingSystem); } if (this.SecurityType.ValueChanged) { upd.AddValue("SecurityType", this.SecurityType); } if (this.ModifiedDateTime.ValueChanged) { upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); } if (this.EffectiveDate.ValueChanged) { upd.AddValue("EffectiveDate", this.EffectiveDate); } if (this.ADR_RATIO_ADR.ValueChanged) { upd.AddValue("ADR_RATIO_ADR", this.ADR_RATIO_ADR); } if (this.ADR_RATIO_ORD.ValueChanged) { upd.AddValue("ADR_RATIO_ORD", this.ADR_RATIO_ORD); } if (this.DutchName.ValueChanged) { upd.AddValue("DutchName", this.DutchName); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("SecurityID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Schedule_Of_Fees_DSC.Get_cmdTP()); if (this.Country.ValueChanged) { upd.AddValue("Country", this.Country); } if (this.Security_Type.ValueChanged) { upd.AddValue("Security_Type", this.Security_Type); /*Optional 3*/ } if (this.Depositary.ValueChanged) { upd.AddValue("Depositary", this.Depositary); } if (this.ShortFormFees.ValueChanged) { upd.AddValue("ShortFormFees", this.ShortFormFees); /*Optional 5*/ } if (this.LongFormFees.ValueChanged) { upd.AddValue("LongFormFees", this.LongFormFees); /*Optional 6*/ } if (this.FavAtSourceFee.ValueChanged) { upd.AddValue("FavAtSourceFee", this.FavAtSourceFee); /*Optional 7*/ } if (this.ExemptAtSourceFee.ValueChanged) { upd.AddValue("ExemptAtSourceFee", this.ExemptAtSourceFee); /*Optional 8*/ } if (this.FavTransparentEntityFee.ValueChanged) { upd.AddValue("FavTransparentEntityFee", this.FavTransparentEntityFee); /*Optional 9*/ } if (this.MinAtSourceFee.ValueChanged) { upd.AddValue("MinAtSourceFee", this.MinAtSourceFee); /*Optional 10*/ } if (this.MinLongFormFee.ValueChanged) { upd.AddValue("MinLongFormFee", this.MinLongFormFee); /*Optional 11*/ } if (this.MinQuickRefundFee.ValueChanged) { upd.AddValue("MinQuickRefundFee", this.MinQuickRefundFee); /*Optional 12*/ } if (this.MinShortFormFee.ValueChanged) { upd.AddValue("MinShortFormFee", this.MinShortFormFee); /*Optional 13*/ } if (this.EffectiveDate.ValueChanged) { upd.AddValue("EffectiveDate", this.EffectiveDate); } if (this.CreatedDate.ValueChanged) { upd.AddValue("CreatedDate", this.CreatedDate); /*Optional 15*/ } if (this.ImportBy.ValueChanged) { upd.AddValue("ImportBy", this.ImportBy); /*Optional 16*/ } if (this.Notes.ValueChanged) { upd.AddValue("Notes", this.Notes); /*Optional 17*/ } if (this.SecurityTypeID.ValueChanged) { upd.AddValue("SecurityTypeID", this.SecurityTypeID); } if (this.IncomeEventID.ValueChanged) { upd.AddValue("IncomeEventID", this.IncomeEventID); /*Optional 19*/ } if (this.Issue.ValueChanged) { upd.AddValue("Issue", this.Issue); /*Optional 20*/ } if (this.CUSIP.ValueChanged) { upd.AddValue("CUSIP", this.CUSIP); /*Optional 21*/ } if (this.AdditionalDSCFee.ValueChanged) { upd.AddValue("AdditionalDSCFee", this.AdditionalDSCFee); /*Optional 22*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("FeesID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }