private bool PreConnect_check()
{
DateTime currTime = DateTime.Now;
//run Monday to Friday
if (currTime.DayOfWeek == DayOfWeek.Saturday || currTime.DayOfWeek == DayOfWeek.Sunday)
{
return(false);
}
//run between 8am to 8pm for Admin
if (currTime.Hour < 8 || currTime.Hour > 20)
{
return(false);
}
this.hdj = Hss_DailyJobs_master.GetJob_class_id("Inbound Data", 3);
if (this.hdj == null)
{
return(false);
}
else
{
this.notes = this.hdj.Notes.Value;
}
if (HssDateTime.CompareDateTime_day(currTime, this.hdj.LastRunAt.Value) <= 0)
{
Console.WriteLine("---> InboundData3_SPR info 0: Task previous run at " + this.hdj.LastRunAt.Value);
return(false);
}
return(true);
}
public static List <Dividend> Get_DividendList_CR(string CUSIP, DateTime recordDate, DividendTable_option table = DividendTable_option.Dividend_Control_Approved)
{
List <Dividend> all_List = Helper_Dividend.Get_DividendList_CUSIP(CUSIP, table);
List <Dividend> res_list = new List <Dividend>();
foreach (Dividend dvd in all_List)
{
int val = HssDateTime.CompareDateTime_day(recordDate, dvd.RecordDate_ADR.Value);
if (val == 0)
{
res_list.Add(dvd);
}
}
return(res_list);
}
private DateTime startDate = new DateTime(2017, 10, 1);//starting date for
public void Run()
{
Hss_DailyJobs hdj = Hss_DailyJobs_master.GetJob_class_id("Task Manager", 20);
if (hdj == null)
{
return;
}
if (HssDateTime.CompareDateTime_day(DateTime.Now, hdj.LastRunAt.Value) <= 0)
{
return;
}
if (!hdj.UpdateRecordLock(true))
{
return;
}
Console.WriteLine("Task 20 start running");
this.PerformTasks();
hdj.UpdateRecordLock(false, true);
}
/// <summary>
/// Button events handler in Action column
/// </summary>
private void ActionButtonEvent_textEditor(object sender, EditorButtonEventArgs e)
{
if (e.Context is UltraGridCell == false)
{
return;
}
UltraGridCell cell = (UltraGridCell)e.Context;
int ID = (int)cell.Row.Cells["ID"].Value;
SPR_file sf = new SPR_file(ID);
sf.Init_from_DB();
string option = e.Button.Key;
if (option.StartsWith("Approve", StringComparison.OrdinalIgnoreCase))
{
if (MessageBox.Show("Approve file " + ID + "?", "Happy!", MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
Dividend curr_dvd = null;
string CUSIP = cell.Row.Cells["CUSIP"].Value.ToString();
List <Dividend> dvdList = Helper_Dividend.Get_DividendList_CUSIP(CUSIP);
foreach (Dividend dvd in dvdList)
{
if (HssDateTime.CompareDateTime_day(sf.RecordDate.Value, dvd.RecordDate_ADR.Value) == 0)
{
curr_dvd = dvd;//matching Dividend found
break;
}
}
if (curr_dvd == null) //CUSIP and Record Date not found record in [Dividend_Control] table, let user to choose
{
Form_DividendSelector fds = new Form_DividendSelector();
int dvd_index = fds.Init_from_list(dvdList);
if (dvd_index > 0)
{
curr_dvd = new Dividend(dvd_index);
}
}
else //CUSIP and Record Date match record in [Dividend_Control] table
{
if (MessageBox.Show("Update Dividend " + curr_dvd.DividendIndex + "?", "???", MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
}
if (curr_dvd != null)
{
if (!curr_dvd.Insert_DTC_position(sf))
{
return;
}
sf.SetStatus(HssStatus.Approved);
sf.LastModifyAction.Value = "Approve";
sf.Update_to_DB();
MessageBox.Show("Dividend #" + curr_dvd.DividendIndex + " DTC position updated!");
this.RefreshData();
}
else
{
MessageBox.Show("Dividend Event not found...");
}
}
else if (option.StartsWith("ViewData", StringComparison.OrdinalIgnoreCase))
{
ViewDataForm vdf = new ViewDataForm();
vdf.Set_notePad_dataSource(sf.FileBinary, ViewDataOption.RawView_strLine);
vdf.Show();
}
else if (option.StartsWith("Reject", StringComparison.OrdinalIgnoreCase))
{
if (MessageBox.Show("Reject file " + ID + "?", "Sad...", MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
sf.SetStatus(HssStatus.Rejected);
sf.LastModifyAction.Value = "Reject";
sf.Update_to_DB();
this.RefreshData();
}
else if (option.StartsWith("Restore", StringComparison.OrdinalIgnoreCase))
{
if (MessageBox.Show("Restore file " + ID + "?", "Hero is back!", MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
sf.SetStatus(HssStatus.Pending);
sf.LastModifyAction.Value = "Restore";
sf.Update_to_DB();
this.RefreshData();
}
}
