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); }