public MonitoringContextMatchResult GetActionInfo(long callId, long contextId, long phraseId) { MonitoringContextMatchResult result = new MonitoringContextMatchResult(); try { using (var cn = new SqlConnection(_connection)) { cn.Open(); using (var cm = new SqlCommand("[icc_Digital_Monitoring].[dbo].[usp_GetActionByCallId]", cn)) { cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@CallId", callId); cm.Parameters.AddWithValue("@ContextId", contextId); cm.Parameters.AddWithValue("@PhraseId", phraseId); using (var dr = cm.ExecuteReader()) while (dr.Read()) { result.Action = dr["Action"]?.ToString(); } } } } catch (Exception ex) { } return(result); }
static void Main(string[] args) { long callId = 10640115; long contextId = 5; long phraseId = 104146; MonitoringContextMatchResult result = new MonitoringContextMatchResult(); Voicer.Context.Monitor.IContextMonitorServices monitor = Voicer.Context.Monitor.VoicerContextMonitor.GetInstance(); result = monitor.GetActionInfo(callId, contextId, phraseId); string teste = String.Empty; }