public ActionResult viewAccountStatement(int Temp_id, int Cycle) { CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData(); List <AccountSearch> list = obj.viewAccountStatement(Temp_id, Cycle); Session["id"] = Temp_id; Session["Cycle"] = Cycle; if (list == null) { return(RedirectToAction("Exception")); } return(View(list)); }
public void DownloadExcelAccountStatement() { CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData(); List <AccountSearch> list = obj.viewAccountStatement(Convert.ToInt32(Session["id"]), Convert.ToInt32(Session["Cycle"])); WebGrid grid = new WebGrid(source: list); string gridData = grid.GetHtml(columns: grid.Columns( grid.Column("TransactionID", "Transaction ID"), grid.Column("TransactionDescription", "Description"), grid.Column("TransactionDate", "Date(mm-dd-yyyy)"), grid.Column("TransactionAmount", "Amount(INR)") )).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=AccountStatementexcel.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }