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