protected void CarterasPoligonales_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Ver")
{
string nombreCarteraP = CarterasPoligonales.Rows[int.Parse(e.CommandArgument.ToString())].Cells[0].Text;
string emailP = lblEmail.Text;
CarteraDAO cartera = new CarteraDAO();
lblNombreCartera.Text = nombreCarteraP;
List <CarteraDAO> lista = cartera.verPoligonal(emailP, nombreCarteraP);
CarteraPoligonal.DataSource = lista;
CarteraPoligonal.DataBind();
List <CarteraDAO> listaC = cartera.verCaracPoligonal(emailP, nombreCarteraP);
CaracPoligonal.DataSource = listaC;
CaracPoligonal.DataBind();
}
else
{
if (e.CommandName == "Eliminar")
{
CarteraDAO carteraE = new CarteraDAO();
string nombreCarteraE = CarterasPoligonales.Rows[int.Parse(e.CommandArgument.ToString())].Cells[0].Text;
string emailE = lblEmail.Text;
carteraE.EliminarCartera(emailE, nombreCarteraE);
}
else
{
}
}
}
private void ExportGridToExcel()
{
/*Response.Clear();
* Response.Buffer = true;
* Response.ClearContent();
* Response.ClearHeaders();
* Response.Charset = "";
* string FileName = lblNombreCartera.Text + ".xls";
* StringWriter strwritter = new StringWriter();
* HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
* Response.Cache.SetCacheability(HttpCacheability.NoCache);
* Response.ContentType = "application/vnd.ms-excel";
* Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
* CarteraPoligonal.GridLines = GridLines.Both;
* CarteraPoligonal.HeaderStyle.Font.Bold = true;
* CarteraPoligonal.RenderControl(htmltextwrtter);
* CaracPoligonal.GridLines = GridLines.Both;
* CaracPoligonal.HeaderStyle.Font.Bold = true;
* CaracPoligonal.RenderControl(htmltextwrtter);
* Response.Write(strwritter.ToString());
* Response.End();
*/
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename = '" + lblNombreCartera.Text + "'.xls");
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
CarteraPoligonal.RenderControl(htmlWrite);
CaracPoligonal.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
