So, this is quite simple example.
Controller:
public ActionResult Index()
{
using (var db = new BilijonEntities())
{
userscontext = new ApplicationDbContext();
UserId = System.Web.HttpContext.Current.User.Identity.GetUserId();
var userStore = new UserStore<ApplicationUser>(userscontext);
var userManager = new UserManager<ApplicationUser>(userStore);
var evidencija = from e in db.Evidencija
join u in db.AspNetUsers on e.DjelatId equals u.Id
join p in db.Proizvod on e.ProizvodID equals p.ProizvodID
join pg in db.ProizvodGrupa on p.GrupaID equals pg.GrupaID
join st in db.Stranka on e.StrankaID equals st.StrankaID
join s in db.AspNetUsers on e.SuradID equals s.Id into sur
from surad in sur.DefaultIfEmpty()
join pol in db.Polica on e.EvidID equals pol.EvidID into pol1
from pol2 in pol1.DefaultIfEmpty()
orderby e.Datum descending
select new
{
e.EvidID,
e.EvidBroj,
e.Datum,
Stranka = st.Prezime + ", " + st.Ime,
Djelatnik = u.Prezime + " " + u.Ime,
Suradnik = surad.Prezime + " " + surad.Ime,
ProizvodNaziv = pg.Naziv + " - " + p.Naziv,
UserId = u.Id,
BrojPolice = pol2.BrojPolice
};
if (!userManager.IsInRole(UserId, "Administrator"))
{
evidencija = evidencija.Where(e => e.UserId == UserId);
}
ViewBag.dsEvidencija = evidencija.ToList();
return View();
}
}
[ValidateInput(false)]
public void ExportToExcel(string GridModel)
{
ExcelExport exp = new ExcelExport();
GridProperties obj = ConvertGridObject(GridModel);
exp.Export(obj, (IEnumerable)obj.DataSource, "Export.xlsx", ExcelVersion.Excel2010, false, false, "flat-saffron");
}
private GridProperties ConvertGridObject(string gridProperty)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
IEnumerable div = (IEnumerable)serializer.Deserialize(gridProperty, typeof(IEnumerable));
GridProperties gridProp = new GridProperties();
foreach (KeyValuePair<string, object> datasource in div)
{
var property = gridProp.GetType()
.GetProperty(datasource.Key, BindingFlags.Instance | BindingFlags.Public | BindingFlags.IgnoreCase);
if (property != null)
{
Type type = property.PropertyType;
string serialize = serializer.Serialize(datasource.Value);
object value = serializer.Deserialize(serialize, type);
property.SetValue(gridProp, value, null);
}
}
return gridProp;
}
View:
@(Html.EJ().Grid<object>("gridEvid")
.Datasource((IEnumerable<object>)ViewBag.dsEvidencija)
.AllowPaging()
.ToolbarSettings(toolbar =>
{
toolbar.ShowToolbar().ToolbarItems(items =>
{
items.AddTool(ToolBarItems.ExcelExport);
items.AddTool(ToolBarItems.Search);
});
})
.EnableRowHover(false)
.AllowSelection(false)
.IsResponsive(true)
.Locale("hr-HR")
.AllowSorting(true)
.AllowFiltering(true)
.EnableTouch(true)
.FilterSettings(filter => { filter.FilterType(FilterType.Excel); })
.Columns(col =>
{
col.Field("EvidID").HeaderText("EvidID").IsPrimaryKey(true).Add();
col.Field("EvidBroj").HeaderText("Broj").Width(55).Add();
col.Field("UserId").HeaderText("UserId").Width(75).Priority(3).Add();
}).ClientSideEvents(ev => ev.Load("load"))
)
function load(args) {
toastr.info("Učitavam...", "Grid");
this.ignoreOnExport.splice(this.ignoreOnExport.indexOf('dataSource'), 1);
}
But when I want to export
Any ideas how to solve this?
I tried to load only those three columns in the dsEvidencija but with the same error.
Thanks!
Bernard.
