public IActionResult OrderSummaryExport(OrderExportViewModel exportViewModel)
{
List <OrderHeader> orderHeaderList = _db.OrderHeader
.Where(o => o.OrderDate >= exportViewModel.startDate && o.OrderDate <= exportViewModel.endDate)
.OrderByDescending(u => u.OrderDate).ToList();
List <OrderDetails> orderDetails = new List <OrderDetails>();
foreach (var item in orderHeaderList)
{
orderDetails.AddRange(_db.OrderDetails.Where(o => o.OrderId == item.Id).ToList());
}
byte[] bytes = Encoding.ASCII.GetBytes(ConvertToString(orderDetails));
return(File(bytes, "application/text", "OrderDetail.csv"));
}
public IActionResult OrderSummaryExport(OrderExportViewModel orderExportVM)
{
List <OrderHeader> OrderHeaderList = _db.orderHeader.Where(o => o.OrderDate >= orderExportVM.startDate && o.OrderDate <= orderExportVM.endDate).ToList();
List <OrderDetails> OrderDetailList = new List <OrderDetails>();
List <OrderDetails> IndividualOrderList = new List <OrderDetails>();
foreach (var OrderHeader in OrderHeaderList)
{
IndividualOrderList = _db.orderDetails.Where(o => o.OrderId == OrderHeader.Id).ToList();
foreach (var individualOrder in IndividualOrderList)
{
OrderDetailList.Add(individualOrder);
}
}
byte[] bytes = Encoding.ASCII.GetBytes(ConvertToString(OrderDetailList));
return(File(bytes, "application/text", "OrderDetail.csv"));
}
public IActionResult OrderSummaryReport(OrderExportViewModel orderExportVM)
{
List <OrderHeader> orderHeadersList = _context.OrderHeaders.Where(c => c.OrderDate >= orderExportVM.startDate && c.OrderDate
<= orderExportVM.endDate).ToList();
List <OrderDetails> orderDetailsList = new List <OrderDetails>();
List <OrderDetails> IndividualorderDetailsList = new List <OrderDetails>();
foreach (var orderHeader in orderHeadersList)
{
IndividualorderDetailsList = _context.OrderDetails.Where(c => c.OrderId == orderHeader.Id).ToList();
foreach (var individualOrder in IndividualorderDetailsList)
{
orderDetailsList.Add(individualOrder);
}
}
byte[] bytes = Encoding.ASCII.GetBytes(ConvertToString(orderDetailsList));
return(File(bytes, "application/text", "Orderdetail.csv"));
}
