public DataSet getChartDetails(Model.clsIssueStatus objclsIssueStatus)
{
DataSet dsgetChartDetails;
SqlParameter [] objparam = new SqlParameter [3];
objparam [0] = new SqlParameter("@startMonth", System.Data.SqlDbType.DateTime);
objparam [0].Value = objclsIssueStatus.StartMonth;
objparam [1] = new SqlParameter("@endMonth", System.Data.SqlDbType.DateTime);
objparam [1].Value = objclsIssueStatus.EndMonth;
objparam[2] = new SqlParameter("@problemseverityid", System.Data.SqlDbType.Int);
objparam[2].Value = objclsIssueStatus.problemSeverityId;
try
{
dsgetChartDetails = SqlHelper.ExecuteDataset(strConnectionString, CommandType.StoredProcedure, "sp_GetGraphicalIssues", objparam);
return(dsgetChartDetails);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLgraphIssueStatus.cs", "getChartDetails", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
//Model.clsLine2D objclsLine2D;
#endregion Variable Declaration
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
//code to clear all the cache so that after logout, previous page cannot be revisited.
//--- starts here---------
//--- ends here---------
objclsIssueStatus = new clsIssueStatus();
objclsBLIssueStaus = new clsBLIssueStaus();
// objclsIssueStatus.connectionString = ConfigurationSettings.AppSettings["sql_Helpdesk_connection"].ToString();
EmployeeID = Convert.ToInt32(Session["EmployeeID"]);
SAEmployeeID = Convert.ToInt32(Session["SAEmployeeID"]);
OnlySuperAdmin = Convert.ToInt32(Session["OnlySuperAdmin"]);
if (OnlySuperAdmin != 0)
{
Response.Redirect("AuthorizationErrorMessage.aspx");
}
//if(EmployeeID.ToString() == "" || EmployeeID == 0)
//{
if (SAEmployeeID.ToString() == "" || SAEmployeeID == 0)
{
Response.Redirect(ConfigurationManager.AppSettings["Log-OffURL"].ToString());
}
//}
//else
//{
// Response.Redirect("AuthorizationErrorMessage.aspx");
//}
if (!IsPostBack)
{
objclsIssueStatus.EmployeeId = SAEmployeeID;
BindData();
BindYear();
}
btnshow.Attributes.Add("onclick", "return validateCategory()");
btnshow.Attributes.Add("onclick", "return DateRequired()");
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "IssueStatusReport.aspx", "Page_Load", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet getDsIssueStatus(Model.clsIssueStatus objclsIssueStatus)
{
try
{
return(objclsDlIssueStatus.getDsIssueStatus(objclsIssueStatus));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLIssueStaus.cs", "getDsIssueStatus", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public clsBLIssueStaus()
{
try
{
objclsDlIssueStatus = new clsDlIssueStatus();
objclsIssueStatus = new clsIssueStatus();
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLIssueStaus.cs", "clsBLIssueStaus", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
