public ChatBotHelpQuestion getChatBotHelpQuestionByID(int questionID)
{
SqlConnection conn = new SqlConnection();
ChatBotHelpQuestion toReturn = new ChatBotHelpQuestion();
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 * from [ChatBotHelpQuestion] where questionID=@questionID";
comm.Parameters.AddWithValue("@questionID", questionID);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
toReturn.questionID = (int)dr["questionID"];
toReturn.question = (string)dr["question"];
}
dr.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(toReturn);
}
public List <ChatBotHelpQuestion> getAllChatBotHelpQuestions()
{
SqlConnection conn = new SqlConnection();
List <ChatBotHelpQuestion> toReturn = new List <ChatBotHelpQuestion>();
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 * from [ChatBotHelpQuestion]";
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
ChatBotHelpQuestion cbhq = new ChatBotHelpQuestion();
cbhq.questionID = (int)dr["questionID"];
cbhq.question = (string)dr["question"];
toReturn.Add(cbhq);
}
dr.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(toReturn);
}
protected void btnCfmDelete_Click(object sender, EventArgs e)
{
//To do validations
ChatBotHelpQuestionDAO cbhqDAO = new ChatBotHelpQuestionDAO();
ChatBotHelpQuestion currentQuestion = cbhqDAO.getChatBotHelpQuestionByID(Convert.ToInt32(Request.QueryString["id"]));
cbhqDAO.deleteQuestionByID(currentQuestion.questionID);
//set audit
User currentUser = (User)Session["currentUser"];
setAudit(currentUser, "learny help questions", "delete", currentQuestion.questionID.ToString(), "deleted question: " + currentQuestion.question);
Response.Redirect("askLearnyHelpQn.aspx");
}
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
{
ChatBotHelpQuestionDAO cbhqDAO = new ChatBotHelpQuestionDAO();
ChatBotHelpQuestion currentQuestion = cbhqDAO.getChatBotHelpQuestionByID(Convert.ToInt32(Request.QueryString["id"]));
if (currentQuestion.question != null)
{
txtHelpInput.Text = currentQuestion.question;
}
else
{
Response.Redirect("errorPage.aspx");
}
}
}
}
}
