public void GenerateDisplayTable(ISearchService indexSearchService, IRepositoryFactory repositoryFactory,IWorkgroupService workgroupService, int workgroupId, DateTime month) { Check.Require(month.Day == 1); var endMonth = month.AddMonths(1); var workgroup = repositoryFactory.WorkgroupRepository.Queryable.Single(a => a.Id == workgroupId); var allChildWorkgroups = new List<int>(); allChildWorkgroups.Add(workgroupId); if (workgroup.Administrative) { allChildWorkgroups = workgroupService.GetChildWorkgroups(workgroupId); } Columns = new List<ReportProcessingColumns>(); var workgroups = repositoryFactory.WorkgroupRepository.Queryable.Where(a => allChildWorkgroups.Contains(a.Id)).ToList(); var matchingOrders = indexSearchService.GetOrdersByWorkgroups(workgroups, month, endMonth); foreach (var matchingOrder in matchingOrders.Where(a => a.IsComplete && a.StatusId != OrderStatusCode.Codes.Denied && a.StatusId != OrderStatusCode.Codes.Cancelled)) { var column = new ReportProcessingColumns(); var order = repositoryFactory.OrderRepository.Queryable.Single(a => a.Id == matchingOrder.OrderId); column.Organization = order.Workgroup.PrimaryOrganization.Id; column.Workgroup = order.Workgroup.Name; column.OrderRequestNumber = order.RequestNumber; column.OrderId = order.Id; var orderHistory = order.OrderTrackings.LastOrDefault(a => a.StatusCode.Id == OrderStatusCode.Codes.AccountManager && a.Description.StartsWith("approved")); if (orderHistory != null) { column.ArrivedAtPurchaser = orderHistory.DateCreated; } orderHistory = order.OrderTrackings.LastOrDefault(a => a.Description.StartsWith("rerouted to purchaser")); if (orderHistory != null) { column.ReroutedToPurchaserDate = orderHistory.DateCreated; column.ReRoutedToPurchaserBy = orderHistory.User.FullName; column.ReroutedToPurchaserName = orderHistory.Description.Substring(22); if (column.ArrivedAtPurchaser != null) { column.ReRoutTime = column.ReroutedToPurchaserDate.Value - column.ArrivedAtPurchaser.Value; } } else if(OnlyShowReRouted) { continue; } orderHistory = order.OrderTrackings.FirstOrDefault(a => a.StatusCode.IsComplete); if (orderHistory != null) { column.CompletedByPurchaserDate = orderHistory.DateCreated; column.CompletedByPurchaserName = orderHistory.User.FullName; if (column.ArrivedAtPurchaser != null && column.ReroutedToPurchaserDate != null) { column.CompletionTime = column.CompletedByPurchaserDate.Value - column.ReroutedToPurchaserDate.Value; } else if (column.ArrivedAtPurchaser != null && column.ReroutedToPurchaserDate == null) { column.CompletionTime = column.CompletedByPurchaserDate.Value - column.ArrivedAtPurchaser.Value; } } Columns.Add(column); } }
public void GenerateDisplayTable(ISearchService indexSearchService, IRepositoryFactory repositoryFactory, IWorkgroupService workgroupService, int workgroupId, DateTime month) { const int defaultResultSize = 1000; Check.Require(month.Day == 1); var endMonth = month.AddMonths(1); var workgroup = repositoryFactory.WorkgroupRepository.Queryable.Single(a => a.Id == workgroupId); var allChildWorkgroups = new List <int>(); allChildWorkgroups.Add(workgroupId); if (workgroup.Administrative) { allChildWorkgroups = workgroupService.GetChildWorkgroups(workgroupId); } Columns = new List <ReportProcessingColumns>(); var workgroups = repositoryFactory.WorkgroupRepository.Queryable.Where(a => allChildWorkgroups.Contains(a.Id)).ToList(); var matchingOrders = indexSearchService.GetOrdersByWorkgroups(workgroups, month, endMonth, defaultResultSize); SearchResultsCount = matchingOrders.Count; foreach (var matchingOrder in matchingOrders.Where(a => a.IsComplete && a.StatusId != OrderStatusCode.Codes.Denied && a.StatusId != OrderStatusCode.Codes.Cancelled)) { var column = new ReportProcessingColumns(); var order = repositoryFactory.OrderRepository.Queryable.Single(a => a.Id == matchingOrder.OrderId); column.Organization = order.Workgroup.PrimaryOrganization.Id; column.Workgroup = order.Workgroup.Name; column.OrderRequestNumber = order.RequestNumber; column.OrderId = order.Id; var orderHistory = order.OrderTrackings.LastOrDefault(a => a.StatusCode.Id == OrderStatusCode.Codes.AccountManager && a.Description.StartsWith("approved")); if (orderHistory != null) { column.ArrivedAtPurchaser = orderHistory.DateCreated; } orderHistory = order.OrderTrackings.LastOrDefault(a => a.Description.StartsWith("rerouted to purchaser")); if (orderHistory != null) { column.ReroutedToPurchaserDate = orderHistory.DateCreated; column.ReRoutedToPurchaserBy = orderHistory.User.FullName; column.ReroutedToPurchaserName = orderHistory.Description.Substring(22); if (column.ArrivedAtPurchaser != null) { column.ReRoutTime = column.ReroutedToPurchaserDate.Value - column.ArrivedAtPurchaser.Value; } } else if (OnlyShowReRouted) { continue; } orderHistory = order.OrderTrackings.FirstOrDefault(a => a.StatusCode.IsComplete); if (orderHistory != null) { column.CompletedByPurchaserDate = orderHistory.DateCreated; column.CompletedByPurchaserName = orderHistory.User.FullName; if (column.ArrivedAtPurchaser != null && column.ReroutedToPurchaserDate != null) { column.CompletionTime = column.CompletedByPurchaserDate.Value - column.ReroutedToPurchaserDate.Value; } else if (column.ArrivedAtPurchaser != null && column.ReroutedToPurchaserDate == null) { column.CompletionTime = column.CompletedByPurchaserDate.Value - column.ArrivedAtPurchaser.Value; } } Columns.Add(column); } }