public static void InsertEmergencyCall(EmergencyCall call)
{
using (SqlConnection conn = new SqlConnection(Config.connectionString))
{
conn.Open();
conn.Insert(call);
}
}
public void PostTropo([FromBody] Emergency emergency)
{
string message = emergency.result.transcription;
string identifier = emergency.result.identifier;
string[] result = identifier.Split(',');
EmergencyCall call = new EmergencyCall();
call.transcription = message;
call.identifier = result[0];
call.latitude = Convert.ToDecimal(result[1]);
call.longitude = Convert.ToDecimal(result[2]);
string mapsLink = "https://www.google.ca/maps?q=" + call.latitude + "," + call.longitude;
SparkBot.NotifyText(message + "\n" + mapsLink);
SparkBot.PostMessage("Emergency notification: " + message + "\n" + "Emergency location: " + mapsLink);
DBAccess.InsertEmergencyCall(call);
}
public static void ExecuteCommand(string roomId, string command, Data personData)
{
_roomId = roomId;
string commandHeader, commandParameters;
int index = command.IndexOf(' ');
if (index != -1)
{
commandHeader = command.Substring(0, index);
commandParameters = command.Substring(index).Trim(' ');
}
else
{
commandHeader = command;
commandParameters = "";
}
switch (commandHeader)
{
case "help":
ListCommands();
break;
case "time":
PostMessage(DateTime.Now.ToString("h:mm:ss tt zz"));
break;
case "text":
TextUser(commandParameters);
break;
case "emergency":
NotifyText(commandParameters);
//NotifyCall(commandParameters);
PostMessage("Users notified!");
var emergCall = new EmergencyCall();
emergCall.transcription = commandParameters;
emergCall.identifier = personData.personEmail;
DBAccess.InsertEmergencyCall(emergCall);
break;
case "checkTemperature":
CheckTemperature();
break;
case "checkSensor":
CheckSensor();
break;
case "conference":
StartConference(commandParameters);
break;
case "invite":
Invite(commandParameters);
break;
case "remove":
Remove(commandParameters);
break;
case "teamInvite":
TeamInvite(commandParameters);
break;
case "teamRemove":
TeamRemove(commandParameters);
break;
case "searchTweet":
TwitterBot.postLastTweet(commandParameters);
break;
case "streamTweet":
TwitterBot.UserStream();
break;
case "searchStream":
TwitterBot.StreamTwitter(commandParameters);
break;
default:
PostMessage(command + " is not a valid command!");
break;
}
}
