public IQueryable <OrderDto> GetAllOrder()
{
var result = from po in _purchaseOrder.GetAll()
select new OrderDto()
{
OrderId = po.PurchaseOrderID,
DateCreated = po.DateCreated,
CreatedBy = po.CreatedBy
};
return(result);
}
public IQueryable <BatchInventoryLogDto> GetAllBatchInventory()
{
var result = from batchLogs in _batchInventoryLog.GetAll()
select new BatchInventoryLogDto()
{
BatchInventoryId = batchLogs.BatchInventoryId,
FileName = batchLogs.FileName,
CreatedBy = batchLogs.CreatedBy,
DateCreated = batchLogs.DateCreated,
ResultMessage = batchLogs.ResultMessage
};
return(result);
}
public IQueryable <ReportSalesOrderDto> GetAllSalesOrderReport()
{
var products = _inventoryService.GetAll();
var customers = _customerService.GetAll();
var result = from sOrder in _salesOrder.GetAll()
select new ReportSalesOrderDto()
{
SalesOrderId = sOrder.SalesOrderID,
SalesNo = sOrder.SalesNo,
CustomerId = sOrder.CustomerID,
customer = customers.Where(s => s.CustomerId == sOrder.CustomerID).FirstOrDefault(),
IsPrinted = sOrder.IsPrinted,
IsCorrected = sOrder.IsCorrected,
DateCreated = sOrder.DateCreated,
TotalSalesPrice = sOrder.SalesOrderDetails.Where(s => s.SalesOrderID == sOrder.SalesOrderID).Sum(s => s.SalesPrice),
TotalNumberItems = sOrder.SalesOrderDetails.Where(s => s.SalesOrderID == sOrder.SalesOrderID).Count(),
TotalQuantity = sOrder.SalesOrderDetails.Where(s => s.SalesOrderID == sOrder.SalesOrderID).Sum(s => s.Quantity)
};
return(result);
}
public IQueryable <SalesOrderListDto> GetAllSalesOrderDetail(long salesOrderId)
{
var products = _inventoryService.GetAll();
var result = from sOrderDetail in _salesOrderDetail.GetAll().Where(so => so.SalesOrderID == salesOrderId)
select new SalesOrderListDto()
{
SalesOrderId = salesOrderId,
ProductId = sOrderDetail.ProductID,
product = products.Where(p => p.ProductId == sOrderDetail.ProductID).FirstOrDefault(),
SalesPrice = sOrderDetail.SalesPrice,
Quantity = sOrderDetail.Quantity,
DateCreated = sOrderDetail.DateCreated,
UnitPrice = sOrderDetail.UnitPrice
};
return(result);
}