Example #1
0
        public void SendVehNextStop(string preamble)
        {
            string msgText    = "";
            string pickupAddr = "";


            SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings.Get("ConnString2"));

            try
            {
                conn.Open();
                using (SqlCommand ct = conn.CreateCommand())
                {
                    string sqlQuery = "select * from stop, route, passenger where stop.stop_id='" + currentStop + "' and stop.route_id=route.route_id and (pickup=stop.stop_id or dropoff=stop.stop_id)";
                    log.InfoFormat("{0}", sqlQuery);
                    ct.CommandText = sqlQuery;
                    SqlDataReader dr    = ct.ExecuteReader();
                    int           count = 0;

                    while (dr.Read())
                    {
                        ++count;
                        pickupAddr = String.Format("{0} {1}%R", dr["ad_str_name"].ToString(), dr["ad_city"].ToString());
                        // Pickup Node
                        if (dr["pickup"].ToString().Equals(dr["stop_id"].ToString()))
                        {
                            msgText += VehFormatPickup(dr);
                        }
                        // Dropoff Node
                        else
                        {
                            msgText += VehFormatDropoff(dr);
                        }
                    }
                    msgText = String.Format("{0}{1}{2}", preamble, pickupAddr, msgText);
                    log.InfoFormat("{0}", msgText);
                }
                conn.Close();
            }
            catch (SqlException exc)
            {
                conn.Close();
                log.InfoFormat("Error accessing DB {0}", exc.Message);
            }
            catch (Exception exc)
            {
                conn.Close();
                log.InfoFormat("Error - SendVehNextStop - {0}", exc.Message);
            }

            TPakMsg myTPakMsg = new TPakMsg(vehID.ToString(), "H", "T");

            myTPakMsg.Msg = msgText;
            myTPakMsg.Send();
        }
Example #2
0
        public void SendFirstStop(string routeID)
        {
            string firstStopID = "";

            SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings.Get("MPKODBC"));

            try
            {
                conn.Open();
                using (SqlCommand ct = conn.CreateCommand())
                {
                    string sqlQuery = "select * from stop, vehicle where stop.route_id='" + routeID + "' and stop.route_id=vehicle.route_id order by sequence_nbr";
                    ct.CommandText = sqlQuery;
                    SqlDataReader dr = ct.ExecuteReader();
                    if (dr.Read())
                    {
                        firstStopID = dr["stop_id"].ToString();
                    }
                    else
                    {
                        log.Error(String.Format("Error retrieving stops for vehicle {0} route {1}",
                                                this.vehID.ToString(), routeID));
                        dr.Close();
                        conn.Close();
                        return;
                    }
                    dr.Close();
                }
                conn.Close();
            }
            catch (SqlException exc)
            {
                conn.Close();
                log.InfoFormat("Error accessing DB {0}", exc.Message);
            }
            catch (Exception exc)
            {
                conn.Close();
                log.InfoFormat("Error in SendFirstStop - {0}", exc.Message);
            }


            log.InfoFormat("Sending first stop {0} to vehicle {1}", firstStopID, this.vehID.ToString());


            string msgText    = "";
            string pickupAddr = "";


            try
            {
                conn.Open();
                using (SqlCommand ct = conn.CreateCommand())
                {
                    string sqlQuery = "select * from stop,route,passenger where stop_id='" + firstStopID + "' and route.route_id=stop.route_id and (pickup=stop_id)";
                    ct.CommandText = sqlQuery;
                    SqlDataReader dr = ct.ExecuteReader();
                    while (dr.Read())
                    {
                        pickupAddr = String.Format("{0} {1}%R", dr["ad_str_name"].ToString(), dr["ad_city"].ToString());
                        // Pickup Node
                        if (dr["pickup"].ToString().Equals(dr["stop_id"].ToString()))
                        {
                            msgText += VehFormatPickup(dr);
                        }
                    }
                    dr.Close();
                    msgText = String.Format("{0}{1}", pickupAddr, msgText);
                }
                conn.Close();
            }
            catch (OdbcException exc)
            {
                conn.Close();
                log.InfoFormat("Error accessing DB {0}", exc.Message);
            }
            catch (Exception exc)
            {
                conn.Close();
                log.InfoFormat("Error in SendFirstStop - {0}", exc.Message);
            }



            TPakMsg myTPakMsg = new TPakMsg(vehID.ToString(), "H", "T");

            myTPakMsg.Msg = msgText;
            myTPakMsg.Send();
        }