///////////////////////////////////////////////////////////////////////
public void Page_Load(Object sender, EventArgs e)
{
Util.do_not_cache(Response);
security = new Security();
security.check_security(HttpContext.Current, Security.ANY_USER_OK);
if (security.user.is_admin || security.user.can_search)
{
//
}
else
{
Response.Write("You are not allowed to use this page.");
Response.End();
}
titl.InnerText = Util.get_setting("AppTitle", "BugTracker.NET") + " - "
+ "search";
show_udf = (Util.get_setting("ShowUserDefinedBugAttribute", "1") == "1");
use_full_names = (Util.get_setting("UseFullNames", "0") == "1");
ds_custom_cols = Util.get_custom_columns();
dt_users = Util.get_related_users(security, false);
if (!IsPostBack)
{
load_drop_downs();
project_custom_dropdown1_label.Style["display"] = "none";
project_custom_dropdown1.Style["display"] = "none";
project_custom_dropdown2_label.Style["display"] = "none";
project_custom_dropdown2.Style["display"] = "none";
project_custom_dropdown3_label.Style["display"] = "none";
project_custom_dropdown3.Style["display"] = "none";
// are there any project dropdowns?
string sql = @"
select count(1)
from projects
where isnull(pj_enable_custom_dropdown1,0) = 1
or isnull(pj_enable_custom_dropdown2,0) = 1
or isnull(pj_enable_custom_dropdown3,0) = 1";
int projects_with_custom_dropdowns = (int)btnet.DbUtil.execute_scalar(sql);
if (projects_with_custom_dropdowns == 0)
{
project.AutoPostBack = false;
}
}
else
{
// get the project dropdowns
string sql = @"
select
pj_id,
isnull(pj_enable_custom_dropdown1,0) pj_enable_custom_dropdown1,
isnull(pj_enable_custom_dropdown2,0) pj_enable_custom_dropdown2,
isnull(pj_enable_custom_dropdown3,0) pj_enable_custom_dropdown3,
isnull(pj_custom_dropdown_label1,'') pj_custom_dropdown_label1,
isnull(pj_custom_dropdown_label2,'') pj_custom_dropdown_label2,
isnull(pj_custom_dropdown_label3,'') pj_custom_dropdown_label3,
isnull(pj_custom_dropdown_values1,'') pj_custom_dropdown_values1,
isnull(pj_custom_dropdown_values2,'') pj_custom_dropdown_values2,
isnull(pj_custom_dropdown_values3,'') pj_custom_dropdown_values3
from projects
where isnull(pj_enable_custom_dropdown1,0) = 1
or isnull(pj_enable_custom_dropdown2,0) = 1
or isnull(pj_enable_custom_dropdown3,0) = 1";
DataSet ds_projects = btnet.DbUtil.get_dataset(sql);
foreach (DataRow dr in ds_projects.Tables[0].Rows)
{
BtnetProject btnet_project = new BtnetProject();
ProjectDropdown dropdown;
dropdown = new ProjectDropdown();
dropdown.enabled = Convert.ToBoolean((int)dr["pj_enable_custom_dropdown1"]);
dropdown.label = (string)dr["pj_custom_dropdown_label1"];
dropdown.values = (string)dr["pj_custom_dropdown_values1"];
btnet_project.map_dropdowns[1] = dropdown;
dropdown = new ProjectDropdown();
dropdown.enabled = Convert.ToBoolean((int)dr["pj_enable_custom_dropdown2"]);
dropdown.label = (string)dr["pj_custom_dropdown_label2"];
dropdown.values = (string)dr["pj_custom_dropdown_values2"];
btnet_project.map_dropdowns[2] = dropdown;
dropdown = new ProjectDropdown();
dropdown.enabled = Convert.ToBoolean((int)dr["pj_enable_custom_dropdown3"]);
dropdown.label = (string)dr["pj_custom_dropdown_label3"];
dropdown.values = (string)dr["pj_custom_dropdown_values3"];
btnet_project.map_dropdowns[3] = dropdown;
map_projects[(int)dr["pj_id"]] = btnet_project;
}
// which button did the user hit?
if (project_changed.Value == "1" && project.AutoPostBack == true)
{
handle_project_custom_dropdowns();
}
else if (hit_submit_button.Value == "1")
{
handle_project_custom_dropdowns();
do_query();
}
else
{
dv = (DataView)Session["bugs"];
if (dv == null)
{
do_query();
}
call_sort_and_filter_buglist_dataview();
}
}
hit_submit_button.Value = "0";
project_changed.Value = "0";
if (security.user.is_admin || security.user.can_edit_sql)
{
}
else
{
visible_sql_label.Style["display"] = "none";
visible_sql_text.Style["display"] = "none";
}
}
///////////////////////////////////////////////////////////////////////
public void Page_Load(Object sender, EventArgs e)
{
Util.do_not_cache(Response);
security = new Security();
security.check_security(HttpContext.Current, Security.ANY_USER_OK);
titl.InnerText = Util.get_setting("AppTitle", "BugTracker.NET") + " - "
+ Util.get_setting("PluralBugLabel", "bugs");
if (!IsPostBack)
{
load_query_dropdown();
if (Session["just_did_text_search"] == null)
{
do_query();
}
else
{
Session["just_did_text_search"] = null;
dv = (DataView)Session["bugs"];
}
}
else
{
// posting back a query change?
// posting back a filter change?
// posting back a sort change?
if (actn.Value == "query")
{
qu_id_string = Convert.ToString(query.SelectedItem.Value);
reset_query_state();
do_query();
}
else
{
// sorting, paging, filtering, so don't go back to the database
dv = (DataView)Session["bugs"];
if (dv == null)
{
do_query();
}
else
{
if (actn.Value == "sort")
{
new_page.Value = "0";
}
}
}
}
select_query_in_dropdown();
call_sort_and_filter_buglist_dataview();
actn.Value = "";
}
///////////////////////////////////////////////////////////////////////
public void Page_Load(Object sender, EventArgs e)
{
Util.do_not_cache(Response);
security = new Security();
security.check_security(HttpContext.Current, Security.ANY_USER_OK);
if (security.user.is_admin || security.user.can_search)
{
//
}
else
{
Response.Write("You are not allowed to use this page.");
Response.End();
}
titl.InnerText = Util.get_setting("AppTitle", "BugTracker.NET") + " - "
+ "search";
show_udf = (Util.get_setting("ShowUserDefinedBugAttribute", "1") == "1");
use_full_names = (Util.get_setting("UseFullNames", "0") == "1");
ds_custom_cols = Util.get_custom_columns();
dt_users = Util.get_related_users(security, false);
if (!IsPostBack)
{
load_drop_downs();
project_custom_dropdown1_label.Style["display"] = "none";
project_custom_dropdown1.Style["display"] = "none";
project_custom_dropdown2_label.Style["display"] = "none";
project_custom_dropdown2.Style["display"] = "none";
project_custom_dropdown3_label.Style["display"] = "none";
project_custom_dropdown3.Style["display"] = "none";
// are there any project dropdowns?
string sql = @"
select count(1)
from projects
where isnull(pj_enable_custom_dropdown1,0) = 1
or isnull(pj_enable_custom_dropdown2,0) = 1
or isnull(pj_enable_custom_dropdown3,0) = 1";
int projects_with_custom_dropdowns = (int)btnet.DbUtil.execute_scalar(sql);
if (projects_with_custom_dropdowns == 0)
{
project.AutoPostBack = false;
}
}
else
{
// get the project dropdowns
string sql = @"
select
pj_id,
isnull(pj_enable_custom_dropdown1,0) pj_enable_custom_dropdown1,
isnull(pj_enable_custom_dropdown2,0) pj_enable_custom_dropdown2,
isnull(pj_enable_custom_dropdown3,0) pj_enable_custom_dropdown3,
isnull(pj_custom_dropdown_label1,'') pj_custom_dropdown_label1,
isnull(pj_custom_dropdown_label2,'') pj_custom_dropdown_label2,
isnull(pj_custom_dropdown_label3,'') pj_custom_dropdown_label3,
isnull(pj_custom_dropdown_values1,'') pj_custom_dropdown_values1,
isnull(pj_custom_dropdown_values2,'') pj_custom_dropdown_values2,
isnull(pj_custom_dropdown_values3,'') pj_custom_dropdown_values3
from projects
where isnull(pj_enable_custom_dropdown1,0) = 1
or isnull(pj_enable_custom_dropdown2,0) = 1
or isnull(pj_enable_custom_dropdown3,0) = 1";
DataSet ds_projects = btnet.DbUtil.get_dataset(sql);
foreach (DataRow dr in ds_projects.Tables[0].Rows)
{
BtnetProject btnet_project = new BtnetProject();
ProjectDropdown dropdown;
dropdown = new ProjectDropdown();
dropdown.enabled = Convert.ToBoolean((int)dr["pj_enable_custom_dropdown1"]);
dropdown.label = (string)dr["pj_custom_dropdown_label1"];
dropdown.values = (string)dr["pj_custom_dropdown_values1"];
btnet_project.map_dropdowns[1] = dropdown;
dropdown = new ProjectDropdown();
dropdown.enabled = Convert.ToBoolean((int)dr["pj_enable_custom_dropdown2"]);
dropdown.label = (string)dr["pj_custom_dropdown_label2"];
dropdown.values = (string)dr["pj_custom_dropdown_values2"];
btnet_project.map_dropdowns[2] = dropdown;
dropdown = new ProjectDropdown();
dropdown.enabled = Convert.ToBoolean((int)dr["pj_enable_custom_dropdown3"]);
dropdown.label = (string)dr["pj_custom_dropdown_label3"];
dropdown.values = (string)dr["pj_custom_dropdown_values3"];
btnet_project.map_dropdowns[3] = dropdown;
map_projects[(int)dr["pj_id"]] = btnet_project;
}
// which button did the user hit?
if (project_changed.Value == "1" && project.AutoPostBack == true)
{
handle_project_custom_dropdowns();
}
else if (hit_submit_button.Value == "1")
{
handle_project_custom_dropdowns();
do_query();
}
else
{
dv = (DataView)Session["bugs"];
if (dv == null)
{
do_query();
}
call_sort_and_filter_buglist_dataview();
}
}
hit_submit_button.Value = "0";
project_changed.Value = "0";
if (security.user.is_admin || security.user.can_edit_sql)
{
}
else
{
visible_sql_label.Style["display"] = "none";
visible_sql_text.Style["display"] = "none";
}
}
///////////////////////////////////////////////////////////////////////
public void Page_Load(Object sender, EventArgs e)
{
Util.do_not_cache(Response);
security = new Security();
security.check_security(HttpContext.Current, Security.ANY_USER_OK);
titl.InnerText = Util.get_setting("AppTitle", "BugTracker.NET") + " - "
+ Util.get_setting("PluralBugLabel", "bugs");
if (!IsPostBack)
{
load_query_dropdown();
if (Session["just_did_text_search"] == null)
{
do_query();
}
else
{
Session["just_did_text_search"] = null;
dv = (DataView)Session["bugs"];
}
}
else
{
// posting back a query change?
// posting back a filter change?
// posting back a sort change?
if (actn.Value == "query")
{
qu_id_string = Convert.ToString(query.SelectedItem.Value);
reset_query_state();
do_query();
}
else
{
// sorting, paging, filtering, so don't go back to the database
dv = (DataView)Session["bugs"];
if (dv == null)
{
do_query();
}
else
{
if (actn.Value == "sort")
{
new_page.Value = "0";
}
}
}
}
select_query_in_dropdown();
call_sort_and_filter_buglist_dataview();
actn.Value = "";
}