//===============================
// 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);
}
