public DataSet ChangeCategoryOfIssue(clsIssueAssignment objIssueAssignment)
{
SqlParameter[] objParam = new SqlParameter[3];
objParam[0] = new SqlParameter("@ReportIssueID", SqlDbType.Int);
objParam[0].Value = objIssueAssignment.ReportIssueID;
objParam[1] = new SqlParameter("@SubCategoryID", SqlDbType.Int, 4);
objParam[1].Value = objIssueAssignment.SubCategoryID;
objParam[2] = new SqlParameter("@StatusID", SqlDbType.Int, 4);
objParam[2].Value = objIssueAssignment.StatusID;
try
{
DataSet dsCategory = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "ChangeCategoryOfIssue", objParam);
return(dsCategory);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLIssueAssignment.cs", "ChangeCategoryOfIssue", ex.StackTrace);
throw new V2Exceptions();
}
}
public bool IssueUpdateBySuperAdmin(clsIssueAssignment objIssueAssignment)
{
try
{
if (objDLIssueAssignment.IssueUpdateBySuperAdmin(objIssueAssignment))
{
return(true);
}
else
{
return(false);
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLIssueAssignment.cs", "IssueUpdateBySuperAdmin", ex.StackTrace);
throw new V2Exceptions();
}
}
public bool UpdateIssueByLoginUser(clsIssueAssignment objIssueAssignment, string name1)
{
try
{
if (objDLIssueAssignment.UpdateIssueByLoginUser(objIssueAssignment, name1))
{
return(true);
}
else
{
return(false);
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLIssueAssignment.cs", "UpdateIssueByLoginUser", ex.StackTrace);
throw new V2Exceptions();
}
}
public bool IssueUpdateBySuperAdmin(clsIssueAssignment objIssueAssignment)
{
SqlParameter[] objParam = new SqlParameter[8];
objParam[0] = new SqlParameter("@StatusID", SqlDbType.Int);
objParam[0].Value = objIssueAssignment.StatusID;
objParam[1] = new SqlParameter("@IssueAssignmentID", SqlDbType.Int);
objParam[1].Value = objIssueAssignment.IssueAssignmentID;
objParam[2] = new SqlParameter("@ReportIssueID", SqlDbType.Int);
objParam[2].Value = objIssueAssignment.ReportIssueID;
objParam[3] = new SqlParameter("@Cause", SqlDbType.VarChar, 255);
objParam[3].Value = objIssueAssignment.Cause;
objParam[4] = new SqlParameter("@Fix", SqlDbType.VarChar, 255);
objParam[4].Value = objIssueAssignment.Fix;
objParam[5] = new SqlParameter("@EmployeeID", SqlDbType.Int);
objParam[5].Value = objIssueAssignment.EmployeeID;
objParam[6] = new SqlParameter("@SubCategory", SqlDbType.Int);
objParam[6].Value = objIssueAssignment.SubCategory;
objParam[7] = new SqlParameter("@TypeID", SqlDbType.Int);
objParam[7].Value = objIssueAssignment.TypeID;
int recaffected1;
try
{
//recaffected1 = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "sp_IssueUpdateBySuperAdmin", objParam);
recaffected1 = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "sp_IssueAssignmentBySuperAdmin", objParam);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLIssueAssignment.cs", "IssueUpdateBySuperAdmin", ex.StackTrace);
throw new V2Exceptions();
}
return(true);
}
public bool UpdateIssueByLoginUser(clsIssueAssignment objIssueAssignment, string name1)
{
SqlParameter[] objParam = new SqlParameter[7];
objParam[0] = new SqlParameter("@StatusID", SqlDbType.Int);
objParam[0].Value = objIssueAssignment.StatusID;
objParam[1] = new SqlParameter("@IssueAssignmentID", SqlDbType.Int);
objParam[1].Value = objIssueAssignment.IssueAssignmentID;
objParam[2] = new SqlParameter("@ReportIssueID", SqlDbType.Int);
objParam[2].Value = objIssueAssignment.ReportIssueID;
objParam[3] = new SqlParameter("@Cause", SqlDbType.VarChar, 255);
objParam[3].Value = objIssueAssignment.Cause;
objParam[4] = new SqlParameter("@Fix", SqlDbType.VarChar, 255);
objParam[4].Value = objIssueAssignment.Fix;
objParam[5] = new SqlParameter("@Comments", SqlDbType.NVarChar, 2000);
objParam[5].Value = objIssueAssignment.AddComment;
objParam[6] = new SqlParameter("@EmployeeID", SqlDbType.Int);
objParam[6].Value = name1;
int recaffected1;
try
{
recaffected1 = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "sp_UpdateIssueByLoginUser_New11", objParam);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLIssueAssignment.cs", "UpdateIssueByLoginUser", ex.StackTrace);
throw new V2Exceptions();
}
return(true);
}
public DataSet FileName(clsIssueAssignment objIssueAssignment)
{
try
{
return(objDLIssueAssignment.FileName(objIssueAssignment));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLIssueAssignment.cs", "FileName", ex.StackTrace);
throw new V2Exceptions();
}
}
public string getEmployeeEmailID(clsIssueAssignment objIssueAssignment)
{
try
{
return(objDLIssueAssignment.getEmployeeEmailID(objIssueAssignment));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLIssueAssignment.cs", "getEmployeeEmailID", ex.StackTrace);
throw new V2Exceptions();
}
}
public DataSet FileName(clsIssueAssignment objIssueAssignment)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@ReportIssueID", SqlDbType.Int, 4);
sqlParams[0].Value = objIssueAssignment.ReportIssueID;
//sqlParams[0].Direction = ParameterDirection.Input;
DataSet dsFromEmailID = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "sp_FileName", sqlParams);
return(dsFromEmailID);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLIssueAssignment.cs", "FileName", ex.StackTrace);
throw new V2Exceptions();
}
}
public string getEmployeeEmailID(clsIssueAssignment objIssueAssignment)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@EmployeeID", SqlDbType.Int, 4);
sqlParams[0].Value = objIssueAssignment.EmployeeID;
sqlParams[0].Direction = ParameterDirection.Input;
string strEmployeeEmailID = (SqlHelper.ExecuteScalar(sqlConn, CommandType.StoredProcedure, "sp_getEmployeeEmailID", sqlParams)).ToString();
return(strEmployeeEmailID);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLIssueAssignment.cs", "getEmployeeEmailID", ex.StackTrace);
throw new V2Exceptions();
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
// Put user code to initialize the page here
//code to clear all the cache so that after logout, previous page cannot be revisited.
//--- starts here---------
//--- ends here---------
EmployeeID = Convert.ToInt32(Session["EmployeeID"]);
SAEmployeeID = Convert.ToInt32(Session["SAEmployeeID"]);
intReportIssueID = Convert.ToInt32(Session["ReportIssueID"]);
intStatusID = Convert.ToInt32(Session["StatusID"]);
txtFromDate.Attributes.Add("readonly", "readonly");
txtEndDate.Attributes.Add("readonly", "readonly");
if (SAEmployeeID.ToString() == "" || SAEmployeeID == 0)
{
Response.Redirect(ConfigurationManager.AppSettings["Log-OffURL"].ToString());
}
pnlMessage.Visible = false;
clsIssueAssignment objIssueAssignment = new clsIssueAssignment();
clsBLIssueAssignment objBLIssueAssignment = new clsBLIssueAssignment();
if (!IsPostBack)
{
if (SAEmployeeID.ToString() == "" || SAEmployeeID == 0)
{
Response.Redirect(ConfigurationManager.AppSettings["Log-OffURL"].ToString());
}
else
{
varEmployeeID = SAEmployeeID;
Session["varEmployeeID"] = varEmployeeID;
}
lblCheckHistory.Visible = false;
dgIssueDetails.Visible = false;
GetSelectedIssue();
GetReportIssueHistory();
}
objIssueAssignment.ReportIssueID = intReportIssueID;
dsfileName = objBLIssueAssignment.FileName(objIssueAssignment);
if (dsfileName.Tables[0].Rows.Count > 0)
{
for (int i = 0, j = 0; i < dsfileName.Tables[0].Rows.Count; i++, j++)
{
lnkFileName = new LinkButton();
lnkFileName.Attributes.Add("runat", "server");
Session["FileNames"] = dsfileName.Tables[0].Rows[j]["FileName"].ToString();
lnkFileName.Text = dsfileName.Tables[0].Rows[j]["FileName"].ToString();
lnkFileName.Click += new EventHandler(lnkFileName_Click);
pnlFileName.Controls.Add(lnkFileName);
pnlFileName.Controls.Add(new LiteralControl("<br/>"));
}
}
btnSubmit.Attributes.Add("onclick", "return validate();");
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ViewSelectedIssue.aspx", "Page_Load", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
