Copyright 2002-2005 Corey Trager
Distributed under the terms of the GNU General Public License
-->
DataSet ds;
DbUtil dbutil;
Security security;
void Page_Load(Object sender, EventArgs e)
{
Util.do_not_cache(Response);
dbutil = new DbUtil();
security = new Security();
security.check_security(dbutil, Request, Response, Security.MUST_BE_ADMIN);
title.InnerText = Util.get_setting("AppTitle","BugTracker.NET") + " - "
+ "projects";
ds = dbutil.get_dataset(
@"select pj_id [id],
pj_name [project],
case when pj_active = 1 then 'Y' else 'N' end [active],
us_username [default user],
case when isnull(pj_auto_assign_default_user,0) = 1 then 'Y' else 'N' end [auto assigndefault user],
case when isnull(pj_auto_subscribe_default_user,0) = 1 then 'Y' else 'N' end [auto subscribedefault user],
case when isnull(pj_enable_pop3,0) = 1 then 'Y' else 'N' end [enable pop3bug entry],
pj_pop3_username [pop3 username],
pj_pop3_email_from [from email addressl],
'permissions' [per userpermissions],
pj_id [hidden]
from projects
left outer join users on us_id = pj_default_user
order by pj_name");
}
void Page_Unload(Object sender, EventArgs e)
{
if (dbutil != null) {dbutil.close();}
}
btnet projects
add new project
if (ds.Tables[0].Rows.Count > 0)
{
SortableHtmlTable.create_from_dataset(
Response, ds, "edit_project.aspx?id=", "delete_project.aspx?id=", false);
}
else
{
Response.Write ("No projects in the database.");
}
%>
