<%@ Page language="C#"%>
<!--
Copyright 2002-2008 Corey Trager
Distributed under the terms of the GNU General Public License
-->
<!-- #include file = "inc.aspx" -->
<script language="C#" runat="server">
String sql;
DbUtil dbutil;
Security security;
void Page_Init (object sender, EventArgs e) {ViewStateUserKey = Session.SessionID;}
///////////////////////////////////////////////////////////////////////
void Page_Load(Object sender, EventArgs e)
{
Util.do_not_cache(Response);
dbutil = new DbUtil();
security = new Security();
security.check_security(dbutil, HttpContext.Current, Security.MUST_BE_ADMIN);
if (IsPostBack)
{
// do delete here
sql = @"delete statuses where st_id = $1";
sql = sql.Replace("$1", row_id.Value);
dbutil.execute_nonquery(sql);
Server.Transfer ("statuses.aspx");
}
else
{
titl.InnerText = Util.get_setting("AppTitle","BugTracker.NET") + " - "
+ "delete status";
string id = Util.sanitize_integer(Request["id"]);
sql = @"declare @cnt int
select @cnt = count(1) from bugs where bg_status = $1
select st_name, @cnt [cnt] from statuses where st_id = $1";
sql = sql.Replace("$1", id);
DataRow dr = dbutil.get_datarow(sql);
if ((int) dr["cnt"] > 0)
{
Response.Write ("You can't delete status \""
+ Convert.ToString(dr["st_name"])
+ "\" because some bugs still reference it.");
Response.End();
}
else
{
confirm_href.InnerText = "confirm delete of \""
+ Convert.ToString(dr["st_name"])
+ "\"";
row_id.Value = id;
}
}
}
</script>
<html>
<head>
<title id="titl" runat="server">btnet delete status</title>
<link rel="StyleSheet" href="btnet.css" type="text/css">
</head>
<body>
<% security.write_menu(Response, "admin"); %>
<p>
<div class=align>
<p> </p>
<a href=statuses.aspx>back to statuses</a>
<p>or<p>
<script>
function submit_form()
{
var frm = document.getElementById("frm");
frm.submit();
return true;
}
</script>
<form runat="server" id="frm">
<a id="confirm_href" runat="server" href="javascript: submit_form()"></a>
<input type="hidden" id="row_id" runat="server">
</form>
</div>
<% Response.Write(Application["custom_footer"]); %></body>
</html>