void Login_Show() { // Login Show begin // Login Open Event begin // Login Open Event end // Login BeforeShow Event begin // Login BeforeShow Event end if (Login_logged) { // User logged in Login_login.Text = "Logout"; Login_trpassword.Visible = false; Login_trname.Visible = false; Login_labelname.Visible = true; Login_labelname.Text = Utility.Dlookup("users", "login", "user_id=" + Session["UserID"]) + " "; } else { // User is not logged in Login_login.Text = "Login"; Login_trpassword.Visible = true; Login_trname.Visible = true; Login_labelname.Visible = false; } // Login Close Event begin // Login Close Event end // Login Show end }
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); }
public void Issues_Repeater_ItemDataBound(Object Sender, RepeaterItemEventArgs e) { // Issues Show Event begin if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { //Process Assigned To if (((DataRowView)e.Item.DataItem)["i_assigned_to"].ToString() == Session["UserID"].ToString()) { ((Label)e.Item.FindControl("Issues_assigned_to")).Text = "<font color=\"red\">" + ((DataRowView)e.Item.DataItem)["u_user_name"].ToString() + "</font>"; } //Process Priority (value and color) string priority_id = Utility.Dlookup("priorities", "priority_desc", "priority_id=" + ((DataRowView)e.Item.DataItem)["i_priority_id"].ToString()); string priority_color = Utility.Dlookup("priorities", "priority_color", "priority_id=" + ((DataRowView)e.Item.DataItem)["i_priority_id"].ToString()); ((Label)e.Item.FindControl("Issues_priority_id")).Text = "<font color=\"" + priority_color + "\">" + priority_id + "</font>"; } // Issues Show Event 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 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 }