/// <summary>
///
/// </summary>
/// <param name="control"></param>
private static void PrepareControlForExport(Control control)
{
for (int i = 0; i < control.Controls.Count; i++)
{
Control current = control.Controls[i];
if (current is LinkButton)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text));
}
else if (current is Image)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as Image).AlternateText));
}
else if (current is ImageButton)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText));
}
else if (current is HtmlImage)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as HtmlImage).Alt));
}
else if (current is HyperLink)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as HyperLink).Text));
}
else if (current is HtmlAnchor)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as HtmlAnchor).Title));
}
else if (current is DropDownList)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as DropDownList).SelectedItem.Text));
}
else if (current is CheckBox)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as CheckBox).Checked ? "True" : "False"));
}
if (current.HasControls())
{
GridViewExport.PrepareControlForExport(current);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="grid"></param>
/// <returns></returns>
private static Table GetTablularData(Grid grid)
{
Table table = new Table();
if (grid != null && grid.gridView != null && grid.gridView.Rows != null && grid.gridView.Rows.Count > 0)
{
if (grid.gridView.AllowPaging == true)
{
grid.gridView.AllowPaging = false;
grid.gridView.DataBind();
}
int counter = 0;
// add the header row to the table
if (grid.gridView.HeaderRow != null)
{
GridViewExport.PrepareControlForExport(grid.gridView.HeaderRow);
GridViewRow gr = grid.gridView.HeaderRow;
if (gr != null && gr.Cells != null)
{
using (TableHeaderRow tr = new TableHeaderRow())
{
while (gr.Cells.Count > 0)
{
using (TableCell tc = gr.Cells[0])
{
ColumnModel columnConfig = grid.columnsConfiguration[counter];
if (columnConfig != null)
{
if (!columnConfig.isHidden)
{
if (!string.IsNullOrEmpty(columnConfig.headerText))
{
tc.Text = columnConfig.headerText;
}
tc.BorderColor = System.Drawing.ColorTranslator.FromHtml(grid.borderColor);
tc.BorderWidth = Unit.Pixel(grid.borderWidthInPixel);
tc.BackColor = System.Drawing.ColorTranslator.FromHtml(grid.headerBackgroundColor);
tc.ForeColor = System.Drawing.ColorTranslator.FromHtml(grid.headerForeColor);
tr.Cells.Add(tc);
}
else
{
// hack to get rid of the hidden column cell
TableHeaderRow tempRow = new TableHeaderRow();
tempRow.Cells.Add(tc);
}
}
}
table.Rows.Add(tr);
counter++;
}
}
}
}
// add each of the data rows to the table
foreach (GridViewRow row in grid.gridView.Rows)
{
GridViewExport.PrepareControlForExport(row);
GridViewRow gr = row;
if (gr != null && gr.Cells != null)
{
using (TableHeaderRow tr = new TableHeaderRow())
{
counter = 0;
while (gr.Cells.Count > 0)
{
using (TableCell tc = gr.Cells[0])
{
ColumnModel columnConfig = grid.columnsConfiguration[counter];
if (columnConfig != null)
{
if (!columnConfig.isHidden)
{
tc.BorderColor = System.Drawing.ColorTranslator.FromHtml(grid.borderColor);
tc.BorderWidth = Unit.Pixel(grid.borderWidthInPixel);
tr.Cells.Add(tc);
}
else
{
// hack to get rid of the hidden column cell
TableHeaderRow tempRow = new TableHeaderRow();
tempRow.Cells.Add(tc);
}
}
}
table.Rows.Add(tr);
counter++;
}
}
}
}
// add the footer row to the table
if (grid.gridView.FooterRow != null)
{
GridViewExport.PrepareControlForExport(grid.gridView.FooterRow);
GridViewRow gr = grid.gridView.FooterRow;
if (gr != null && gr.Cells != null)
{
using (TableHeaderRow tr = new TableHeaderRow())
{
counter = 0;
while (gr.Cells.Count > 0)
{
using (TableCell tc = gr.Cells[0])
{
ColumnModel columnConfig = grid.columnsConfiguration[counter];
if (columnConfig != null)
{
if (!columnConfig.isHidden)
{
tc.BorderColor = System.Drawing.ColorTranslator.FromHtml(grid.borderColor);
tc.BorderWidth = Unit.Pixel(grid.borderWidthInPixel);
tc.BackColor = System.Drawing.ColorTranslator.FromHtml(grid.footerBackgroundColor);
tc.ForeColor = System.Drawing.ColorTranslator.FromHtml(grid.footerForeColor);
tr.Cells.Add(tc);
}
else
{
// hack to get rid of the hidden column cell
TableHeaderRow tempRow = new TableHeaderRow();
tempRow.Cells.Add(tc);
}
}
}
table.Rows.Add(tr);
counter++;
}
}
}
}
}
return(table);
}