public IActionResult DealerSaleLists(DealerSaleListViewModel DealerSaleListViewModel)
{
ViewBag.WarehouseList = _context.Warehouse.ToList();
int? orderId = DealerSaleListViewModel.OrderId;
int? warehouseId = DealerSaleListViewModel.WarehouseID;
DateTime?fromDate = DealerSaleListViewModel.FromDate;
DateTime?toDate = DealerSaleListViewModel.ToDate;
var DealerSaleList = _context.DealerSale.AsEnumerable()
.Join(_context.Dealer, ds => ds.DealerId, d => d.Id, (ds, d) => new { ds, d })
.Select(s => new DealerSale
{
Id = s.ds.Id,
DealerName = s.d.Name,
OrderNo = s.ds.OrderNo,
createDate = s.ds.createDate,
WarehouseId = s.ds.WarehouseId,
payableTotal = s.ds.payableTotal,
Due = s.ds.Due
}).Where(w => (orderId == null || w.Id == orderId) && (warehouseId == null || w.WarehouseId == warehouseId) && (fromDate == null || w.createDate.Date >= fromDate) && (toDate == null || w.createDate.Date <= toDate)).ToList();
var DlrSaleListViewModel = new DealerSaleListViewModel();
DlrSaleListViewModel.DealerSalesList = DealerSaleList;
return(View(DlrSaleListViewModel));
}
public IActionResult DealerSaleLists()
{
ViewBag.WarehouseList = _context.Warehouse.ToList();
var DealerSaleListViewModel = new DealerSaleListViewModel();
var DealerSaleList = _context.DealerSale.AsEnumerable()
.Join(_context.Dealer, ds => ds.DealerId, d => d.Id, (ds, d) => new { ds, d })
.Select(s => new DealerSale
{
DealerName = s.d.Name,
OrderNo = s.ds.OrderNo,
createDate = s.ds.createDate,
payableTotal = s.ds.payableTotal,
Due = s.ds.Due
}).ToList();
DealerSaleListViewModel.DealerSalesList = DealerSaleList;
return(View(DealerSaleListViewModel));
}
