protected void btnConfirmSubmit_Click(object sender, EventArgs e) { //to do validations ChatBotAnswerDAO cbaDAO = new ChatBotAnswerDAO(); ChatBotAnswer cbAnswer = new ChatBotAnswer(); cbAnswer.answer = txtAnswers.Text; cbAnswer.intent = ddlIntent.SelectedValue; if (txtEntity.Text != "") { cbAnswer.entityName = txtEntity.Text; } else { cbAnswer.entityName = null; } int answerID = cbaDAO.insertAnswer(cbAnswer); //set audit User currentUser = (User)Session["currentUser"]; setAudit(currentUser, "learny answers", "create", answerID.ToString(), "answer: " + txtAnswers.Text); Response.Redirect("askLearnyAddAns.aspx"); }
public int insertAnswer(ChatBotAnswer cbAnswer) // Insert. { SqlConnection conn = null; int toReturn = -1; try { conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = "Insert into [ChatBotAns] (answer, intentID, entityName) OUTPUT INSERTED.answerID VALUES (@answer, @intentID, @entityName)"; comm.Parameters.AddWithValue("@answer", cbAnswer.answer); comm.Parameters.AddWithValue("@intentID", cbAnswer.intent); if (cbAnswer.entityName != null) { comm.Parameters.AddWithValue("@entityName", cbAnswer.entityName); } else { comm.Parameters.AddWithValue("@entityName", DBNull.Value); } toReturn = (Int32)comm.ExecuteScalar(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }
protected void Page_Load(object sender, EventArgs e) { if (Session["currentUser"] == null) { Response.Redirect("/Login.aspx"); } else { if (!IsPostBack) { User currentUser = (User)Session["currentUser"]; Boolean superuser = false; foreach (String s in currentUser.getRoles()) { if (s.Equals("superuser")) { superuser = true; } } if (!currentUser.getDepartment().Equals("hr")) { if (!superuser) { Response.Redirect("errorPage.aspx"); } } else { ChatBotAnswerDAO cbaDAO = new ChatBotAnswerDAO(); ChatBotAnswer currrentAnswer = cbaDAO.getChatBotAnswerByID(Convert.ToInt32(Request.QueryString["id"])); if (currrentAnswer.answer != null) { txtAnswers.Text = currrentAnswer.answer; txtEntity.Text = currrentAnswer.entityName; ddlIntent.DataBind(); ddlIntent.SelectedIndex = ddlIntent.Items.IndexOf(ddlIntent.Items.FindByText(currrentAnswer.intent)); } else { Response.Redirect("errorPage.aspx"); } } } } }
private void Callbacks_PlayerChat(object sender, PlayerChatEventArgs e) { RunCatchLog(() => { if (e.IsServerMessage || e.Text.IsNullOrTimmedEmpty()) { return; } if (e.IsRegisteredCommand && CheckForReadSettingsCommand(e)) { return; } if (e.IsRegisteredCommand) { return; } foreach (string phrase in Phrases) { string regexPattern = @"\b" + Regex.Escape(phrase) + @"\b"; if (!Regex.IsMatch(e.Text, regexPattern, RegexOptions.Singleline | RegexOptions.IgnoreCase)) { continue; } ChatBotAnswer answer = Answers[phrase]; if (answer.Wisper) { SendFormattedMessageToLogin(e.Login, string.Format("{0}{1}", Botname, answer.Answer)); } else { SendFormattedMessage(string.Format("{0}{1}", Botname, answer.Answer)); } break; } }, "Error in Callbacks_PlayerChat Method.", true); }
public List <ChatBotAnswer> getChatBotAnswerByIntent(string intent) { SqlConnection conn = new SqlConnection(); List <ChatBotAnswer> toReturn = new List <ChatBotAnswer>(); try { conn = new SqlConnection(); string connstr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString(); conn.ConnectionString = connstr; conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = "select cba.answerID, cba.answer, cbi.intent, cba.entityName from [ChatBotAns] cba inner join [ChatBotIntent] cbi on cba.intentID = cbi.intentID where cbi.intent=@intent"; comm.Parameters.AddWithValue("@intent", intent); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { ChatBotAnswer cba = new ChatBotAnswer(); cba.answerID = (int)dr["answerID"]; cba.answer = (string)dr["answer"]; cba.intent = (string)dr["intent"]; if (!dr.IsDBNull(3)) { cba.entityName = (string)dr["entityName"]; } toReturn.Add(cba); } dr.Close(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }