Hi,
This is a sample where "data" parameter is not empty but the download window does not apprea.
Here is the Controller:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using POCO;
using Microsoft.Practices.Unity;
using BusinessCrud;
using Ext.Net.MVC;
using System.Reflection;
using Services.InstanceManager;
using System.Collections;
using Ext.Net;
using System.Xml.Linq;
using ViewEngine;
using System.Data.Common;
using System.Data;
using System.Web.Script.Serialization;
using Newtonsoft.Json;
using System.Xml.Xsl;
using System.Xml;
using System.IO;
using System.Text;
using System.Xml.XPath;
using Services.SQLRequestManager;
namespace Presentation.Controllers
{
public class ConsumerController : Controller
{
//
// GET: /Consumer/
public ActionResult Index()
{
return View();
}
[HttpGet]
public ActionResult Search()
{
return View();
}
[NonAction]
public GridPanel GenerateGridPnl()
{
GridPanel gridPanel = new GridPanel();
gridPanel.AutoHeight = true;
gridPanel.AutoWidth = true;
gridPanel.TrackMouseOver = true;
gridPanel.ID = "_gridSearch";
gridPanel.Listeners.Command.Fn = "commandHandler";
gridPanel.LoadMask.ShowMask = true;
Store store = new Store();
store.ID = "_store";
store.UseIdConfirmation = true;
store.RemoteSort = true;
HttpProxy httpProxy = new HttpProxy();
httpProxy.Url = "/Consumer/GetData";
store.Proxy.Add(httpProxy);
RecordField recordField = null;
RecordField recordField1 = null;
Parameter limitParameter = null;
Parameter startParameter = null;
Column column = null;
PagingToolbar pagingToolbar = null;
Ext.Net.JsonReader jsonReader = new Ext.Net.JsonReader();
jsonReader.Root = "data";
jsonReader.TotalProperty = "total";
recordField = new RecordField();
recordField1 = new RecordField();
recordField.Name = "counterparty_id";
recordField1.Name = "counterparty_shortname";
jsonReader.Fields.Add(recordField);
jsonReader.Fields.Add(recordField1);
column = new Column();
Column column1 = new Column();
column1.ColumnID = "counterparty_shortname";
column1.DataIndex = "counterparty_shortname";
column1.Header = "counterparty_shortname";
column.ColumnID = "counterparty_id";
column.DataIndex = "counterparty_id";
column.Header = "counterparty_id";
column.Width = 150;
gridPanel.ColumnModel.Columns.Add(column);
gridPanel.ColumnModel.Columns.Add(column1);
RowSelectionModel rowSelection = new RowSelectionModel();
rowSelection.SingleSelect = true;
gridPanel.SelectionModel.Add(rowSelection);
store.Reader.Add(jsonReader);
store.RemotePaging = true;
pagingToolbar = new PagingToolbar();
pagingToolbar.PageSize = 15;
pagingToolbar.AutoWidth = true;
gridPanel.BottomBar.Add(pagingToolbar);
limitParameter = new Parameter();
limitParameter.Name = "limit";
limitParameter.Value = "15";
limitParameter.Mode = ParameterMode.Raw;
startParameter = new Parameter();
startParameter.Name = "start";
startParameter.Value = "0";
startParameter.Mode = ParameterMode.Raw;
store.BaseParams.Add(limitParameter);
store.BaseParams.Add(startParameter);
Toolbar toolbar = new Toolbar();
toolbar.ID = "_toolbar";
toolbar.AutoWidth = true;
ToolbarFill toolbarFill = new ToolbarFill();
toolbarFill.AutoWidth = true;
toolbarFill.ID = "_toolbarFill";
Button excelButton = new Button();
excelButton.Icon = Icon.PageExcel;
excelButton.ID = "_excelButton";
excelButton.Text = "To Excel";
//excelButton.Listeners.Click.Handler = "submitValue(#{_gridSearch},'xls');";
Parameter dataParam = new Parameter();
dataParam.Name = "data";
dataParam.Value = "#{_gridSearch}.getRowsValues()";
dataParam.Mode = ParameterMode.Raw;
dataParam.Encode = true;
Parameter formatXlsParam = new Parameter();
formatXlsParam.Name = "format";
formatXlsParam.Mode = ParameterMode.Value;
formatXlsParam.Value = "xls";
ParameterCollection xlsPrms = new ParameterCollection();
xlsPrms.Add(dataParam);
xlsPrms.Add(formatXlsParam);
excelButton.DirectEvents.Click.IsUpload = true;
excelButton.DirectEvents.Click.Url = "/Consumer/ExportData";
excelButton.DirectEvents.Click.CleanRequest = true;
excelButton.DirectEvents.Click.ExtraParams.AddRange(xlsPrms);
Button csvButton = new Button();
csvButton.Icon = Icon.PageAttach;
csvButton.ID = "_csvButton";
csvButton.Text = "To CSV";
Parameter formatCsvParam = new Parameter();
formatCsvParam.Name = "format";
formatCsvParam.Mode = ParameterMode.Value;
formatCsvParam.Value = "csv";
ParameterCollection csvPrms = new ParameterCollection();
csvPrms.Add(dataParam);
csvPrms.Add(formatCsvParam);
csvButton.DirectEvents.Click.IsUpload = true;
csvButton.DirectEvents.Click.Url = "/Consumer/ExportData";
csvButton.DirectEvents.Click.CleanRequest = true;
csvButton.DirectEvents.Click.ExtraParams.AddRange(csvPrms);
toolbar.Items.Add(excelButton);
toolbar.Items.Add(csvButton);
toolbar.Items.Add(toolbarFill);
gridPanel.TopBar.Add(toolbar);
gridPanel.Store.Add(store);
return gridPanel;
}
public ContentResult LoadSearchResultGridPnl(String containerID)
{
ContentResult cr = new ContentResult();
cr.Content = string.Format("<script>{0}</script>",
GenerateGridPnl()
.ToScript(
RenderMode.AddTo,
containerID));
return cr;
}
public AjaxStoreResult GetData()
{
List<Counterparty> items = new List<Counterparty>();
Counterparty cpty1 = new Counterparty();
cpty1.counterparty_id = 1;
cpty1.counterparty_shortname = "ShortName";
items.Add(cpty1);
Counterparty cpty2 = new Counterparty();
cpty2.counterparty_id = 1;
cpty2.counterparty_shortname = "ShortName";
items.Add(cpty2);
var query = (from q in items
select new
{
q.counterparty_id,
q.counterparty_shortname,
}).ToList();
return new AjaxStoreResult(query);
}
[HttpPost]
public ActionResult ExportData(String data, String format)
{
XslCompiledTransform xt = new XslCompiledTransform();
//string exportWithRoot = string.Format("{{ records: {{ record: {0} }} }}", data);
//XmlNode xml = JsonConvert.DeserializeXmlNode(exportWithRoot);
Ext.Net.SubmitHandler submitData = new Ext.Net.SubmitHandler(data);
XmlNode xml = submitData.Xml;
StringBuilder s = new StringBuilder();
XmlWriterSettings settings = new XmlWriterSettings()
{
ConformanceLevel = ConformanceLevel.Auto
};
XmlWriter writer = null;
FileContentResult result = null;
switch (format)
{
#region Excel
case "xls":
xt.Load(Server.MapPath("~/Resources/xsl/Excel.xsl"));
writer = XmlWriter.Create(s, settings);
xt.Transform(xml, writer);
result = new FileContentResult(Encoding.UTF8.GetBytes(s.ToString()), "application/vnd.ms-excel");
result.FileDownloadName = "Temp.xls";
break;
#endregion
#region CSV
case "csv":
xt.Load(Server.MapPath("~/Resources/xsl/Csv.xsl"));
writer = XmlWriter.Create(s, settings);
xt.Transform(xml, writer);
result = new FileContentResult(Encoding.UTF8.GetBytes(s.ToString()), "application/octet-stream");
result.FileDownloadName = "Temp.csv";
break;
#endregion
case "xml":
result = new FileContentResult(Encoding.UTF8.GetBytes(xml.OuterXml), "application/xml");
result.FileDownloadName = string.Format("Temp.xml");
return result;
}
return result;
}
}
}
Here is the partial view that holds the GridPanel:
<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl<dynamic>" %>
<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
<ext:Panel ID="_gridPnlCpty" Border="false" Header="false" runat="server" AutoHeight="true"
Layout="FitLayout">
<AutoLoad Url="/Consumer/LoadSearchResultGridPnl">
<Params>
<ext:Parameter Name="containerID" Value="#{_gridPnlCpty}" Mode="Value" />
</Params>
</AutoLoad>
</ext:Panel>
Hope this helps and thank you.
Originally Posted by Daniil
Posting Permissions
| Frameworks and Tools for .NET Developers