public async Task <IActionResult> DownloadOrderDetailsPost(DownloadOrderDetailsViewModel downloadOrderDetailsVM) { var orders = await _db.OrderHeader.Where(o => o.OrderDate >= downloadOrderDetailsVM.FromDate && o.OrderDate <= downloadOrderDetailsVM.ToDate) .ToListAsync(); var csv = string.Join(Environment.NewLine, orders.Select(o => $"\"{o.Id}\",\"{o.OrderDate}\",\"{o.OrderTotal}\",\"{o.Status}\"").ToList()); return(File(Encoding.ASCII.GetBytes(csv), "text/csv", "OrderDetails.csv")); }
public async Task <IActionResult> DownloadOrderDetails() { var downloadOrderDetailsViewModel = new DownloadOrderDetailsViewModel { FromDate = DateTime.Today.AddDays(-7), ToDate = DateTime.Today.AddDays(1).AddMinutes(-1) }; return(View(downloadOrderDetailsViewModel)); }