// This function represents the planner's ability to simulate the passage of time by 1 day
// This will calculate where each active truck is after 24h: which is convoluted by the
// amount of time between stops and time spent at each stop.
// METHOD HEADER COMMENT -------------------------------------------------------------------------------
/**
* \fn static void IncrementDay()
* \brief This method will be used to simulate the passage of time.
* \details The data from each of the current trip tickets and their Route Data will be read from the data base.
* The time that each ticket has been alive will be used to determine the current location of the truck. This data will be saved back into the database.
* \param[in] null
* \param[out] null
* \exception null
* \see na
* \return void
*
* ---------------------------------------------------------------------------------------------------- */
public static void IncrementDay(Trip_Ticket inTicket)
{
inTicket.Days_Passed += 1;
double DriveTime = inTicket.Days_Passed * 8;
double StopTime = inTicket.Days_Passed * 12;
//load the route stops from data base
PlannerSQL sql = new PlannerSQL();
sql.Open();
List <RouteData> stops = sql.PullRouteDataByTicket(inTicket.TicketID);
Truck localTruck = sql.ReadFromTrucksByID(inTicket.TruckID);
sql.Close();
int i = 0;
RouteData current;
// Calculate how much distance is left for the truck's delivery.
while (true)
{
current = stops[i];
DriveTime -= current.PickupTime;
StopTime -= current.PickupTime;
DriveTime -= current.DrivenTime;
DriveTime -= current.LtlTime;
StopTime -= current.LtlTime;
DriveTime -= current.DropoffTime;
StopTime -= current.DropoffTime;
if (DriveTime <= 0 || StopTime <= 0)
{
break;
}
i++;
}
sql.Open();
sql.UpdateTruckLocation(inTicket.TruckID, current.CityA); //the city a thing is wrong, change it at some point.
sql.UpdateTicket(inTicket);
sql.Close();
}
public bool UpdateTicket(Trip_Ticket inTicket)
{
try
{
string query = "update TripTicket " +
"set Days_Passed = '" + inTicket.Days_Passed + "'," +
"Is_Complete = '" + inTicket.Is_Complete + "'" +
"where TruckID = '" + inTicket.TicketID + "';";
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
return(false);
}
}
