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