private void BindIssueDetails()
{
try
{
clsBLViewMyStatus objClsBLViewMyStatus = new clsBLViewMyStatus();
clsViewMyStatus objClsViewMyStatus = new clsViewMyStatus();
objClsViewMyStatus.IssueID = IssueID;
DataSet dsIssueDetails1 = objClsBLViewMyStatus.GetIssueDetails(objClsViewMyStatus);
pnlIssueDetails.Visible = true;
if (dsIssueDetails1.Tables[0].Rows.Count > 0)
{
//pnlDataGrid.Visible = true;
dgIssueDetails.DataSource = dsIssueDetails1.Tables[0];
dgIssueDetails.DataBind();
if (dgIssueDetails.PageCount > 1)
{
dgIssueDetails.PagerStyle.Visible = true;
}
else
{
dgIssueDetails.PagerStyle.Visible = false;
}
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ViewIssueStatus.aspx", "BindIssueDetails", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetIssueDetails(clsViewMyStatus objClsViewMyStatus)
{
try
{
DataSet dsGetIssueDetails = new DataSet();
SqlParameter[] sqlParams = new SqlParameter[1];
/*sqlParams[0] = new SqlParameter("@EmailID", SqlDbType.VarChar, 100);
* sqlParams[0].Value = objClsViewMyStatus.EmailID;
* sqlParams[0].Direction = ParameterDirection.Input;*/
sqlParams[0] = new SqlParameter("@IssueID", SqlDbType.Int);
sqlParams[0].Value = objClsViewMyStatus.IssueID;
sqlParams[0].Direction = ParameterDirection.Input;
dsGetIssueDetails = SqlHelper.ExecuteDataset(strConnectionString, CommandType.StoredProcedure, "sp_GetIssueDetails", sqlParams);
return(dsGetIssueDetails);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyStatus.cs", "GetIssueDetails", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
//public clsDLViewMyStatus()
//{
// try
// {
// }
// catch(V2Exceptions ex)
// {
// throw ;
// }
// catch(System.Exception ex)
// {
// FileLog objFileLog = FileLog.GetLogger();
// objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyStatus.cs", "clsDLViewMyStatus", ex.StackTrace);
// throw new V2Exceptions();
// }
//}
public DataSet GetIssues(clsViewMyStatus objClsViewMyStatus)
{
DataSet dsGetIssues = new DataSet();
// SqlParameter[] sqlParams = new SqlParameter[1];
// sqlParams[0] = new SqlParameter("@issuesId", SqlDbType.VarChar, 100);
// sqlParams[0].Value = objClsViewMyStatus.IssueID;
// sqlParams[0].Direction = ParameterDirection.Input;
SqlParameter[] sqlParams = new SqlParameter[1];
//sqlParams[0] = new SqlParameter("@Password", SqlDbType.VarChar, 100);
//sqlParams[0].Value = objClsViewMyStatus.Password;
//sqlParams[0].Direction = ParameterDirection.Input;
sqlParams[0] = new SqlParameter("@LoginID", SqlDbType.Int, 10);
sqlParams[0].Value = objClsViewMyStatus.LoginID;
sqlParams[0].Direction = ParameterDirection.Input;
//sp_GetIssues
try
{
dsGetIssues = SqlHelper.ExecuteDataset(strConnectionString, CommandType.StoredProcedure, "sp_GetIssues", sqlParams);
return(dsGetIssues);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyStatus.cs", "GetIssues", ex.StackTrace);
throw new V2Exceptions();
}
}
public int updateIssue1(clsViewMyStatus objClsViewMyStatus, int counter, string userloginid)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[6];
sqlParams[0] = new SqlParameter("@Comments", SqlDbType.VarChar, 1000);
sqlParams[0].Value = objClsViewMyStatus.Comments;
sqlParams[0].Direction = ParameterDirection.Input;
/*sqlParams[1] = new SqlParameter("@statusID", SqlDbType.Int);
* sqlParams[1].Value = objClsViewMyStatus.StatusID;
* sqlParams[1].Direction = ParameterDirection.Input;*/
sqlParams[1] = new SqlParameter("@SubCategoryID", SqlDbType.Int);
sqlParams[1].Value = objClsViewMyStatus.SubCategoryID;
sqlParams[1].Direction = ParameterDirection.Input;
sqlParams[2] = new SqlParameter("@reportIssueID", SqlDbType.Int);
sqlParams[2].Value = objClsViewMyStatus.IssueID;
sqlParams[2].Direction = ParameterDirection.Input;
sqlParams[3] = new SqlParameter("@StatusID", SqlDbType.Int);
sqlParams[3].Value = objClsViewMyStatus.StatusID;
sqlParams[3].Direction = ParameterDirection.Input;
sqlParams[4] = new SqlParameter("@counter", SqlDbType.Int);
sqlParams[4].Value = counter;
sqlParams[4].Direction = ParameterDirection.Input;
//sqlParams[4] = new SqlParameter("@UserName", SqlDbType.VarChar, 200);
//sqlParams[4].Value = name;
//sqlParams[4].Direction = ParameterDirection.Input;
sqlParams[5] = new SqlParameter("@EmployeeID", SqlDbType.VarChar, 100);
sqlParams[5].Value = userloginid;
sqlParams[5].Direction = ParameterDirection.Input;
int noOfrecordsAffected = 0;
//[sp_UpdateIssueStatus]
noOfrecordsAffected = SqlHelper.ExecuteNonQuery(strConnectionString, CommandType.StoredProcedure, "sp_UpdateIssueStatus_New", sqlParams);
//noOfrecordsAffected = SqlHelper.ExecuteNonQuery(strConnectionString, CommandType.StoredProcedure, "sp_UpdateIssue", sqlParams);
return(noOfrecordsAffected);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyStatus.cs", "updateIssue", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
private void viewDetails()
{
try
{
clsBLViewMyStatus objClsBLViewMyStatus = new clsBLViewMyStatus();
clsViewMyStatus objClsViewMyStatus = new clsViewMyStatus();
IssueID = Convert.ToInt32(Session["IssueID"]);
objClsViewMyStatus.IssueID = IssueID;
objClsViewMyStatus.EmailID = "";
BindIssueDetails();
DataSet dsIssueDetails = objClsBLViewMyStatus.GetIssuesReport(objClsViewMyStatus);
if (dsIssueDetails.Tables[0].Rows.Count > 0)
{
lblIssueID.Text = dsIssueDetails.Tables[0].Rows[0]["ReportIssueID"].ToString();
lblReportedBy.Text = dsIssueDetails.Tables[0].Rows[0]["Name"].ToString();
lblReportedOn.Text = dsIssueDetails.Tables[0].Rows[0]["ReportIssueDate"].ToString();
lblSubCategory_Category.Text = dsIssueDetails.Tables[0].Rows[0]["SubCategory"].ToString();
lblSeverity.Text = dsIssueDetails.Tables[0].Rows[0]["ProblemSeverity"].ToString();
////lblPriority.Text = dsIssueDetails.Tables[0].Rows[0]["ProblemPriority"].ToString();
lblDescription.Text = dsIssueDetails.Tables[0].Rows[0]["Description"].ToString();
lblReportStatus.Text = dsIssueDetails.Tables[0].Rows[0]["Status"].ToString();
// int intStatusID = Convert.ToInt32(dsIssueDetails.Tables[0].Rows[0]["Status"].ToString());
//if(intStatusID == 1)
//{
// lblReportStatus.Text = IssueStatus.New.ToString();
//}
//else if(intStatusID == 2)
//{
// lblReportStatus.Text = IssueStatus.Resolved.ToString();
//}
//else if(intStatusID == 3)
//{
// lblReportStatus.Text = IssueStatus.Moved.ToString();
//}
//else if(intStatusID == 4)
//{
// lblReportStatus.Text = IssueStatus.Reopen.ToString();
//}
//IssueID = Convert.ToInt32(dsIssueDetails.Tables[0].Rows[0]["IssueAssignmentID"]);
ReportIssueID = Convert.ToInt32(dsIssueDetails.Tables[0].Rows[0]["ReportIssueID"]);
//StatusID = Convert.ToInt32(dsIssueDetails.Tables[0].Rows[0]["StatusID"]);
SubCategoryID = Convert.ToInt32(dsIssueDetails.Tables[0].Rows[0]["SubCategoryID"]);
btnAddComments.Visible = false;
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ViewIssueStatus.aspx", "viewDetails", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
private void updateIssue()
{
try
{
clsBLViewMyStatus objClsBLViewMyStatus = new clsBLViewMyStatus();
clsViewMyStatus objClsViewMyStatus = new clsViewMyStatus();
objClsViewMyStatus.Comments = txtComments.Text;
objClsViewMyStatus.IssueID = Convert.ToInt32(lblIssueID.Text);
objClsViewMyStatus.SubCategoryID = SubCategoryID;
int noOfRecordsUpdated = 0;
noOfRecordsUpdated = objClsBLViewMyStatus.updateIssue(objClsViewMyStatus);
if (noOfRecordsUpdated > 0)
{
DataSet dsIssueDetails1 = objClsBLViewMyStatus.GetIssueDetails(objClsViewMyStatus);
pnlIssueDetails.Visible = true;
if (dsIssueDetails1.Tables[0].Rows.Count > 0)
{
dgIssueDetails.DataSource = dsIssueDetails1.Tables[0];
dgIssueDetails.DataBind();
if (dgIssueDetails.PageCount > 1)
{
dgIssueDetails.PagerStyle.Visible = true;
}
else
{
dgIssueDetails.PagerStyle.Visible = false;
}
pnlAddComments.Visible = false;
lblMessage.Text = "Issue is Reopened.";
lblDescription.Text = dsIssueDetails1.Tables[0].Rows[0]["Description"].ToString();
}
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ViewIssueStatus.aspx", "updateIssue", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetIssueDetails(clsViewMyStatus objClsViewMyStatus)
{
try
{
clsDLViewMyStatus objClsDLViewMyStatus = new clsDLViewMyStatus();
return(objClsDLViewMyStatus.GetIssueDetails(objClsViewMyStatus));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLViewMyStatus.cs", "GetIssueDetails", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public int updateIssue1(clsViewMyStatus objClsViewMyStatus, int counter, string userloginid)
{
try
{
clsDLViewMyStatus objClsDLViewMyStatus = new clsDLViewMyStatus();
return(objClsDLViewMyStatus.updateIssue1(objClsViewMyStatus, counter, userloginid));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLViewMyStatus.cs", "updateIssue", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public string getEmailID(clsViewMyStatus objClsViewMyStatus)
{
try
{
clsDLViewMyStatus objClsDLViewMyStatus = new clsDLViewMyStatus();
return(objClsDLViewMyStatus.getEmailID(objClsViewMyStatus));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLViewMyStatus.cs", "getEmailID", ex.StackTrace);
throw new V2Exceptions();
}
}
public DataSet GetIssuesReport(clsViewMyStatus objClsViewMyStatus)
{
DataSet dsGetIssues = new DataSet();
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@issuesId", SqlDbType.Int, 10);
sqlParams[0].Value = objClsViewMyStatus.IssueID;
try
{
dsGetIssues = SqlHelper.ExecuteDataset(strConnectionString, CommandType.StoredProcedure, "sp_GetIssuesReport", sqlParams);
return(dsGetIssues);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyStatus.cs", "GetIssuesReport", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public string getEmailID(clsViewMyStatus objClsViewMyStatus)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@IssueID", SqlDbType.Int, 4);
sqlParams[0].Value = objClsViewMyStatus.IssueID;
sqlParams[0].Direction = ParameterDirection.Input;
string strEmailID = (SqlHelper.ExecuteScalar(strConnectionString, CommandType.StoredProcedure, "sp_GetEmailID", sqlParams)).ToString();
return(strEmailID);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyStatus.cs", "getEmailID", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
