using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data;
using GisSolution.App_Code;
using System.Web;
using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.tool.xml;
using iTextSharp.text.html.simpleparser;
namespace Application
{
public partial class ParcelPoints : Page
{
string BQP_CODE;
const string query = "select رقم_الطلب,
NO_POINT,COORDINATE_X,COORDINATE_Y from IDENTIFY_SUR_POINTS where
BQP_CODE='{0}'";
protected void
Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
ScriptManager scriptManager =
ScriptManager.GetCurrent(Page);
scriptManager.RegisterPostBackControl(btnExport);
scriptManager.RegisterPostBackControl(btnExportToPDF);
}
}
private void
BindGrid()
{
//if
(string.IsNullOrEmpty(hf_BQP_CODE.Value))
BQP_CODE = Request.QueryString["BQP_CODE"];
hf_BQP_CODE.Value = BQP_CODE;
if (!string.IsNullOrEmpty(BQP_CODE))
{
DBConnection dataAccess = new DBConnection();
using (DataTable dt = dataAccess.GetData(string.Format(query, BQP_CODE)))
{
GV_ParcelsPoints.DataSource
= dt;
GV_ParcelsPoints.DataBind();
}
}
}
protected void
OnPageIndexChanging(object sender,
GridViewPageEventArgs e)
{
GV_ParcelsPoints.PageIndex =
e.NewPageIndex;
BindGrid();
}
protected void
ExportToExcel(object sender,
EventArgs e)
{
if (!string.IsNullOrEmpty(hf_BQP_CODE.Value))
{
DBConnection dataAccess = new DBConnection();
ExportToExcel(dataAccess.GetData(string.Format(query, hf_BQP_CODE.Value)), string.Format(@"Parcel_{0}_Points_{1}", hf_BQP_CODE.Value,DateTime.Now));
}
}
protected void
btnExportToPDF_Click(object sender,
EventArgs e)
{
if (!string.IsNullOrEmpty(hf_BQP_CODE.Value))
{
DBConnection dataAccess = new DBConnection();
ExportGridToPDF(dataAccess.GetData(string.Format(query, hf_BQP_CODE.Value)), string.Format(@"Parcel_{0}_Points_{1}", hf_BQP_CODE.Value, DateTime.Now));
}
}
protected void
ExportToExcel(DataTable tblData, string fileName)
{
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xls");
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer
= true;
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding =
System.Text.Encoding.UTF8;
HttpContext.Current.Response.ContentType
= "application/vnd.ms-excel";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
DataGrid grdExcel = new DataGrid();
grdExcel.AllowPaging = false;
grdExcel.DataSource = tblData;
grdExcel.DataBind();
foreach (DataGridItem i in grdExcel.Items)
{
foreach (TableCell tc in i.Cells)
tc.Attributes.Add("class", "text");
}
grdExcel.RenderControl(htmlWrite);
HttpContext.Current.Response.Write("");
string style = @" ";
HttpContext.Current.Response.Write(style);
HttpContext.Current.Response.Write(stringWrite.ToString());
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
private void
ExportGridToPDF(DataTable tblData, string fileName)
{
Response.ContentType = "application/pdf; charset=utf-8\"";
Response.AddHeader("content-disposition", "attachment;filename=UserDetails.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GV_ParcelsPoints.AllowPaging = false;
BindGrid();
int cc=GV_ParcelsPoints.Rows.Count;
GV_ParcelsPoints.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 7f, 7f, 7f,
0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc,
Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
//Confirms that
an HtmlForm control is rendered for the
//specified
ASP.NET server control at run time.
public override void
VerifyRenderingInServerForm(Control control)
{ }
}
}
