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; } }