// private void BindProblemPriority()
// {
//
// clsBLResolutionTimeReport objClsBLResolutionTimeReport = new clsBLResolutionTimeReport();
// DataSet dsBindProblemPriority = objClsBLResolutionTimeReport.getProblemPriority();
// if(dsBindProblemPriority.Tables[0].Rows.Count > 0)
// {
// ddlPriority.DataSource = dsBindProblemPriority.Tables[0];
// ddlPriority.DataTextField = dsBindProblemPriority.Tables[0].Columns["ProblemPriority"].ToString();
// ddlPriority.DataValueField = dsBindProblemPriority.Tables[0].Columns["ProblemPriorityID"].ToString();
// ddlPriority.DataBind();
// }
// }
private void BindProblemSeverity()
{
try
{
clsBLResolutionTimeReport objClsBLResolutionTimeReport = new clsBLResolutionTimeReport();
DataSet dsBindProblemSeverity = objClsBLResolutionTimeReport.getProblemSeverity();
if (dsBindProblemSeverity.Tables[0].Rows.Count > 0)
{
ddlSeverity.DataSource = dsBindProblemSeverity.Tables[0];
ddlSeverity.DataTextField = dsBindProblemSeverity.Tables[0].Columns["ProblemSeverity"].ToString();
ddlSeverity.DataValueField = dsBindProblemSeverity.Tables[0].Columns["ProblemSeverityID"].ToString();
ddlSeverity.DataBind();
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ResolutionTimeReport.aspx", "BindProblemSeverity", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
private void GetGraphDetails()
{
try
{
clsResolutionTimeReport objClsResolutionTimeReport = new clsResolutionTimeReport();
objClsResolutionTimeReport = (clsResolutionTimeReport)Session["Graph"];
clsBLResolutionTimeReport objClsBLResolutionTimeReport = new clsBLResolutionTimeReport();
dsResolutionTimeReport = objClsBLResolutionTimeReport.getGraphDetails(objClsResolutionTimeReport);
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ResolutionTimeReport.aspx", "GetGraphDetails", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public void getResolutionTimeReport(string ReportType)
{
try
{
clsBLResolutionTimeReport objClsBLResolutionTimeReport = new clsBLResolutionTimeReport();
clsResolutionTimeReport objClsResolutionTimeReport = new clsResolutionTimeReport();
//DataSet dsResolutionTimeReport = new DataSet();
objClsResolutionTimeReport.EmployeeID = Convert.ToInt32(ddlEmployeeName.SelectedItem.Value);
selectedToMonth = getEndDate(Convert.ToInt32(ddlToMonth.SelectedItem.Value), Convert.ToInt32(ddlToYear.SelectedItem.Value)).ToString();
selectedFromMonth = Convert.ToDateTime(ddlFromMonth.SelectedItem.Value + "-" + ddlFromYear.SelectedItem.Value).ToString();
objClsResolutionTimeReport.FromMonth = Convert.ToDateTime(selectedFromMonth); //Convert.ToDateTime(ddlFromMonth.SelectedItem.Value + "-" + ddlFromYear.SelectedItem.Value);
objClsResolutionTimeReport.ToMonth = Convert.ToDateTime(selectedToMonth); //getEndDate(Convert.ToInt32(ddlToMonth.SelectedItem.Value), Convert.ToInt32(ddlToYear.SelectedItem.Value));
/*objClsResolutionTimeReport.FromMonth = Convert.ToInt32(ddlFromMonth.SelectedItem.Value);
* objClsResolutionTimeReport.FromYear = Convert.ToInt32(ddlFromYear.SelectedItem.Value);
* objClsResolutionTimeReport.ToMonth = Convert.ToInt32(ddlToMonth.SelectedItem.Value);
* objClsResolutionTimeReport.ToYear = Convert.ToInt32(ddlToYear.SelectedItem.Value);*/
// ddlIssueHealth
IssueHealthId = Convert.ToInt32(ddlIssueHealth.Items[ddlIssueHealth.SelectedIndex].Value);
////objClsResolutionTimeReport.PriorityID = Convert.ToInt32(ddlPriority.SelectedItem.Value);
objClsResolutionTimeReport.SeverityID = Convert.ToInt32(ddlSeverity.SelectedItem.Value);
int superAdmin = Convert.ToInt32(Session["SAEmployeeID"]);
dsResolutionTimeReport = objClsBLResolutionTimeReport.getResolutionTimeDetails(objClsResolutionTimeReport, superAdmin);
if (ReportType == "Graph")
{
Session["Graph"] = objClsResolutionTimeReport;
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ResolutionTimeReport.aspx", "getResolutionTimeReport", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public void showResolutionTimeReport()
{
try
{
getResolutionTimeReport("Tabular");
clsBLResolutionTimeReport objClsBLResolutionTimeReport = new clsBLResolutionTimeReport();
clsResolutionTimeReport objClsResolutionTimeReport = new clsResolutionTimeReport();
if (dsResolutionTimeReport.Tables[0].Rows.Count > 0)
{
lblError.Visible = false;
dgReport.Visible = true;
lnkbtnGenrateToExcel.Visible = true;
//DataView
//added
dv = new DataView(dsResolutionTimeReport.Tables[0]);
if (IssueHealthId > 0)
{
dv.RowFilter = "ResolutionHealth = " + IssueHealthId;
}
if (dv.Count > 0)
{
dgReport.DataSource = dv;
dgReport.DataBind();
//added
//Session["FilteredReport"] = dv;
if (dgReport.PageCount > 1)
{
dgReport.PagerStyle.Visible = true;
}
else
{
dgReport.PagerStyle.Visible = false;
}
}
else
{
lblError.Visible = true;
dgReport.Visible = false;
lnkbtnGenrateToExcel.Visible = false;
lblError.Text = "No Records Found.";
}
}
else
{
lblError.Visible = true;
dgReport.Visible = false;
lnkbtnGenrateToExcel.Visible = false;
lblError.Text = "No Records Found.";
}
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "ResolutionTimeReport.aspx", "showResolutionTimeReport", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
