void Login_login_Click(Object Src, EventArgs E)
{
if (Login_logged)
{
// Login Logout begin
// Login OnLogout Event begin
// Login OnLogout Event end
Login_logged = false;
Session["UserID"] = 0;
Session["UserRights"] = 0;
Login_Show();
// Login Logout end
}
else
{
// Login Login begin
int iPassed = Convert.ToInt32(Utility.Dlookup("users", "count(*)", "login ='******' and pass='******'"));
if (iPassed > 0)
{
// Login OnLogin Event begin
// Login OnLogin Event end
Login_message.Visible = false;
Session["UserID"] = Convert.ToInt32(Utility.Dlookup("users", "user_id", "login ='******' and pass='******'"));
Login_logged = true;
Session["UserRights"] = Convert.ToInt32(Utility.Dlookup("users", "security_level", "login ='******' and pass='******'"));
Session["Supervisor"] = Convert.ToInt32(Utility.Dlookup("users", "supervisor_id", "login ='******' and pass='******'"));
string sQueryString = Utility.GetParam("querystring");
string sPage = Utility.GetParam("ret_page");
if (!sPage.Equals(Request.ServerVariables["SCRIPT_NAME"]) && sPage.Length > 0)
{
Response.Redirect(sPage + "?" + sQueryString);
}
else
{
Response.Redirect(Login_FormAction);
}
}
else
{
Login_message.Visible = true;
}
// Login Login end
}
}
//===============================
// IssueExport Show begin
protected void Page_Load(object sender, EventArgs e)
{
Utility = new CCUtility(this);
//===============================
// IssueExport Open Event begin
//No Header or Footer needed
((UserControl)Page.FindControl("Header")).Visible = false;
((UserControl)Page.FindControl("Footer")).Visible = false;
this.EnableViewState = false;
Response.ContentType = "application/vnd.ms-excel";
//Change HTML header to specify Excel's MIME content type
// IssueExport Open Event end
//===============================
//
//===============================
// IssueExport PageSecurity begin
// IssueExport PageSecurity end
//===============================
if (!IsPostBack)
{
p_Issues_issue_id.Value = Utility.GetParam("issue_id");
Page_Show(sender, e);
}
}
//===============================
// IssueNew Show begin
protected void Page_Load(object sender, EventArgs e)
{
Utility = new CCUtility(this);
//===============================
// IssueNew Open Event begin
HtmlInputFile FileUpload = new HtmlInputFile();
Issues_Field1.Controls.Add(FileUpload);
ControlCollection myCol = this.Controls;
for (int i = 0; i < myCol.Count; i++)
{
if (myCol[i] is HtmlForm)
{
((HtmlForm)myCol[i]).Enctype = "multipart/form-data";
}
}
// IssueNew Open Event end
//===============================
//
//===============================
// IssueNew PageSecurity begin
Utility.CheckSecurity(1);
// IssueNew PageSecurity end
//===============================
if (!IsPostBack)
{
p_Issues_issue_id.Value = Utility.GetParam("issue_id");
Page_Show(sender, e);
}
}
//===============================
// StatusList Show begin
protected void Page_Load(object sender, EventArgs e)
{
Utility = new CCUtility(this);
//===============================
// StatusList Open Event begin
// StatusList Open Event end
//===============================
//===============================
// StatusList OpenAnyPage Event begin
// StatusList OpenAnyPage Event end
//===============================
//
//===============================
// StatusList PageSecurity begin
Utility.CheckSecurity(2);
// StatusList PageSecurity end
//===============================
if (!IsPostBack)
{
p_StatusList_status_id.Value = Utility.GetParam("status_id");
Page_Show(sender, e);
}
}
//===============================
// ResponseMaint Show begin
protected void Page_Load(object sender, EventArgs e)
{
Utility = new CCUtility(this);
//===============================
// ResponseMaint Open Event begin
// ResponseMaint Open Event end
//===============================
//===============================
// ResponseMaint OpenAnyPage Event begin
// ResponseMaint OpenAnyPage Event end
//===============================
//
//===============================
// ResponseMaint PageSecurity begin
Utility.CheckSecurity(3);
// ResponseMaint PageSecurity end
//===============================
if (!IsPostBack)
{
p_Response_response_id.Value = Utility.GetParam("response_id");
Page_Show(sender, e);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
Utility = new CCUtility(this);
CvsFiles = new ViewCvs.ViewCvs();
Utility.CheckSecurity(1);
if (!IsPostBack)
{
int iIssueID = Convert.ToInt32(Utility.GetParam("Issue_ID"));
Label1.Text = "Files for Issue: " + iIssueID.ToString();
try
{
CvsFiles.OpenDB();
ds = CvsFiles.GetIssueFiles(iIssueID);
//test
// DataGrid1.DataSource = ds;
// DataGrid1.AllowSorting = true;
//
// DataGrid1.DataBind();
dvFiles.Table = ds.Tables[0];
if (dvFiles.Count > 0)
{
Repeater.DataSource = dvFiles;
Repeater.Visible = true;
Repeater.DataBind();
}
else
{
Label1.Text += " No Files!";
}
// DataGrid1.DataBind();
// ds.Clear();
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
finally
{
CvsFiles.CloseDB();
}
}
}
bool Response_update_Click(Object Src, EventArgs E)
{
string sWhere = "";
string sSQL = "";
bool bResult = Response_Validate();
if (bResult)
{
if (p_Response_response_id.Value.Length > 0)
{
sWhere = sWhere + "response_id=" + CCUtility.ToSQL(p_Response_response_id.Value, CCUtility.FIELD_TYPE_Number);
}
// Response Check Event begin
// Response Check Event end
if (bResult)
{
sSQL = "update responses set " +
"[user_id]=" + CCUtility.ToSQL(Utility.GetParam("Response_user_id"), CCUtility.FIELD_TYPE_Number) +
",[date_response]=" + CCUtility.ToSQL(Utility.GetParam("Response_date_response"), CCUtility.FIELD_TYPE_Date) +
",[response]=" + CCUtility.ToSQL(Utility.GetParam("Response_response"), CCUtility.FIELD_TYPE_Text) +
",[assigned_to]=" + CCUtility.ToSQL(Utility.GetParam("Response_assigned_to"), CCUtility.FIELD_TYPE_Number) +
",[qaassigned_to]=" + CCUtility.ToSQL(Utility.GetParam("Response_qaassigned_to"), CCUtility.FIELD_TYPE_Number) +
",[priority_id]=" + CCUtility.ToSQL(Utility.GetParam("Response_priority_id"), CCUtility.FIELD_TYPE_Number) +
",[status_id]=" + CCUtility.ToSQL(Utility.GetParam("Response_status_id"), CCUtility.FIELD_TYPE_Number);
sSQL = sSQL + " where " + sWhere;
// Response Update Event begin
// Response Update Event end
Response_BeforeSQLExecute(sSQL, "Update");
OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Response_ValidationSummary.Text += e.Message;
Response_ValidationSummary.Visible = true;
return(false);
}
}
if (bResult)
{
// Response AfterUpdate Event begin
// Response AfterUpdate Event end
}
}
return(bResult);
}
// VersionMaint Action begin
bool VersionMaint_insert_Click(Object Src, EventArgs E)
{
string sSQL = "";
bool bResult = VersionMaint_Validate();
// VersionMaint Check Event begin
// VersionMaint Check Event end
if (bResult)
{
string p2_version = CCUtility.ToSQL(Utility.GetParam("VersionMaint_version"), CCUtility.FIELD_TYPE_Text);
// VersionMaint Insert Event begin
// VersionMaint Insert Event end
sSQL = "insert into versions (" +
"version)" +
" values (" +
p2_version + ")";
VersionMaint_BeforeSQLExecute(sSQL, "Insert");
OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
VersionMaint_ValidationSummary.Text += e.Message;
VersionMaint_ValidationSummary.Visible = true;
return(false);
}
// VersionMaint AfterInsert Event begin
// VersionMaint AfterInsert Event end
}
return(bResult);
}
//===============================
// Settings Show begin
protected void Page_Load(object sender, EventArgs e)
{
Utility = new CCUtility(this);
//===============================
// Settings Open Event begin
Settings_settings_id.Value = "1";
// Settings Open Event end
//===============================
//
//===============================
// Settings PageSecurity begin
Utility.CheckSecurity(3);
// Settings PageSecurity end
//===============================
if (!IsPostBack)
{
p_Settings_settings_id.Value = Utility.GetParam("settings_id");
Page_Show(sender, e);
}
}
public void Issues_Open(ref string sWhere, ref string sOrder)
{
// Issues Open Event begin
//Show Status of Shown Issues
string param_status = Utility.GetParam("status_id");
string param_notstatus = Utility.GetParam("notstatus_id");
if (param_notstatus == "0")
{
param_notstatus = "";
}
string issue_look = "", issue_view = "";
if (param_notstatus.Length > 0)
{
issue_look = Utility.Dlookup("statuses", "status", "status_id=" + param_notstatus);
issue_view = "Issues that are not " + issue_look;
}
if (param_status.Length > 0)
{
issue_look = Utility.Dlookup("statuses", "status", "status_id in (" + param_status + ")");
issue_view = issue_look + " Issues";
}
if (param_status == "" && param_notstatus == "")
{
issue_view = "All Issues";
}
if (sOrder.IndexOf("date_modified") != -1)
{
issue_view = issue_view + "<br><font size=-1>(sorted by Last Update Date, descending)</font>";
}
((Label)Page.FindControl("IssuesForm_Title")).Text = issue_view;
// Issues Open Event end
}
ICollection StatusList_CreateDataSource()
{
// StatusList Show begin
StatusList_sSQL = "";
StatusList_sCountSQL = "";
string sWhere = "", sOrder = "";
bool HasParam = false;
//-------------------------------
// Build ORDER BY statement
//-------------------------------
sOrder = " order by s.status_id Asc";
if (Utility.GetParam("FormStatusList_Sorting").Length > 0 && !IsPostBack)
{
ViewState["SortColumn"] = Utility.GetParam("FormStatusList_Sorting");
ViewState["SortDir"] = "ASC";
}
if (ViewState["SortColumn"] != null)
{
sOrder = " ORDER BY " + ViewState["SortColumn"].ToString() + " " + ViewState["SortDir"].ToString();
}
System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary();
//-------------------------------
// Build base SQL statement
//-------------------------------
StatusList_sSQL = "select [s].[status] as s_status, " +
"[s].[status_id] as s_status_id " +
" from [statuses] s ";
//-------------------------------
//-------------------------------
//-------------------------------
//-------------------------------
// Assemble full SQL statement
//-------------------------------
StatusList_sSQL = StatusList_sSQL + sWhere + sOrder;
if (StatusList_sCountSQL.Length == 0)
{
int iTmpI = StatusList_sSQL.ToLower().IndexOf("select ");
int iTmpJ = StatusList_sSQL.ToLower().LastIndexOf(" from ") - 1;
StatusList_sCountSQL = StatusList_sSQL.Replace(StatusList_sSQL.Substring(iTmpI + 7, iTmpJ - 6), " count(*) ");
iTmpI = StatusList_sCountSQL.ToLower().IndexOf(" order by");
if (iTmpI > 1)
{
StatusList_sCountSQL = StatusList_sCountSQL.Substring(0, iTmpI);
}
}
//-------------------------------
OleDbDataAdapter command = new OleDbDataAdapter(StatusList_sSQL, Utility.Connection);
DataSet ds = new DataSet();
command.Fill(ds, (i_StatusList_curpage - 1) * StatusList_PAGENUM, StatusList_PAGENUM, "StatusList");
OleDbCommand ccommand = new OleDbCommand(StatusList_sCountSQL, Utility.Connection);
int PageTemp = (int)ccommand.ExecuteScalar();
StatusList_Pager.MaxPage = (PageTemp % StatusList_PAGENUM) > 0?(int)(PageTemp / StatusList_PAGENUM) + 1:(int)(PageTemp / StatusList_PAGENUM);
bool AllowScroller = StatusList_Pager.MaxPage == 1?false:true;
DataView Source;
Source = new DataView(ds.Tables[0]);
if (ds.Tables[0].Rows.Count == 0)
{
StatusList_no_records.Visible = true;
AllowScroller = false;
}
else
{
StatusList_no_records.Visible = false;
AllowScroller = AllowScroller && true;
}
StatusList_Pager.Visible = AllowScroller;
return(Source);
// StatusList Show end
}
bool Issue_update_Click(Object Src, EventArgs E)
{
string sWhere = "";
string sSQL = "";
bool bResult = Issue_Validate();
if (bResult)
{
if (p_Issue_issue_id.Value.Length > 0)
{
sWhere = sWhere + "issue_id=" + CCUtility.ToSQL(p_Issue_issue_id.Value, CCUtility.FIELD_TYPE_Number);
}
// Issue Check Event begin
// Issue Check Event end
if (bResult)
{
sSQL = "update issues set " +
"[issue_name]=" + CCUtility.ToSQL(Utility.GetParam("Issue_issue_name"), CCUtility.FIELD_TYPE_Text) +
",[issue_desc]=" + CCUtility.ToSQL(Utility.GetParam("Issue_issue_desc"), CCUtility.FIELD_TYPE_Text) +
",[user_id]=" + CCUtility.ToSQL(Utility.GetParam("Issue_user_id"), CCUtility.FIELD_TYPE_Number) +
",[modified_by]=" + CCUtility.ToSQL(Utility.GetParam("Issue_modified_by"), CCUtility.FIELD_TYPE_Number) +
",[date_submitted]=" + CCUtility.ToSQL(Utility.GetParam("Issue_date_submitted"), CCUtility.FIELD_TYPE_Date) +
",[bugversion]=" + CCUtility.ToSQL(Utility.GetParam("Issue_bugversion"), CCUtility.FIELD_TYPE_Text) +
",[version]=" + CCUtility.ToSQL(Utility.GetParam("Issue_version"), CCUtility.FIELD_TYPE_Text) +
",[assigned_to_orig]=" + CCUtility.ToSQL(Utility.GetParam("Issue_assigned_to_orig"), CCUtility.FIELD_TYPE_Number) +
",[assigned_to]=" + CCUtility.ToSQL(Utility.GetParam("Issue_assigned_to"), CCUtility.FIELD_TYPE_Number) +
",[priority_id]=" + CCUtility.ToSQL(Utility.GetParam("Issue_priority_id"), CCUtility.FIELD_TYPE_Number) +
",[status_id]=" + CCUtility.ToSQL(Utility.GetParam("Issue_status_id"), CCUtility.FIELD_TYPE_Number) +
",[qastatus_id]=" + CCUtility.ToSQL(Utility.GetParam("Issue_qastatus_id"), CCUtility.FIELD_TYPE_Number) +
",[screen]=" + CCUtility.ToSQL(Utility.GetParam("Issue_screen"), CCUtility.FIELD_TYPE_Text) +
",[dev_issue_number]=" + CCUtility.ToSQL(Utility.GetParam("Issue_dev_issue_number"), CCUtility.FIELD_TYPE_Text) +
",[its_number]=" + CCUtility.ToSQL(Utility.GetParam("Issue_its_number"), CCUtility.FIELD_TYPE_Text) +
",[product_id]=" + CCUtility.ToSQL(Utility.GetParam("Issue_product_id"), CCUtility.FIELD_TYPE_Number) +
",[steps_to_recreate]=" + CCUtility.ToSQL(Utility.GetParam("Issue_steps_to_recreate"), CCUtility.FIELD_TYPE_Text);
sSQL = sSQL + " where " + sWhere;
// Issue Update Event begin
// Issue Update Event end
Issue_BeforeSQLExecute(sSQL, "Update");
OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Issue_ValidationSummary.Text += e.Message;
Issue_ValidationSummary.Visible = true;
return(false);
}
}
if (bResult)
{
// Issue AfterUpdate Event begin
// Issue AfterUpdate Event end
}
}
return(bResult);
}
// User Action begin
bool User_insert_Click(Object Src, EventArgs E)
{
string sSQL = "";
bool bResult = User_Validate();
// User Check Event begin
// User Check Event end
if (bResult)
{
string p2_login = CCUtility.ToSQL(Utility.GetParam("User_login"), CCUtility.FIELD_TYPE_Text);
string p2_pass = CCUtility.ToSQL(Utility.GetParam("User_pass"), CCUtility.FIELD_TYPE_Text);
string p2_security_level = CCUtility.ToSQL(Utility.GetParam("User_security_level"), CCUtility.FIELD_TYPE_Number);
string p2_user_name = CCUtility.ToSQL(Utility.GetParam("User_user_name"), CCUtility.FIELD_TYPE_Text);
string p2_email = CCUtility.ToSQL(Utility.GetParam("User_email"), CCUtility.FIELD_TYPE_Text);
string c1_allow_upload = CCUtility.getCheckBoxValue(Utility.GetParam("User_allow_upload"), "1", "0", CCUtility.FIELD_TYPE_Number);
string c1_notify_new = CCUtility.getCheckBoxValue(Utility.GetParam("User_notify_new"), "1", "0", CCUtility.FIELD_TYPE_Number);
string c1_notify_original = CCUtility.getCheckBoxValue(Utility.GetParam("User_notify_original"), "1", "0", CCUtility.FIELD_TYPE_Number);
string c1_notify_reassignment = CCUtility.getCheckBoxValue(Utility.GetParam("User_notify_reassignment"), "1", "0", CCUtility.FIELD_TYPE_Number);
string p2_supervisor_id = CCUtility.ToSQL(Utility.GetParam("User_supervisor"), CCUtility.FIELD_TYPE_Number);
// User Insert Event begin
// User Insert Event end
sSQL = "insert into users (" +
"login," +
"pass," +
"security_level," +
"user_name," +
"email," +
"allow_upload," +
"notify_new," +
"notify_original," +
"notify_reassignment," +
"supervisor_id)" +
" values (" +
p2_login + "," +
p2_pass + "," +
p2_security_level + "," +
p2_user_name + "," +
p2_email + "," +
c1_allow_upload + "," +
c1_notify_new + "," +
c1_notify_original + "," +
c1_notify_reassignment + "," +
p2_supervisor_id + ")";
User_BeforeSQLExecute(sSQL, "Insert");
OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
User_ValidationSummary.Text += e.Message;
User_ValidationSummary.Visible = true;
return(false);
}
// User AfterInsert Event begin
// User AfterInsert Event end
}
return(bResult);
}
ICollection Issues_CreateDataSource()
{
// Issues Show begin
Issues_sSQL = "";
Issues_sCountSQL = "";
string sWhere = "", sOrder = "";
bool HasParam = false;
//-------------------------------
// Build ORDER BY statement
//-------------------------------
if (Utility.GetParam("FormIssues_Sorting").Length > 0 && !IsPostBack)
{
ViewState["SortColumn"] = Utility.GetParam("FormIssues_Sorting");
ViewState["SortDir"] = "ASC";
}
if (ViewState["SortColumn"] != null)
{
sOrder = " ORDER BY " + ViewState["SortColumn"].ToString() + " " + ViewState["SortDir"].ToString();
}
//-------------------------------
// Build WHERE statement
//-------------------------------
System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary();
if (!Params.ContainsKey("assigned_to"))
{
string temp = Utility.GetParam("assigned_to");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number);
}
else
{
temp = "";
}
Params.Add("assigned_to", temp);
}
if (!Params.ContainsKey("issue_name"))
{
string temp = Utility.GetParam("issue_name");
Params.Add("issue_name", temp);
}
if (!Params.ContainsKey("notstatus_id"))
{
string temp = Utility.GetParam("notstatus_id");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number);
}
else
{
temp = "";
}
Params.Add("notstatus_id", temp);
}
if (!Params.ContainsKey("notqastatus_id"))
{
string temp = Utility.GetParam("notqastatus_id");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number);
}
else
{
temp = "";
}
Params.Add("notqastatus_id", temp);
}
if (!Params.ContainsKey("priority_id"))
{
string temp = Utility.GetParam("priority_id");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number);
}
else
{
temp = "";
}
Params.Add("priority_id", temp);
}
if (!Params.ContainsKey("status_id"))
{
string temp = Utility.GetParam("status_id");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number);
}
else
{
temp = "";
}
Params.Add("status_id", temp);
}
if (!Params.ContainsKey("qastatus_id"))
{
string temp = Utility.GetParam("qastatus_id");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number);
}
else
{
temp = "";
}
Params.Add("qastatus_id", temp);
}
if (Params["assigned_to"].Length > 0)
{
HasParam = true;
sWhere += "i.[assigned_to]=" + Params["assigned_to"];
}
if (Params["issue_name"].Length > 0)
{
if (sWhere.Length > 0)
{
sWhere += " and ";
}
HasParam = true;
sWhere += "i.[issue_name] like '%" + Params["issue_name"].Replace("'", "''") + "%'";
}
if (Params["notstatus_id"].Length > 0)
{
if (sWhere.Length > 0)
{
sWhere += " and ";
}
HasParam = true;
sWhere += "i.[status_id]<>" + Params["notstatus_id"];
}
if (Params["notqastatus_id"].Length > 0)
{
if (sWhere.Length > 0)
{
sWhere += " and ";
}
HasParam = true;
sWhere += "i.[qastatus_id]<>" + Params["notqastatus_id"];
}
if (Params["priority_id"].Length > 0)
{
if (sWhere.Length > 0)
{
sWhere += " and ";
}
HasParam = true;
sWhere += "i.[priority_id]=" + Params["priority_id"];
}
if (Params["status_id"].Length > 0)
{
if (sWhere.Length > 0)
{
sWhere += " and ";
}
HasParam = true;
sWhere += "i.[status_id]=" + Params["status_id"];
}
if (Params["qastatus_id"].Length > 0)
{
if (sWhere.Length > 0)
{
sWhere += " and ";
}
HasParam = true;
sWhere += "i.[qastatus_id]=" + Params["qastatus_id"];
}
if (HasParam)
{
sWhere = " WHERE (" + sWhere + ")";
}
//-------------------------------
// Build base SQL statement
//-------------------------------
Issues_sSQL = "select [i].[assigned_to] as i_assigned_to, " +
"[i].[date_modified] as i_date_modified, " +
"[i].[date_resolved] as i_date_resolved, " +
"[i].[date_submitted] as i_date_submitted, " +
"[i].[issue_id] as i_issue_id, " +
"[i].[issue_name] as i_issue_name, " +
"[i].[dev_issue_number] as i_dev_issue_number, " +
"[i].[priority_id] as i_priority_id, " +
"[i].[status_id] as i_status_id, " +
"[s].[status_id] as s_status_id, " +
"[s].[status] as s_status, " +
"[i].[qastatus_id] as i_qastatus_id, " +
"[qs].[qastatus_id] as qs_qastatus_id, " +
"[qs].[qastatus] as qs_qastatus, " +
"[u].[user_id] as u_user_id, " +
"[u].[user_name] as u_user_name " +
" from ((([issues] i left join [statuses] s on [s].[status_id]=i.[status_id]) left join [qastatuses] qs on [qs].[qastatus_id]=i.[qastatus_id]) inner join [users] u on [u].[user_id]=i.[assigned_to]) ";
//-------------------------------
//-------------------------------
//-------------------------------
//-------------------------------
// Assemble full SQL statement
//-------------------------------
Issues_sSQL = Issues_sSQL + sWhere + sOrder;
if (Issues_sCountSQL.Length == 0)
{
int iTmpI = Issues_sSQL.ToLower().IndexOf("select ");
int iTmpJ = Issues_sSQL.ToLower().LastIndexOf(" from ") - 1;
Issues_sCountSQL = Issues_sSQL.Replace(Issues_sSQL.Substring(iTmpI + 7, iTmpJ - 6), " count(*) ");
iTmpI = Issues_sCountSQL.ToLower().IndexOf(" order by");
if (iTmpI > 1)
{
Issues_sCountSQL = Issues_sCountSQL.Substring(0, iTmpI);
}
}
//-------------------------------
OleDbDataAdapter command = new OleDbDataAdapter(Issues_sSQL, Utility.Connection);
DataSet ds = new DataSet();
command.Fill(ds, (i_Issues_curpage - 1) * Issues_PAGENUM, Issues_PAGENUM, "Issues");
OleDbCommand ccommand = new OleDbCommand(Issues_sCountSQL, Utility.Connection);
int PageTemp = (int)ccommand.ExecuteScalar();
Issues_Pager.MaxPage = (PageTemp % Issues_PAGENUM) > 0?(int)(PageTemp / Issues_PAGENUM) + 1:(int)(PageTemp / Issues_PAGENUM);
bool AllowScroller = Issues_Pager.MaxPage == 1?false:true;
DataView Source;
Source = new DataView(ds.Tables[0]);
if (ds.Tables[0].Rows.Count == 0)
{
Issues_no_records.Visible = true;
AllowScroller = false;
}
else
{
Issues_no_records.Visible = false;
AllowScroller = AllowScroller && true;
}
Issues_Pager.Visible = AllowScroller;
return(Source);
// Issues Show end
}
/*===============================
* Display Record Form
* -------------------------------*/
void Issues_Show()
{
// Issues Show begin
Utility.buildListBox(Issues_priority_id.Items, "select priority_id,priority_desc from priorities order by 1", "priority_id", "priority_desc", null, "");
Utility.buildListBox(Issues_status_id.Items, "select status_id,status from statuses order by 1", "status_id", "status", null, "");
Utility.buildListBox(Issues_qastatus_id.Items, "select qastatus_id,qastatus from qastatuses order by 1", "qastatus_id", "qastatus", null, "");
Utility.buildListBox(Issues_category_id.Items, "select category_id,category from categories order by 1", "category_id", "category", null, "");
Utility.buildListBox(Issues_bugversion.Items, "select version_id,version from versions order by 2", "version_id", "version", null, "");
Utility.buildListBox(Issues_version.Items, "select version_id,version from versions order by 2", "version_id", "version", null, "");
Utility.buildListBox(Issues_assigned_to.Items, "select user_id,user_name from users order by 2", "user_id", "user_name", null, "");
Utility.buildListBox(Issues_qaassigned_to.Items, "select user_id,user_name from users order by 2", "user_id", "user_name", null, "");
Utility.buildListBox(Issues_product_id.Items, "select product_id,product from products order by 2 desc", "product_id", "product", null, "");
Issues_priority_id.SelectedIndex = Issues_priority_id.Items.IndexOf(Issues_priority_id.Items.FindByValue("7"));
Issues_status_id.SelectedIndex = Issues_status_id.Items.IndexOf(Issues_status_id.Items.FindByValue("1"));
Issues_qastatus_id.SelectedIndex = Issues_qastatus_id.Items.IndexOf(Issues_qastatus_id.Items.FindByValue("1"));
Issues_category_id.SelectedIndex = Issues_category_id.Items.IndexOf(Issues_category_id.Items.FindByValue("1"));
Issues_assigned_to.SelectedIndex = Issues_assigned_to.Items.IndexOf(Issues_assigned_to.Items.FindByValue(Session["Supervisor"].ToString()));
Issues_qaassigned_to.SelectedIndex = Issues_qaassigned_to.Items.IndexOf(Issues_qaassigned_to.Items.FindByValue(Session["UserID"].ToString()));
bool ActionInsert = true;
if (p_Issues_issue_id.Value.Length > 0)
{
string sWhere = "";
sWhere += "issue_id=" + CCUtility.ToSQL(p_Issues_issue_id.Value, CCUtility.FIELD_TYPE_Number);
// Issues Open Event begin
// Issues Open Event end
string sSQL = "select * from issues where " + sWhere;
OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection);
DataSet ds = new DataSet();
DataRow row;
if (dsCommand.Fill(ds, 0, 1, "Issues") > 0)
{
row = ds.Tables[0].Rows[0];
Issues_issue_id.Value = CCUtility.GetValue(row, "issue_id");
Issues_issue_name.Text = CCUtility.GetValue(row, "issue_name");
Issues_issue_desc.Text = CCUtility.GetValue(row, "issue_desc");
Issues_steps_to_recreate.Text = CCUtility.GetValue(row, "steps_to_recreate");
Issues_screen.Text = CCUtility.GetValue(row, "steps_screen");
Issues_dev_number.Text = CCUtility.GetValue(row, "dev_issue_number");
Issues_its_number.Text = CCUtility.GetValue(row, "its_number");
{
string s;
s = CCUtility.GetValue(row, "priority_id");
if (s.Length == 0)
{
s = "3";
}
try {
Issues_priority_id.SelectedIndex = Issues_priority_id.Items.IndexOf(Issues_priority_id.Items.FindByValue(s));
}
catch {}
}
{
string s;
s = CCUtility.GetValue(row, "status_id");
if (s.Length == 0)
{
s = "1";
}
try {
Issues_status_id.SelectedIndex = Issues_status_id.Items.IndexOf(Issues_status_id.Items.FindByValue(s));
}
catch {}
}
{
string s;
s = CCUtility.GetValue(row, "product_id");
if (s.Length == 0)
{
s = "1";
}
try
{
Issues_product_id.SelectedIndex = Issues_product_id.Items.IndexOf(Issues_product_id.Items.FindByValue(s));
}
catch {}
}
{
string s;
s = CCUtility.GetValue(row, "qastatus_id");
if (s.Length == 0)
{
s = "1";
}
try {
Issues_qastatus_id.SelectedIndex = Issues_qastatus_id.Items.IndexOf(Issues_qastatus_id.Items.FindByValue(s));
}
catch {}
}
{
string s;
s = CCUtility.GetValue(row, "category_id");
if (s.Length == 0)
{
s = "1";
}
try {
Issues_category_id.SelectedIndex = Issues_category_id.Items.IndexOf(Issues_category_id.Items.FindByValue(s));
}
catch {}
}
{
string s;
s = CCUtility.GetValue(row, "bugversion");
if (s.Length == 0)
{
s = "1";
}
try
{
Issues_bugversion.SelectedIndex = Issues_bugversion.Items.IndexOf(Issues_bugversion.Items.FindByValue(s));
}
catch {}
}
{
string s;
s = CCUtility.GetValue(row, "version");
if (s.Length == 0)
{
s = "1";
}
try
{
Issues_version.SelectedIndex = Issues_version.Items.IndexOf(Issues_version.Items.FindByValue(s));
}
catch {}
}
{
string s;
s = CCUtility.GetValue(row, "assigned_to");
try
{
Issues_assigned_to.SelectedIndex = Issues_assigned_to.Items.IndexOf(Issues_assigned_to.Items.FindByValue(s));
}
catch {}
}
{
string s;
s = CCUtility.GetValue(row, "qaassigned_to");
try
{
Issues_qaassigned_to.SelectedIndex = Issues_qaassigned_to.Items.IndexOf(Issues_qaassigned_to.Items.FindByValue(s));
}
catch {}
}
Issues_submitted_by_l.Text = Server.HtmlEncode(Utility.Dlookup("users", "user_name", "user_id=" + CCUtility.ToSQL(CCUtility.GetValue(row, "user_id"), CCUtility.FIELD_TYPE_Number)).ToString());
Issues_date_submitted_l.Text = Server.HtmlEncode(CCUtility.GetValue(row, "date_submitted").ToString().Replace('T', ' '));
Issues_date_submitted.Value = CCUtility.GetValue(row, "date_submitted").Replace('T', ' ');
Issues_submitted_by.Value = CCUtility.GetValue(row, "user_id");
Issues_date_modified.Value = CCUtility.GetValue(row, "date_modified").Replace('T', ' ');
Issues_assigned_to_orig.Value = CCUtility.GetValue(row, "assigned_to_orig");
Issues_qaassigned_to_orig.Value = CCUtility.GetValue(row, "qaassigned_to_orig");
Issues_insert.Visible = false;
ActionInsert = false;
// Issues ShowEdit Event begin
// Issues ShowEdit Event end
}
}
else
{
try
{
Issues_bugversion.SelectedIndex = Issues_bugversion.Items.IndexOf(Issues_bugversion.Items.FindByText("Awaiting Approval")) + 1;
//Issues_version.SelectedIndex = Issues_version.Items.IndexOf(Issues_version.Items.FindByText("Not Released Yet"));
}
catch {}
}
if (ActionInsert)
{
String pValue;
pValue = Utility.GetParam("issue_id");
Issues_issue_id.Value = pValue;
if (Session["UserID"] != null)
{
pValue = Session["UserID"].ToString();
}
else
{
pValue = "";
}
if (pValue.Length > 0)
{
Issues_submitted_by_l.Text = Utility.Dlookup("users", "user_name", "user_id=" + pValue);
}
if (Session["UserID"] != null)
{
pValue = Session["UserID"].ToString();
}
else
{
pValue = "";
}
Issues_submitted_by.Value = pValue;
// Issues ShowInsert Event begin
// Issues ShowInsert Event end
}
// Issues Open Event begin
// Issues Open Event end
// Issues Show Event begin
Issues_date_submitted.Value = DateTime.Now.ToString("g").Replace("T", " ");
Issues_date_submitted_l.Text = DateTime.Now.ToString("g").Replace("T", " ");
Issues_submitted_by_l.Text = Utility.Dlookup("users", "user_name", "user_id=" + Issues_submitted_by.Value);
Issues_date_modified.Value = System.DateTime.Now.ToString("g");
// Issues Show Event end
// Issues Show end
// Issues Close Event begin
// Issues Close Event end
}
bool Settings_update_Click(Object Src, EventArgs E)
{
string sWhere = "";
string sSQL = "";
bool bResult = Settings_Validate();
if (bResult)
{
if (p_Settings_settings_id.Value.Length > 0)
{
sWhere = sWhere + "settings_id=" + CCUtility.ToSQL(p_Settings_settings_id.Value, CCUtility.FIELD_TYPE_Number);
}
// Settings Check Event begin
// Settings Check Event end
if (bResult)
{
sSQL = "update settings set " +
"[file_extensions]=" + CCUtility.ToSQL(Utility.GetParam("Settings_file_extensions"), CCUtility.FIELD_TYPE_Text) +
",[file_path]=" + CCUtility.ToSQL(Utility.GetParam("Settings_file_path"), CCUtility.FIELD_TYPE_Text) +
",[notify_new_from]=" + CCUtility.ToSQL(Utility.GetParam("Settings_notify_new_from"), CCUtility.FIELD_TYPE_Text) +
",[notify_new_subject]=" + CCUtility.ToSQL(Utility.GetParam("Settings_notify_new_subject"), CCUtility.FIELD_TYPE_Text) +
",[notify_new_body]=" + CCUtility.ToSQL(Utility.GetParam("Settings_notify_new_body"), CCUtility.FIELD_TYPE_Text) +
",[notify_change_from]=" + CCUtility.ToSQL(Utility.GetParam("Settings_notify_change_from"), CCUtility.FIELD_TYPE_Text) +
",[notify_change_subject]=" + CCUtility.ToSQL(Utility.GetParam("Settings_notify_change_subject"), CCUtility.FIELD_TYPE_Text) +
",[notify_change_body]=" + CCUtility.ToSQL(Utility.GetParam("Settings_notify_change_body"), CCUtility.FIELD_TYPE_Text);
sSQL = sSQL + " where " + sWhere;
// Settings Update Event begin
if (!System.IO.Directory.Exists(Server.MapPath((Settings_file_path.Text).Trim())))
{
try
{
System.IO.Directory.CreateDirectory(Server.MapPath((Settings_file_path.Text).Trim()));
}
catch (Exception ed)
{
Settings_ValidationSummary.Text += ed.ToString() + "<BR>Please contact with server administrator";
Settings_ValidationSummary.Visible = true;
return(false);
}
}
try
{
System.IO.FileStream fs = System.IO.File.Create(Server.MapPath((Settings_file_path.Text).Trim() + "\\test.tmp"));
fs.Close();
System.IO.File.Delete(Server.MapPath((Settings_file_path.Text).Trim() + "\\test.tmp"));
}
catch (Exception ed)
{
Settings_ValidationSummary.Text += ed.ToString() + "<BR>Please contact with server administrator";
Settings_ValidationSummary.Visible = true;
return(false);
}
// Settings Update Event end
Settings_BeforeSQLExecute(sSQL, "Update");
OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Settings_ValidationSummary.Text += e.Message;
Settings_ValidationSummary.Visible = true;
return(false);
}
}
if (bResult)
{
// Settings AfterUpdate Event begin
// Settings AfterUpdate Event end
}
}
return(bResult);
}
/*===============================
* Display Record Form
* -------------------------------*/
void Files_Show()
{
// Files Show begin
Utility.buildListBox(Files_uploaded_by.Items, "select user_id,user_name from users order by 2", "user_id", "user_name", null, "");
bool ActionInsert = true;
if (p_Files_file_id.Value.Length > 0)
{
string sWhere = "";
sWhere += "file_id=" + CCUtility.ToSQL(p_Files_file_id.Value, CCUtility.FIELD_TYPE_Number);
// Files Open Event begin
// Files Open Event end
string sSQL = "select * from files where " + sWhere;
OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection);
DataSet ds = new DataSet();
DataRow row;
if (dsCommand.Fill(ds, 0, 1, "Files") > 0)
{
row = ds.Tables[0].Rows[0];
Files_file_id.Value = CCUtility.GetValue(row, "file_id");
Files_issue_id.Value = CCUtility.GetValue(row, "issue_id");
Files_file_name.Text = CCUtility.GetValue(row, "file_name");
{
string s;
s = CCUtility.GetValue(row, "uploaded_by");
try
{
Files_uploaded_by.SelectedIndex = Files_uploaded_by.Items.IndexOf(Files_uploaded_by.Items.FindByValue(s));
}
catch {}
}
Files_date_uploaded.Text = CCUtility.GetValue(row, "date_uploaded")
.Replace('T', ' ');
ActionInsert = false;
// Files ShowEdit Event begin
// Files ShowEdit Event end
}
}
if (ActionInsert)
{
String pValue;
pValue = Utility.GetParam("file_id");
Files_file_id.Value = pValue;
pValue = Utility.GetParam("issue_id");
Files_issue_id.Value = pValue;
Files_delete.Visible = false;
Files_update.Visible = false;
// Files ShowInsert Event begin
// Files ShowInsert Event end
}
// Files Open Event begin
// Files Open Event end
// Files Show Event begin
// Files Show Event end
// Files Show end
// Files Close Event begin
// Files Close Event end
}
ICollection Users_CreateDataSource()
{
// Users Show begin
Users_sSQL = "";
Users_sCountSQL = "";
string sWhere = "", sOrder = "";
bool HasParam = false;
//-------------------------------
// Build ORDER BY statement
//-------------------------------
sOrder = " order by u.User_name Asc";
if (Utility.GetParam("FormUsers_Sorting").Length > 0 && !IsPostBack)
{
ViewState["SortColumn"] = Utility.GetParam("FormUsers_Sorting");
ViewState["SortDir"] = "ASC";
}
if (ViewState["SortColumn"] != null)
{
sOrder = " ORDER BY " + ViewState["SortColumn"].ToString() + " " + ViewState["SortDir"].ToString();
}
System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary();
//-------------------------------
// Build base SQL statement
//-------------------------------
Users_sSQL = "select [u].[allow_upload] as u_allow_upload, " +
"[u].[email] as u_email, " +
"[u].[security_level] as u_security_level, " +
"[u].[user_id] as u_user_id, " +
"[u].[user_name] as u_user_name " +
" from [users] u ";
//-------------------------------
//-------------------------------
//-------------------------------
//-------------------------------
// Assemble full SQL statement
//-------------------------------
Users_sSQL = Users_sSQL + sWhere + sOrder;
if (Users_sCountSQL.Length == 0)
{
int iTmpI = Users_sSQL.ToLower().IndexOf("select ");
int iTmpJ = Users_sSQL.ToLower().LastIndexOf(" from ") - 1;
Users_sCountSQL = Users_sSQL.Replace(Users_sSQL.Substring(iTmpI + 7, iTmpJ - 6), " count(*) ");
iTmpI = Users_sCountSQL.ToLower().IndexOf(" order by");
if (iTmpI > 1)
{
Users_sCountSQL = Users_sCountSQL.Substring(0, iTmpI);
}
}
//-------------------------------
OleDbDataAdapter command = new OleDbDataAdapter(Users_sSQL, Utility.Connection);
DataSet ds = new DataSet();
command.Fill(ds, (i_Users_curpage - 1) * Users_PAGENUM, Users_PAGENUM, "Users");
OleDbCommand ccommand = new OleDbCommand(Users_sCountSQL, Utility.Connection);
int PageTemp = (int)ccommand.ExecuteScalar();
Users_Pager.MaxPage = (PageTemp % Users_PAGENUM) > 0?(int)(PageTemp / Users_PAGENUM) + 1:(int)(PageTemp / Users_PAGENUM);
bool AllowScroller = Users_Pager.MaxPage == 1?false:true;
DataView Source;
Source = new DataView(ds.Tables[0]);
if (ds.Tables[0].Rows.Count == 0)
{
Users_no_records.Visible = true;
AllowScroller = false;
}
else
{
Users_no_records.Visible = false;
AllowScroller = AllowScroller && true;
}
Users_Pager.Visible = AllowScroller;
return(Source);
// Users Show end
}
/*===============================
* Display Record Form
* -------------------------------*/
void PriorityMaint_Show()
{
// PriorityMaint Show begin
bool ActionInsert = true;
if (p_PriorityMaint_priority_id.Value.Length > 0)
{
string sWhere = "";
sWhere += "priority_id=" + CCUtility.ToSQL(p_PriorityMaint_priority_id.Value, CCUtility.FIELD_TYPE_Number);
// PriorityMaint Open Event begin
// PriorityMaint Open Event end
string sSQL = "select * from priorities where " + sWhere;
OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection);
DataSet ds = new DataSet();
DataRow row;
if (dsCommand.Fill(ds, 0, 1, "PriorityMaint") > 0)
{
row = ds.Tables[0].Rows[0];
PriorityMaint_priority_id.Value = CCUtility.GetValue(row, "priority_id");
PriorityMaint_priority_desc.Text = CCUtility.GetValue(row, "priority_desc");
PriorityMaint_priority_color.Text = CCUtility.GetValue(row, "priority_color");
PriorityMaint_priority_order.Text = CCUtility.GetValue(row, "priority_order");
PriorityMaint_insert.Visible = false;
ActionInsert = false;
// PriorityMaint ShowEdit Event begin
// PriorityMaint ShowEdit Event end
}
}
if (ActionInsert)
{
String pValue;
pValue = Utility.GetParam("priority_id");
PriorityMaint_priority_id.Value = pValue;
PriorityMaint_delete.Visible = false;
PriorityMaint_update.Visible = false;
// PriorityMaint ShowInsert Event begin
// PriorityMaint ShowInsert Event end
}
// PriorityMaint Open Event begin
// PriorityMaint Open Event end
// PriorityMaint Show Event begin
// PriorityMaint Show Event end
// PriorityMaint Show end
// PriorityMaint Close Event begin
// PriorityMaint Close Event end
}
