protected void showPHistory(object sender, EventArgs e)
{
Response.Redirect("StudentMyAppointment.aspx");
ListViewPAdvising.Visible = true;
ListViewAAdvising.Visible = false;
SqlCommand cmd = new SqlCommand("SELECT PConsultationId,Status,CONVERT(varchar(10), dbo.PeerAdviserConsultations.ConsultationDate, 20) as ConsultationDate, dbo.PeerAdviserConsultations.ConsultationType, dbo.PeerAdviserConsultations.CourseCode, CONVERT(varchar(10), dbo.PeerAdviserConsultations.TimeStart, dbo.PeerAdviserConsultations.TimeEnd, dbo.PeerAdviserConsultations.PAdviserId as PeerAdvisers FROM dbo.PeerAdviserConsultations INNER JOIN dbo.Student ON dbo.PeerAdviserConsultations.StudentNumber = dbo.Student.StudentNumber INNER JOIN dbo.[User] ON dbo.Student.UserId = dbo.[User].UserId WHERE STATUS <> 'CANCELLED' and NOT EXISTS (SELECT * FROM [dbo].[ConsultationEvaluation] WHERE dbo.PeerAdviserConsultations.PConsultationId = dbo.[ConsultationEvaluation].PConsultationId) and dbo.[User].UserId = " + Session["UserId"] + "ORDER BY ConsultationDate desc;");
ListViewPAdvising.DataSource = Class2.getDataSet(cmd);
ListViewPAdvising.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
checkUsertype.filter("STUDENT", Session["UserType"].ToString());
SqlCommand cmd = new SqlCommand("SELECT PConsultationId,Status,CONVERT(varchar(10), dbo.PeerAdviserConsultations.ConsultationDate, 20) as ConsultationDate, dbo.PeerAdviserConsultations.ConsultationType, dbo.PeerAdviserConsultations.CourseCode, dbo.PeerAdviserConsultations.TimeStart, dbo.PeerAdviserConsultations.TimeEnd, dbo.PeerAdviserConsultations.PAdviserId as PeerAdvisers FROM dbo.PeerAdviserConsultations INNER JOIN dbo.Student ON dbo.PeerAdviserConsultations.StudentNumber = dbo.Student.StudentNumber INNER JOIN dbo.[User] ON dbo.Student.UserId = dbo.[User].UserId WHERE STATUS <> 'CANCELLED' and STATUS <> 'DONE' and NOT EXISTS (SELECT * FROM [dbo].[ConsultationEvaluation] WHERE dbo.PeerAdviserConsultations.PConsultationId = dbo.[ConsultationEvaluation].PConsultationId) and dbo.[User].UserId = " + Session["UserId"] + " ORDER BY ConsultationDate desc;");
ListViewPAdvising.DataSource = Class2.getDataSet(cmd);
ListViewPAdvising.DataBind();
if (Request.QueryString["sortby"] == "1")
{
sortByAcad();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
checkUsertype.filter("STUDENT", Session["UserType"].ToString());
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('You have been inactive for too long. Please relogin.');window.location ='Out.aspx';", true);
}
SqlCommand cmd = new SqlCommand("SELECT PConsultationId,Status,CONVERT(varchar(10), dbo.PeerAdviserConsultations.ConsultationDate, 20) as ConsultationDate, dbo.PeerAdviserConsultations.ConsultationType, dbo.PeerAdviserConsultations.CourseCode, dbo.PeerAdviserConsultations.TimeStart, dbo.PeerAdviserConsultations.TimeEnd, dbo.PeerAdviserConsultations.PAdviserId as PeerAdvisers FROM dbo.PeerAdviserConsultations INNER JOIN dbo.Student ON dbo.PeerAdviserConsultations.StudentNumber = dbo.Student.StudentNumber INNER JOIN dbo.[User] ON dbo.Student.UserId = dbo.[User].UserId WHERE STATUS = 'PENDING' and NOT EXISTS (SELECT * FROM [dbo].[ConsultationEvaluation] WHERE dbo.PeerAdviserConsultations.PConsultationId = dbo.[ConsultationEvaluation].PConsultationId) and dbo.[User].UserId = " + Session["UserId"] + " ORDER BY ConsultationDate desc;");
ListViewPAdvising.DataSource = Class2.getDataSet(cmd);
ListViewPAdvising.DataBind();
if (Request.QueryString["sortby"] == "1")
{
sortByAcad();
}
}
