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