protected void InsertAnswer() { QAAnswer answer = new QAAnswer(); string Question = Request.QueryString["QuestionId"]; int UserId = Convert.ToInt32(Session["UserId"]); int LastId = 0; answer.Answer = txtAnswer.Text; answer.Date = DateTime.Now.ToString(); answer.QuestionId = Convert.ToInt32(Question); answer.UserId = UserId; try { SqlCommand cmd = new SqlCommand("INSERT INTO Answer (Answer, QuestionId, UserId, Date) VALUES (@Answer, @QuestionId, @UserId, @Date); SELECT SCOPE_IDENTITY();"); cmd.CommandType = CommandType.Text; cmd.Connection = connection; cmd.Parameters.AddWithValue("@Answer", answer.Answer); cmd.Parameters.AddWithValue("@Date", DateTime.Now); cmd.Parameters.AddWithValue("@QuestionId", answer.QuestionId); cmd.Parameters.AddWithValue("@UserId", answer.UserId); connection.Open(); //cmd.exExecuteNonQuery(); LastId = Convert.ToInt16(cmd.ExecuteScalar()); ClientScript.RegisterStartupScript(typeof(Page), "myscript", "alert('You answer on question!');", true); txtAnswer.Text = ""; connection.Close(); } catch (Exception ex) { //MessageBox.Show("Članak nije unesen!", "Important Message"); ClientScript.RegisterStartupScript(typeof(Page), "myscript", "alert('Failed!');", true); } finally { connection.Close(); } }
protected void showAnswers(int Question) { QAAnswer answer = new QAAnswer(); List<QAAnswer> answerlist = new List<QAAnswer>(); int _question = Question; DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataRow dr = null; SqlCommand cmd = new SqlCommand("SELECT dbo.Answer.AnswerId, dbo.Answer.Answer, dbo.Answer.QuestionId, dbo.Answer.UserId," + "dbo.Answer.Date,dbo.Answer.Score, dbo.Users.Username FROM dbo.Answer INNER JOIN dbo.Question ON dbo.Answer.QuestionId = dbo.Question.QuestionId " + " INNER JOIN dbo.Users ON dbo.Answer.UserId = dbo.Users.UserId" + " Where dbo.Question.QuestionId=@QuestionId" , connection); cmd.Parameters.AddWithValue("@QuestionId", _question); dt.Columns.Add("Answer"); dt.Columns.Add("Date"); dt.Columns.Add("Score"); dt.Columns.Add("Username"); connection.Open(); try { SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds, "Answer"); da.Fill(dt); SqlDataReader reader = cmd.ExecuteReader(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = dt.NewRow(); dr["AnswerId"] = ds.Tables[0].Rows[i]["AnswerId"].ToString(); dr["Answer"] = ds.Tables[0].Rows[i]["Answer"].ToString(); dr["Date"] = ds.Tables[0].Rows[i]["Date"].ToString(); dr["Score"] = ds.Tables[0].Rows[i]["Score"].ToString(); dr["Username"] = ds.Tables[0].Rows[i]["Username"].ToString(); answer = new QAAnswer(); answer.AnswerId = Convert.ToInt32(dr["AnswerId"].ToString()); answer.Answer = dr["Answer"].ToString(); answer.Date = dr["Date"].ToString(); answer.Score = Convert.ToInt32(dr["Score"]); answer.Username = dr["Username"].ToString(); answerlist.Add(answer); } } catch (Exception e) { } finally { connection.Close(); } rprAnswers.DataSource = answerlist; rprAnswers.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { string username = (string)Session["Username"]; string Question = Request.QueryString["QuestionId"]; string numviews = "0"; showAnswers(Convert.ToInt32(Question)); List<QAQuestion> questionbody = new List<QAQuestion>(); QAQuestion question = new QAQuestion(); QAAnswer answer = new QAAnswer(); List<QAAnswer> answerlist = new List<QAAnswer>(); QATag tag = new QATag(); if (!IsPostBack) { DataSet ds = new DataSet(); connection.Open(); SqlCommand cmd = new SqlCommand("SELECT dbo.Question.QuestionId As QuestionId, dbo.Question.QuestionTitle AS QuestionTitle, dbo.Question.QuestionBody AS QuestionBody, dbo.Question.CreatedDate AS CreatedDate,dbo.Question.NumOfViews AS NumOfViews, dbo.Users.UserId AS UserId, dbo.Users.Firstname, dbo.Users.Lastname, dbo.Users.Username" + " FROM dbo.Question INNER JOIN dbo.Users ON dbo.Question.UserId = dbo.Users.UserId WHERE dbo.Question.QuestionId=" + Question, connection); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); refreshVotingData(); List<QATag> taglist = new List<QATag>(); //rprTags.DataSource = taglist; //rprTags.DataBind(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { if (reader["NumOfViews"].ToString() != "") numviews = reader["NumOfViews"].ToString(); else numviews = "0"; question.QuestionTitle = reader["QuestionTitle"].ToString(); question.QuestionBody = reader["QuestionBody"].ToString(); question.NumOfViews = Convert.ToInt32(reader["NumOfViews"].ToString()); if (reader["NumOfViews"].ToString() != "") numviews = reader["NumOfViews"].ToString(); else numviews = "0"; questionbody.Add(question); Repeater1.DataSource = questionbody; Repeater1.DataBind(); lblDate.Text = reader["CreatedDate"].ToString(); lblAutor.Text = reader["Firstname"].ToString() + " " + reader["Lastname"].ToString() + ""; reader.Close(); connection.Close(); UpdateViews(numviews); } lblKljucneRijeci.Text = ""; GetTagInQuestions(); connection.Close(); //////Recommend StackOverflow StackOverflowRecommendation(taglist, question.QuestionTitle); } }