// GET: DashboardFilter/DashboardCompany public string DashboardCompany(DashboardFilter aInfo) { try { var userId = Session["UserId"].ToString(); if (true) { _aDashboardMultiFilterHandler = new DashboardMultiFilterHandler(); var data = _aDashboardMultiFilterHandler.GetMpCompanies(userId, aInfo); TempData["FilterData"] = data; return(JsonConvert.SerializeObject(data)); } } catch (Exception ex) { return(ex.Message); } }
public ActionResult GetExportToExcell(DashboardFilter aInfo) { try { DataTable data; if (TempData["FilterData"] == null) { var userId = Session["UserId"].ToString(); data = _aDashboardMultiFilterHandler.GetMpCompanies(userId, aInfo); } else { data = TempData["FilterData"] as DataTable; } var fileName = "MP_Filtered_Data_" + DateTime.Now.ToString("yyyy_dd_M_HH_mm_ss") + ".xls"; var gv = new GridView { DataSource = data }; gv.DataBind(); Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment; filename=" + fileName); Response.ContentType = "application/ms-excel"; Response.Charset = ""; var sw = new StringWriter(); var htw = new HtmlTextWriter(sw); gv.RenderControl(htw); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); return(View("MpBudgetOnroll")); } catch (Exception ex) { throw new HttpException(404, "Not found"); } }