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
}