internal void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("event_id");
this.dividend_index.Value = reader.GetInt("dividend_index");
this.security_id.Value = reader.GetInt("security_id");
this.record_date_adr.Value = reader.GetDateTime("record_date_adr");
this.pay_date_adr.Value = reader.GetDateTime("pay_date_adr");
this.record_date_ord.Value = reader.GetDateTime("record_date_ord");
this.pay_date_ord.Value = reader.GetDateTime("pay_date_ord");
this.deadline_at_source.Value = reader.GetDateTime("deadline_at_source");
this.deadline_quick_refund.Value = reader.GetDateTime("deadline_quick_refund");
this.deadline_long_form.Value = reader.GetDateTime("deadline_long_form");
this.depositary_info_id.Value = reader.GetInt("depositary_info_id");
this.market_statute_of_limitations.Value = reader.GetDateTime("market_statute_of_limitations");
this.enabled.Value = reader.GetBool("enabled");
this.notes.Value = reader.GetString("notes");
this.last_modified_by.Value = reader.GetString("last_modified_by");
this.last_modified_at.Value = reader.GetDateTime("last_modified_at");
this.is_active.Value = reader.GetBool("is_active");
this.dividend.Value = reader.GetString("dividend");
this.is_exception.Value = reader.GetBool("is_exception");
this.esp_model_id.Value = reader.GetInt("esp_model_id");
this.SyncWithDB();
}
internal void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.DividendIndex = reader.GetInt("DividendIndex");
this.DTC_Number = reader.GetString("DTC_Number");
this.Company_Name = reader.GetString("Company_Name");
this.Total_RecDate_Position = reader.GetDecimal("Total_RecDate_Position");
this.CustodianID = reader.GetInt("CustodianID");
for (int i = 1; i <= Rates.RateCount; ++i)
{
this.curr_ratePos[i] = reader.GetDecimal("Rate_Position_" + i);
this.DB_ratePos[i] = this.curr_ratePos[i];
this.curr_rateCharges[i] = reader.GetDecimal("Rate_Chargeback_" + i);
this.DB_rateCharges[i] = this.curr_rateCharges[i];
}
for (int i = 1; i <= 5; ++i)
{
this.Exampts[i] = reader.GetDecimal("Exempt" + i);
}
}
internal void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.curr_DCT = reader.GetInt("DTC");
this.DCT_Number = reader.GetString("DTC_Number");
this.Company_Name = reader.GetString("Company_Name");
this.Type = reader.GetString("Type");
}
internal void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.Dividend_OptionID = reader.GetInt("Dividend_OptionID");
this.DividendIndex = reader.GetInt("DividendIndex");
this.OptionNumber = reader.GetInt("OptionNumber");
this.Sender = reader.GetString("Sender");
this.OptionActionType = reader.GetString("OptionActionType");
}
internal void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("security_id");
this.security_name.Value = reader.GetString("security_name");
this.esp_system_id.Value = reader.GetInt("esp_system_id");
this.cusip.Value = reader.GetString("cusip");
this.isin.Value = reader.GetString("isin");
this.sedol.Value = reader.GetString("sedol");
this.SyncWithDB();
}
private HashSet <int> Get_currFX_ID_set(string taskName)
{
HashSet <int> hs = new HashSet <int>();
CmdTemplate tp = new CmdTemplate();
tp.schema = "Task";
tp.tableName = "Task_Detail";
tp.AddColumn("SourceID");
DB_select selt = new DB_select(tp);
SQL_relation rel0 = new SQL_relation("TaskID", RelationalOperator.Equals, Task20_master.TaskID_20);
SQL_relation rel1 = new SQL_relation("TaskName", RelationalOperator.Equals, taskName);
SQL_condition cond0 = new SQL_condition(rel0), cond1 = new SQL_condition(rel1);
SQL_condition cond = new SQL_condition(cond0, ConditionalOperator.And, cond1);
selt.SetCondition(cond);
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
int tempInt = -1;
string tempStr = reader.GetString("SourceID");
if (int.TryParse(tempStr, out tempInt))
{
hs.Add(tempInt);
}
}
reader.Close();
return(hs);
}
internal void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.TABLE_SCHEMA = reader.GetString("TABLE_SCHEMA");
this.TABLE_NAME = reader.GetString("TABLE_NAME");
this.COLUMN_NAME = reader.GetString("COLUMN_NAME");
this.ORDINAL_POSITION = reader.GetInt("ORDINAL_POSITION");
this.IS_NULLABLE = reader.GetString("IS_NULLABLE");
this.DATA_TYPE = reader.GetString("DATA_TYPE");
this.attr_name = this.COLUMN_NAME.Replace(' ', '_');
}
public void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.DTC_Number = reader.GetString("DTC_Number");
this.DividendIndex = reader.GetInt("DividendIndex");
this.ClaimShares_ADRS_SUM = reader.GetDecimal("ClaimShares_ADRS_SUM");
}
public void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.DividendIndex = reader.GetInt("DividendIndex");
this.Issue = reader.GetString("Issue");
this.Country = reader.GetString("Country");
this.CUSIP = reader.GetString("CUSIP");
this.DTCPosition_ModelNumber = reader.GetInt("DTCPosition_ModelNumber");
this.RecordDate_ADR = reader.GetDateTime("RecordDate_ADR", Utility.MinDate);
this.PayDate_ADR = reader.GetDateTime("PayDate_ADR", Utility.MinDate);
this.PayDate_ORD = reader.GetDateTime("PayDate_ORD", Utility.MinDate);
this.FinalDivGrossAmount_ORD = reader.GetDecimal("FinalDivGrossAmount_ORD");
this.FinalDivGrossAmount_ADR = reader.GetDecimal("FinalDivGrossAmount_ADR");
this.LongFormFee = reader.GetDecimal("LongFormFee");
this.StatutoryRate = reader.GetDecimal("StatutoryRate");
}
internal void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("esp_system_id");
this.coi_code.Value = reader.GetString("coi_code");
this.clearing_system_id.Value = reader.GetInt("clearing_system_id");
this.security_type_id.Value = reader.GetInt("security_type_id");
this.event_restriction_id.Value = reader.GetInt("event_restriction_id");
this.SyncWithDB();
}
internal void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("depositary_info_id");
this.depositary_name.Value = reader.GetString("depositary_name");
this.depositary_address1.Value = reader.GetString("depositary_address1");
this.depositary_address2.Value = reader.GetString("depositary_address2");
this.phone.Value = reader.GetString("phone");
this.fax.Value = reader.GetString("fax");
this.international_phone.Value = reader.GetString("international_phone");
this.depositary_full_name.Value = reader.GetString("depositary_full_name");
this.depositary_index.Value = reader.GetInt("depositary_index");
this.active.Value = reader.GetBool("active");
this.stamp_name.Value = reader.GetString("stamp_name");
this.SyncWithDB();
}
public void Init_from_reader(DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.DTC_PositionID = reader.GetInt("DTC_PositionID");
this.DTC_Number = reader.GetString("DTC_Number");
this.DividendIndex = reader.GetInt("DividendIndex");
this.Total_RecDate_Position = reader.GetDecimal("Total_RecDate_Position");
for (int i = 1; i <= 18; ++i)
{
string colName = "Rate_Position_" + i;
decimal val = reader.GetDecimal(colName, 0);
if (val > 0)
{
this.values_dic[colName] = val;
}
}
for (int i = 1; i <= 18; ++i)
{
string colName = "Rate_Chargeback_" + i;
decimal val = reader.GetDecimal(colName, 0);
if (val > 0)
{
this.values_dic[colName] = val;
}
}
for (int i = 1; i <= 5; ++i)
{
string colName = "Exempt" + i;
decimal val = reader.GetDecimal(colName, 0);
if (val > 0)
{
this.values_dic[colName] = val;
}
}
}