public void sortByDept(string column, string key)
{
SqlCommand cmd = new SqlCommand("SELECT dbo.Department.DeptName, dbo.AcademicAdviser.AAdviserId, dbo.AcademicAdviser.LName + ', ' + dbo.AcademicAdviser.FName + ' (' + dbo.AcademicAdviser.MName + ')' as [FullName], dbo.AcademicAdviser.Status, dbo.AcademicAdviser.DateRegistered FROM dbo.AcademicAdviser INNER JOIN dbo.Department ON dbo.AcademicAdviser.DeptId = dbo.Department.DeptId WHERE Status = 'ACTIVE' and " + column + " LIKE '%" + key + "%'");
ListViewAAdvisers.DataSource = Class2.getDataSet(cmd);
ListViewAAdvisers.DataBind();
}
public void populateLView()
{
SqlCommand cmd = new SqlCommand("SELECT dbo.Department.DeptName, dbo.AcademicAdviser.AAdviserId, dbo.AcademicAdviser.LName + ', ' + dbo.AcademicAdviser.FName + ' (' + dbo.AcademicAdviser.MName + ')' as [FullName], dbo.AcademicAdviser.Status, dbo.AcademicAdviser.DateRegistered FROM dbo.AcademicAdviser INNER JOIN dbo.Department ON dbo.AcademicAdviser.DeptId = dbo.Department.DeptId");
ListViewAAdvisers.DataSource = Class2.getDataSet(cmd);
ListViewAAdvisers.DataBind();
}
public void sortByDept(string column, string key)
{
string act;
if (Session["AArchive"] == "NO")
{
act = "ACTIVE";
}
else
{
act = "INACTIVE";
}
SqlCommand cmd = new SqlCommand("SELECT dbo.Department.DeptName, dbo.AcademicAdviser.AAdviserId, dbo.AcademicAdviser.LName + ', ' + dbo.AcademicAdviser.FName + ' (' + dbo.AcademicAdviser.MName + ')' as [FullName], dbo.AcademicAdviser.Status, dbo.AcademicAdviser.DateRegistered FROM dbo.AcademicAdviser INNER JOIN dbo.Department ON dbo.AcademicAdviser.DeptId = dbo.Department.DeptId WHERE Status = '" + act + "' and " + column + " LIKE '%" + key + "%'");
ListViewAAdvisers.DataSource = Class2.getDataSet(cmd);
ListViewAAdvisers.DataBind();
}
