private void LoadIssueData()
{
try
{
string query = "select * from tbl_Issue_Master where Application_Id='" + resAppl + "'";
DataTable dtIssue = DBUtils.SQLSelect(new SqlCommand(query));
DrpIssueType.DataSource = dtIssue;
DrpIssueType.DataTextField = "Issue_Name";
DrpIssueType.DataValueField = "Issue_Id";
DrpIssueType.Items.Insert(0, new ListItem("--Select Issue--", "Select"));
DrpIssueType.DataBind();
DrpPriority.Items.Clear();
DrpPriority.Items.Insert(0, new ListItem("--Select Priority--", "Select"));
DrpPriority.Items.Insert(1, new ListItem("High", "High"));
DrpPriority.Items.Insert(2, new ListItem("Medium", "Medium"));
DrpPriority.Items.Insert(3, new ListItem("Low", "Low"));
DrpPriority.DataBind();
drpStatus.Items.Clear();
drpStatus.Items.Insert(1, new ListItem("Open", "1"));
drpStatus.Items.Insert(0, new ListItem("Close", "0"));
drpStatus.DataBind();
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert(" + ex.Message + ")", true);
}
finally
{
constr.Close();
}
}
private void LoadIssueData()
{
try
{
string query = "select * from tbl_Issue_Master where Application_Id='" + resAppl + "'";
SqlCommand cmd = new SqlCommand(query, constr);
dt = DBUtils.SQLSelect(cmd);
DrpIssueType.DataSource = dt;
DrpIssueType.DataTextField = "Issue_Name";
DrpIssueType.DataValueField = "Issue_Id";
if (CultureInfo.CurrentCulture.Name == "es-ES")
{
DrpIssueType.Items.Insert(0, new ListItem("--Seleccionar problema--", "Seleccionar"));
}
else
{
DrpIssueType.Items.Insert(0, new ListItem("--Select Issue--", "Select"));
}
DrpIssueType.DataBind();
DrpPriority.Items.Clear();
if (CultureInfo.CurrentCulture.Name == "es-ES")
{
DrpPriority.Items.Insert(0, new ListItem("--Seleccionar prioridad--", "Seleccionar"));
DrpPriority.Items.Insert(1, new ListItem("Alto", "Alto"));
DrpPriority.Items.Insert(2, new ListItem("Medio", "Medio"));
DrpPriority.Items.Insert(3, new ListItem("Bajo", "Bajo"));
}
else
{
DrpPriority.Items.Insert(0, new ListItem("--Select Priority--", "Select"));
DrpPriority.Items.Insert(1, new ListItem("High", "High"));
DrpPriority.Items.Insert(2, new ListItem("Medium", "Medium"));
DrpPriority.Items.Insert(3, new ListItem("Low", "Low"));
}
DrpPriority.DataBind();
drpStatus.Items.Clear();
if (CultureInfo.CurrentCulture.Name == "es-ES")
{
drpStatus.Items.Insert(1, new ListItem("Abierto", "1"));
drpStatus.Items.Insert(0, new ListItem("Cerrar", "0"));
}
else
{
drpStatus.Items.Insert(1, new ListItem("Open", "1"));
drpStatus.Items.Insert(0, new ListItem("Close", "0"));
}
drpStatus.DataBind();
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert(" + ex.Message + ")", true);
}
finally
{
constr.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string Id = Request.QueryString["id"];
if (Id == null)
{
Response.Redirect("Login.aspx");
return;
}
else if (DBNulls.StringValue(Session[PublicMethods.ConstUserEmail]).Equals(""))
{
Response.Redirect("Login.aspx");
return;
}
string query = "select * from fnGetTicketDetail('" + Id + "')";
table = DBUtils.SQLSelect(new SqlCommand(query));
if (table.Rows.Count < 1)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "No Data Found", "alert('No Data Found...'); ", true);
return;
}
drpStatus.DataSource = table;
string dt = table.Rows[0]["Created Time"].ToString();
lblCreatedAt.Text = " Created Time : " + Convert.ToDateTime(dt).ToString("dd/MMM/yyyy HH:mm:ss tt", CultureInfo.InvariantCulture);
drpStatus.DataTextField = "Status";
drpStatus.DataBind();
lblStatus.Text = DBNulls.StringValue(table.Rows[0]["Status"].ToString());
if (lblStatus.Text.Equals("Open"))
{
btn_Edit_Details.Visible = true;
}
txt_Comments.Enabled = true;
btn_UpdateComment.Enabled = true;
lblStatus.ForeColor = System.Drawing.Color.Green;
//}
//else
//{
//lblStatus.ForeColor = System.Drawing.Color.Red;
//txt_Comments.Enabled = false;
//btn_UpdateComment.Enabled = false;
//}
TicketID.Text = table.Rows[0]["Ticket No"].ToString();
drpDownType.DataSource = table;
drpDownType.DataTextField = "Type Name";
drpDownType.DataBind();
drpDownApplication.DataSource = table;
drpDownApplication.DataTextField = "Application Name";
drpDownApplication.DataBind();
DrpIssueType.DataSource = table;
DrpIssueType.DataTextField = "Issue Name";
DrpIssueType.DataBind();
IssueDetail.Text = table.Rows[0]["Issue Details"].ToString();
DrpPriority.DataSource = table;
DrpPriority.DataTextField = "Priority";
DrpPriority.DataBind();
query = "select * from tbl_Attachment_Master where Ticket_Id='" + Id + "'";
table = DBUtils.SQLSelect(new SqlCommand(query));
if (table.Rows.Count > 0)
{
FileDownload.Enabled = true;
txtFileName.Text = table.Rows[0]["File_Name"].ToString();
}
else
{
FileDownload.Enabled = false;
}
if (!IsPostBack)
{
fillData();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string Id = Request.QueryString["id"];
if (Id == null)
{
Response.Redirect("Login.aspx");
return;
}
else if (DBNulls.StringValue(Session[PublicMethods.ConstUserEmail]).Equals(""))
{
Response.Redirect("Login.aspx");
return;
}
if (!IsPostBack)
{
LoadTypeData();
string queryToFetchAllData = "SELECT tbl_Issue_Master.Issue_Name, tbl_Ticket_Master.*,tbl_Type_Master.Type_Name, tbl_Application_Master.Application_Name FROM tbl_Ticket_Master INNER JOIN tbl_Type_Master ON tbl_Ticket_Master.Type_Id = tbl_Type_Master.Type_Id INNER JOIN tbl_Application_Master ON tbl_Ticket_Master.Application_Id =tbl_Application_Master.Application_Id INNER JOIN tbl_Issue_Master ON tbl_Ticket_Master.Issue_Id = tbl_Issue_Master.Issue_Id where tbl_Ticket_Master.Ticket_Id='" + Id + "' ";
DataTable dtAllData = DBUtils.SQLSelect(new SqlCommand(queryToFetchAllData));
drpDownType.SelectedValue = dtAllData.Rows[0]["Type_Id"].ToString();
resType = dtAllData.Rows[0]["Type_Id"].ToString();
LoadApplicationData();
drpDownApplication.SelectedValue = dtAllData.Rows[0]["Application_Id"].ToString();
resAppl = dtAllData.Rows[0]["Application_Id"].ToString();
LoadIssueData();
DrpIssueType.SelectedValue = dtAllData.Rows[0]["Issue_Id"].ToString();
}
else
{
resType = drpDownType.SelectedValue;
}
createdBy = DBNulls.StringValue(Session[PublicMethods.ConstUserEmail]);
//Query to prevent changes in URL
//User can change query string and access other tickets so this query prevent this condition
string queryToGetUserId = "SELECT [User_Id] FROM [tbl_User_Master] where [User_Email]='" + DBNulls.StringValue(Session[PublicMethods.ConstUserEmail]) + "'";
string userId = DBUtils.SqlSelectScalar(new SqlCommand(queryToGetUserId));
string query = "select * from fnGetTicketDetail('" + Id + "') where User_Id='" + userId + "'";
table = DBUtils.SQLSelect(new SqlCommand(query));
foreach (DataRow drDetails in table.Rows)
{
typeName = drDetails["Type Name"].ToString();
applicationName = drDetails["Application Name"].ToString();
issueName = drDetails["Issue Name"].ToString();
}
drpStatus.DataSource = table;
drpStatus.DataTextField = "Status";
drpStatus.DataBind();
lblStatus.Text = DBNulls.StringValue(table.Rows[0]["Status"].ToString());
if (lblStatus.Text.Equals("Open"))
{
btn_Edit_Details.Visible = true;
}
lblStatus.ForeColor = System.Drawing.Color.Green;
TicketID.Text = table.Rows[0]["Ticket No"].ToString();
drpDownType.DataSource = table;
if (!IsPostBack)
{
IssueDetail.Text = table.Rows[0]["Issue Details"].ToString();
}
DrpPriority.DataSource = table;
DrpPriority.DataTextField = "Priority";
DrpPriority.DataBind();
query = "select * from tbl_Attachment_Master where Ticket_Id='" + Id + "'";
table = DBUtils.SQLSelect(new SqlCommand(query));
if (table.Rows.Count > 0)
{
FileDownload.Enabled = true;
txtFileName.Text = table.Rows[0]["File_Name"].ToString();
}
else
{
FileDownload.Enabled = false;
}
}