public ActionResult ExporttoExcel() { var customerdata = ManageCustomerService.ManageEvents(0, Convert.ToString(TempData["SearchTitle"])); List <ManageEventModel> ManageEventModel = new List <Models.ManageEventModel>(); foreach (var item in customerdata) { var model = new ManageEventModel(); model.CustomerName = item.Name; model.EventName = item.EventName; model.EventStartDate = item.EventStartDate; model.EventEndDate = item.EventEndDate; model.RegisteredUser = item.TotalCount; model.ReferredUser = item.ReferredUsers; ManageEventModel.Add(model); } GridView gv = new GridView(); gv.DataSource = ManageEventModel; gv.DataBind(); Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment; filename=ManageEvent.xls"); Response.ContentType = "application/ms-excel"; Response.Charset = ""; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); gv.RenderControl(htw); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); return(RedirectToAction("Index")); }
private IEnumerable GetData(int SearchRecords, string SearchTitle, string Alpha) { SearchTitle = SearchTitle.Trim().ToLower(); Alpha = Alpha.Trim().ToLower(); List <ManageEventModel> Customerlist = new List <ManageEventModel>(); var customerdata = ManageCustomerService.ManageEvents(0, SearchTitle); foreach (var data in customerdata) { ManageEventModel model = new ManageEventModel(); model.CustomerName = data.Name; model.EventName = data.EventName; model.EventStartDate = data.EventStartDate; model.EventEndDate = data.EventEndDate; model.RegisteredUser = data.TotalCount; model.ReferredUser = data.ReferredUsers; Customerlist.Add(model); } return(Customerlist); }