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_Per_Rate.Get_cmdTP());
if (this.Security_Type.ValueChanged)
{
upd.AddValue("Security_Type", this.Security_Type); /*Optional 2*/
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary);
}
if (this.WithholdingRate.ValueChanged)
{
upd.AddValue("WithholdingRate", this.WithholdingRate); /*Optional 4*/
}
if (this.ADSC.ValueChanged)
{
upd.AddValue("ADSC", this.ADSC); /*Optional 5*/
}
if (this.RateWithADSC.ValueChanged)
{
upd.AddValue("RateWithADSC", this.RateWithADSC); /*Optional 6*/
}
if (this.EffectiveDate.ValueChanged)
{
upd.AddValue("EffectiveDate", this.EffectiveDate); /*Optional 7*/
}
if (this.CreatedDate.ValueChanged)
{
upd.AddValue("CreatedDate", this.CreatedDate); /*Optional 8*/
}
if (this.ImportBy.ValueChanged)
{
upd.AddValue("ImportBy", this.ImportBy); /*Optional 9*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Country", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
public Schedule_Of_Fees_Per_Rate GetCopy()
{
Schedule_Of_Fees_Per_Rate newEntity = new Schedule_Of_Fees_Per_Rate();
if (!this.Security_Type.IsNull_flag)
{
newEntity.Security_Type.Value = this.Security_Type.Value;
}
if (!this.Depositary.IsNull_flag)
{
newEntity.Depositary.Value = this.Depositary.Value;
}
if (!this.WithholdingRate.IsNull_flag)
{
newEntity.WithholdingRate.Value = this.WithholdingRate.Value;
}
if (!this.ADSC.IsNull_flag)
{
newEntity.ADSC.Value = this.ADSC.Value;
}
if (!this.RateWithADSC.IsNull_flag)
{
newEntity.RateWithADSC.Value = this.RateWithADSC.Value;
}
if (!this.EffectiveDate.IsNull_flag)
{
newEntity.EffectiveDate.Value = this.EffectiveDate.Value;
}
if (!this.CreatedDate.IsNull_flag)
{
newEntity.CreatedDate.Value = this.CreatedDate.Value;
}
if (!this.ImportBy.IsNull_flag)
{
newEntity.ImportBy.Value = this.ImportBy.Value;
}
return(newEntity);
}
public static void Init_from_DB()
{
if ((DateTime.Now - DSC_master.lastUpdateTime).TotalHours < Utility.RefreshInterval)
{
return;
}
DSC_master.Reset();
DB_select selt = new DB_select(Schedule_Of_Fees_Per_Rate.Get_cmdTP());
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
Schedule_Of_Fees_Per_Rate sfpr = new Schedule_Of_Fees_Per_Rate();
sfpr.Init_from_reader(reader);
DSC_master.sfpr_list.Add(sfpr);
}
reader.Close();
DSC_master.sfpr_list.Sort((a, b) => DateTime.Compare(b.EffectiveDate.Value, a.EffectiveDate.Value));
DSC_master.lastUpdateTime = DateTime.Now;
}
/// <summary>
/// Initialize object from DB
/// </summary>
public bool Init_from_DB()
{
if (string.IsNullOrEmpty(this.Country))
{
return(false);
}
HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Schedule_Of_Fees_Per_Rate.Get_cmdTP());
db_sel.tableName = "Schedule_Of_Fees_Per_Rate";
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Country", HssUtility.General.RelationalOperator.Equals, this.Country);
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_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Schedule_Of_Fees_Per_Rate.Get_cmdTP());
dbIns.AddValue("Security_Type", this.Security_Type); /*Optional 2*/
dbIns.AddValue("Depositary", this.Depositary);
dbIns.AddValue("WithholdingRate", this.WithholdingRate); /*Optional 4*/
dbIns.AddValue("ADSC", this.ADSC); /*Optional 5*/
dbIns.AddValue("RateWithADSC", this.RateWithADSC); /*Optional 6*/
dbIns.AddValue("EffectiveDate", this.EffectiveDate); /*Optional 7*/
dbIns.AddValue("CreatedDate", this.CreatedDate); /*Optional 8*/
dbIns.AddValue("ImportBy", this.ImportBy); /*Optional 9*/
return(dbIns);
}
