private void Page_Load(object sender, System.EventArgs e) { string opcode = Request.Params["op"]; string reqXml = ""; string sqlConnSQL = ConfigurationSettings.AppSettings.Get("SUTIODBC"); XmlTextReader xRdr; XmlDocument xDoc; XmlNode idMsgNode; SUTI smsg; SUTI rmsg; Stream reqStream = Request.InputStream; StreamReader rdr = new StreamReader(reqStream, Encoding.GetEncoding("utf-8")); XmlSerializer mySerializer = new XmlSerializer(typeof(SUTI)); try { XPathNavigator nav; XPathDocument docNav; string xPath; reqXml = rdr.ReadToEnd(); //log.InfoFormat("SOAP Received: " + reqXml); using (StringReader sr = new StringReader(reqXml)) { docNav = new XPathDocument(sr); nav = docNav.CreateNavigator(); xPath = "//*[local-name()='xmlstring']"; reqXml = nav.SelectSingleNode(xPath).Value; } smsg = SUTI.Deserialize(reqXml); //SUTIMsg msgResponse = new SUTIMsg(); //idType id = new idType(); //id.id = "1234"; //msgResponse.idMsg = id; //msgResponse.msgName = "Keep alive"; //rmsg = new SUTI(); //rmsg.msg = new System.Collections.Generic.List<SUTIMsg>(); //rmsg.msg.Add(msgResponse); //log.InfoFormat(rmsg.Serialize().ToString()); } catch (Exception exc) { Console.WriteLine(exc.Message); log.InfoFormat(exc.Message); Response.Redirect(@".\SUTI_2014_MessageXSD.xsd"); return; } if (reqXml.Length == 0) { Session.Clear(); Session.Abandon(); Response.Redirect(@".\SUTI_2014_MessageXSD.xsd"); return; } if (smsg.msg != null) { List <SUTIMsg> messagesIn = smsg.msg; messagesIn.ForEach(delegate(SUTIMsg theMsg) { if (theMsg.msgType.Equals("7000")) // Keep alive { if (theMsg.idMsg != null) { Ping myPing = new Ping(smsg, theMsg, theMsg.idMsg.id, Int32.Parse(Application["msgCount"].ToString())); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; Response.ContentType = "text/xml"; //Response.Write(myPing.ReplyPing().ToCharArray(), 0, myPing.ReplyPing().Length); Response.Filter = new HDIResponseFilter(Response.Filter); Response.Write(myPing.QuickReply()); //sends just the ACK back. lock (Global.lockObject) { Global.MsgHashTable.Add(theMsg.idMsg.id, smsg); } } } if (theMsg.msgType.Equals("5020")) // Location request { Ping myPing = new Ping(smsg, theMsg, theMsg.idMsg.id, Int32.Parse(Application["msgCount"].ToString())); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; Response.ContentType = "text/xml"; Response.Filter = new HDIResponseFilter(Response.Filter); Response.Write(myPing.QuickReply()); //sends just the ACK back. // Send to PI handler // Then acknowledge receipt PI_RQST_GPS myRqstGPS = new PI_RQST_GPS(); // myRqstGPS.veh_nbr = 465; idType idVehicle = theMsg.referencesTo.idVehicle; myRqstGPS.veh_nbr = Int32.Parse(idVehicle.id); SUTI_svc.locationRequest theRequest = ((SUTI_svc.locationRequest)theMsg.Item); if (myRqstGPS.veh_nbr != 9800) { //try //{ // myPISocket = new PI_Lib.PIClient(); // log.InfoFormat("<-- Successful PI socket connection"); //} //catch (System.Net.Sockets.SocketException ex) //{ // log.InfoFormat("Error on PI socket ({0})", ex.Message); // return; //} //myPISocket.SetType(MessageTypes.PI_RQST_GPS); //myPISocket.sendBuf = myRqstGPS.ToByteArray(Int32.Parse(idVehicle.id)); ////myPISocket.sendBuf = myRqstGPS.ToByteArray(Int32.Parse("9996")); //try //{ // log.InfoFormat("<-- PI_RQST_GPS"); // myPISocket.SendMessage(); // myPISocket.CloseMe(); //} //catch (Exception exc) //{ // log.InfoFormat("<-- error on PI socket send (PI_RQST_GPS) " + exc.Message); // return; //} } try { lock (Global.lockObject) { //smsg.timestamp = DateTime.Now; Global.MsgHashTable.Add(theMsg.idMsg.id, smsg); } } catch (Exception exc) { log.InfoFormat("<-- duplicate PI_RQST_GPS hashtable value " + exc.Message); } } else if (theMsg.msgType.Equals("7099")) { Ping myPing = new Ping(smsg, theMsg, theMsg.idMsg.id, Int32.Parse(Application["msgCount"].ToString())); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; Response.ContentType = "text/xml"; Response.Filter = new HDIResponseFilter(Response.Filter); Response.Write(myPing.QuickReply()); //sends just the ACK back. } else if (theMsg.msgType.Equals("7032")) { // ACK handler - just provide a response OrderKELA myOrderKELA = new OrderKELA(smsg, theMsg, theMsg.idMsg.id, Int32.Parse(Application["msgCount"].ToString())); Response.Filter = new HDIResponseFilter(Response.Filter); Response.Write(myOrderKELA.QuickReply()); } else if (theMsg.msgType.Equals("2003")) // Order Reject Confirm { log.InfoFormat("HUT -> HTD: " + reqXml); OrderKelaRejectConfirm myOrderKELARejectConfirm = new OrderKelaRejectConfirm(smsg, theMsg, theMsg.idMsg.id, Int32.Parse(Application["msgCount"].ToString())); Response.Filter = new HDIResponseFilter(Response.Filter); Response.Write(myOrderKELARejectConfirm.QuickReply()); } else if (theMsg.msgType.Equals("2000")) { log.InfoFormat("HUT -> HTD: " + reqXml); // Order handler OrderKELA myOrderKELA = new OrderKELA(smsg, theMsg, theMsg.idMsg.id, Int32.Parse(Application["msgCount"].ToString())); SUTI_svc.order theOrder = ((SUTI_svc.order)theMsg.Item); OdbcConnection connIfx = new OdbcConnection(ConfigurationManager.AppSettings.Get("MadsODBC")); try { connIfx.Open(); String rteID = theOrder.idOrder.id; OdbcCommand myCommand = new OdbcCommand("select * from vpu_node where rte_id='" + rteID + "'", connIfx); OdbcDataReader myReader = myCommand.ExecuteReader(); try { if (myReader.Read()) // route exists....reject!! { // SEND ORDER REJECT 2002 OrderKELAReject or = new OrderKELAReject(rteID, "0000", smsg, Int32.Parse(Application["msgCount"].ToString())); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; or.ReplyOrderCancel(); myReader.Close(); connIfx.Close(); Response.Filter = new HDIResponseFilter(Response.Filter); Response.Write(myOrderKELA.QuickReply()); return; } myReader.Close(); connIfx.Close(); } catch (Exception exc) { connIfx.Close(); } } catch (Exception exc) { System.Diagnostics.Debug.WriteLine(exc.Message); } PI_DISPATCH_CALL myCall = new PI_DISPATCH_CALL(); myCall.call_type = ConfigurationSettings.AppSettings["CallType"].ToCharArray(); myCall.fleet = Convert.ToChar(ConfigurationSettings.AppSettings["FleetID"]); myCall.priority = Convert.ToInt16("25"); myCall.number_of_calls = Convert.ToChar("1"); List <routeNode> rteList = theOrder.route; resourceType ro = theOrder.resourceOrder; if (ro.vehicle != null) { List <attribute> attrList = ro.vehicle.attributesVehicle; string veh_attr = ConfigurationSettings.AppSettings["Vehicle_Attr"]; string drv_attr = ConfigurationSettings.AppSettings["Driver_Attr"]; if (attrList.Count > 0) { foreach (var idAttr in attrList) { if (idAttr.idAttribute.id.Equals("1618")) //EB { veh_attr = "EEEEEEEKEKEEEEEEEEEEEEEEEKEEEEEE"; } else if (idAttr.idAttribute.id.Equals("1601")) //FA (4) { veh_attr = "EEEKEEEEKKEEEEEEEEEEEEEEEKEEEEEE"; } else if (idAttr.idAttribute.id.Equals("1619")) //8H (2) { veh_attr = "EKEEEEEEKKEEEEEEEEEEEEEEEKEEEEEE"; } else if (idAttr.idAttribute.id.Equals("1614")) //IN { veh_attr = "EEEEEEEEEKEEEEEEEEEEEEEEEKEEKEKE"; } else if (idAttr.idAttribute.id.Equals("1615")) //IN { veh_attr = "EEEEEEEEEKEEEEEEEEEEEEEEEKEEKEKE"; } else if (idAttr.idAttribute.id.Equals("1613")) //PA-19 { veh_attr = "EEEEEEEEEKEEEEEEEEKEEEEEEKEEKEEE"; } else if (idAttr.idAttribute.id.Equals("1620")) //TEST { veh_attr = "EKEEEEEKEKEEEEEEEEEEEEEEEKEEEEEE"; } } } capacity cap = ro.vehicle.capacity; if (cap != null) { if (cap.seats != null) { int nbrSeats = Int16.Parse(cap.seats.noOfSeats); if (nbrSeats == 4 || nbrSeats == 5) { veh_attr = "K" + veh_attr.Substring(1, 31); } else if (nbrSeats > 5) { veh_attr = "EK" + veh_attr.Substring(2, 30); } } } manualDescriptionType md = ro.manualDescriptionResource[0]; if (md != null) { String sComment = md.manualText.Replace("Ennakkotilaus:", "").ToUpper(); if (sComment.Length > 64) { sComment = sComment.Substring(0, 64); } myCall.call_comment = sComment.ToCharArray(); } myCall.car_attrib = veh_attr.ToCharArray(); myCall.driver_attrib = drv_attr.ToCharArray(); myCall.car_number = Convert.ToInt16(ro.vehicle.idVehicle.id); } int pickupCount = 0; int totalCount = 0; int orderCount = 0; Dictionary <int, string> sm = new Dictionary <int, string>(); foreach (var rte in rteList) { totalCount++; System.Diagnostics.Debug.WriteLine(rte.addressNode.street); List <idType> subOrderContent = rte.contents[0].subOrderContent; foreach (var idOrder in subOrderContent) { if (idOrder.src.Contains("SUBORDERID")) //this is booking_ID { //myCall.to_addr_street = idOrder.id.ToCharArray(); if (!sm.ContainsValue(idOrder.id)) { ++orderCount; sm.Add(orderCount, idOrder.id); } } } // Translation table for 'community' rte.addressNode.community = CityTranslate(rte.addressNode.community.ToUpper()); if (rte.nodeType == nodeNodeType.pickup && pickupCount == 0) { ++pickupCount; if (rte.addressNode.community.Length < 3) { // attempt to get city from Nominatim server //String nomcity = NomCity([email protected](), // rte.addressNode.geographicLocation.lat.ToString()); //nomcity = CityTranslate(nomcity.ToUpper()); //myCall.from_addr_city = nomcity.ToCharArray(); myCall.from_addr_city = " ".ToCharArray(); } else { myCall.from_addr_city = rte.addressNode.community.ToCharArray(); } myCall.from_addr_street = rte.addressNode.street.ToUpper().ToCharArray(); myCall.from_addr_number = Convert.ToInt32(rte.addressNode.streetNo); // Customer phone number List <contactInfo> contactList = rte.contents[0].contactInfosContent; foreach (var idContact in contactList) { if (idContact.contactType == contactInfoContactType.phone) { String tmpPhone = idContact.contactInfo1; tmpPhone = tmpPhone.Replace("+358", "0"); myCall.phone = tmpPhone.ToCharArray(); } } // time call or immediate call? List <timesTypeTime> timesList = rte.timesNode; if (timesList.Count > 0) { myCall.due_date = String.Format("{0}", timesList[0].time1.ToString("ddMMyy")).ToCharArray(); myCall.due_time = String.Format("{0}", timesList[0].time1.ToString("HHmm")).ToCharArray(); } // get coordinates and convert... //LLUtm llconverter = new LLUtm(); //double utm_east = 0.0; //double utm_north = 0.0; //string utm_zone = ""; //llconverter.LLtoUTM(rte.addressNode.geographicLocation.lat, // rte.addressNode.geographicLocation.@long, out utm_east, out utm_north, out utm_zone); myCall.gpsx = [email protected]().ToCharArray(); myCall.gpsy = rte.addressNode.geographicLocation.lat.ToString().ToCharArray(); myCall.to_addr_city = String.Empty.ToCharArray(); myCall.to_addr_street = String.Empty.ToCharArray(); myCall.to_addr_zone = 0; } else if (rte.nodeType == nodeNodeType.destination) { if (rte.addressNode.community.Length < 3) { myCall.to_addr_city = " ".ToCharArray(); } else { myCall.to_addr_city = rte.addressNode.community.ToCharArray(); } myCall.to_addr_street = rte.addressNode.street.ToUpper().ToCharArray(); myCall.to_addr_number = Convert.ToInt32(rte.addressNode.streetNo); } } if (totalCount > 0) { //myCall.to_addr_street = " ".ToCharArray(); myCall.to_addr_city = String.Empty.ToCharArray(); } myCall.to_addr_street = String.Empty.ToCharArray(); myCall.to_addr_zone = 0; // Send to PI handler // Then acknowledge receipt try { myPISocket = new PI_Lib.PIClient(); log.InfoFormat("<-- Successful PI socket connection"); } catch (System.Net.Sockets.SocketException ex) { log.InfoFormat("Error on PI socket ({0})", ex.Message); return; } myPISocket.SetType(MessageTypes.PI_DISPATCH_CALL); myPISocket.sendBuf = myCall.ToByteArray(); try { log.InfoFormat("<-- Starting PI Socket SEND"); //System.Threading.Thread.Sleep(30000); myPISocket.SendMessage(); log.InfoFormat("<-- Done with PI Socket SEND"); log.InfoFormat("<-- Starting PI Socket RECV"); myPISocket.ReceiveMessage(); log.InfoFormat("<-- Done with PI Socket RECV"); myCall.Deserialize(myPISocket.recvBuf); myPISocket.CloseMe(); log.InfoFormat("<-- success send PI socket"); } catch (Exception exc) { log.InfoFormat("<--- error on PI socket send " + exc.Message); return; } myOrderKELA.LoadKelaOrderDB(smsg, theMsg, theMsg.idMsg.id, myCall.call_number); myOrderKELA.CallNbr = myCall.call_number.ToString(); lock (Global.lockObject) { SUTI_svc.order od = ((SUTI_svc.order)theMsg.Item); OrderMonitor om = new OrderMonitor(smsg, myOrderKELA.CallNbr, od.idOrder.id); om.due_date_time = myOrderKELA._UnixTime; //log.InfoFormat("OrderMonitor created: {0} - {1}", myOrderKELA.CallNbr, myCall.call_number); om.orderStatus = OrderMonitor.CallStatus.NEW; Global.CallHashTable.Add(om, myOrderKELA.CallNbr); } log.InfoFormat("*** Call {0} ***", myOrderKELA.CallNbr); //Response.Write(myCall.call_number.ToString()); Response.Filter = new HDIResponseFilter(Response.Filter); lock (Global.lockObject) { Global.MsgHashTable.Add(theMsg.idMsg.id, smsg); } Response.Write(myOrderKELA.QuickReply()); } else if (theMsg.msgType.Equals("2010")) { log.InfoFormat("HUT -> HTD: " + reqXml); OrderKelaCancel myOrderCancel = new OrderKelaCancel(smsg, theMsg, theMsg.idMsg.id, Int32.Parse(Application["msgCount"].ToString())); SUTI_svc.referencesTo refTo = ((SUTI_svc.referencesTo)theMsg.referencesTo); string routeID = refTo.idOrder[0].id; // Lookup tpak_nbr in vpu_node table int tpak_id = 0; OdbcConnection connIfx = new OdbcConnection(ConfigurationSettings.AppSettings.Get("MadsODBC")); try { connIfx.Open(); OdbcCommand myCommand = new OdbcCommand("select tpak_id from vpu_node where rte_id='" + routeID + "'", connIfx); OdbcDataReader myReader = myCommand.ExecuteReader(); try { while (myReader.Read()) { tpak_id = myReader.GetInt32(0); } } catch (Exception exc) { } connIfx.Close(); } catch (Exception exc) { } lock (Global.lockObject) { Global.MsgHashTable.Add(theMsg.idMsg.id, smsg); foreach (DictionaryEntry de in Global.CallHashTable) { OrderMonitor om = (OrderMonitor)de.Key; if (Int32.Parse(om.tpak_id) == tpak_id) { Global.CallHashTable.Remove(de.Key); break; } } } PI_CANCEL_CALL canxCall = new PI_CANCEL_CALL(); try { myPISocket = new PI_Lib.PIClient(); log.InfoFormat("<-- Successful PI socket connection"); } catch (System.Net.Sockets.SocketException ex) { log.InfoFormat("Error on PI socket ({0})", ex.Message); return; } myPISocket.SetType(MessageTypes.PI_CANCEL_CALL); myPISocket.sendBuf = canxCall.ToByteArray(tpak_id); try { log.InfoFormat("Cancelling TaxiPak order {0}", tpak_id.ToString()); myPISocket.SendMessage(); myPISocket.ReceiveMessage(); canxCall.Deserialize(myPISocket.recvBuf); myPISocket.CloseMe(); } catch (Exception exc) { log.InfoFormat("<--- error on PI socket send " + exc.Message); return; } Response.Filter = new HDIResponseFilter(Response.Filter); Response.Write(myOrderCancel.QuickReply()); } else if (theMsg.msgType.Equals("5000")) { log.InfoFormat("HUT -> HTD: " + reqXml); // Message to Vehicle handler MsgToVehicle myMsgToVehicle = new MsgToVehicle(smsg, theMsg, theMsg.idMsg.id, Int32.Parse(Application["msgCount"].ToString())); SUTI_svc.msgManualDescriptionMsg msgToSend = ((SUTI_svc.msgManualDescriptionMsg)theMsg.Item); // Send to PI handler // Then acknowledge receipt try { myPISocket = new PI_Lib.PIClient(); log.InfoFormat("<-- Successful PI socket connection"); } catch (System.Net.Sockets.SocketException ex) { log.InfoFormat("Error on PI socket ({0})", ex.Message); return; } myPISocket.SetType(MessageTypes.PI_SEND_MESSAGE); PI_SEND_MESSAGE myMsg = new PI_SEND_MESSAGE(); myMsg.Fleet = Convert.ToChar(ConfigurationSettings.AppSettings["FleetID"]); myMsg.ReceiveGroup = 'Q'; myMsg.ReceiveID = "3007".ToCharArray(); myMsg.MessageText = msgToSend.manualText.ToCharArray(); myPISocket.sendBuf = myMsg.ToByteArray(); try { log.InfoFormat("<-- Starting PI Socket SEND"); myPISocket.SendMessage(); log.InfoFormat("<-- Done with PI Socket SEND"); log.InfoFormat("<-- Starting PI Socket RECV"); myPISocket.ReceiveMessage(); log.InfoFormat("<-- Done with PI Socket RECV"); myMsg.Deserialize(myPISocket.recvBuf); myPISocket.CloseMe(); log.InfoFormat("<-- success send PI socket"); } catch { log.InfoFormat("<--- error on PI socket send"); return; } myPISocket.Close(); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; Response.Write(myMsgToVehicle.QuickReply()); lock (Global.lockObject) { Global.MsgHashTable.Add(theMsg.idMsg.id, smsg); } } }); Session.Clear(); Session.Abandon(); return; } int endXml = reqXml.LastIndexOf("</msg>"); string xmlFragment = reqXml.Substring(0, endXml); xRdr = new XmlTextReader(reqXml, XmlNodeType.Element, null); xDoc = new XmlDocument(); try { xDoc.Load(xRdr); } catch (Exception exc) { Console.WriteLine(exc.Message); } idMsgNode = xDoc.SelectSingleNode("/SUTI/msg"); if (idMsgNode != null) { XmlNode idMsg; XmlAttributeCollection msgAttr = idMsgNode.Attributes; Int32 msgType = Int32.Parse(msgAttr.GetNamedItem("msgType").InnerXml); string msgName = (msgAttr.GetNamedItem("msgName").InnerXml); idMsg = xDoc.SelectSingleNode("/SUTI/msg/idMsg"); XmlAttributeCollection idAttr = idMsg.Attributes; string sSrc = idAttr.GetNamedItem("src").InnerXml; string sID = idAttr.GetNamedItem("id").InnerXml; switch (msgType) { case 6000: // Report -- DONE! if (idMsg != null) { Report myReport = new Report(idMsg, Int32.Parse(Application["msgCount"].ToString()), xDoc); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; Response.Write(myReport.ReportConfirm()); } break; case 2002: //Order reject idMsg = xDoc.SelectSingleNode("/SUTI/msg/idMsg"); if (idMsg != null) { Reject myReject = new Reject(idMsg, Int32.Parse(Application["msgCount"].ToString()), xDoc); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; Response.Write(myReject.ReplyReject()); } break; case 2010: // Order cancel idMsg = xDoc.SelectSingleNode("/SUTI/msg/idMsg"); if (idMsg != null) { Cancel myCancel = new Cancel(idMsg, Int32.Parse(Application["msgCount"].ToString()), xDoc); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; Response.Write(myCancel.ReplyCancel()); } break; case 3003: //Dispatch Confirmation - trip is assigned idMsg = xDoc.SelectSingleNode("/SUTI/msg/idMsg"); if (idMsg != null) { Confirm myConfirm = new Confirm(idMsg, Int32.Parse(Application["msgCount"].ToString()), xDoc); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; Response.Write(myConfirm.ReplyConfirm()); } break; case 2000: //ORDER if (idMsgNode != null) { Order myOrder = new Order(reqXml, Int32.Parse(Application["msgCount"].ToString())); TPakTrip theTrip = new TPakTrip(); if (theTrip.Fill(myOrder) == false) { SyntaxError mySyntaxError = new SyntaxError(sID, "Unable to process. Comment length exceeded", Int32.Parse(Application["msgCount"].ToString())); Response.Write(mySyntaxError.ReplySyntaxError()); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; } else { if (theTrip.ValidateVehicleAttr() == false) { SyntaxError mySyntaxError = new SyntaxError(sID, "Unable to process. Bad vehicle attribute", Int32.Parse(Application["msgCount"].ToString())); Response.Write(mySyntaxError.ReplySyntaxError()); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; } else { if (((RteNode)(myOrder._route._nodes[0])).Zone != "-1" && ((RteNode)(myOrder._route._nodes[0])).Locality.Length != 0) { myOrder.TPakID = theTrip.Dispatch(); if (myOrder.TPakID > 0) { myOrder.UpdateTPakID(myOrder.TPakID); } else { myOrder.UpdateTPakID(32142); } Response.Write(myOrder.ReplyOrder()); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; } else if (((RteNode)(myOrder._route._nodes[0])).Locality.Length == 0) { SyntaxError mySyntaxError = new SyntaxError(sID, "Address error: No CITY", Int32.Parse(Application["msgCount"].ToString())); Response.Write(mySyntaxError.ReplySyntaxError()); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; } else // Return error message { SyntaxError mySyntaxError = new SyntaxError(sID, "Zone translation error", Int32.Parse(Application["msgCount"].ToString())); Response.Write(mySyntaxError.ReplySyntaxError()); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; } } } } else { SyntaxError mySyntaxError = new SyntaxError(sID, "Order error", Int32.Parse(Application["msgCount"].ToString())); Response.Write(mySyntaxError.ReplySyntaxError()); Application["msgCount"] = Convert.ToInt32(Application["msgCount"]) + 1; } break; case 2003: // ORDER_REJECT_CONFIRMATION break; } } Session.Clear(); Session.Abandon(); }
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); } }