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