private void ScheduleRow(int i, DataRow dr)
{
if (i < SPLIT_ENTRIES)
{
DSInteractiveEntry dsie = _parent.StackPanelLeftInteractive.Children[i] as DSInteractiveEntry;
DSInteractiveEntryData data = dsie.DataContext as DSInteractiveEntryData;
dsie.ActionClick -= Action_UpdateRow;
dsie.DockChanged -= Action_UpdateDock;
dsie.NoShowClick -= Action_NoShow;
data.SetupData(dr);
dsie.ActionClick += Action_UpdateRow;
dsie.DockChanged += Action_UpdateDock;
dsie.NoShowClick += Action_NoShow;
}
else
{
DSInteractiveEntry dsie = _parent.StackPanelRightInteractive.Children[i % SPLIT_ENTRIES] as DSInteractiveEntry;
DSInteractiveEntryData data = dsie.DataContext as DSInteractiveEntryData;
dsie.ActionClick -= Action_UpdateRow;
dsie.DockChanged -= Action_UpdateDock;
dsie.NoShowClick -= Action_NoShow;
data.SetupData(dr);
dsie.ActionClick += Action_UpdateRow;
dsie.DockChanged += Action_UpdateDock;
dsie.NoShowClick += Action_NoShow;
}
}
public void Action_UpdateDock(object sender, EventArgs e)
{
DSInteractiveEntry dsie = sender as DSInteractiveEntry;
DSInteractiveEntryData data = dsie.DataContext as DSInteractiveEntryData;
if (data.Dock != "0" && data.Dock != "")
{
SQL_dockSchedule.InsertDockNumber(data.Dock, data.PairId);
}
else
{
SQL_dockSchedule.ClearDockNumber(data.PairId);
}
}
//'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
//'''''''''''''''''''''''''''''''''''' PANEL BUTTONS ''''''''''''''''''''''''''''''''''''
//'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
public void Action_UpdateRow(object sender, EventArgs e)
{
DSInteractiveEntry dsie = sender as DSInteractiveEntry;
DSInteractiveEntryData data = dsie.DataContext as DSInteractiveEntryData;
string id = data.PairId;
var now = DateTime.Now;
if (data.Action == DSInteractiveEntryData.MARK_ARRIVED)
{
//LATE ARRIVAL HIGHLIGHT-------------------------
SQL_search.RunQuery("db_Sandbar", $"SELECT * FROM DS_entries WHERE ID = {id}");
var scheduleTime = SQL_search.Ds.Tables[0].Rows[0]["SCHEDULE_TIME"].ToString();
var displayTime = DateTime.Parse(scheduleTime, new CultureInfo("en-US", true));
if (DateTime.Now > displayTime)
{
data.MarkLate();
}
//-----------------------------------------------
data.Action = DSInteractiveEntryData.SENT_TO_DOCK;
data.ArrivedValue = now.ToShortTimeString();
SQL_dockSchedule.InsertTime("ARRIVAL_TIME", id);
}
else if (data.Action == DSInteractiveEntryData.SENT_TO_DOCK)
{
data.Action = DSInteractiveEntryData.ARRIVED_AT_DOCK;
data.STDValue = now.ToShortTimeString();
SQL_dockSchedule.InsertTime("SENT_TIME", id);
}
else if (data.Action == DSInteractiveEntryData.ARRIVED_AT_DOCK)
{
data.Action = DSInteractiveEntryData.DEPARTED_DOCK;
data.TimeInValue = now.ToShortTimeString();
SQL_dockSchedule.InsertTime("IN_TIME", id);
}
else if (data.Action == DSInteractiveEntryData.DEPARTED_DOCK)
{
SQL_dockSchedule.InsertTime("OUT_TIME", id);
LoadDailySchedule();
}
}
public void Action_NoShow(object sender, EventArgs e)
{
DSInteractiveEntry dsie = sender as DSInteractiveEntry;
DSInteractiveEntryData data = dsie.DataContext as DSInteractiveEntryData;
_parent.CancelDisplayPairId.Content = data.PairId;
_parent.CancelDisplayTime.Content = data.Time;
_parent.CancelDisplayDock.Content = data.Dock;
_parent.CancelDisplayUnits.Content = data.Units;
_parent.CancelDisplayArrived.Content = data.ArrivedValue;
_parent.CancelDisplaySent.Content = data.STDValue;
_parent.CancelDisplayTimeIn.Content = data.TimeInValue;
_parent.CancelDisplayCarrier.Content = data.Carrier;
_parent.CancelDisplayCustomer.Content = data.Customer;
_parent.CancelDisplayOrderDoPo.Content = data.OrderDopo;
_parent.CancelDialogPanel.Visibility = Visibility.Visible;
}
