/*===============================
* 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 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 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 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
}
