public ActionResult ExporttoExcel() { var customerdata = ManageCustomerService.CustomerDetails(0, ""); List <ExportManageUserModel> ExportManageUserModel = new List <Models.ExportManageUserModel>(); foreach (var item in customerdata) { var model = new ExportManageUserModel(); model.CustomerNo = item.CustomerId; model.CustomerName = item.FirstName + item.LastName; model.Email = item.Email; model.DateofRegistration = item.Date_of_Registration; model.AvailableCredits = item.Availablecredits; model.NoOfEvents = item.No_of_events; ExportManageUserModel.Add(model); } GridView gv = new GridView(); gv.DataSource = ExportManageUserModel; gv.DataBind(); Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment; filename=ManageUser.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 <CustomerModel> Customerlist = new List <CustomerModel>(); var customerdata = ManageCustomerService.CustomerDetails(0, Alpha); foreach (var data in customerdata) { CustomerModel model = new CustomerModel(); model.CustomerId = data.CustomerId; model.FirstName = data.FirstName; model.LastName = data.LastName; model.Email = data.Email; model.Contactno = data.Contactno; model.Username = data.Username; model.Password = data.Password; model.CompanyName = data.CompanyName; model.Date_of_Registration = data.Date_of_Registration; model.NoOfEvents = data.No_of_events.Value; model.AvailableCredits = data.Availablecredits.Value; Customerlist.Add(model); } return(Customerlist); }