public ActionResult ViewAllAccount() { CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData(); List <AccountSearch> clist = obj.viewALLAccount(); return(View(clist)); }
public void DownloadExcelAllAccount() { CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData(); List <AccountSearch> clist = obj.viewALLAccount(); WebGrid grid = new WebGrid(source: clist); string gridData = grid.GetHtml(columns: grid.Columns( grid.Column("AccountID", "Account ID"), grid.Column("Customer_Id", "Customer ID"), grid.Column("AccountType", "Account Type"), grid.Column("account_status", "Status"), grid.Column("account_message", "Message"), grid.Column("update_date", "Last Updated(mm-dd-yyyy)") )).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=accountexcel.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }