internal List <CommonQuestions> getCommonQuestions()
{
List <CommonQuestions> commonQuestions = new List <CommonQuestions>();
try
{
string getQuestionQry = QueryBuilder.GetCommonQuestions();
DataSet commonQuestionsList = dA.executeSqlStatement(getQuestionQry);
if (commonQuestionsList.Tables[0].Rows.Count > 0)
{
foreach (DataRow question in commonQuestionsList.Tables[0].Rows)
{
CommonQuestions cQues = new CommonQuestions();
cQues.QuestionID = Convert.ToInt64(question["QuestionID"]);
cQues.Question = Convert.ToString(question["Question"]);
cQues.Answer = Convert.ToString(question["Answer"]);
cQues.ConversationState = Convert.ToString(question["ConversationState"]);
cQues.ConversationStateValue = Convert.ToString(question["COnversationStateValue"]);
commonQuestions.Add(cQues);
}
}
}
catch (Exception)
{
}
return(commonQuestions);
}
internal List <CommonQuestions> getCommonQuestions()
{
List <CommonQuestions> commonQuestions = new List <CommonQuestions>();
try
{
string getQuestionQry = QueryBuilder.GetCommonQuestions();
//DataSet commonQuestionsList = dA.executeSqlStatement(getQuestionQry);
DataSet commonQuestionsList = new DataSet();
try
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(ConfigurationManager.AppSettings["ChatBot.Service.URL"].ToString());
var responseTask = client.GetAsync("executeSqlStatement?sqlstatement=" + getQuestionQry);
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <DataSet>();
readTask.Wait();
commonQuestionsList = readTask.Result;
}
}
}
catch (Exception ex)
{
}
if (commonQuestionsList.Tables[0].Rows.Count > 0)
{
foreach (DataRow question in commonQuestionsList.Tables[0].Rows)
{
CommonQuestions cQues = new CommonQuestions();
cQues.QuestionID = Convert.ToInt64(question["QuestionID"]);
cQues.Question = Convert.ToString(question["Question"]);
cQues.Answer = Convert.ToString(question["Answer"]);
cQues.ConversationState = Convert.ToString(question["ConversationState"]);
cQues.ConversationStateValue = Convert.ToString(question["COnversationStateValue"]);
commonQuestions.Add(cQues);
}
}
}
catch (Exception)
{
}
return(commonQuestions);
}
