public static void Init_from_DB()
{
if ((DateTime.Now - DepositaryMaster.lastUpdateTime).TotalHours < Utility.RefreshInterval)
{
return;
}
DepositaryMaster.Reset();
DB_select selt = new DB_select(Depositary.Get_cmdTP());
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
Depositary depo = new Depositary();
depo.Init_from_reader(reader);
DepositaryMaster.depoID_dic[depo.DepositaryID.Value] = depo;
DepositaryMaster.shortName_dic[depo.DepositaryShortName.Value] = depo;
if (DepositaryMaster.depoName_dic.ContainsKey(depo.DepositaryName.Value)) //handle "unsponsered"
{
Depositary existing_depo = DepositaryMaster.depoName_dic[depo.DepositaryName.Value];
if (depo.DepositaryIndex.Value < 0)
{
continue;
}
if (existing_depo.DepositaryIndex.Value < 0)
{
DepositaryMaster.depoName_dic[depo.DepositaryName.Value] = depo;
}
else if (depo.DepositaryIndex.Value < existing_depo.DepositaryIndex.Value)
{
DepositaryMaster.depoName_dic[depo.DepositaryName.Value] = depo;
}
else
{
continue;
}
}
else
{
DepositaryMaster.depoName_dic[depo.DepositaryName.Value] = depo;
}
}
reader.Close();
DepositaryMaster.lastUpdateTime = DateTime.Now;
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Depositary.Get_cmdTP());
dbIns.AddValue("DepositaryID", this.DepositaryID.Value);
dbIns.AddValue("DepositaryName", this.DepositaryName.Value);
dbIns.AddValue("DepositaryDisplayName", this.DepositaryDisplayName.Value); /*Optional 4*/
dbIns.AddValue("DepositaryShortName", this.DepositaryShortName.Value); /*Optional 5*/
dbIns.AddValue("DepositaryIndex", this.DepositaryIndex.Value); /*Optional 6*/
dbIns.AddValue("Depositary_Contact", this.Depositary_Contact.Value); /*Optional 7*/
dbIns.AddValue("Depositary_Phone", this.Depositary_Phone.Value); /*Optional 8*/
dbIns.AddValue("Depositary_Address1", this.Depositary_Address1.Value); /*Optional 9*/
dbIns.AddValue("Depositary_Address2", this.Depositary_Address2.Value); /*Optional 10*/
dbIns.AddValue("Depositary_City", this.Depositary_City.Value); /*Optional 11*/
dbIns.AddValue("Depositary_State", this.Depositary_State.Value); /*Optional 12*/
dbIns.AddValue("Active", this.Active.Value); /*Optional 13*/
dbIns.AddValue("UniqueDepositaryIndex", this.UniqueDepositaryIndex.Value); /*Optional 14*/
dbIns.AddValue("SecurityTypeID", this.SecurityTypeID.Value); /*Optional 15*/
dbIns.AddValue("ESP_DepositaryName", this.ESP_DepositaryName.Value); /*Optional 16*/
dbIns.AddValue("ESP_DepositaryAddress1", this.ESP_DepositaryAddress1.Value); /*Optional 17*/
dbIns.AddValue("ESP_DepositaryAddress2", this.ESP_DepositaryAddress2.Value); /*Optional 18*/
dbIns.AddValue("ESP_Phone", this.ESP_Phone.Value); /*Optional 19*/
dbIns.AddValue("ESP_Fax", this.ESP_Fax.Value); /*Optional 20*/
dbIns.AddValue("ESP_InternationalPhone", this.ESP_InternationalPhone.Value); /*Optional 21*/
dbIns.AddValue("ESP_DepositaryFullName", this.ESP_DepositaryFullName.Value); /*Optional 22*/
dbIns.AddValue("ESP_Idemnification", this.ESP_Idemnification.Value); /*Optional 23*/
dbIns.AddValue("ESP_Idemnification2", this.ESP_Idemnification2.Value); /*Optional 24*/
dbIns.AddValue("ESP_Idemnification_DI", this.ESP_Idemnification_DI.Value); /*Optional 25*/
dbIns.AddValue("ESP_Idemnification2_DI", this.ESP_Idemnification2_DI.Value); /*Optional 26*/
dbIns.AddValue("ESP_DepositaryAccount", this.ESP_DepositaryAccount.Value); /*Optional 27*/
dbIns.AddValue("ESP_DepositaryIBANCode", this.ESP_DepositaryIBANCode.Value); /*Optional 28*/
dbIns.AddValue("ESP_DepositaryBIC", this.ESP_DepositaryBIC.Value); /*Optional 29*/
dbIns.AddValue("ESP_DepositaryBank", this.ESP_DepositaryBank.Value); /*Optional 30*/
dbIns.AddValue("Nominee", this.Nominee.Value); /*Optional 31*/
dbIns.AddValue("Nominee_Address", this.Nominee_Address.Value); /*Optional 32*/
dbIns.AddValue("ESP_Idemnification_RUSSIA", this.ESP_Idemnification_RUSSIA.Value); /*Optional 33*/
dbIns.AddValue("ActiveFirstFiler", this.ActiveFirstFiler.Value); /*Optional 34*/
dbIns.AddValue("PaymentInvoiceCurrency", this.PaymentInvoiceCurrency.Value);
dbIns.AddValue("ClearingSystem", this.ClearingSystem.Value); /*Optional 36*/
dbIns.AddValue("ACH_Enabled", this.ACH_Enabled.Value); /*Optional 37*/
dbIns.AddValue("Originated_ACH_Company_ID", this.Originated_ACH_Company_ID.Value); /*Optional 38*/
dbIns.AddValue("Originated_Account_Number", this.Originated_Account_Number.Value); /*Optional 39*/
dbIns.AddValue("ACH_ModifiedBy", this.ACH_ModifiedBy.Value); /*Optional 40*/
dbIns.AddValue("ACH_ModifiedDateTime", this.ACH_ModifiedDateTime.Value); /*Optional 41*/
dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime.Value); /*Optional 42*/
dbIns.AddValue("Unique_DepositaryName", this.Unique_DepositaryName.Value); /*Optional 43*/
return(dbIns);
}
public bool Init_from_DB()
{
if (this.ID < 0)
{
return(false);
}
HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Depositary.Get_cmdTP());
db_sel.tableName = "Depositaries";
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.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);
}