protected void Page_Load(object sender, EventArgs e)
{
try
{
checkUsertype.filter("STAFF", 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);
}
if (!IsPostBack)
{
try
{
SqlCommand cmd = new SqlCommand("SELECT StaffId, LName + ', ' + FName + ' (' + MName + ')' as FullName, Status, DateRegistered FROM dbo.Staff WHERE STATUS = 'ACTIVE' AND UserId <> " + Session["UserId"]);
ListViewStaff.DataSource = Class2.getDataSet(cmd);
ListViewStaff.DataBind();
}
catch (Exception ex)
{
}
Session["SArchive"] = "NO";
}
}
protected void Page_Load(object sender, EventArgs e)
{
checkUsertype.filter("STAFF", Session["UserType"].ToString());
SqlCommand cmd = new SqlCommand("SELECT StaffId, LName + ', ' + FName + ' (' + MName + ')' as FullName, Status, DateRegistered FROM dbo.Staff WHERE STATUS = 'ACTIVE'");
ListViewStaff.DataSource = Class2.getDataSet(cmd);
ListViewStaff.DataBind();
}
protected void showArchive(object sender, EventArgs e)
{
if (Session["SArchive"] == "NO")
{
SqlCommand cmd = new SqlCommand("SELECT StaffId, LName + ', ' + FName + ' (' + MName + ')' as FullName, Status, DateRegistered FROM dbo.Staff WHERE STATUS = 'INACTIVE' AND UserId <> " + Session["UserId"]);
ListViewStaff.DataSource = Class2.getDataSet(cmd);
ListViewStaff.DataBind();
Session["SArchive"] = "YES";
archive.Title = "View Active";
rem.ToolTip = "Move to Active";
}
else
{
SqlCommand cmd2 = new SqlCommand("SELECT StaffId, LName + ', ' + FName + ' (' + MName + ')' as FullName, Status, DateRegistered FROM dbo.Staff WHERE STATUS = 'ACTIVE' AND UserId <> " + Session["UserId"]);
ListViewStaff.DataSource = Class2.getDataSet(cmd2);
ListViewStaff.DataBind();
Session["SArchive"] = "NO";
archive.Title = "View Archive";
rem.ToolTip = "Move to Archive";
}
}
