public DataSet GetSuperAdminReportIssueHistory(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();
}
}
public DataSet GetSelectedIssue(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].Direction = ParameterDirection.Input;
objParam[1] = new SqlParameter("@UserID", SqlDbType.Int);
objParam[1].Value = userid;
objParam[1].Direction = ParameterDirection.Input;
try
{
dsSelectedIssue = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_GetSelectedIssue", objParam);
return(dsSelectedIssue);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLViewMyIssues.cs", "GetSelectedIssue", ex.StackTrace);
throw new V2Exceptions();
}
}
public DataSet MoveIssue(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();
}
}
public DataSet bindCategory(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();
}
}
public DataSet GetSuperAdminIssueList(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;
try
{
dsSelectedIssue = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_GetSuperAdminIssueListNew1", objParam);
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();
}
}
public DataSet MoveIssue(clsViewMyIssues objViewMyIssues)
{
try
{
return(objDLViewMyIssues.MoveIssue(objViewMyIssues));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLViewMyIssues.cs", "MoveIssue", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet GetSelectedIssue(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();
}
}
public DataSet GetSuperAdminReportIssueHistory(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();
}
}
public DataSet LoadDepartment(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();
}
}
