/// <summary>
/// Export handler.
/// </summary>
protected void lnkExportToExcel_Click(object sender, EventArgs e)
{
UniGridExportHelper export = new UniGridExportHelper(gridValidationResult);
export.ExportRawData = false;
export.GenerateHeader = true;
export.FileName = ValidationHelper.GetSafeFileName("CSSValidation_" + ((Node != null) ? Node.DocumentNamePath : Url) + "_" + DateTime.Now.ToString()).Replace(" ", "_");
export.ExportData(DataExportFormatEnum.XLSX, Page.Response);
}
/// <summary>
/// Exports data based on given format.
/// </summary>
/// <param name="format">Format to export data in</param>
/// <param name="forceMaxItems">Max items count (for preview export)</param>
private void ExportData(DataExportFormatEnum format, int?forceMaxItems = null)
{
UniGridExportHelper.ExportRawData = chkExportRawData.Checked && UserCanEditSql;
UniGridExportHelper.CSVDelimiter = CurrentDelimiter;
UniGridExportHelper.GenerateHeader = chkExportHeader.Checked;
UniGridExportHelper.CurrentPageOnly = chkCurrentPageOnly.Checked;
UniGridExportHelper.Records = ValidationHelper.GetInteger(txtRecords.Text, -1);
// Preview export
if (forceMaxItems != null)
{
int limit;
if (UniGridExportHelper.CurrentPageOnly)
{
limit = UniGrid.Pager.DisplayPager ? UniGrid.Pager.CurrentPageSize : 0;
}
else
{
limit = UniGridExportHelper.Records;
}
if ((limit >= forceMaxItems) || (limit <= 0))
{
UniGridExportHelper.Records = forceMaxItems.Value;
UniGridExportHelper.CurrentPageOnly = false;
}
}
// Get order by clause from correct control
if (!chkCurrentPageOnly.Checked)
{
UniGridExportHelper.OrderBy = UserCanEditSql ? TrimExtendedTextAreaValue(txtOrderBy.Text) : ValidationHelper.GetString(orderByElem.Value, null);
UniGridExportHelper.WhereCondition = UserCanEditSql ? TrimExtendedTextAreaValue(txtWhereCondition.Text) : String.Empty;
}
UniGridExportHelper.Columns = GetSelectedColumns();
if (UIContext.SiteID > 0)
{
UniGridExportHelper.SiteName = SiteInfoProvider.GetSiteName(UIContext.SiteID);
}
else if (IsCMSDesk)
{
UniGridExportHelper.SiteName = SiteContext.CurrentSiteName;
}
UniGridExportHelper.ExportData(format, Page.Response);
}
/// <summary>
/// Exports data based on given format.
/// </summary>
/// <param name="format">Format to export data in</param>
/// <param name="forceMaxItems">Max items count (for preview export)</param>
private void ExportData(DataExportFormatEnum format, int?forceMaxItems = null)
{
UniGridExportHelper.ExportRawData = chkExportRawData.Checked;
UniGridExportHelper.CSVDelimiter = CurrentDelimiter;
UniGridExportHelper.GenerateHeader = chkExportHeader.Checked;
UniGridExportHelper.CurrentPageOnly = chkCurrentPageOnly.Checked;
UniGridExportHelper.Records = ValidationHelper.GetInteger(txtRecords.Text, -1);
// Preview export
if (forceMaxItems != null)
{
int limit = 0;
if (UniGridExportHelper.CurrentPageOnly)
{
limit = UniGrid.Pager.DisplayPager ? UniGrid.Pager.CurrentPageSize : 0;
}
else
{
limit = UniGridExportHelper.Records;
}
if ((limit >= forceMaxItems) || (limit <= 0))
{
UniGridExportHelper.Records = forceMaxItems.Value;
UniGridExportHelper.CurrentPageOnly = false;
}
}
UniGridExportHelper.UseGridFilter = chkUseGridFilter.Checked;
// Get order by clause from correct control
if (MembershipContext.AuthenticatedUser.IsGlobalAdministrator)
{
UniGridExportHelper.OrderBy = TrimExtendedTextAreaValue(txtOrderBy.Text);
}
else
{
UniGridExportHelper.OrderBy = ValidationHelper.GetString(orderByElem.Value, null);
}
UniGridExportHelper.WhereCondition = TrimExtendedTextAreaValue(txtWhereCondition.Text);
UniGridExportHelper.Columns = GetSelectedColumns();
if (IsCMSDesk)
{
UniGridExportHelper.SiteName = SiteContext.CurrentSiteName;
}
UniGridExportHelper.ExportData(format, Page.Response);
}
/// <summary>
/// Export handler.
/// </summary>
protected void lnkExportToExcel_Click(object sender, EventArgs e)
{
UniGridExportHelper export = new UniGridExportHelper(gridValidationResult);
export.ExportRawData = false;
export.GenerateHeader = true;
export.FileName = ValidationHelper.GetSafeFileName("HTMLValidation_" + ((Node != null) ? Node.DocumentNamePath : Url) + "_" + DateTime.Now.ToString()).Replace(" ", "_");
export.ExportData(DataExportFormatEnum.XLSX, Page.Response);
}