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