public static void Init_from_DB() { if ((DateTime.Now - DTC_Participants_master.lastUpdateTime).TotalHours < Utility.RefreshInterval) { return; } DTC_Participants_master.Reset(); DB_select selt = new DB_select(DTC_Participants.Get_cmdTP()); DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB()); while (reader.Read()) { DTC_Participants dp = new DTC_Participants(); dp.Init_from_reader(reader); DTC_Participants_master.ID_dic[dp.DTC] = dp; DTC_Participants_master.DTCnum_dic[dp.DTC_Number.Value] = dp; } reader.Close(); DTC_Participants_master.lastUpdateTime = DateTime.Now; }
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_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(DTC_Participants.Get_cmdTP()); dbIns.AddValue("DTC", this.DTC); dbIns.AddValue("DTC_Number", this.DTC_Number); dbIns.AddValue("Company_Name", this.Company_Name); dbIns.AddValue("ATTN", this.ATTN); /*Optional 4*/ dbIns.AddValue("Address1", this.Address1); /*Optional 5*/ dbIns.AddValue("Address2", this.Address2); /*Optional 6*/ dbIns.AddValue("City", this.City); /*Optional 7*/ dbIns.AddValue("State", this.State); /*Optional 8*/ dbIns.AddValue("Country", this.Country); /*Optional 9*/ dbIns.AddValue("Zip_Postal_Code", this.Zip_Postal_Code); /*Optional 10*/ dbIns.AddValue("Phone", this.Phone); /*Optional 11*/ dbIns.AddValue("Fax", this.Fax); /*Optional 12*/ dbIns.AddValue("WebsiteUrl", this.WebsiteUrl); /*Optional 13*/ dbIns.AddValue("Email", this.Email); /*Optional 14*/ dbIns.AddValue("Fixed_Payment_ATTN", this.Fixed_Payment_ATTN); /*Optional 15*/ dbIns.AddValue("Type", this.Type); /*Optional 16*/ dbIns.AddValue("Depositary", this.Depositary); /*Optional 17*/ dbIns.AddValue("RejectEmail", this.RejectEmail); /*Optional 18*/ dbIns.AddValue("PaymentEmail", this.PaymentEmail); /*Optional 19*/ dbIns.AddValue("DocInventoryEmail", this.DocInventoryEmail); /*Optional 20*/ dbIns.AddValue("SecurityTypeID", this.SecurityTypeID); dbIns.AddValue("AccountNumber", this.AccountNumber); dbIns.AddValue("IssuerCSD", this.IssuerCSD); /*Optional 23*/ dbIns.AddValue("ACH_Override", this.ACH_Override); /*Optional 24*/ dbIns.AddValue("ACH_Bank", this.ACH_Bank); /*Optional 25*/ dbIns.AddValue("ACH_ABA", this.ACH_ABA); /*Optional 26*/ dbIns.AddValue("ACH_Account", this.ACH_Account); /*Optional 27*/ dbIns.AddValue("ClearingSystem", this.ClearingSystem); dbIns.AddValue("CustomWireMemo", this.CustomWireMemo); /*Optional 29*/ dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 30*/ dbIns.AddValue("Email_backup", this.Email_backup); /*Optional 31*/ dbIns.AddValue("PaymentEmail_backup", this.PaymentEmail_backup); /*Optional 32*/ dbIns.AddValue("RejectEmail_backup", this.RejectEmail_backup); /*Optional 33*/ dbIns.AddValue("DocInventoryEmail_backup", this.DocInventoryEmail_backup); /*Optional 34*/ return(dbIns); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (this.DTC < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(DTC_Participants.Get_cmdTP()); db_sel.tableName = "DTC_Participants"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("DTC", HssUtility.General.RelationalOperator.Equals, this.DTC); 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); }