public static List <Schedule_Of_Fees_DSC> GetList_from_CD(string country, string depositary)
{
List <Schedule_Of_Fees_DSC> list = new List <Schedule_Of_Fees_DSC>();
if (string.IsNullOrEmpty(country) || string.IsNullOrEmpty(depositary))
{
return(list);
}
DB_select selt = new DB_select(Schedule_Of_Fees_DSC.Get_cmdTP());
SQL_relation rela1 = new SQL_relation("Country", RelationalOperator.Equals, country);
SQL_relation rela2 = new SQL_relation("Depositary", RelationalOperator.Equals, depositary);
SQL_condition cond = new SQL_condition(new SQL_condition(rela1), ConditionalOperator.And, new SQL_condition(rela2));
selt.SetCondition(cond);
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
Schedule_Of_Fees_DSC sof = new Schedule_Of_Fees_DSC();
sof.Init_from_reader(reader);
list.Add(sof);
}
reader.Close();
list.Sort((a, b) => DateTime.Compare(b.EffectiveDate.Value, a.EffectiveDate.Value));
return(list);
}
private void RefreshMainGrid()
{
string str = this.task_comboBox.Text;
int option = -1;
if (str.Equals("Uncompleted", StringComparison.OrdinalIgnoreCase))
{
option = 0;
}
else if (str.Equals("Completed", StringComparison.OrdinalIgnoreCase))
{
option = 1;
}
SQL_condition formCond = this.GetForm_SQLcondition(), filterCond = this.formFilter.FilterCondition;
SQL_condition cond = new SQL_condition(formCond, ConditionalOperator.And, filterCond);
this.tsk_vc.Get_viewDT_async(option, cond);
//Display setting in Grid
this.SetGird_sortFilter(this.tsk_vc.ViewData_match_flag);
UltraGrid_helper.AutoResize(this.main_ultraGrid);
UltraGrid_helper.ClearCurrentFilters(this.main_ultraGrid);
this.main_ultraGrid.ActiveRowScrollRegion.Scroll(RowScrollAction.Top);
}
public void SetTable(string tableName, string schema, hssDB hDB)
{
if (hDB == null || !hDB.Connected)
{
MessageBox.Show("AutoCreatClass error 0: No DB connection");
return;
}
this.col_list.Clear();
this.tableName = tableName;
if (string.IsNullOrEmpty(this.className))
{
this.className = tableName;
}
this.schema = schema;
DB_select selt = new DB_select(ColumnSchema.Get_cmdTP());
SQL_relation rela1 = new SQL_relation("TABLE_NAME", RelationalOperator.Equals, tableName);
SQL_relation rela2 = new SQL_relation("TABLE_SCHEMA", RelationalOperator.Equals, schema);
SQL_condition cond = new SQL_condition(new SQL_condition(rela1), ConditionalOperator.And, new SQL_condition(rela2));
selt.SetCondition(cond);
DB_reader reader = new DB_reader(selt, hDB);
while (reader.Read())
{
ColumnSchema cs = new ColumnSchema();
cs.Init_from_reader(reader);
this.col_list.Add(cs);
}
reader.Close();
this.col_list.Sort((a, b) => (a.ORDINAL_POSITION - b.ORDINAL_POSITION));
}
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);
}
public int Delete_CustodianID_dvdDetail(string reclaimFeeType)
{
DB_update upd = new DB_update(Dividend_Detail_full.Get_cmdTP());
upd.AddNull("CustodianID");
SQL_relation rela0 = new SQL_relation("DividendIndex", RelationalOperator.Equals, this.DividendIndex);
if (string.IsNullOrEmpty(reclaimFeeType))
{
upd.SetCondition(rela0);
}
else
{
SQL_relation rela1 = new SQL_relation("ReclaimFeesType", RelationalOperator.Equals, reclaimFeeType);
SQL_condition cond = new SQL_condition(rela0, ConditionalOperator.And, rela1);
upd.SetCondition(cond);
}
Helper_SQLserver.AllTrigers("Dividend_Detail", false, Utility.Get_DRWIN_hDB());
int count = upd.SaveToDB(Utility.Get_DRWIN_hDB());
Helper_SQLserver.AllTrigers("Dividend_Detail", true, Utility.Get_DRWIN_hDB());
return(count);
}
/// <summary>
/// Get DividendCustodian dictionary, [CustodianID] as key
/// </summary>
public Dictionary <int, DividendCustodian> Get_dvdCust_dic(string custodianType)
{
Dictionary <int, DividendCustodian> dic = new Dictionary <int, DividendCustodian>();
DB_select selt = new DB_select(DividendCustodian.Get_cmdTP());
SQL_relation rela0 = new SQL_relation("DividendIndex", RelationalOperator.Equals, this.DividendIndex);
if (string.IsNullOrEmpty(custodianType))
{
selt.SetCondition(rela0);
}
else
{
SQL_relation rela1 = new SQL_relation("Custodian_Type", RelationalOperator.Equals, custodianType);
SQL_condition cond = new SQL_condition(rela0, ConditionalOperator.And, rela1);
selt.SetCondition(cond);
}
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
DividendCustodian dc = new DividendCustodian();
dc.Init_from_reader(reader);
dic[dc.CustodianID] = dc;
}
reader.Close();
return(dic);
}
private static DB_reader Get_DB_reader(HssStatus status, SQL_condition extraCond)
{
DB_select selt = new DB_select(XBRL_SavedFile.Get_cmdTP());
selt.IgnoreColumn("savedfile");
SQL_relation rela = null;
if (status == HssStatus.Pending || status == HssStatus.Approved)
{
rela = new SQL_relation("processState", RelationalOperator.Equals, (int)status);
}
else
{
HashSet <int> hs = new HashSet <int>();
hs.Add(0); hs.Add(1);
rela = new SQL_relation("processState", false, hs);
}
SQL_condition cond = new SQL_condition(rela, ConditionalOperator.And, extraCond);
selt.SetCondition(cond);
DB_reader reader = new DB_reader(selt, Utility.Get_XBRL_hDB());
return(reader);
}
public List <Dividend_Detail_simpleAP> Get_dvdDetailAP_list(string reclaimFeeType)
{
List <Dividend_Detail_simpleAP> list = new List <Dividend_Detail_simpleAP>();
DB_select selt = new DB_select(Dividend_Detail_simpleAP.Get_cmdTP());
SQL_relation rela0 = new SQL_relation("DividendIndex", RelationalOperator.Equals, this.DividendIndex);
if (string.IsNullOrEmpty(reclaimFeeType))
{
selt.SetCondition(rela0);
}
else
{
SQL_relation rela1 = new SQL_relation("ReclaimFeesType", RelationalOperator.Equals, reclaimFeeType);
SQL_condition cond = new SQL_condition(rela0, ConditionalOperator.And, rela1);
selt.SetCondition(cond);
}
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
Dividend_Detail_simpleAP dd = new Dividend_Detail_simpleAP();
dd.Init_from_reader(reader);
list.Add(dd);
}
reader.Close();
return(list);
}
public static List <Task_Detail> GetTaskDetail_list(int taskID, string sourceID, string taskName)
{
List <Task_Detail> list = new List <Task_Detail>();
DB_select db_sel = new DB_select(Task_Detail.Get_cmdTP());
SQL_relation rela0 = new SQL_relation("TaskID", RelationalOperator.Equals, taskID);
SQL_relation rela1 = new SQL_relation("sourceID", RelationalOperator.Equals, sourceID);
SQL_condition cond = new SQL_condition(rela0, ConditionalOperator.And, rela1);
if (taskName != null)
{
SQL_relation rela2 = new SQL_relation("TaskName", RelationalOperator.Equals, taskName);
cond = new SQL_condition(cond, ConditionalOperator.And, rela2);
}
db_sel.SetCondition(cond);
DB_reader reader = new DB_reader(db_sel, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
Task_Detail dp = new Task_Detail();
dp.Init_from_reader(reader);
list.Add(dp);
}
reader.Close();
return(list);
}
/****************************************************************************************************************/
private void CreateSqlCondition()
{
this.cond = null;
ConditionalOperator copt = this.and_radioButton.Checked ? ConditionalOperator.And : ConditionalOperator.Or;
foreach (Filter_UserControl fuc in this.ctl_list)
{
SQL_relation rela = fuc.SQL_Rela;
if (rela == null)
{
continue;
}
if (this.cond == null)
{
this.cond = new SQL_condition(rela);
}
else
{
this.cond = new SQL_condition(this.cond, copt, rela);
}
}
this.Close();
}
/// <summary>
/// Refresh data on Grid
/// </summary>
public void RefreshData(SQL_condition cond)
{
if (this.StopRefresh_flag)
{
return;
}
if ((DateTime.Now - this.lastRefreshAt).TotalSeconds < 5)
{
Console.WriteLine("---> XBRL_UserControl_func info 0: no refresh within 5 seconds, last at " + this.lastRefreshAt);
return;
}
else
{
this.lastRefreshAt = DateTime.Now;
}
Console.WriteLine("---> XBRL_UserControl_func info 1: LastRefreshAt: " + this.lastRefreshAt);
//get display data table
this.sf_master.Get_viewDT_async(this.shown_processState, cond);
//Get action textEditor
UltraTextEditor curr_textEditor = null;
if (this.approved_radioButton.Checked)
{
curr_textEditor = this.appr_textEditor;
}
else if (this.rejected_radioButton.Checked)
{
curr_textEditor = this.rej_textEditor;
}
else
{
curr_textEditor = this.pending_textEditor;
}
this.main_ultraGrid.DisplayLayout.Bands[0].Columns[UltraGrid_helper.ActionColumnName].EditorComponent = curr_textEditor;
//Display setting in Grid
this.SetGird_sortFilter(this.sf_master.ViewData_match_flag);
UltraGrid_helper.AutoResize(this.main_ultraGrid);
UltraGrid_helper.ClearCurrentFilters(this.main_ultraGrid);
this.main_ultraGrid.ActiveRowScrollRegion.Scroll(RowScrollAction.Top);
}
private void Cal_ClaimShares_ADRS_SUM(Dictionary <int, BD_Dividend> dic)
{
this.statusInfo.status = "Calculate ClaimShares_ADRS_SUM";
DB_select selt = new DB_select(BD_detailSum.Get_cmdTP());
SQL_relation rela0 = new SQL_relation("Status", RelationalOperator.NotEqual, "REJECTED");
SQL_relation rela1 = new SQL_relation("ReceivedDate", RelationalOperator.GreaterThan, "1900-1-1");
SQL_condition cond0 = new SQL_condition(rela0, ConditionalOperator.And, rela1);
SQL_relation rela2 = new SQL_relation("RecordDatePosition", RelationalOperator.GreaterThan, 0);
selt.SetCondition(new SQL_condition(cond0, ConditionalOperator.And, rela2));
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
int count = 0;
while (reader.Read())
{
BD_detailSum detail = new BD_detailSum();
detail.Init_from_reader(reader);
if (!dic.ContainsKey(detail.DividendIndex))
{
continue;
}
BD_Dividend dvd = this.dvd_dic[detail.DividendIndex];
if (!dvd.bdp_dic.ContainsKey(detail.DTC_Number))
{
continue;
}
BD_DTC_Position bdp = dvd.bdp_dic[detail.DTC_Number];
bdp.ClaimShares_ADRS_SUM = detail.ClaimShares_ADRS_SUM;
++count;
++this.statusInfo.recordNum;
}
reader.Close();
this.statusInfo.additional_info_list.Add("Total BD_detailSum count=" + count);
}
/// <summary>
/// Invoke by UserControl to retrieve data
/// </summary>
public void Get_viewDT_async(int completed_option, SQL_condition extraCond)
{
if (this.listThread != null)
{
this.threadStop_flag = true;
this.listThread.Join();
}
this.sourceDT.Clear();//reset values
this.taskDetail_list.Clear();
this.currList_id = 0;
this.threadStop_flag = false;
this.dataFinishedLoading_flag = false;
this.curr_reader = TaskDetailMaster.Get_DB_reader(completed_option, extraCond);//create reader for multi-threading
this.listThread = new Thread(this.Get_TDlist_threadRun);
this.listThread.Start();
int loopCount = 0;
while (true)
{
++loopCount;
Thread.Sleep(1);
if (this.dataFinishedLoading_flag)
{
break;
}
if (this.taskDetail_list.Count > 50)
{
break;
}
}
if (Utility.Is_DWRIN_admin())
{
Console.WriteLine("---> TaskForm_viewControl info 0: loopCount = " + loopCount);
}
this.Add_TDrows_to_DT(UltraGrid_helper.RowsLoaded_per_scroll * 2);
}
/// <summary>
/// Get DB_reader for retrieving Task_Detail info
/// </summary>
/// <param name="completed_option">0 for Uncompleted, 1 for Completed, other values for all</param>
/// <param name="extraCond">Extra Condition</param>
public static DB_reader Get_DB_reader(int completed_option, SQL_condition extraCond)
{
DB_select selt = new DB_select(Task_Detail.Get_cmdTP());
SQL_relation rela = null;
if (completed_option == 0)
{
rela = new SQL_relation("Completed", RelationalOperator.Equals, false);
}
else if (completed_option == 1)
{
rela = new SQL_relation("Completed", RelationalOperator.Equals, true);
}
SQL_condition cond = new SQL_condition(rela, ConditionalOperator.And, extraCond);
selt.SetCondition(cond);
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
return(reader);
}
/// <summary>
/// Invoke by UserControl to retrieve data
/// </summary>
public void Get_viewDT_async(HssStatus status, SQL_condition extraCond)
{
if (this.listThread != null)
{
this.threadStop_flag = true;
this.listThread.Join();
}
this.sourceDT.Clear();//reset values
this.XBRL_list.Clear();
this.currList_id = 0;
this.threadStop_flag = false;
this.dataFinishedLoading_flag = false;
this.curr_reader = XBRL_SavedFile_master.Get_DB_reader(status, extraCond);//create reader for multi-threading
this.listThread = new Thread(this.Get_XBRLlist_threadRun);
this.listThread.Start();
int loopCount = 0;
while (true)
{
++loopCount;
Thread.Sleep(1);
if (this.dataFinishedLoading_flag)
{
break;
}
if (this.XBRL_list.Count > 50)
{
break;
}
}
//Console.WriteLine("---> XBRL_SavedFile_master info 0: loopCount = " + loopCount);
this.Add_XBRLrows_to_DT(UltraGrid_helper.RowsLoaded_per_scroll * 2);
}
public void ClearAll()
{
this.ctl_list.Clear();
this.main_flowLayoutPanel.Controls.Clear();
this.cond = null;
}
