public DataSet getResolutionTimeDetails(clsResolutionTimeReport objClsResolutionTimeReport, int superAdmin) { try { SqlParameter[] sqlParams = new SqlParameter[5]; sqlParams[0] = new SqlParameter("@EmployeeID", SqlDbType.Int, 100); sqlParams[0].Value = objClsResolutionTimeReport.EmployeeID; sqlParams[0].Direction = ParameterDirection.Input; //// sqlParams[1] = new SqlParameter("@PriorityID", SqlDbType.Int,10); //// sqlParams[1].Value = objClsResolutionTimeReport.PriorityID; //// sqlParams[1].Direction = ParameterDirection.Input; sqlParams[1] = new SqlParameter("@SeverityID", SqlDbType.Int, 10); sqlParams[1].Value = objClsResolutionTimeReport.SeverityID; sqlParams[1].Direction = ParameterDirection.Input; /*sqlParams[3] = new SqlParameter("@FromDate", SqlDbType.VarChar,10); * sqlParams[3].Value = objClsResolutionTimeReport.FromDate; * sqlParams[3].Direction = ParameterDirection.Input;*/ sqlParams[2] = new SqlParameter("@FromMonth", SqlDbType.VarChar, 10); sqlParams[2].Value = objClsResolutionTimeReport.FromMonth.ToShortDateString(); sqlParams[2].Direction = ParameterDirection.Input; sqlParams[3] = new SqlParameter("@ToMonth", SqlDbType.VarChar, 10); sqlParams[3].Value = objClsResolutionTimeReport.ToMonth.ToShortDateString(); sqlParams[3].Direction = ParameterDirection.Input; sqlParams[4] = new SqlParameter("@superAdmin", SqlDbType.Int); sqlParams[4].Value = superAdmin; sqlParams[4].Direction = ParameterDirection.Input; /*sqlParams[4] = new SqlParameter("@ToDate", SqlDbType.VarChar,10); * sqlParams[4].Value = objClsResolutionTimeReport.ToDate; * sqlParams[4].Direction = ParameterDirection.Input;*/ DataSet dsResolutionTimeDetails = SqlHelper.ExecuteDataset(strConnectionString, CommandType.StoredProcedure, "sp_GetResolutionTimeDetails_New1", sqlParams); return(dsResolutionTimeDetails); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLResolutionTimeReport.cs", "getResolutionTimeDetails", ex.StackTrace); throw new V2Exceptions(); } }
public DataSet getResolutionTimeDetails(clsResolutionTimeReport objClsResolutionTimeReport, int superAdmin) { try { return(objClsDLResolutionTimeReport.getResolutionTimeDetails(objClsResolutionTimeReport, superAdmin)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsBLResolutionTimeReport.cs", "getResolutionTimeDetails", 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 DataSet getResolutionTimeDetails(clsResolutionTimeReport objClsResolutionTimeReport, int superAdmin) { try { //SqlParameter[] sqlParams = new SqlParameter[5]; //sqlParams[0] = new SqlParameter("@EmployeeID", SqlDbType.Int,100); //sqlParams[0].Value = objClsResolutionTimeReport.EmployeeID; //sqlParams[0].Direction = ParameterDirection.Input; //sqlParams[1] = new SqlParameter("@SeverityID", SqlDbType.Int,10); //sqlParams[1].Value = objClsResolutionTimeReport.SeverityID; //sqlParams[1].Direction = ParameterDirection.Input; //sqlParams[2] = new SqlParameter("@FromMonth", SqlDbType.VarChar,10); //sqlParams[2].Value = objClsResolutionTimeReport.FromMonth.ToShortDateString(); //sqlParams[2].Direction = ParameterDirection.Input; //sqlParams[3] = new SqlParameter("@ToMonth", SqlDbType.VarChar,10); //sqlParams[3].Value = objClsResolutionTimeReport.ToMonth.ToShortDateString(); //sqlParams[3].Direction = ParameterDirection.Input; //sqlParams[4] = new SqlParameter("@superAdmin", SqlDbType.Int); //sqlParams[4].Value = superAdmin; //sqlParams[4].Direction = ParameterDirection.Input; DataSet dsResolutionTimeDetails = new DataSet(); SqlConnection con = new SqlConnection(strConnectionString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_GetResolutionTimeDetails_New1"; cmd.CommandTimeout = 6000; cmd.Parameters.Add("@EmployeeID", SqlDbType.Int, 100); cmd.Parameters["@EmployeeID"].Value = objClsResolutionTimeReport.EmployeeID; cmd.Parameters.Add("@SeverityID", SqlDbType.Int, 10); cmd.Parameters["@SeverityID"].Value = objClsResolutionTimeReport.SeverityID; cmd.Parameters.Add("@FromMonth", SqlDbType.VarChar, 10); cmd.Parameters["@FromMonth"].Value = objClsResolutionTimeReport.FromMonth.ToShortDateString(); cmd.Parameters.Add("@ToMonth", SqlDbType.VarChar, 10); cmd.Parameters["@ToMonth"].Value = objClsResolutionTimeReport.ToMonth.ToShortDateString(); cmd.Parameters.Add("@superAdmin", SqlDbType.Int); cmd.Parameters["@superAdmin"].Value = superAdmin; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dsResolutionTimeDetails); return(dsResolutionTimeDetails); //DataSet dsResolutionTimeDetails = SqlHelper.ExecuteDataset(strConnectionString, CommandType.StoredProcedure, "sp_GetResolutionTimeDetails_New1", sqlParams); //return dsResolutionTimeDetails; } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "clsDLResolutionTimeReport.cs", "getResolutionTimeDetails", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
protected void lnkbtnGenrateToExcel_Click(object sender, System.EventArgs e) { try { dgReport.CurrentPageIndex = 0; showResolutionTimeReport(); clsResolutionTimeReport objClsResolutionTimeReport = new clsResolutionTimeReport(); objClsResolutionTimeReport.EmployeeID = SAEmployeeID; strFileNameCust = "Report_" + objClsResolutionTimeReport.EmployeeID + ".xls"; // DataGrid dgForCSVFile = new DataGrid(); // DataView dv = new DataView(); //if(dsResolutionTimeReport.Tables[0].Rows.Count>0) // { #region Commented code // dgForCSVFile.AutoGenerateColumns = false; // BoundColumn ReportIssueID = new BoundColumn(); // ReportIssueID.HeaderText = "Issue ID"; // ReportIssueID.DataField = "ReportIssueID"; // dgForCSVFile.Columns.Add(ReportIssueID); // // dgForCSVFile.AutoGenerateColumns = false; // BoundColumn ReportedBy = new BoundColumn(); // ReportedBy.HeaderText = "Reported By"; // ReportedBy.DataField = "ReportedBy"; // dgForCSVFile.Columns.Add(ReportedBy); // // dgForCSVFile.AutoGenerateColumns = false; // BoundColumn ReportedOn = new BoundColumn(); // ReportedOn.HeaderText = "Reported On"; // ReportedOn.DataField = "ReportedOn"; // dgForCSVFile.Columns.Add(ReportedOn); // // dgForCSVFile.AutoGenerateColumns = false; // BoundColumn AssignedTo = new BoundColumn(); // AssignedTo.HeaderText = "Issue ID"; // AssignedTo.DataField = "AssignedTo"; // dgForCSVFile.Columns.Add(AssignedTo); // // dgForCSVFile.AutoGenerateColumns = false; // BoundColumn ResolvedOn = new BoundColumn(); // ResolvedOn.HeaderText = "Resolved On"; // ResolvedOn.DataField = "ResolvedOn"; // dgForCSVFile.Columns.Add(ResolvedOn); // // dgForCSVFile.AutoGenerateColumns = false; // BoundColumn StatusID = new BoundColumn(); // StatusID.HeaderText = "Status ID"; // StatusID.DataField = "StatusID"; // dgForCSVFile.Columns.Add(StatusID); // // dgForCSVFile.AutoGenerateColumns = false; // BoundColumn ResolutionTime = new BoundColumn(); // ResolutionTime.HeaderText = "Resolution Time"; // ResolutionTime.DataField = "ResolutionTime"; // dgForCSVFile.Columns.Add(ResolutionTime); // // dgForCSVFile.AutoGenerateColumns = false; // TemplateColumn ResolutionHealth = new TemplateColumn(); // Label lblResolutionHealth = new Label(); // //BoundColumn ResolutionHealth = new BoundColumn(); // ResolutionHealth.HeaderText = "Resolution Health"; // lblResolutionHealth.Text = DataBinder.Eval(Container.DataItem,"ResolutionHealth"); // // dgForCSVFile.Columns.Add(ResolutionHealth); // #endregion Commented code // Datagrid1.DataSource = dsResolutionTimeReport;//.Tables[0]; // Datagrid1.DataBind(); // } if (dv.Count > 0) { Datagrid1.DataSource = dv;//.Tables[0]; Datagrid1.DataBind(); } Response.Clear(); Response.Charset = ""; Response.AddHeader("content-disposition", "attachment;FileName = " + strFileNameCust); Response.ContentType = "application/vnd.ms-excel"; StringWriter objStringWriter = new StringWriter(); System.Web.UI.HtmlTextWriter objHtmlTextWriter = new HtmlTextWriter(objStringWriter); Datagrid1.RenderControl(objHtmlTextWriter); Response.Write(objStringWriter.ToString()); Response.End(); } catch (System.Threading.ThreadAbortException ex) { } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "ResolutionTimeReport.aspx", "lnkbtnGenrateToExcel_Click", 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); } }