/*=============================== * 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 }
/*=============================== * 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 }
/*=============================== * 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 }
/*=============================== * 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 }
/*=============================== * Display Record Form * -------------------------------*/ void Settings_Show() { // Settings Show begin bool ActionInsert = true; if (p_Settings_settings_id.Value.Length > 0) { string sWhere = ""; sWhere += "settings_id=" + CCUtility.ToSQL(p_Settings_settings_id.Value, CCUtility.FIELD_TYPE_Number); // Settings Open Event begin // Settings Open Event end string sSQL = "select * from settings where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "Settings") > 0) { row = ds.Tables[0].Rows[0]; Settings_settings_id.Value = CCUtility.GetValue(row, "settings_id"); Settings_file_extensions.Text = CCUtility.GetValue(row, "file_extensions"); Settings_file_path.Text = CCUtility.GetValue(row, "file_path"); Settings_notify_new_from.Text = CCUtility.GetValue(row, "notify_new_from"); Settings_notify_new_subject.Text = CCUtility.GetValue(row, "notify_new_subject"); Settings_notify_new_body.Text = CCUtility.GetValue(row, "notify_new_body"); Settings_notify_change_from.Text = CCUtility.GetValue(row, "notify_change_from"); Settings_notify_change_subject.Text = CCUtility.GetValue(row, "notify_change_subject"); Settings_notify_change_body.Text = CCUtility.GetValue(row, "notify_change_body"); ActionInsert = false; // Settings ShowEdit Event begin // Settings ShowEdit Event end } } if (ActionInsert) { Settings_update.Visible = false; // Settings ShowInsert Event begin // Settings ShowInsert Event end } // Settings Open Event begin // Settings Open Event end // Settings Show Event begin Settings_settings_id.Value = "1"; // Settings Show Event end // Settings Show end // Settings Close Event begin // Settings Close Event end }
/*=============================== * 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 }
/*=============================== * 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 }
/*=============================== * Display Record Form * -------------------------------*/ void User_Show() { // User Show begin 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_user_name.Text = Server.HtmlEncode(CCUtility.GetValue(row, "user_name").ToString()); User_login.Text = Server.HtmlEncode(CCUtility.GetValue(row, "login").ToString()); User_pass.Text = CCUtility.GetValue(row, "pass"); 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_allow_upload.Text = Server.HtmlEncode(CCUtility.GetValFromLOV(CCUtility.GetValue(row, "allow_upload"), User_allow_upload_lov).ToString()); User_security_level.Text = Server.HtmlEncode(CCUtility.GetValFromLOV(CCUtility.GetValue(row, "security_level"), User_security_level_lov).ToString()); ActionInsert = false; // User ShowEdit Event begin // User ShowEdit Event end } } if (ActionInsert) { String pValue; if (Session["UserID"] != null) { pValue = Session["UserID"].ToString(); } else { pValue = ""; } User_user_id.Value = pValue; 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 }
/*=============================== * 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 }