예제 #1
0
        public void SaveActiveAnswer(string email, string ans, string tim)
        {
            Stack <ConidAndAnswer> usersAtLocation = new Stack <ConidAndAnswer>();
            ConidAndAnswer         data            = new ConidAndAnswer();

            try
            {
                LogMsg("SaveActiveAnswer", "Top ");
                LogMsg("email", email);
                LogMsg("ans", ans);
                LogMsg("time", tim.ToString());
                string        conString = ConfigurationManager.ConnectionStrings["Easypassworld2017ConnectionString"].ConnectionString;
                SqlConnection con       = new SqlConnection();
                con.ConnectionString = conString;
                string         strr = "execute [insertAnwer]" + "'" + email + "'" + "," + "'" + ans + "'" + "," + "'" + tim + "'";
                SqlDataAdapter da   = new SqlDataAdapter(strr, con);
                DataTable      dtt  = new DataTable();
                da.Fill(dtt);
                LogMsg("SaveActiveAnswer", "Bottom");
            }
            catch (Exception e)
            {
                LogMsg("SaveActiveAnswer", "Failed " + e.ToString());
            }
        }
예제 #2
0
        public Stack <ConidAndAnswer> getUserByLocatnAndTimeForTraffic(double minlat, double maxlat, double minlon, double maxlon, string tim)
        {
            Stack <ConidAndAnswer> usersAtLocation = new Stack <ConidAndAnswer>();
            ConidAndAnswer         data            = new ConidAndAnswer();

            try
            {
                LogMsg("Block 6 Time", tim);
                LogMsg("Block 6", "I entered Block 6");
                string        conString = ConfigurationManager.ConnectionStrings["Easypassworld2017ConnectionString"].ConnectionString;
                SqlConnection con       = new SqlConnection();
                con.ConnectionString = conString;
                string         strr = "execute getUserByLocatnForTraffic2" + "'" + minlat + "'" + "," + "'" + maxlat + "'" + "," + "'" + minlon + "'" + "," + "'" + maxlon + "'" + "," + "'" + tim + "'";
                SqlDataAdapter da   = new SqlDataAdapter(strr, con);
                DataTable      dtt  = new DataTable();
                da.Fill(dtt);
                LogMsg("Block 7", "I entered Block 7");
                if (dtt.Rows.Count > 0)
                {
                    for (int i = 0; i < 10; i++)
                    {
                        data.conid  = dtt.Rows[i]["conId"].ToString();
                        data.answer = dtt.Rows[i]["answer"].ToString();
                        LogMsg("Block 7 answer", data.answer);
                        LogMsg("Block 7 Conid", data.conid);
                        usersAtLocation.Push(data);
                    }
                }
            }
            catch (Exception e)
            {
                LogMsg("Block 8", e.ToString());
            }

            return(usersAtLocation);
        }
예제 #3
0
        public void onTrafficQuestion(PrivateMessage data)
        {
            //Get the connectionid of the user from the database
            string fromConn = GetConnection(data.From);

            LogMsg("From", data.From);

            //Select the connectionid of all users at the specified location from the database
            //Add the selected connectionIds to a new group
            //Send the request to all of them
            LogMsg("Traffic", "I entered traffic block");
            Stack <string>         usersAtLocation  = new Stack <string>();
            Stack <ConidAndAnswer> usersAtLocation2 = new Stack <ConidAndAnswer>();

            usersAtLocation2 = getUserByLocatnAndTimeForTraffic(data.MinLat, data.MaxLat, data.MinLongi, data.MaxLongi, data.tim);
            ConidAndAnswer ConnectionIds = null;

            if (usersAtLocation2.Count > 0)
            {
                LogMsg("Level1", "inside level1");
                LogMsg("Count", usersAtLocation2.Count.ToString());
                int veryfree    = 0;
                int movinslowly = 0;
                int standstill  = 0;
                //Analyse the data

                while (usersAtLocation2.Count > 0)
                {
                    LogMsg("Level2", "inside level2");

                    ConnectionIds = usersAtLocation2.Pop();

                    if (ConnectionIds.answer == "Very Free")
                    {
                        veryfree += 1;
                    }
                    else if (ConnectionIds.answer == "Moving Slowly")
                    {
                        movinslowly += 1;
                    }
                    else if (ConnectionIds.answer == "Standstill")
                    {
                        standstill += 1;
                    }
                }

                //Find the highest answer
                String result = "Very Free";
                int    high   = veryfree;
                if (high < movinslowly)
                {
                    LogMsg("Level3", "inside level3");
                    high   = movinslowly;
                    result = "Moving Slowly";
                }
                else if (high < standstill)
                {
                    high   = standstill;
                    result = "Standstill";
                }

                //Send anawer back
                PrivateMessage trafficData = new PrivateMessage();
                trafficData.type          = "trafficAnswer";
                trafficData.trafficAnswer = result;
                trafficData.From          = "activeAnswer";
                trafficData.To            = fromConn;
                trafficData.msgId         = data.msgId;

                Clients.Client(fromConn).TrafficAnswer(trafficData);
            }
            else
            {
                LogMsg("Level4", "inside level4");
                usersAtLocation = getUserByLocatnForTraffic(data.MinLat, data.MaxLat, data.MinLongi, data.MaxLongi);

                PrivateMessage trafficData = new PrivateMessage();
                trafficData.type  = data.type;
                trafficData.msgId = data.msgId;
                trafficData.From  = data.From;

                //  Clients.Client(Context.ConnectionId).TrafficQuestion(trafficData);//Remove later----------------

                while (usersAtLocation.Count > 0)
                {
                    LogMsg("Level5", "inside level5");
                    LogMsg("TrafficCon", usersAtLocation.Count.ToString());

                    string ConnectionIdss = usersAtLocation.Pop();
                    trafficData.ToConn = ConnectionIdss;
                    LogMsg("TrafficCon", ConnectionIdss);

                    Clients.Client(ConnectionIdss).TrafficQuestion(trafficData);
                }
            }
        }