public bool Monitor()
{
DateTime interimTime = DateTime.Now;
TimeSpan ts = interimTime.Subtract(startTime); // Used to track how long we've been monitoring
//connIfx = new IfxConnection(ConfigurationSettings.AppSettings.Get("MadsConnect"));
OdbcConnection odbcIfx = new OdbcConnection(ConfigurationSettings.AppSettings.Get("MadsODBC"));
try
{
odbcIfx.Open();
}
catch (OdbcException exc)
{
log.InfoFormat("ODBC exception {0}", exc.Message);
}
while (true)
{
interimTime = DateTime.Now;
ts = interimTime.Subtract(startTime);
#region main TRY block
try
{
System.Threading.Thread.Sleep(10000);
using (OdbcCommand ct = odbcIfx.CreateCommand())
{
string sqlQuery = "select cl_veh_nbr, cl_status from calls where cl_nbr=" + call_nbr.ToString();
ct.CommandText = sqlQuery;
ct.CommandTimeout = 5;
//log.InfoFormat("Querying IFX vehicle table {0}", sqlQuery);
try
{
OdbcDataReader dr = ct.ExecuteReader(CommandBehavior.SingleResult);
if (dr == null)
{
log.InfoFormat("Error with IFX reader call #{0}", call_nbr.ToString());
odbcIfx.Close();
return(false);
}
if (dr.Read())
{
log.InfoFormat("Found call {0} Vehicle {1} Status {2}",
call_nbr.ToString(), Convert.ToInt32(dr["cl_veh_nbr"]), dr["cl_status"].ToString());
cl_status = dr["cl_status"].ToString().Trim();
if (Int32.Parse(dr["cl_veh_nbr"].ToString()) > 0)
{
//log.InfoFormat("Call {0} accepted by vehicle {1}", call_nbr.ToString(), Convert.ToInt32(dr["cl_veh_nbr"]));
veh_nbr = Convert.ToInt32(dr["cl_veh_nbr"]);
break;
//break so we continue vehicle acceptance processing below
}
else if (cl_status.Equals("PERUTTU")) // canceled on TaxiPak side
{
log.InfoFormat("Trip cancelled {0}", this.call_nbr.ToString());
// Send new RouteAccept message
RouteAccept rteAccept = new RouteAccept();
rteAccept.Accept = "no";
rteAccept.RouteID = this.route_id;
rteAccept.Send();
veh_nbr = 0;
break; // return true so that this element is removed from call monitor list
}
else // Check if we should cancel the trip because of duration
{
// Check how long we've been monitoring this trip
if (ts.Minutes >= Convert.ToInt32(timeout))
{
log.Info(String.Format("Stop monitoring and cancel trip #{0}", this.call_nbr.ToString()));
//Console.WriteLine("Stop Monitoring and cancel trip #{0}", this.call_nbr.ToString());
try
{
myPISocket = new PIClient();
}
catch (System.Net.Sockets.SocketException ex)
{
log.Info(String.Format("Error connecting to TaxiPak for cancel: {0}", ex.Message));
//Console.WriteLine("Error connecting to TaxiPak ({0})", ex.Message);
break;
}
catch (Exception ex)
{
log.InfoFormat("Generic error connecting to TaxiPak for cancel: {0}", ex.Message);
break;
}
myPISocket.SetType(MessageTypes.PI_CANCEL_CALL);
PI_Lib.PI_CANCEL_CALL myCancelCall = new PI_CANCEL_CALL();
myPISocket.sendBuf = myCancelCall.ToByteArray(Convert.ToInt32(call_nbr));
try
{
myPISocket.SendMessage();
//myPISocket.ReceiveMessage();
//PI_CANCEL_CALL.Deserialize(myPISocket.recvBuf);
myPISocket.CloseMe();
}
catch (Exception ex)
{
log.InfoFormat("Error cancelling trip in TaxiPak {0} {1}", call_nbr.ToString(), ex.Message);
break;
}
log.InfoFormat("Trip cancelled {0}", this.call_nbr.ToString());
// Send new RouteAccept message
RouteAccept rteAccept = new RouteAccept();
rteAccept.Accept = "no";
rteAccept.RouteID = this.route_id;
rteAccept.Send();
break; // return true so that this element is removed from call monitor list
}
}
}
else
{
log.Error(String.Format("Call #{0} not found in TaxiPak", call_nbr.ToString()));
}
dr.Close();
}
catch (OdbcException exc)
{
log.InfoFormat("IFX exception on read {0}", exc.Message);
odbcIfx.Close();
break;
}
}
}
catch (Exception exc)
{
log.InfoFormat("Error on query call #{0} {1}", call_nbr.ToString(), exc.Message);
veh_nbr = 0;
odbcIfx.Close();
break;
}
#endregion
} // end while
// close off the previous connection
try
{
//log.InfoFormat("Closing IFX connections");
odbcIfx.Close();
}
catch (Exception exc)
{
log.InfoFormat("Error with IFX {0}", exc.Message);
veh_nbr = 0;
return(false);
}
if (veh_nbr > 0) // trip has been accepted
{
#region vehicle accepted trip
log.Info(String.Format("Trip #{0} accepted by taxi #{1}", call_nbr.ToString(), veh_nbr.ToString()));
// Add a new record to vehicle table for this route
VehicleRec acceptVehicle = new VehicleRec(veh_nbr, this.route_id);
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings.Get("ConnString2"));
try
{
conn.Open();
using (SqlCommand ct = conn.CreateCommand())
{
ct.CommandType = CommandType.StoredProcedure;
ct.CommandText = "UpdateRouteVehicle";
ct.Parameters.Add("@aRouteID", route_id);
ct.Parameters.Add("@aVehicleID", veh_nbr);
ct.Parameters.Add("@aLocX", Convert.ToInt32(acceptVehicle.LocX));
ct.Parameters.Add("@aLocY", Convert.ToInt32(acceptVehicle.LocY));
ct.Parameters.Add("@aMobilePhone", acceptVehicle.MobilePhone);
ct.Parameters.Add("@aLicense", acceptVehicle.License);
ct.ExecuteNonQuery();
}
}
catch (SqlException exc)
{
conn.Close();
log.InfoFormat("Error accessing DB {0}", exc.Message);
}
catch (Exception exc)
{
conn.Close();
log.InfoFormat("Error accessing DB {0}", exc.Message);
}
conn.Close();
// Send new RouteAccept message
RouteAccept rteAccept = new RouteAccept();
rteAccept.VehPax = acceptVehicle.PassCapacity.ToString();
if (acceptVehicle.Wheelchair == true)
{
rteAccept.VehWheels = "1";
}
else
{
rteAccept.VehWheels = "0";
}
try
{
conn.Open();
using (SqlCommand ct = conn.CreateCommand())
{
string sqlQuery = "select * from route, vehicle where route.route_id='" + this.route_id + "' and vehicle.route_id=route.route_id";
ct.CommandText = sqlQuery;
SqlDataReader rdr1 = ct.ExecuteReader();
if (rdr1.Read())
{
rteAccept.RouteID = this.route_id;
rteAccept.VehicleID = rdr1["veh_id"].ToString();
rteAccept.Version = rdr1["version"].ToString();
rteAccept.PriceGroup = "1";
rteAccept.CompanyID = "17";
rteAccept.Accept = "yes";
rteAccept.TPakID = rdr1["tpak_id"].ToString();
rteAccept.Send();
}
rdr1.Close();
}
}
catch (SqlException exc)
{
conn.Close();
log.InfoFormat("Error accessing DB {0}", exc.Message);
}
catch (Exception exc)
{
conn.Close();
log.InfoFormat("Error accessing DB {0}", exc.Message);
}
conn.Close();
//Setup the Vehicle record with the first and next STOP
acceptVehicle.SetFirstStop(this.route_id);
// Send the first stop to the taxi automatically
//acceptVehicle.SendFirstStop(this.route_id);
acceptVehicle.GetAllStops();
return(true);
#endregion
}
return(true);
}
public string Send()
{
String result = "";
myWebRequestMPK.ContentType = "text/xml;charset=\"utf-8\"";
myWebRequestMPK.Method = "POST";
XmlTextWriter w;
try
{
w = new XmlTextWriter(@"C:\\temp\\routeaccept_" + System.Threading.Thread.CurrentThread.GetHashCode().ToString() + ".xml", Encoding.UTF8);
w.Formatting = Formatting.None;
w.WriteStartDocument();
w.WriteStartElement("route_accept");
w.WriteStartElement("id");
w.WriteString(this.RouteID);
w.WriteEndElement();
w.WriteStartElement("version");
w.WriteString(this.Version);
w.WriteEndElement();
w.WriteStartElement("accept");
w.WriteString(this.Accept);
w.WriteEndElement();
w.WriteStartElement("vehicle");
w.WriteString(this.VehicleID);
w.WriteEndElement();
if (this.VehicleID != null)
{
w.WriteStartElement("vehicle_capacity");
w.WriteStartElement("passengers");
w.WriteString(this.VehPax);
w.WriteEndElement();
w.WriteStartElement("wheelchairs");
w.WriteString(this.VehWheels);
w.WriteEndElement();
w.WriteEndElement();
}
w.WriteStartElement("price_group");
w.WriteString("1");
//w.WriteString(this.PriceGroup);
w.WriteEndElement();
w.WriteStartElement("company_id");
w.WriteString(this.CompanyID);
w.WriteEndElement();
w.WriteEndElement();
w.Close();
XmlDocument xDoc = new XmlDocument();
xDoc.Load(@"c:\\temp\\routeaccept_" + System.Threading.Thread.CurrentThread.GetHashCode().ToString() + ".xml");
log.Info(String.Format("<route_accept> sent: {0}", xDoc.OuterXml));
//Console.WriteLine("Sending <route_accept> msg: {0}",xDoc.OuterXml);
MD5Verifier ver = new MD5Verifier(Encoding.UTF8);
ver.doVerify(xDoc.OuterXml);
Stream reqStream = myWebRequestMPK.GetRequestStream();
StreamWriter sw = new StreamWriter(reqStream);
sw.Write(xDoc.OuterXml);
sw.Write(ver.GetCheckSum());
sw.Close();
}
catch (WebException e)
{
log.ErrorFormat("Timeout error awaiting route_accept response from server {0}", e.Message);
return(null);
}
catch (Exception e)
{
log.Error(String.Format("Error formatting <route_accept> {0}", e.Message));
//Console.WriteLine("Exception raised: {0}", e.Message);
}
try
{
myWebResponseMPK = (HttpWebResponse)myWebRequestMPK.GetResponse();
using (StreamReader sr = new StreamReader(myWebResponseMPK.GetResponseStream()))
{
XmlNode idMsgNode;
result = sr.ReadToEnd();
result = result.Substring(0, result.LastIndexOf("</ack>") + 6);
log.Info(String.Format("MPK Server reply: {0}", result));
// Check for ERROR response
XmlTextReader xRdr = new XmlTextReader(result, XmlNodeType.Element, null);
XmlDocument xDoc = new XmlDocument();
xDoc.Load(xRdr);
idMsgNode = xDoc.SelectSingleNode("/ack/status");
if (idMsgNode != null)
{
if (idMsgNode.InnerText.Equals("offer_expired") ||
idMsgNode.InnerText.Equals("error"))
{
log.InfoFormat("MPK Server indicates ERROR. Cancelling trip {0} in TaxiPak", this.TPakID);
// Cancel trip in TaxiPak....MPK side doesn't like our ACCEPT
try
{
myPISocket = new PIClient();
}
catch (System.Net.Sockets.SocketException ex)
{
log.Info(String.Format("Error connecting to TaxiPak for cancel: {0}", ex.Message));
//Console.WriteLine("Error connecting to TaxiPak ({0})", ex.Message);
return(result);
}
catch (Exception ex)
{
log.InfoFormat("Generic error connecting to TaxiPak for cancel: {0}", ex.Message);
return(result);
}
myPISocket.SetType(MessageTypes.PI_CANCEL_CALL);
PI_Lib.PI_CANCEL_CALL myCancelCall = new PI_CANCEL_CALL();
myPISocket.sendBuf = myCancelCall.ToByteArray(Convert.ToInt32(this.TPakID));
try
{
myPISocket.SendMessage();
//myPISocket.ReceiveMessage();
//PI_CANCEL_CALL.Deserialize(myPISocket.recvBuf);
myPISocket.CloseMe();
}
catch (Exception ex)
{
log.InfoFormat("Error cancelling trip in TaxiPak {0} {1}", this.TPakID, ex.Message);
return(result);
}
log.InfoFormat("Trip cancelled {0}", this.TPakID);
}
}
//Console.WriteLine("Received reply: {0}", result);
return(result);
}
}
catch (WebException e)
{
if (e.Status == WebExceptionStatus.Timeout)
{
log.Error("Timeout error awaiting route_accept response from server");
return(null);
}
log.Error(String.Format("MPK Server returned error: {0}", e.Message));
myWebResponseMPK = (HttpWebResponse)e.Response;
if (myWebResponseMPK != null)
{
using (StreamReader sr = new StreamReader(myWebResponseMPK.GetResponseStream()))
{
result = sr.ReadToEnd();
log.InfoFormat("{0}", result);
}
}
//Console.WriteLine("Server error {0}", e.Message);
return(null);
}
}