public static void Init_from_DB() { if ((DateTime.Now - CustodianMaster.lastUpdateTime).TotalHours < Utility.RefreshInterval) { return; } CustodianMaster.Reset(); DB_select selt = new DB_select(Custodian.Get_cmdTP()); DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB()); while (reader.Read()) { Custodian cust = new Custodian(); cust.Init_from_reader(reader); CustodianMaster.num_dic[cust.Custodian_Number] = cust; CustodianMaster.full_dic[cust.Custodian_FullName.Value] = cust; CustodianMaster.short_dic[cust.Custodian_ShortName.Value] = cust; } reader.Close(); CustodianMaster.lastUpdateTime = DateTime.Now; }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Custodian.Get_cmdTP()); dbIns.AddValue("Custodian_ShortName", this.Custodian_ShortName); dbIns.AddValue("Custodian_FullName", this.Custodian_FullName); dbIns.AddValue("Account_Number", this.Account_Number); /*Optional 4*/ dbIns.AddValue("Safekeeping_Number", this.Safekeeping_Number); /*Optional 5*/ dbIns.AddValue("Language", this.Language); /*Optional 6*/ dbIns.AddValue("Country_Code", this.Country_Code); /*Optional 7*/ dbIns.AddValue("Title", this.Title); /*Optional 8*/ dbIns.AddValue("From_FirstName", this.From_FirstName); /*Optional 9*/ dbIns.AddValue("From_LastName", this.From_LastName); /*Optional 10*/ dbIns.AddValue("From_Company", this.From_Company); /*Optional 11*/ dbIns.AddValue("From_Address1", this.From_Address1); /*Optional 12*/ dbIns.AddValue("From_Address2", this.From_Address2); /*Optional 13*/ dbIns.AddValue("From_Address3", this.From_Address3); /*Optional 14*/ dbIns.AddValue("From_Address4", this.From_Address4); /*Optional 15*/ dbIns.AddValue("From_Address5", this.From_Address5); /*Optional 16*/ dbIns.AddValue("Telephone", this.Telephone); /*Optional 17*/ dbIns.AddValue("Fax", this.Fax); /*Optional 18*/ dbIns.AddValue("DefaultCustodianType", this.DefaultCustodianType); /*Optional 19*/ dbIns.AddValue("PrimaryAllowed", this.PrimaryAllowed); /*Optional 20*/ dbIns.AddValue("Tax_Authority", this.Tax_Authority); /*Optional 21*/ dbIns.AddValue("TA_ATTN", this.TA_ATTN); /*Optional 22*/ dbIns.AddValue("TA_Address1", this.TA_Address1); /*Optional 23*/ dbIns.AddValue("TA_Address2", this.TA_Address2); /*Optional 24*/ dbIns.AddValue("Custodian_Alias", this.Custodian_Alias); /*Optional 25*/ dbIns.AddValue("TA_Phone", this.TA_Phone); /*Optional 26*/ dbIns.AddValue("TA_FAX", this.TA_FAX); /*Optional 27*/ dbIns.AddValue("Custodian_Ref_Number", this.Custodian_Ref_Number); /*Optional 28*/ dbIns.AddValue("JPM_Custodian_Ref_Num", this.JPM_Custodian_Ref_Num); /*Optional 29*/ return(dbIns); }
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); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (this.Custodian_Number < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Custodian.Get_cmdTP()); db_sel.tableName = "Custodians"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Custodian_Number", HssUtility.General.RelationalOperator.Equals, this.Custodian_Number); 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); }