public void GetReportIssueHistory()
{
try
{
objViewIssue = new Model.clsViewMyIssues();
objBLViewIssue = new BusinessLayer.clsBLViewMyIssues();
objViewIssue.ReportIssueID = intReportIssueID;
dsReportIssueHistory = objBLViewIssue.GetReportIssueHistory(objViewIssue);
if (dsReportIssueHistory.Tables[0].Rows.Count > 0)
{
dgIssueDetails.Visible = true;
dgIssueDetails.DataSource = dsReportIssueHistory;
dgIssueDetails.DataBind();
lblCheckHistory.Visible = false;
pnlFileName.Visible = true;
}
else
{
dgIssueDetails.Visible = false;
lblCheckHistory.Visible = true;
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ViewSelectedIssue.aspx", "GetReportIssueHistory", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public void GetSelectedIssue()
{
try
{
objViewIssue = new Model.clsViewMyIssues();
objBLViewIssue = new BusinessLayer.clsBLViewMyIssues();
objViewIssue.StatusID = intStatusID;
objViewIssue.ReportIssueID = intReportIssueID;
int userid = EmployeeID;
Session["status"] = (objViewIssue.StatusID).ToString();
dsSelectedIssue = objBLViewIssue.GetSelectedIssue(objViewIssue, userid);
if (dsSelectedIssue.Tables[1].Rows.Count > 0)
{
Session["Username"] = dsSelectedIssue.Tables[1].Rows[0]["UserName"].ToString();
Session["UserEmailId"] = dsSelectedIssue.Tables[1].Rows[0]["EmailID"].ToString();
}
if (dsSelectedIssue.Tables[0].Rows.Count > 0)
{
FillIssueDetails();
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ViewSelectedIssue.aspx", "GetSelectedIssue", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
//have to change here
public void FillStatusList()
{
try
{
objViewIssue = new Model.clsViewMyIssues();
objBLViewIssue = new BusinessLayer.clsBLViewMyIssues();
DataSet dsStatus = new DataSet();
int EmployeeID = Convert.ToInt32(Session["varEmployeeID"]);
int Status = Convert.ToInt32(Session["status"]);
dsStatus = objBLViewIssue.GetStatusAccToRole(EmployeeID, Status);
ddlStatus.Items.Clear();
for (int i = 0; i < dsStatus.Tables[0].Rows.Count; i++)
{
ddlStatus.Items.Add(new ListItem(dsStatus.Tables[0].Rows[i]["StatusDesc"].ToString(), dsStatus.Tables[0].Rows[i]["StatusID"].ToString()));
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ViewSelectedIssue.aspx", "FillStatusList", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet bindCategory(Model.clsViewMyIssues objViewIssue)
{
DataSet dsSelectedIssue;
dsSelectedIssue = new DataSet();
SqlParameter[] objParam = new SqlParameter[1];
objParam[0] = new SqlParameter("@CategoryId", SqlDbType.Int);
objParam[0].Value = objViewIssue.SubCategoryId;
try
{
dsSelectedIssue = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_geSubCategory", objParam);
return(dsSelectedIssue);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyIssues.cs", "bindCategory", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetSuperAdminReportIssueHistory(Model.clsViewMyIssues objViewIssue)
{
DataSet dsSuperAdminReportIssueHistory;
dsSuperAdminReportIssueHistory = new DataSet();
SqlParameter[] objParam = new SqlParameter[1];
objParam[0] = new SqlParameter("@ReportIssueID", SqlDbType.Int);
objParam[0].Value = objViewIssue.ReportIssueID;
try
{
dsSuperAdminReportIssueHistory = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_GetSuperAdminReportIssueHistory", objParam);
return(dsSuperAdminReportIssueHistory);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyIssues.cs", "GetSuperAdminReportIssueHistory", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet MoveIssue(Model.clsViewMyIssues objViewIssue)
{
DataSet dsSelectedIssue;
dsSelectedIssue = new DataSet();
SqlParameter[] objParam = new SqlParameter[2];
objParam[0] = new SqlParameter("@EmployeeID", SqlDbType.Int);
objParam[0].Value = objViewIssue.EmployeeID;
objParam[1] = new SqlParameter("@IssueAssignmentId", SqlDbType.VarChar);
objParam[1].Value = objViewIssue.ReportIssueIDStr;
try
{
dsSelectedIssue = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_MoveIssue", objParam);
return(dsSelectedIssue);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyIssues.cs", "MoveIssue", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetSelectedIssueforSuperAdmin(Model.clsViewMyIssues objViewIssue, int userid)
{
DataSet dsSelectedIssue;
dsSelectedIssue = new DataSet();
SqlParameter[] objParam = new SqlParameter[2];
// objParam[0] = new SqlParameter("@ReportIssueID",SqlDbType.Int);
// objParam[0].Value = objViewIssue.ReportIssueID;
objParam[0] = new SqlParameter("@IssueAssignmentID", SqlDbType.Int);
objParam[0].Value = objViewIssue.IssueAssignmentID;
objParam[1] = new SqlParameter("@UserID", SqlDbType.Int);
objParam[1].Value = userid;
try
{
dsSelectedIssue = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_GetSelectedIssueForSuperAdmin", objParam);
return(dsSelectedIssue);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyIssues.cs", "GetSelectedIssueforSuperAdmin", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public void GetMyIssueList()
{
try
{
objViewMyIssues = new Model.clsViewMyIssues();
objBLViewMyIssues = new BusinessLayer.clsBLViewMyIssues();
objViewMyIssues.EmployeeID = varEmployeeID;
objViewMyIssues.SelectedStatus = Convert.ToString(ddlStatus.SelectedValue.ToString());
dsIssueList = objBLViewMyIssues.GetMyIssueList(objViewMyIssues);
dgViewIssues.DataSource = dsIssueList.Tables[0];
if (dsIssueList.Tables[0].Rows.Count > 0)
{
lblMsg.Visible = false;
dgViewIssues.Visible = true;
dgViewIssues.DataBind();
if (dgViewIssues.PageCount > 1)
{
dgViewIssues.PagerStyle.Visible = true;
}
else
{
dgViewIssues.PagerStyle.Visible = false;
}
if (objViewMyIssues.SelectedStatus == "All" || objViewMyIssues.SelectedStatus == "1" || (objViewMyIssues.SelectedStatus == "2") || (objViewMyIssues.SelectedStatus == "3") || (objViewMyIssues.SelectedStatus == "4") || (objViewMyIssues.SelectedStatus == "5") || (objViewMyIssues.SelectedStatus == "6") || (objViewMyIssues.SelectedStatus == "7") || (objViewMyIssues.SelectedStatus == "8") || (objViewMyIssues.SelectedStatus == "9"))
{
dgViewIssues.Columns[1].Visible = false;
dgViewIssues.Columns[0].Visible = true;
}
if (dgViewIssues.PageCount > 1)
{
dgViewIssues.PagerStyle.Visible = true;
}
else
{
dgViewIssues.PagerStyle.Visible = false;
}
}
else
{
dgViewIssues.Visible = false;
lblMsg.Visible = true;
lblMsg.Text = "No records found";
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ViewMyIssues.aspx", "GetMyIssueList", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetSuperAdminIssueList(Model.clsViewMyIssues objViewIssue)
{
DataSet dsSelectedIssue;
dsSelectedIssue = new DataSet();
//SqlParameter[] objParam = new SqlParameter[4];
//objParam[0] = new SqlParameter("@EmployeeID",SqlDbType.Int);
//objParam[0].Value = objViewIssue.EmployeeID;
//objParam[1] = new SqlParameter("@Status",SqlDbType.NVarChar);
//objParam[1].Value = objViewIssue.SelectedStatus;
//objParam[2] = new SqlParameter("@Name",SqlDbType.VarChar);
//objParam[2].Value = objViewIssue.SelectedEmployee;
//objParam[3] = new SqlParameter("@Category",SqlDbType.VarChar);
//objParam[3].Value = objViewIssue.Category;
SqlConnection con = new SqlConnection(sqlConn);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_GetSuperAdminIssueListNew1";
cmd.CommandTimeout = 6000;
cmd.Parameters.Add("@EmployeeID", SqlDbType.Int);
cmd.Parameters["@EmployeeID"].Value = objViewIssue.EmployeeID;
cmd.Parameters.Add("@Status", SqlDbType.NVarChar);
cmd.Parameters["@Status"].Value = objViewIssue.SelectedStatus;
cmd.Parameters.Add("@Name", SqlDbType.VarChar);
cmd.Parameters["@Name"].Value = objViewIssue.SelectedEmployee;
cmd.Parameters.Add("@Category", SqlDbType.VarChar);
cmd.Parameters["@Category"].Value = objViewIssue.Category;
try
{
//dsSelectedIssue = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure,"sp_GetSuperAdminIssueListNew1",objParam);
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dsSelectedIssue);
return(dsSelectedIssue);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyIssues.cs", "GetSuperAdminIssueList", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet SearchIssueIDData(Model.clsViewMyIssues objViewMyIssues)
{
try
{
return(objDLViewMyIssues.SearchIssueIDData(objViewMyIssues));
}
catch (V2Exceptions ex)
{
throw new V2Exceptions(ex.ToString(), ex);
}
}
public void GetStatus()
{
objViewMyIssues = new Model.clsViewMyIssues();
objBLViewMyIssues = new BusinessLayer.clsBLViewMyIssues();
DataSet dsStatus = new DataSet();
dsStatus = objBLViewMyIssues.GetStatus();
for (int i = 0; i < dsStatus.Tables[0].Rows.Count; i++)
{
ddlStatus.Items.Add(new ListItem(dsStatus.Tables[0].Rows[i]["StatusDesc"].ToString(), dsStatus.Tables[0].Rows[i]["StatusID"].ToString()));
}
ddlStatus.Items.Insert(0, "All");
ddlStatus.SelectedIndex = ddlStatus.Items.IndexOf(ddlStatus.Items.FindByText("Assigned"));
}
public DataSet GetSelectedIssue(Model.clsViewMyIssues objViewIssue, int userid)
{
try
{
return(objDLViewMyIssues.GetSelectedIssue(objViewIssue, userid));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLViewMyIssues.cs", "GetSelectedIssue", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetSuperAdminReportIssueHistory(Model.clsViewMyIssues objViewIssue)
{
try
{
return(objDLViewMyIssues.GetSuperAdminReportIssueHistory(objViewIssue));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLViewMyIssues.cs", "GetSuperAdminReportIssueHistory", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet LoadDepartment(Model.clsViewMyIssues objViewMyIssues)
{
try
{
return(objDLViewMyIssues.LoadDepartment(objViewMyIssues));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLViewMyIssues.cs", "LoadDepartment", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetMyIssueList(Model.clsViewMyIssues objViewMyIssues)
{
DataSet dsIssueList;
dsIssueList = new DataSet();
//SqlParameter[] objParam = new SqlParameter[2];
//objParam[0] = new SqlParameter("@EmployeeID", SqlDbType.Int);
//objParam[0].Value = objViewMyIssues.EmployeeID;
//objParam[1] = new SqlParameter("@StatusID", SqlDbType.NVarChar);
//objParam[1].Value = objViewMyIssues.SelectedStatus;
try
{
//dsIssueList = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure,"sp_GetIssueListNew3",objParam);
//return dsIssueList;
using (SqlConnection con = new SqlConnection(sqlConn))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_GetIssueListNew3";
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 5000;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@EmployeeID", objViewMyIssues.EmployeeID);
cmd.Parameters.AddWithValue("@StatusID", objViewMyIssues.SelectedStatus);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dsIssueList);
}
return(dsIssueList);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyIssues.cs", "GetMyIssueList", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet SearchIssueIDData(Model.clsViewMyIssues objViewIssue)
{
DataSet dsSelectedIssue;
dsSelectedIssue = new DataSet();
SqlParameter[] objParam = new SqlParameter[1];
objParam[0] = new SqlParameter("@ReportIssueID", SqlDbType.Int);
objParam[0].Value = objViewIssue.ReportIssueID;
try
{
dsSelectedIssue = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_IssueIDSearch", objParam);
return(dsSelectedIssue);
}
catch (V2Exceptions ex)
{
throw new V2Exceptions(ex.ToString(), ex);
}
}
