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