public void reportForEE(string SYTERM)//Dynamic Term - Peer Adviser 2 and Peer Adviser 3 { SqlCommand cmd = new SqlCommand("SELECT [Student Name] as Adviser, Sessions, Advisees, Sessions * 3.5 as [Sessions (70%)], Advisees * 3 as [Advisees (30%)], Sessions * 3.5 + Advisees * 3 as [Total (100%)], CAST(ROUND((Sessions * 3.5 + Advisees * 3) / 3.333333, 2) as numeric(36,2)) as [Number of Advisees Assisted (30%)], CAST(ROUND((Sessions * 3.5 + Advisees * 3) / 3.333333, 0) as numeric(36,0)) as Actual FROM (SELECT dbo.Student.StudentName as [Student Name], (SELECT COUNT(PConsultationId) FROM dbo.PeerAdviserConsultations WHERE PAdviserId = (SELECT PAdviserId FROM dbo.PeerAdviser WHERE dbo.PeerAdviser.StudentNumber = dbo.Student.StudentNumber) AND SYTERM = '" + SYTERM + "' AND [STATUS]='DONE') as Sessions, (SELECT COUNT(*) FROM (SELECT DISTINCT StudentNumber FROM dbo.PeerAdviserConsultations WHERE PAdviserId = (SELECT PAdviserId FROM dbo.PeerAdviser WHERE dbo.PeerAdviser.StudentNumber = dbo.Student.StudentNumber) AND SYTERM = '" + SYTERM + "' AND [STATUS]='DONE') as Advisees) as Advisees FROM dbo.Student JOIN dbo.PeerAdviser ON dbo.Student.StudentNumber = dbo.PeerAdviser.StudentNumber) as EE Order By Adviser"); Session["Filename"] = "PeerAdviseesAssisted"; GridViewEE.DataSource = Class2.getDataSet(cmd); GridViewEE.DataBind(); }
protected void btnExportToExcel_Click(object sender, EventArgs e) { try { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=(" + Session["SYTerm"].ToString().Replace(" ", string.Empty) + ")" + Session["Filename"] + ".xls"); Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); if (GridViewZ.Visible == true) { GridViewZ.RenderControl(htmlWrite); } else if (GridViewEE.Visible == true) { GridViewEE.RenderControl(htmlWrite); } else if (GridViewFF.Visible == true) { GridViewFF.RenderControl(htmlWrite); } else if (GridViewGG.Visible == true) { GridViewGG.RenderControl(htmlWrite); } else if (GridViewR.Visible == true) { GridViewR.RenderControl(htmlWrite); } else if (GridViewS.Visible == true) { GridViewS.RenderControl(htmlWrite); } else if (GridViewX.Visible == true) { GridViewX.RenderControl(htmlWrite); } /* * else if(GridViewY.Visible == true) * { * GridViewY.RenderControl(htmlWrite); * }*/ Response.Write(stringWrite.ToString()); Response.End(); } catch (Exception ex) { } }
protected void btnExportToPDF_Click(object sender, EventArgs e) { try { Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=(" + Session["SYTerm"].ToString().Replace(" ", string.Empty) + ")" + Session["Filename"] + ".pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); if (GridViewZ.Visible == true) { GridViewZ.RenderControl(hw); } else if (GridViewEE.Visible == true) { /*GridViewEE.AllowPaging = false; * GridViewEE.DataBind();*/ GridViewEE.RenderControl(hw); } else if (GridViewFF.Visible == true) { GridViewFF.RenderControl(hw); } else if (GridViewGG.Visible == true) { GridViewGG.RenderControl(hw); } else if (GridViewR.Visible == true) { GridViewR.RenderControl(hw); } else if (GridViewS.Visible == true) { GridViewS.RenderControl(hw); } else if (GridViewX.Visible == true) { GridViewX.RenderControl(hw); } /* * else if(GridViewY.Visible == true) * { * GridViewY.RenderControl(htmlWrite); * }*/ StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); Response.End(); } catch (Exception ex) { } }