protected void Page_Load(object sender, EventArgs e) { user = User.Identity.Name; DataTable MyQuestionsTable = new QuesDB().GetMyQuestions(user); if (MyQuestionsTable.Rows.Count != 0) { DataView MyQuestions = new DataView(); MyQuestions.Table = MyQuestionsTable; MyQuestionsView.SetActiveView(QuestionsPresent); if (SelectionCriteria.SelectedItem.Value == "All") MyQuestions.Sort = "PostedTime DESC"; else if (SelectionCriteria.SelectedItem.Value == "Answered") { MyQuestions.RowFilter = "Answered = 1"; MyQuestions.Sort = "PostedTime DESC"; } else if (SelectionCriteria.SelectedItem.Value == "Unanswered") { MyQuestions.RowFilter = "Answered = 0"; MyQuestions.Sort = "PostedTime DESC"; } questionsList.DataSource = MyQuestions; } else MyQuestionsView.SetActiveView(NoQuestions); }
protected void Page_Load(object sender, EventArgs e) { DataTable QuestionTable = new QuesDB().GetAllQuestions(); DataView questionsView = new DataView(); questionsView.Table = QuestionTable; if (Sort.SelectedItem.Value == "Latest") questionsView.Sort = "PostedTime DESC"; else if (Sort.SelectedItem.Value == "Popular") questionsView.Sort = "Views DESC"; else if (Sort.SelectedItem.Value == "Unanswered") { questionsView.RowFilter = "Answered = 0"; questionsView.Sort = "PostedTime DESC"; } else if (Sort.SelectedItem.Value == "Mostanswered") questionsView.Sort = "TotalAnswers DESC"; if (questionsView.Count == 0) PagerDiv.Visible = false; else PagerDiv.Visible = true; questionsList.DataSource = questionsView; }
protected void PostButton_Click(object sender, EventArgs e) { if (Page.IsValid) { QuesDB newQuestionDB = new QuesDB(); newQuestionDB.InsertQuestion(new QuesClass (QuestionTextBox.Text, Membership.GetUser(User.Identity.Name).UserName, DateTime.Now)); } }
protected void Page_Load(object sender, EventArgs e) { QuestionID = int.Parse(Request.QueryString["ID"]); QuesDB questionDB = new QuesDB(); if (!this.IsPostBack) { if (Request.UrlReferrer != null) { if (!(Request.UrlReferrer.Query.Contains(HttpContext.Current.Request.Url.PathAndQuery) || Request.UrlReferrer.AbsoluteUri == Request.Url.AbsoluteUri)) //Do Not Increase View on Refresh or PostBack questionDB.increaseView(QuestionID); } } QuesClass question = questionDB.GetQuestion(QuestionID); Question = question.Question; Author = question.Author; PostedTime = question.PostedTime; Views = question.Views; List<AnsClass> AnswersList = new List<AnsClass>(); AnsDB answersDB = new AnsDB(); AnswersList = answersDB.GetAnswers(QuestionID); if (AnswersList.Count == 0) { AnswersDiv.Visible = false; } List<AnsClass> SolutionsList = new List<AnsClass>(); SolutionsList = answersDB.GetSolutions(QuestionID); if (SolutionsList.Count == 0) { SolutionsDiv.Visible = false; } if (User.Identity.Name == Author) { Repeater2.DataSource = AnswersList; Repeater4.DataSource = SolutionsList; answersView.SetActiveView(postedUser); solutionsView.SetActiveView(creator); } else { Repeater1.DataSource = AnswersList; Repeater3.DataSource = SolutionsList; answersView.SetActiveView(allUsers); solutionsView.SetActiveView(all); } if (Membership.GetUser() != null) AddAnswerView.SetActiveView(LoggedUserView); else AddAnswerView.SetActiveView(NoUserView); ClickHere.NavigateUrl = @"~\Account\Login.aspx?ReturnUrl=" + Page.Request.RawUrl; Page.Title = question.Question; this.DataBind(); }