public ActionResult ExporttoExcel()
{
var exportuserdetails = (from data2 in db.GetTransactionsDetails(0, Convert.ToInt32(Session["CustomerId"]), "", Convert.ToString(TempData["status"]))
select new TransactionsModel
{
CustomerId = data2.CustomerId,
Amount = Convert.ToInt32(data2.Amount.Value),
TransactionDate = data2.TransactionDate,
TransactionType = data2.TransactionType,
status = data2.status,
TransactionId = data2.Id
//PaymentMethod = data2.PaymentMethod
}).ToList();
List <ExportDetailsModel> ExportUserDetailsModel = new List <Models.ExportDetailsModel>();
foreach (var item in exportuserdetails)
{
var model = new ExportDetailsModel();
//model.CustomerId = item.CustomerId;
model.Amount = item.Amount;
model.TransactionDate = item.TransactionDate.ToString("dd-MMM-yyyy");
model.status = item.status;
//model.PaymentMethod = item.PaymentMethod;
model.TransactionType = item.TransactionType;
//model.CustomerId = item.Id;
model.TransactionNumber = item.TransactionId;
ExportUserDetailsModel.Add(model);
}
GridView gv = new GridView();
gv.DataSource = ExportUserDetailsModel;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=TransactionsDetails.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"));
}
public static IEnumerable <GetTransactionsDetails_Result> UserTransactionDetails(int Id, int SearchRecords, int CustomerId, string transactiontype, string status)
{
transactiontype = transactiontype.Trim().ToLower();
status = status.Trim().ToLower();
var RtnData = (from data2 in db.GetTransactionsDetails(Id, CustomerId, transactiontype, status)
select data2);
return(RtnData);
}