void tmrLogTrucks_Elapsed(object sender, ElapsedEventArgs e)
{
SQL.SQLCode mySQL = new SQL.SQLCode();
foreach (TowTruck.TowTruck thisTruck in DataClasses.GlobalData.currentTrucks.ToList())
{
bool Alarms = false;
TowTruck.AlarmTimer alarmSpd = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer findSpd) { return(findSpd.alarmName == "Speeding"); });
TowTruck.AlarmTimer alarmOB = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer findOB) { return(findOB.alarmName == "OffBeat"); });
thisTruck.tta.checkAlarms();
if (thisTruck.tta.hasAlarms == true)
{
Alarms = true;
}
ArrayList arrParams = new ArrayList();
arrParams.Add("@Direction^" + thisTruck.GPSPosition.Head);
arrParams.Add("@VehicleStatus^" + thisTruck.Status.VehicleStatus);
arrParams.Add("@LastUpdate^" + thisTruck.GPSPosition.Time.ToString());
arrParams.Add("@VehicleID^" + thisTruck.TruckNumber);
arrParams.Add("@Speed^" + thisTruck.GPSPosition.Speed.ToString());
arrParams.Add("@Alarms^" + Alarms);
arrParams.Add("@DriverID^" + thisTruck.Driver.DriverID.ToString());
arrParams.Add("@CallSign^" + thisTruck.Driver.callSign);
arrParams.Add("@AssignedShift^" + thisTruck.Driver.AssignedShift);
arrParams.Add("@VehicleNumber^" + thisTruck.Identifier.ToString());
arrParams.Add("@SpeedingAlarm^" + alarmSpd.hasAlarm.ToString());
arrParams.Add("@SpeedingValue^" + alarmSpd.alarmValue);
arrParams.Add("@SpeedingTime^" + alarmSpd.alarmStart.ToString());
arrParams.Add("@OutOfBoundsAlarm^" + alarmOB.hasAlarm.ToString());
arrParams.Add("@OutOfBoundsMessage^" + alarmOB.alarmValue);
string CellVal;
if (string.IsNullOrEmpty(thisTruck.GPSPosition.Cell))
{
CellVal = "NA";
}
else
{
CellVal = thisTruck.GPSPosition.Cell;
}
arrParams.Add("@Cell^" + CellVal);
arrParams.Add("@runID^" + thisTruck.runID);
arrParams.Add("@AssignedBeat^" + thisTruck.beatNumber);
arrParams.Add("@Beat^" + thisTruck.beatNumber);
arrParams.Add("@BeatSegment^" + thisTruck.location);
arrParams.Add("@Lat^" + thisTruck.GPSPosition.Lat);
arrParams.Add("@Lon^" + thisTruck.GPSPosition.Lon);
if (alarmSpd.hasAlarm)
{
arrParams.Add("@SLat^" + thisTruck.GPSPosition.Lat);
arrParams.Add("@SLon^" + thisTruck.GPSPosition.Lon);
}
else
{
arrParams.Add("@SLat^0.0");
arrParams.Add("@SLon^0.0");
}
mySQL.LogGPS("SetGPS", arrParams);
}
}
private void LoadTruckData()
{
string ip = Request.QueryString["ip"];
TowTruck.TowTruck thisTruck = DataClasses.GlobalData.FindTowTruck(ip);
if (thisTruck != null)
{
lblTruck.Text = thisTruck.Extended.TruckNumber;
lblVehicleNumber.Text = thisTruck.Extended.TruckNumber;
lblDriverName.Text = thisTruck.Driver.LastName + ", " + thisTruck.Driver.FirstName;
lblContractCompanyName.Text = thisTruck.Extended.ContractorName;
lblVehicleStatus.Text = thisTruck.Status.VehicleStatus;
lblStatusStarted.Text = thisTruck.Status.StatusStarted.ToString();
if (thisTruck.Driver.schedule != null)
{
lblScheduleName.Text = thisTruck.Driver.schedule.ScheduleName;
}
else
{
lblScheduleName.Text = "no schedule";
}
//Check for alarm status, set green or red accordingly.
#region " Speeding Alarms **FIXED TO NEW WAY**"
TowTruck.AlarmTimer aSpeed = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer find) { return(find.alarmName == "Speeding"); });
if (aSpeed != null)
{
if (aSpeed.hasAlarm == true)
{
lblSpeedingAlarm.ForeColor = System.Drawing.Color.Red;
lblSpeedingValue.ForeColor = System.Drawing.Color.Red;
lblSpeedingTime.ForeColor = System.Drawing.Color.Red;
}
else
{
lblSpeedingAlarm.ForeColor = System.Drawing.Color.Green;
lblSpeedingValue.ForeColor = System.Drawing.Color.Green;
lblSpeedingTime.ForeColor = System.Drawing.Color.Green;
}
lblSpeedingAlarm.Text = aSpeed.hasAlarm.ToString();
lblSpeedingValue.Text = aSpeed.alarmValue;
//lblSpeedingValue.Text = thisTruck.GPSPosition.Speed.ToString() + " / MAX: " + thisTruck.GPSPosition.MaxSpd.ToString();
lblSpeedingTime.Text = aSpeed.alarmStart.ToString("hh:mm:ss");
}
#endregion
#region " Out of Bounds Alarms **FIXED TO NEW WAY** "
TowTruck.AlarmTimer aOOB = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer find) { return(find.alarmName == "OffBeat"); });
if (aOOB != null)
{
if (aOOB.hasAlarm == true)
{
lblOutOfBoundsAlarm.ForeColor = System.Drawing.Color.Red;
lblOutOfBoundsMessage.ForeColor = System.Drawing.Color.Red;
lblOutOfBoundsTime.ForeColor = System.Drawing.Color.Red;
lblOutOfBoundsStartTime.ForeColor = System.Drawing.Color.Red;
}
else
{
lblOutOfBoundsAlarm.ForeColor = System.Drawing.Color.Green;
lblOutOfBoundsMessage.ForeColor = System.Drawing.Color.Green;
lblOutOfBoundsTime.ForeColor = System.Drawing.Color.Green;
lblOutOfBoundsStartTime.ForeColor = System.Drawing.Color.Green;
}
}
lblOutOfBoundsAlarm.Text = aOOB.hasAlarm.ToString();
lblOutOfBoundsMessage.Text = "";
lblOutOfBoundsTime.Text = aOOB.getStatusMinutes().ToString();
lblOutOfBoundsStartTime.Text = aOOB.alarmStart.ToString("hh:mm:ss");
#endregion
#region " Log On Alarms DEPRECATED"
/* OLD
* if (thisTruck.Status.LogOnAlarm == true)
* {
* lblLogOnAlarm.ForeColor = System.Drawing.Color.Red;
* lblLogOnAlarmTime.ForeColor = System.Drawing.Color.Red;
* }
* else
* {
* lblLogOnAlarm.ForeColor = System.Drawing.Color.Green;
* lblLogOnAlarmTime.ForeColor = System.Drawing.Color.Green;
* }
*
* lblLogOnAlarm.Text = thisTruck.Status.LogOnAlarm.ToString();
* lblLogOnAlarmTime.Text = thisTruck.Status.LogOnAlarmTime.ToString();
* lblLogOnAlarmCleared.Text = thisTruck.Status.LogOnAlarmCleared.ToString();
* lblLogOnAlarmExcused.Text = thisTruck.Status.LogOnAlarmExcused.ToString();
* lblLogOnAlarmComments.Text = thisTruck.Status.LogOnAlarmComments;
*/
#endregion
#region " Old "
/*
#region " Roll Out Alarms "
*
* if (thisTruck.Status.RollOutAlarm == true)
* {
* lblRollOutAlarm.ForeColor = System.Drawing.Color.Red;
* lblRollOutAlarmTime.ForeColor = System.Drawing.Color.Red;
* }
* else
* {
* lblRollOutAlarm.ForeColor = System.Drawing.Color.Green;
* lblRollOutAlarmTime.ForeColor = System.Drawing.Color.Green;
* }
*
* lblRollOutAlarm.Text = thisTruck.Status.RollOutAlarm.ToString();
* lblRollOutAlarmTime.Text = thisTruck.Status.RollOutAlarmTime.ToString();
* lblRollOutAlarmCleared.Text = thisTruck.Status.RollOutAlarmCleared.ToString();
* lblRollOutAlarmExcused.Text = thisTruck.Status.RollOutAlarmExcused.ToString();
* lblRollOutAlarmComments.Text = thisTruck.Status.RollOutAlarmComments;
*/
#endregion
#region " On Patrol Alarms "
TowTruck.AlarmTimer aOP = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer find) { return(find.alarmName == "LateOnPatrol"); });
if (aOP != null)
{
if (aOP.hasAlarm == true)
{
lblOnPatrolAlarm.ForeColor = System.Drawing.Color.Red;
lblOnPatrolAlarmMessage.ForeColor = System.Drawing.Color.Red;
lblOnPatrolAlarmTime.ForeColor = System.Drawing.Color.Red;
}
else
{
lblOnPatrolAlarm.ForeColor = System.Drawing.Color.Green;
lblOnPatrolAlarmMessage.ForeColor = System.Drawing.Color.Green;
lblOnPatrolAlarmTime.ForeColor = System.Drawing.Color.Green;
}
lblOnPatrolAlarm.Text = aOP.hasAlarm.ToString();
lblOnPatrolAlarmTime.Text = aOP.alarmStart.ToString("hh:mm:ss");
lblOnPatrolAlarmMessage.Text = aOP.alarmValue;
lblOnPatrolAlarmCleared.Text = aOP.alarmCleared.ToString();
lblOnPatrolAlarmExcused.Text = aOP.alarmExcused.ToString();
}
#endregion
#region " Roll In Alarms "
TowTruck.AlarmTimer aRI = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer find) { return(find.alarmName == "EarlyOutOfService"); });
if (aRI != null)
{
if (aRI.hasAlarm == true)
{
lblRollInAlarm.ForeColor = System.Drawing.Color.Red;
lblRollInAlarmTime.ForeColor = System.Drawing.Color.Red;
lblRollInAlarmMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
lblRollInAlarm.ForeColor = System.Drawing.Color.Green;
lblRollInAlarmTime.ForeColor = System.Drawing.Color.Green;
lblRollInAlarmMessage.ForeColor = System.Drawing.Color.Green;
}
lblRollInAlarm.Text = aRI.hasAlarm.ToString();
lblRollInAlarmTime.Text = aRI.alarmStart.ToString("hh:mm:ss");
lblRollInAlarmMessage.Text = aRI.alarmValue;
lblRollInAlarmCleared.Text = aRI.alarmCleared.ToString();
lblRollInAlarmExcused.Text = aRI.alarmExcused.ToString();
}
#endregion
#region " Log Off Alarms "
/*
* if (thisTruck.Status.LogOffAlarm == true)
* {
* lblLogOffAlarm.ForeColor = System.Drawing.Color.Red;
* lblLogOffAlarmTime.ForeColor = System.Drawing.Color.Red;
* }
* else
* {
* lblLogOffAlarm.ForeColor = System.Drawing.Color.Green;
* lblLogOffAlarmTime.ForeColor = System.Drawing.Color.Green;
* }
*
* lblLogOffAlarm.Text = thisTruck.Status.LogOffAlarm.ToString();
* lblLogOffAlarmTime.Text = thisTruck.Status.LogOffAlarmTime.ToString();
* lblLogOffAlarmCleared.Text = thisTruck.Status.LogOffAlarmCleared.ToString();
* lblLogOffAlarmExcused.Text = thisTruck.Status.LogOffAlarmExcused.ToString();
* lblLogOffAlarmComments.Text = thisTruck.Status.LogOffAlarmComments;
*/
#endregion
#region " Long Incident Alarms **Fixed** "
TowTruck.AlarmTimer aLI = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer find) { return(find.alarmName == "LongIncident"); });
if (aLI != null)
{
if (aLI.hasAlarm == true)
{
lblIncidentAlarm.ForeColor = System.Drawing.Color.Red;
lblIncidentAlarmTime.ForeColor = System.Drawing.Color.Red;
}
else
{
lblIncidentAlarm.ForeColor = System.Drawing.Color.Green;
lblIncidentAlarmTime.ForeColor = System.Drawing.Color.Green;
}
}
lblIncidentAlarm.Text = aLI.hasAlarm.ToString();
lblIncidentAlarmTime.Text = aLI.alarmStart.ToString("hh:mm:ss");
lblIncidentAlarmCleared.Text = aLI.alarmCleared.ToString();
lblIncidentAlarmExcused.Text = aLI.alarmExcused.ToString();
lblIncidentAlarmComments.Text = aLI.comment;
#endregion
#region " GPS Issue Alarms **FIXED TO NEW WAY** "
TowTruck.AlarmTimer aGPS = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer find) { return(find.alarmName == "GPSIssue"); });
if (aGPS != null)
{
if (aGPS.hasAlarm == true)
{
lblGPSIssueAlarm.ForeColor = System.Drawing.Color.Red;
lblGPSIssueStart.ForeColor = System.Drawing.Color.Red;
}
else
{
lblGPSIssueAlarm.ForeColor = System.Drawing.Color.Green;
lblGPSIssueStart.ForeColor = System.Drawing.Color.Green;
}
}
lblGPSIssueAlarm.Text = aGPS.hasAlarm.ToString();
lblGPSIssueStart.Text = aGPS.alarmStart.ToString("hh:mm:ss");
lblGPSIssueCleared.Text = aGPS.alarmCleared.ToString();
lblGPSIssueExcused.Text = aGPS.alarmExcused.ToString();
lblGPSIssueComments.Text = aGPS.comment;
#endregion
#region " Stationary Alarms **FIXED TO NEW WAY** "
TowTruck.AlarmTimer aStationary = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer find) { return(find.alarmName == "Stationary"); });
if (aStationary != null)
{
if (aStationary.hasAlarm == true)
{
lblStationaryAlarm.ForeColor = System.Drawing.Color.Red;
lblStationaryStart.ForeColor = System.Drawing.Color.Red;
}
else
{
lblStationaryAlarm.ForeColor = System.Drawing.Color.Green;
lblStationaryStart.ForeColor = System.Drawing.Color.Green;
}
}
lblStationaryAlarm.Text = aStationary.hasAlarm.ToString();
lblStationaryStart.Text = aStationary.alarmStart.ToString("hh:mm:ss");
lblStationaryCleared.Text = aStationary.alarmCleared.ToString();
lblStationaryExcused.Text = aStationary.alarmExcused.ToString();
lblStationaryComments.Text = aStationary.comment;
#endregion
#region " Long Lunch Alarms "
TowTruck.AlarmTimer aLongLunch = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer find) { return(find.alarmName == "LongLunch"); });
if (aLongLunch != null)
{
if (aLongLunch.hasAlarm == true)
{
lblLongLunchAlarm.ForeColor = System.Drawing.Color.Red;
lblLongLunchComments.ForeColor = System.Drawing.Color.Red;
lblLongLunchStart.ForeColor = System.Drawing.Color.Red;
}
else
{
lblLongLunchAlarm.ForeColor = System.Drawing.Color.Green;
lblLongLunchComments.ForeColor = System.Drawing.Color.Green;
lblLongLunchStart.ForeColor = System.Drawing.Color.Green;
}
lblLongLunchAlarm.Text = aLongLunch.hasAlarm.ToString();
lblLongLunchStart.Text = aLongLunch.GetStartTime();
lblLongLunchComments.Text = aLongLunch.alarmValue;
lblLongLunchCleared.Text = aLongLunch.alarmCleared.ToString();
lblLongLunchExcused.Text = aLongLunch.alarmExcused.ToString();
}
#endregion
#region " Long Break Alarms "
TowTruck.AlarmTimer aLongBreak = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer find) { return(find.alarmName == "LongBreak"); });
if (aLongBreak != null)
{
if (aLongBreak.hasAlarm == true)
{
lblLongBreakAlarm.ForeColor = System.Drawing.Color.Red;
lblLongBreakComments.ForeColor = System.Drawing.Color.Red;
lblLongBreakStart.ForeColor = System.Drawing.Color.Red;
}
else
{
lblLongBreakAlarm.ForeColor = System.Drawing.Color.Green;
lblLongBreakComments.ForeColor = System.Drawing.Color.Green;
lblLongBreakStart.ForeColor = System.Drawing.Color.Green;
}
lblLongBreakAlarm.Text = aLongBreak.hasAlarm.ToString();
lblLongBreakStart.Text = aLongBreak.GetStartTime();
lblLongBreakComments.Text = aLongBreak.alarmValue;
lblLongBreakCleared.Text = aLongBreak.alarmCleared.ToString();
lblLongBreakExcused.Text = aLongBreak.alarmExcused.ToString();
}
#endregion
#region " Overtime "
TowTruck.AlarmTimer aOvertime = thisTruck.tta.truckAlarms.Find(delegate(TowTruck.AlarmTimer find) { return(find.alarmName == "OvertimeActivity"); });
if (aOvertime != null)
{
if (aOvertime.hasAlarm == true)
{
lblOvertimeAlarm.ForeColor = System.Drawing.Color.Red;
lblOvertimeComments.ForeColor = System.Drawing.Color.Red;
lblOvertimeStart.ForeColor = System.Drawing.Color.Red;
}
else
{
lblOvertimeAlarm.ForeColor = System.Drawing.Color.Green;
lblOvertimeComments.ForeColor = System.Drawing.Color.Green;
lblOvertimeStart.ForeColor = System.Drawing.Color.Green;
}
lblOvertimeAlarm.Text = aOvertime.hasAlarm.ToString();
lblOvertimeStart.Text = aOvertime.GetStartTime();
lblOvertimeComments.Text = aOvertime.alarmValue;
lblOvertimeCleared.Text = aOvertime.alarmCleared.ToString();
lblOvertimeExcused.Text = aOvertime.alarmExcused.ToString();
}
#endregion
}
}