// 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); } }