//=============================== // 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); } }
//=============================== // UserMaint Show begin protected void Page_Load(object sender, EventArgs e) { Utility = new CCUtility(this); //=============================== // UserMaint Open Event begin // UserMaint Open Event end //=============================== //=============================== // UserMaint OpenAnyPage Event begin // UserMaint OpenAnyPage Event end //=============================== // //=============================== // UserMaint PageSecurity begin Utility.CheckSecurity(3); // UserMaint PageSecurity end //=============================== if (!IsPostBack) { p_User_user_id.Value = Utility.GetParam("user_id"); Page_Show(sender, e); } }
bool Response_delete_Click(Object Src, EventArgs E) { string sWhere = ""; if (p_Response_response_id.Value.Length > 0) { sWhere += "response_id=" + CCUtility.ToSQL(p_Response_response_id.Value, CCUtility.FIELD_TYPE_Number); } string sSQL = "delete from responses where " + sWhere; // Response Delete Event begin // Response Delete Event end Response_BeforeSQLExecute(sSQL, "Delete"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Response_ValidationSummary.Text += e.Message; Response_ValidationSummary.Visible = true; return(false); } // Response AfterDelete Event begin // Response AfterDelete Event end return(true); }
//=============================== // UserProfile Show begin protected void Page_Load(object sender, EventArgs e) { Utility = new CCUtility(this); //=============================== // UserProfile Open Event begin // UserProfile Open Event end //=============================== //=============================== // UserProfile OpenAnyPage Event begin // UserProfile OpenAnyPage Event end //=============================== // //=============================== // UserProfile PageSecurity begin Utility.CheckSecurity(1); // UserProfile PageSecurity end //=============================== if (!IsPostBack) { if (Session["UserID"] != null) { p_User_user_id.Value = Session["UserID"].ToString(); } else { p_User_user_id.Value = ""; } 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); } }
//=============================== // IssueMaint Show begin protected void Page_Load(object sender, EventArgs e) { Utility = new CCUtility(this); //=============================== // IssueMaint Open Event begin // IssueMaint Open Event end //=============================== //=============================== // IssueMaint OpenAnyPage Event begin // IssueMaint OpenAnyPage Event end //=============================== // //=============================== // IssueMaint PageSecurity begin Utility.CheckSecurity(3); // IssueMaint PageSecurity end //=============================== if (!IsPostBack) { p_Issue_issue_id.Value = Utility.GetParam("issue_id"); p_Responses_response_id.Value = Utility.GetParam("response_id"); p_Files_file_id.Value = Utility.GetParam("file_id"); Page_Show(sender, e); } }
//=============================== // Administration Show begin protected void Page_Load(object sender, EventArgs e) { Utility = new CCUtility(this); //=============================== // Administration Open Event begin // Administration Open Event end //=============================== //=============================== // Administration OpenAnyPage Event begin // Administration OpenAnyPage Event end //=============================== // //=============================== // Administration PageSecurity begin Utility.CheckSecurity(2); // Administration PageSecurity end //=============================== if (Session["UserID"] != null && Int16.Parse(Session["UserID"].ToString()) > 0) { Login_logged = true; } if (!IsPostBack) { Page_Show(sender, e); } }
bool Files_delete_Click(Object Src, EventArgs E) { string sWhere = ""; if (p_Files_file_id.Value.Length > 0) { sWhere += "file_id=" + CCUtility.ToSQL(p_Files_file_id.Value, CCUtility.FIELD_TYPE_Number); } string sSQL = "delete from files where " + sWhere; // Files Delete Event begin System.IO.File.Delete(Server.MapPath(Utility.Dlookup("settings", "file_path", "settings_id=1")) + "\\" + Files_file_name.Text); // Files Delete Event end Files_BeforeSQLExecute(sSQL, "Delete"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Files_ValidationSummary.Text += e.Message; Files_ValidationSummary.Visible = true; return(false); } // Files AfterDelete Event begin // Files AfterDelete Event end return(true); }
bool User_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = User_Validate(); if (bResult) { if (p_User_user_id.Value.Length > 0) { sWhere = sWhere + "user_id=" + CCUtility.ToSQL(p_User_user_id.Value, CCUtility.FIELD_TYPE_Number); } // User Check Event begin // User Check Event end if (bResult) { sSQL = "update users set " + "[login]=" + CCUtility.ToSQL(Utility.GetParam("User_login"), CCUtility.FIELD_TYPE_Text) + ",[pass]=" + CCUtility.ToSQL(Utility.GetParam("User_pass"), CCUtility.FIELD_TYPE_Text) + ",[security_level]=" + CCUtility.ToSQL(Utility.GetParam("User_security_level"), CCUtility.FIELD_TYPE_Number) + ",[user_name]=" + CCUtility.ToSQL(Utility.GetParam("User_user_name"), CCUtility.FIELD_TYPE_Text) + ",[email]=" + CCUtility.ToSQL(Utility.GetParam("User_email"), CCUtility.FIELD_TYPE_Text) + ",[allow_upload]=" + CCUtility.getCheckBoxValue(Utility.GetParam("User_allow_upload"), "1", "0", CCUtility.FIELD_TYPE_Number) + ",[notify_new]=" + CCUtility.getCheckBoxValue(Utility.GetParam("User_notify_new"), "1", "0", CCUtility.FIELD_TYPE_Number) + ",[notify_original]=" + CCUtility.getCheckBoxValue(Utility.GetParam("User_notify_original"), "1", "0", CCUtility.FIELD_TYPE_Number) + ",[notify_reassignment]=" + CCUtility.getCheckBoxValue(Utility.GetParam("User_notify_reassignment"), "1", "0", CCUtility.FIELD_TYPE_Number) + ",[supervisor_id]=" + CCUtility.ToSQL(Utility.GetParam("User_supervisor"), CCUtility.FIELD_TYPE_Number); sSQL = sSQL + " where " + sWhere; // User Update Event begin // User Update Event end User_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { User_ValidationSummary.Text += e.Message; User_ValidationSummary.Visible = true; return(false); } } if (bResult) { // User AfterUpdate Event begin // User AfterUpdate Event end } } return(bResult); }
/*=============================== * Display Record Form * -------------------------------*/ void VersionMaint_Show() { // VersionMaint Show begin bool ActionInsert = true; if (p_VersionMaint_version_id.Value.Length > 0) { string sWhere = ""; sWhere += "version_id=" + CCUtility.ToSQL(p_VersionMaint_version_id.Value, CCUtility.FIELD_TYPE_Number); // VersionMaint Open Event begin // VersionMaint Open Event end string sSQL = "select * from versions where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "VersionMaint") > 0) { row = ds.Tables[0].Rows[0]; VersionMaint_version_id.Value = CCUtility.GetValue(row, "version_id"); VersionMaint_version.Text = CCUtility.GetValue(row, "version"); VersionMaint_insert.Visible = false; ActionInsert = false; // VersionMaint ShowEdit Event begin // VersionMaint ShowEdit Event end } } if (ActionInsert) { VersionMaint_delete.Visible = false; VersionMaint_update.Visible = false; // VersionMaint ShowInsert Event begin // VersionMaint ShowInsert Event end } // VersionMaint Open Event begin // VersionMaint Open Event end // VersionMaint Show Event begin // VersionMaint Show Event end // VersionMaint Show end // VersionMaint Close Event begin // VersionMaint Close Event end }
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); }
// PriorityMaint Action begin bool PriorityMaint_insert_Click(Object Src, EventArgs E) { string sSQL = ""; bool bResult = PriorityMaint_Validate(); { int iCount = Utility.DlookupInt("priorities", "count(*)", "priority_order=" + CCUtility.ToSQL(Utility.GetParam("PriorityMaint_priority_order"), CCUtility.FIELD_TYPE_Number)); if (iCount != 0) { PriorityMaint_ValidationSummary.Visible = true; PriorityMaint_ValidationSummary.Text += "The value in field Order is already in database." + "<br>"; bResult = false; } } // PriorityMaint Check Event begin // PriorityMaint Check Event end if (bResult) { string p2_priority_desc = CCUtility.ToSQL(Utility.GetParam("PriorityMaint_priority_desc"), CCUtility.FIELD_TYPE_Text); string p2_priority_color = CCUtility.ToSQL(Utility.GetParam("PriorityMaint_priority_color"), CCUtility.FIELD_TYPE_Text); string p2_priority_order = CCUtility.ToSQL(Utility.GetParam("PriorityMaint_priority_order"), CCUtility.FIELD_TYPE_Number); // PriorityMaint Insert Event begin // PriorityMaint Insert Event end sSQL = "insert into priorities (" + "priority_desc," + "priority_color," + "priority_order)" + " values (" + p2_priority_desc + "," + p2_priority_color + "," + p2_priority_order + ")"; PriorityMaint_BeforeSQLExecute(sSQL, "Insert"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { PriorityMaint_ValidationSummary.Text += e.Message; PriorityMaint_ValidationSummary.Visible = true; return(false); } // PriorityMaint AfterInsert Event begin // PriorityMaint AfterInsert Event end } return(bResult); }
bool Files_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = Files_Validate(); if (bResult) { if (p_Files_file_id.Value.Length > 0) { sWhere = sWhere + "file_id=" + CCUtility.ToSQL(p_Files_file_id.Value, CCUtility.FIELD_TYPE_Number); } // Files Check Event begin // Files Check Event end if (bResult) { sSQL = "update files set " + "[issue_id]=" + CCUtility.ToSQL(Utility.GetParam("Files_issue_id"), CCUtility.FIELD_TYPE_Number) + ",[file_name]=" + CCUtility.ToSQL(Utility.GetParam("Files_file_name"), CCUtility.FIELD_TYPE_Text) + ",[uploaded_by]=" + CCUtility.ToSQL(Utility.GetParam("Files_uploaded_by"), CCUtility.FIELD_TYPE_Number) + ",[date_uploaded]=" + CCUtility.ToSQL(Utility.GetParam("Files_date_uploaded"), CCUtility.FIELD_TYPE_Date); sSQL = sSQL + " where " + sWhere; // Files Update Event begin // Files Update Event end Files_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Files_ValidationSummary.Text += e.Message; Files_ValidationSummary.Visible = true; return(false); } } if (bResult) { // Files AfterUpdate Event begin // Files AfterUpdate Event end } } return(bResult); }
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 VersionMaint_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = VersionMaint_Validate(); if (bResult) { if (p_VersionMaint_version_id.Value.Length > 0) { sWhere = sWhere + "version_id=" + CCUtility.ToSQL(p_VersionMaint_version_id.Value, CCUtility.FIELD_TYPE_Number); } // VersionMaint Check Event begin // VersionMaint Check Event end if (bResult) { sSQL = "update versions set " + "[version]=" + CCUtility.ToSQL(Utility.GetParam("VersionMaint_version"), CCUtility.FIELD_TYPE_Text); sSQL = sSQL + " where " + sWhere; // VersionMaint Update Event begin // VersionMaint Update Event end VersionMaint_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { VersionMaint_ValidationSummary.Text += e.Message; VersionMaint_ValidationSummary.Visible = true; return(false); } } if (bResult) { // VersionMaint AfterUpdate Event begin // VersionMaint AfterUpdate 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); } }
//=============================== // Footer Show begin protected void Page_Load(object sender, EventArgs e) { Utility = new CCUtility(this); //=============================== // Footer Open Event begin // Footer Open Event end //=============================== //=============================== // Footer OpenAnyPage Event begin // Footer OpenAnyPage Event end //=============================== // //=============================== // Footer PageSecurity begin // Footer PageSecurity end //=============================== if (!IsPostBack) { Page_Show(sender, e); } }
// 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); }
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='******'")); 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 { Login_Show(); } } else { Login_message.Visible = true; } // Login Login end } }
ICollection Files_CreateDataSource() { // Files Show begin Files_sSQL = ""; Files_sCountSQL = ""; string sWhere = "", sOrder = ""; bool HasParam = false; //------------------------------- // Build ORDER BY statement //------------------------------- if (Utility.GetParam("FormFiles_Sorting").Length > 0 && !IsPostBack) { ViewState["SortColumn"] = Utility.GetParam("FormFiles_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("issue_id")) { string temp = Utility.GetParam("issue_id"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number); } else { temp = ""; } Params.Add("issue_id", temp); } if (Params["issue_id"].Length > 0) { HasParam = true; sWhere += "f.[issue_id]=" + Params["issue_id"]; } if (HasParam) { sWhere = " AND (" + sWhere + ")"; } //------------------------------- // Build base SQL statement //------------------------------- Files_sSQL = "select [f].[date_uploaded] as f_date_uploaded, " + "[f].[file_id] as f_file_id, " + "[f].[file_name] as f_file_name, " + "[f].[issue_id] as f_issue_id, " + "[f].[uploaded_by] as f_uploaded_by, " + "[u].[user_id] as u_user_id, " + "[u].[user_name] as u_user_name " + " from [files] f, [users] u" + " where [u].[user_id]=f.[uploaded_by] "; //------------------------------- //------------------------------- //------------------------------- //------------------------------- // Assemble full SQL statement //------------------------------- Files_sSQL = Files_sSQL + sWhere + sOrder; if (Files_sCountSQL.Length == 0) { int iTmpI = Files_sSQL.ToLower().IndexOf("select "); int iTmpJ = Files_sSQL.ToLower().LastIndexOf(" from ") - 1; Files_sCountSQL = Files_sSQL.Replace(Files_sSQL.Substring(iTmpI + 7, iTmpJ - 6), " count(*) "); iTmpI = Files_sCountSQL.ToLower().IndexOf(" order by"); if (iTmpI > 1) { Files_sCountSQL = Files_sCountSQL.Substring(0, iTmpI); } } //------------------------------- OleDbDataAdapter command = new OleDbDataAdapter(Files_sSQL, Utility.Connection); DataSet ds = new DataSet(); command.Fill(ds, (i_Files_curpage - 1) * Files_PAGENUM, Files_PAGENUM, "Files"); OleDbCommand ccommand = new OleDbCommand(Files_sCountSQL, Utility.Connection); int PageTemp = (int)ccommand.ExecuteScalar(); Files_Pager.MaxPage = (PageTemp % Files_PAGENUM) > 0?(int)(PageTemp / Files_PAGENUM) + 1:(int)(PageTemp / Files_PAGENUM); bool AllowScroller = Files_Pager.MaxPage == 1?false:true; DataView Source; Source = new DataView(ds.Tables[0]); if (ds.Tables[0].Rows.Count == 0) { Files_no_records.Visible = true; AllowScroller = false; } else { Files_no_records.Visible = false; AllowScroller = AllowScroller && true; } Files_Pager.Visible = AllowScroller; return(Source); // Files Show end }
ICollection Responses_CreateDataSource() { // Responses Show begin Responses_sSQL = ""; Responses_sCountSQL = ""; string sWhere = "", sOrder = ""; bool bReq = true; bool HasParam = false; //------------------------------- // Build ORDER BY statement //------------------------------- sOrder = " order by r.date_response Asc"; //------------------------------- // Build WHERE statement //------------------------------- System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary(); if (!Params.ContainsKey("issue_id")) { string temp = Utility.GetParam("issue_id"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number); } else { temp = ""; } Params.Add("issue_id", temp); } if (Params["issue_id"].Length > 0) { HasParam = true; sWhere += "r.[issue_id]=" + Params["issue_id"]; } else { bReq = false; } if (HasParam) { sWhere = " AND (" + sWhere + ")"; } //------------------------------- // Build base SQL statement //------------------------------- Responses_sSQL = "select [r].[assigned_to] as r_assigned_to, " + "[r].[date_response] as r_date_response, " + "[r].[issue_id] as r_issue_id, " + "[r].[priority_id] as r_priority_id, " + "[r].[response] as r_response, " + "[r].[response_id] as r_response_id, " + "[r].[status_id] as r_status_id, " + "[r].[user_id] as r_user_id, " + "[u].[user_id] as u_user_id, " + "[u].[user_name] as u_user_name, " + "[u1].[user_id] as u1_user_id, " + "[u1].[user_name] as u1_user_name, " + "[p].[priority_id] as p_priority_id, " + "[p].[priority_desc] as p_priority_desc, " + "[s].[status_id] as s_status_id, " + "[s].[status] as s_status " + " from [responses] r, [users] u, [users] u1, [priorities] p, [statuses] s" + " where [u].[user_id]=r.[user_id] and [u1].[user_id]=r.[assigned_to] and [p].[priority_id]=r.[priority_id] and [s].[status_id]=r.[status_id] "; //------------------------------- //------------------------------- //------------------------------- //------------------------------- // Assemble full SQL statement //------------------------------- Responses_sSQL = Responses_sSQL + sWhere + sOrder; //------------------------------- if (!bReq) { Responses_no_records.Visible = true; return(null); } OleDbDataAdapter command = new OleDbDataAdapter(Responses_sSQL, Utility.Connection); DataSet ds = new DataSet(); command.Fill(ds, 0, Responses_PAGENUM, "Responses"); DataView Source; Source = new DataView(ds.Tables[0]); if (ds.Tables[0].Rows.Count == 0) { Responses_no_records.Visible = true; } else { Responses_no_records.Visible = false; } return(Source); // Responses Show end }
/*=============================== * Display Record Form * -------------------------------*/ void User_Show() { // User Show begin Utility.buildListBox(User_security_level.Items, User_security_level_lov, null, ""); Utility.buildListBox(User_supervisor.Items, "select user_id,user_name from users", "user_id", "user_name", null, ""); bool ActionInsert = true; if (p_User_user_id.Value.Length > 0) { string sWhere = ""; sWhere += "user_id=" + CCUtility.ToSQL(p_User_user_id.Value, CCUtility.FIELD_TYPE_Number); // User Open Event begin // User Open Event end string sSQL = "select * from users where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "User") > 0) { row = ds.Tables[0].Rows[0]; User_user_id.Value = CCUtility.GetValue(row, "user_id"); User_login.Text = CCUtility.GetValue(row, "login"); User_pass.Text = CCUtility.GetValue(row, "pass"); { string s; s = CCUtility.GetValue(row, "security_level"); try { User_security_level.SelectedIndex = User_security_level.Items.IndexOf(User_security_level.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "supervisor_id"); try { User_supervisor.SelectedIndex = User_supervisor.Items.IndexOf(User_supervisor.Items.FindByValue(s)); } catch {} } User_user_name.Text = CCUtility.GetValue(row, "user_name") ; User_email.Text = CCUtility.GetValue(row, "email"); User_allow_upload.Checked = CCUtility.GetValue(row, "allow_upload").ToLower().Equals("1".ToLower()); User_notify_new.Checked = CCUtility.GetValue(row, "notify_new").ToLower().Equals("1".ToLower()); User_notify_original.Checked = CCUtility.GetValue(row, "notify_original").ToLower().Equals("1".ToLower()); User_notify_reassignment.Checked = CCUtility.GetValue(row, "notify_reassignment").ToLower().Equals("1".ToLower()); User_insert.Visible = false; ActionInsert = false; // User ShowEdit Event begin // User ShowEdit Event end } } if (ActionInsert) { User_delete.Visible = false; User_update.Visible = false; // User ShowInsert Event begin // User ShowInsert Event end } // User Open Event begin // User Open Event end // User Show Event begin // User Show Event end // User Show end // User Close Event begin // User Close Event 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); }
/*=============================== * Display Record Form * -------------------------------*/ void Issue_Show() { // Issue Show begin Utility.buildListBox(Issue_user_id.Items, "select user_id,user_name from users order by 2", "user_id", "user_name", null, ""); Utility.buildListBox(Issue_modified_by.Items, "select user_id,user_name from users order by 2", "user_id", "user_name", null, ""); Utility.buildListBox(Issue_assigned_to_orig.Items, "select user_id,user_name from users order by 2", "user_id", "user_name", null, ""); Utility.buildListBox(Issue_assigned_to.Items, "select user_id,user_name from users order by 2", "user_id", "user_name", null, ""); Utility.buildListBox(Issue_priority_id.Items, "select priority_id,priority_desc from priorities order by 2", "priority_id", "priority_desc", null, ""); Utility.buildListBox(Issue_status_id.Items, "select status_id,status from statuses order by 2", "status_id", "status", null, ""); Utility.buildListBox(Issue_bugversion.Items, "select version_id,version from versions order by 1", "version_id", "version", null, ""); Utility.buildListBox(Issue_version.Items, "select version_id,version from fversions order by 1", "version_id", "version", null, ""); Utility.buildListBox(Issue_qastatus_id.Items, "select qastatus_id,qastatus from qastatuses order by 1", "qastatus_id", "qastatus", null, ""); Utility.buildListBox(Issue_product_id.Items, "select product_id,product from products order by 2", "product_id", "product", null, ""); bool ActionInsert = true; if (p_Issue_issue_id.Value.Length > 0) { string sWhere = ""; sWhere += "issue_id=" + CCUtility.ToSQL(p_Issue_issue_id.Value, CCUtility.FIELD_TYPE_Number); // Issue Open Event begin // Issue 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, "Issue") > 0) { row = ds.Tables[0].Rows[0]; Issue_issue_id.Value = CCUtility.GetValue(row, "issue_id"); Issue_issue_name.Text = CCUtility.GetValue(row, "issue_name"); Issue_issue_desc.Text = CCUtility.GetValue(row, "issue_desc"); Issue_steps_to_recreate.Text = CCUtility.GetValue(row, "steps_to_recreate"); Issue_dev_issue_number.Text = CCUtility.GetValue(row, "dev_issue_number"); Issue_its_number.Text = CCUtility.GetValue(row, "its_number"); Issue_screen.Text = CCUtility.GetValue(row, "screen"); { string s; s = CCUtility.GetValue(row, "user_id"); try { Issue_user_id.SelectedIndex = Issue_user_id.Items.IndexOf(Issue_user_id.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "qastatus_id"); try { Issue_qastatus_id.SelectedIndex = Issue_qastatus_id.Items.IndexOf(Issue_qastatus_id.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "modified_by") ; try { Issue_modified_by.SelectedIndex = Issue_modified_by.Items.IndexOf(Issue_modified_by.Items.FindByValue(s)); } catch {} } Issue_date_submitted.Text = CCUtility.GetValue(row, "date_submitted") .Replace('T', ' '); { string s; s = CCUtility.GetValue(row, "bugversion"); try { Issue_bugversion.SelectedIndex = Issue_bugversion.Items.IndexOf(Issue_bugversion.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "version"); try { Issue_version.SelectedIndex = Issue_version.Items.IndexOf(Issue_version.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "assigned_to_orig"); try { Issue_assigned_to_orig.SelectedIndex = Issue_assigned_to_orig.Items.IndexOf(Issue_assigned_to_orig.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "assigned_to") ; try { Issue_assigned_to.SelectedIndex = Issue_assigned_to.Items.IndexOf(Issue_assigned_to.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "priority_id") ; try { Issue_priority_id.SelectedIndex = Issue_priority_id.Items.IndexOf(Issue_priority_id.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "status_id") ; try { Issue_status_id.SelectedIndex = Issue_status_id.Items.IndexOf(Issue_status_id.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "product_id") ; try { Issue_product_id.SelectedIndex = Issue_product_id.Items.IndexOf(Issue_product_id.Items.FindByValue(s)); } catch {} } ActionInsert = false; // Issue ShowEdit Event begin // Issue ShowEdit Event end } } if (ActionInsert) { Issue_delete.Visible = false; Issue_update.Visible = false; // Issue ShowInsert Event begin // Issue ShowInsert Event end } // Issue Open Event begin // Issue Open Event end // Issue Show Event begin // Issue Show Event end // Issue Show end // Issue Close Event begin // Issue Close Event end }
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 }
ICollection Issues_CreateDataSource() { // Issues Show begin Issues_sSQL = ""; Issues_sCountSQL = ""; string sWhere = "", sOrder = ""; bool HasParam = false; //------------------------------- // Build ORDER BY statement //------------------------------- sOrder = " order by date_modified Desc"; //------------------------------- // Build WHERE statement //------------------------------- System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary(); if (!Params.ContainsKey("assigned_by")) { string temp = Utility.GetParam("assigned_by"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number, true); } else { temp = ""; } Params.Add("assigned_by", temp); } 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, true); } else { temp = ""; } Params.Add("assigned_to", temp); } if (!Params.ContainsKey("qaassigned_to")) { string temp = Utility.GetParam("qaassigned_to"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number, true); } else { temp = ""; } Params.Add("qaassigned_to", temp); } if (!Params.ContainsKey("category_id")) { string temp = Utility.GetParam("category_id"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number, true); } else { temp = ""; } Params.Add("category_id", 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, true); } else { temp = ""; } Params.Add("notstatus_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, true); } 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, true); } 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, true); } else { temp = ""; } Params.Add("qastatus_id", temp); } //************************** if (!Params.ContainsKey("bug_version_id")) { string temp = Utility.GetParam("bug_version_id"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number, true); } else { temp = ""; } Params.Add("bug_version_id", temp); } if (!Params.ContainsKey("release_version_id")) { string temp = Utility.GetParam("release_version_id"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number, true); } else { temp = ""; } Params.Add("release_version_id", temp); } if (!Params.ContainsKey("dev_nr")) { string temp = Utility.GetParam("dev_nr"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, CCUtility.FIELD_TYPE_Number, true); } else { temp = ""; } Params.Add("dev_nr", temp); } //************************** if (Params["assigned_by"].Length > 0) { HasParam = true; sWhere += "i.[user_id] IN (" + Params["assigned_by"] + ")"; } if (Params["assigned_to"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; sWhere += "i.[assigned_to] IN (" + Params["assigned_to"] + ")"; } if (Params["qaassigned_to"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; sWhere += "[qaassigned_to] IN (" + Params["qaassigned_to"] + ")"; } if (Params["category_id"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; sWhere += "i.[category_id] IN (" + Params["category_id"] + ")"; } if (Params["issue_name"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; bool bHasKeys = false; string[] Keys = Params["issue_name"].Split(' '); foreach (string key in Keys) { if (key.Equals(" ") == false) { if (bHasKeys == true) { sWhere += " and "; } sWhere += "("; sWhere += "i.[issue_desc] like '%" + key.Replace("'", "''") + "%'"; sWhere += " OR "; sWhere += "i.[issue_name] like '%" + key.Replace("'", "''") + "%'"; sWhere += " OR "; sWhere += "i.[dev_issue_number] like '%" + key.Replace("'", "''") + "%'"; sWhere += " OR "; int iId = 0; try { iId = Convert.ToInt32(key); } catch (Exception e) { e.ToString(); iId = 0; } sWhere += "i.[issue_id] = " + iId.ToString(); sWhere += ")"; bHasKeys = true; } } // sWhere +="[issue_desc] 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["priority_id"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; sWhere += "i.[priority_id] IN (" + Params["priority_id"] + ")"; } if (Params["status_id"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; sWhere += "i.[status_id] IN (" + Params["status_id"] + ")"; } if (Params["qastatus_id"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; sWhere += "i.[qastatus_id] IN (" + Params["qastatus_id"] + ")"; } //********************************** if (Params["bug_version_id"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; sWhere += " [bugversion] IN (" + Params["bug_version_id"] + ")"; } if (Params["release_version_id"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; sWhere += " i.[version] IN (" + Params["release_version_id"] + ")"; } if (Params["dev_nr"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; if (Params["dev_nr"].ToString() == "0") { sWhere += " i.[dev_issue_number] is null"; } else { sWhere += " i.[dev_issue_number] is not null"; } } //********************************** if (HasParam) { sWhere = " WHERE (" + sWhere + ")"; } //------------------------------- // Build base SQL statement //------------------------------- Issues_sSQL = "select " + "[i].[assigned_to] as i_assigned_to, " + "[i].[qaassigned_to] as i_qaassigned_to, " + "[i].[date_modified] as i_date_modified, " + "[i].[date_submitted] as i_date_submitted, " + "[i].[issue_desc] as i_issue_desc, " + "[i].[issue_id] as i_issue_id, " + "[i].[issue_name] as i_issue_name, " + "[i].[dev_issue_number] as i_dev_issue_number, " + "[i].[modified_by] as i_modified_by, " + "[i].[priority_id] as i_priority_id, " + "[i].[status_id] as i_status_id, " + "[i].[user_id] as i_user_id, " + "[i].[bugversion] as i_bugversion, " + "[i].[version] as i_version, " + "[i].[steps_to_recreate] as i_steps_to_recreate, " + "[s].[status_id] as s_dev_status_id, " + "[s].[status] as s_dev_status, " + "[qa].[qastatus_id] as qa_qastatus_id, " + "[qa].[qastatus] as qa_qastatus, " + "[p].[priority_id] as p_priority_id, " + "[p].[priority_desc] as p_priority_desc, " + "[c].[category_id] as c_category_id, " + "[c].[category] as c_category, " + "[u1].[user_id] as u1_user_id_submitted_by, " + "[u1].[user_name] as u1_user_name_submitted_by, " + "[u2].[user_id] as u2_user_id_owner, " + "[u2].[user_name] as u2_user_name_owner, " + "[u3].[user_id] as u3_user_id_qaowner, " + "[u3].[user_name] as u3_user_name_qaowner, " + "[u4].[user_id] as u4_user_id_last_updated_by, " + "[u4].[user_name] as u4_user_name_last_updated_by, " + "[v].[version] as v_version, " + "[bv].[version] as bv_version " + " from (((((((((([issues] i left join [statuses] s on [s].[status_id]=i.[status_id]) left join [qastatuses] qa on [qa].[qastatus_id]=i.[qastatus_id]) left join [priorities] p on [p].[priority_id]=i.[priority_id]) left join [users] u1 on [u1].[user_id]=i.[user_id]) left join [users] u2 on [u2].[user_id]=i.[assigned_to]) left join [users] u3 on [u3].[user_id]=i.[qaassigned_to]) left join [users] u4 on [u4].[user_id]=i.[modified_by]) left join [versions] v on [v].[version_id]=[i].[version]) left join [versions] bv on [bv].[version_id]=[i].[bugversion]) left join [categories] c on [c].[category_id]=i.[category_id]) "; //------------------------------- //------------------------------- Issues_Open(ref sWhere, ref sOrder); //------------------------------- //------------------------------- // Assemble full SQL statement //------------------------------- Issues_sSQL = Issues_sSQL + sWhere + sOrder; //------------------------------- OleDbDataAdapter command = new OleDbDataAdapter(Issues_sSQL, Utility.Connection); DataSet ds = new DataSet(); command.Fill(ds, 0, Issues_PAGENUM, "Issues"); DataView Source; Source = new DataView(ds.Tables[0]); if (ds.Tables[0].Rows.Count == 0) { Issues_no_records.Visible = true; } else { Issues_no_records.Visible = false; } return(Source); // Issues Show end }
bool Issue_delete_Click(Object Src, EventArgs E) { string sWhere = ""; if (p_Issue_issue_id.Value.Length > 0) { sWhere += "issue_id=" + CCUtility.ToSQL(p_Issue_issue_id.Value, CCUtility.FIELD_TYPE_Number); } string sSQL = "delete from issues where " + sWhere; // Issue Delete Event begin string fileSQL = "SELECT file_name FROM files WHERE issue_id=" + Issue_issue_id.Value; OleDbDataAdapter fileCmd = new OleDbDataAdapter(fileSQL, Utility.Connection); DataSet fileSet = new DataSet(); try { fileCmd.Fill(fileSet, "files"); if (fileSet.Tables[0].Rows.Count > 0) { for (int i = 0; i < fileSet.Tables[0].Rows.Count; i++) { System.IO.File.Delete(Server.MapPath(Utility.Dlookup("settings", "file_path", "settings_id=1")) + "\\" + fileSet.Tables[0].Rows[i]["file_name"].ToString()); } } } catch (Exception e) { Issue_ValidationSummary.Text += e.Message; Issue_ValidationSummary.Visible = true; return(false); } string sSQL1 = "delete from responses where issue_id=" + Issue_issue_id.Value; string sSQL2 = "delete from files where issue_id=" + Issue_issue_id.Value; OleDbCommand cmd1 = new OleDbCommand(sSQL1, Utility.Connection); OleDbCommand cmd2 = new OleDbCommand(sSQL2, Utility.Connection); try { cmd1.ExecuteNonQuery(); cmd2.ExecuteNonQuery(); } catch (Exception e) { Issue_ValidationSummary.Text += e.Message; Issue_ValidationSummary.Visible = true; return(false); } // Issue Delete Event end Issue_BeforeSQLExecute(sSQL, "Delete"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Issue_ValidationSummary.Text += e.Message; Issue_ValidationSummary.Visible = true; return(false); } // Issue AfterDelete Event begin // Issue AfterDelete Event end return(true); }
/*=============================== * Display Record Form * -------------------------------*/ void Response_Show() { // Response Show begin Utility.buildListBox(Response_user_id.Items, "select user_id,user_name from users order by 2", "user_id", "user_name", null, ""); Utility.buildListBox(Response_assigned_to.Items, "select user_id,user_name from users order by 2", "user_id", "user_name", null, ""); Utility.buildListBox(Response_qaassigned_to.Items, "select user_id,user_name from users order by 2", "user_id", "user_name", null, ""); Utility.buildListBox(Response_priority_id.Items, "select priority_id,priority_desc from priorities order by 2", "priority_id", "priority_desc", null, ""); Utility.buildListBox(Response_status_id.Items, "select status_id,status from statuses order by 2", "status_id", "status", null, ""); bool ActionInsert = true; if (p_Response_response_id.Value.Length > 0) { string sWhere = ""; sWhere += "response_id=" + CCUtility.ToSQL(p_Response_response_id.Value, CCUtility.FIELD_TYPE_Number); // Response Open Event begin // Response Open Event end string sSQL = "select * from responses where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "Response") > 0) { row = ds.Tables[0].Rows[0]; Response_response_id.Value = CCUtility.GetValue(row, "response_id"); { string s; s = CCUtility.GetValue(row, "user_id"); try { Response_user_id.SelectedIndex = Response_user_id.Items.IndexOf(Response_user_id.Items.FindByValue(s)); } catch {} } Response_date_response.Text = CCUtility.GetValue(row, "date_response") .Replace('T', ' '); Response_response.Text = CCUtility.GetValue(row, "response"); { string s; s = CCUtility.GetValue(row, "assigned_to"); try { Response_assigned_to.SelectedIndex = Response_assigned_to.Items.IndexOf(Response_assigned_to.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "qaassigned_to") ; try { Response_qaassigned_to.SelectedIndex = Response_qaassigned_to.Items.IndexOf(Response_qaassigned_to.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "priority_id") ; try { Response_priority_id.SelectedIndex = Response_priority_id.Items.IndexOf(Response_priority_id.Items.FindByValue(s)); } catch {} } { string s; s = CCUtility.GetValue(row, "status_id") ; try { Response_status_id.SelectedIndex = Response_status_id.Items.IndexOf(Response_status_id.Items.FindByValue(s)); } catch {} } ActionInsert = false; // Response ShowEdit Event begin // Response ShowEdit Event end } } if (ActionInsert) { Response_delete.Visible = false; Response_update.Visible = false; // Response ShowInsert Event begin // Response ShowInsert Event end } // Response Open Event begin // Response Open Event end // Response Show Event begin // Response Show Event end // Response Show end // Response Close Event begin // Response Close Event end }
// 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); }