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();
}
