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