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 }