private void getProdID_TurnStarting(object sender, TurnStartingEventArgs e) |
{ |
|
} |
|
private void getProdID_ConfirmationTurnStarting(object sender, TurnStartingEventArgs e) |
{ |
ProdID = getProdID.RecognitionResult.Text; |
|
getProdID.ConfirmationPrompts.MainPrompt.SetText( |
string.Format(System.Globalization.CultureInfo.CurrentCulture, |
this.GetPromptResource(this.getProdID.ConfirmationPrompts.MainPrompt.Id), ProdID)); |
} |
|
private void codeActivity1_ExecuteCode(object sender, EventArgs e) |
{ |
|
SqlConnection conn = null; |
SqlDataReader reader = null; |
|
ProdID = ""; |
|
///string ProdName = IDResponse.MainPrompt.AppendText(Convert.ToString(reader["ProductName"])); |
|
try |
{ |
|
|
conn = new SqlConnection("Data Source=MEGATRON\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"); |
conn.Open(); |
|
SqlCommand cmd = new SqlCommand("SELECT * FROM [Current Product List] WHERE ProductID = @ProdID", conn); |
|
SqlParameter param = new SqlParameter(); |
param.ParameterName = "@ProdID"; |
param.Value = ProdID; |
|
///SqlParameter param2 = new SqlParameter(); |
///param.ParameterName = "@ProdName"; |
///param.Value = ProdName; |
|
cmd.Parameters.Add(param); |
|
reader = cmd.ExecuteReader(); |
|
IDResponse.MainPrompt.ClearContent(); |
IDResponse.MainPrompt.AppendText("The Product Name is"); |
|
while (reader.Read()==true) |
{ |
|
IDResponse.MainPrompt.AppendText("{0}", |
Convert.ToString(reader["ProductName"])); |
///IDResponse.MainPrompt.AppendText(Convert.ToString(reader["ProductName"])); |
IDResponse.MainPrompt.AppendBreak(Microsoft.SpeechServer.Synthesis.PromptBreak.Small); |
|
} |
|
reader.Close(); |
|
} |
|
catch |
{ |
|
IDResponse.MainPrompt.SetText("Epic Failure"); |
|
} |
|
finally |
{ |
|
conn.Close(); |
|
} |