public IEnumerable <BloodworksLabelViewModel> GetBloodworksLabel(long eventId) { var eventCustomers = _eventCustomerRepository.GetbyEventId(eventId); eventCustomers = eventCustomers.Where(ec => ec.AppointmentId.HasValue).Select(ec => ec); if (eventCustomers.IsNullOrEmpty()) { return(null); } var orderIdEventCustomerIdPairs = _orderRepository.GetOrderEventCustomerIdPairforEventCustomerIds(eventCustomers.Select(ec => ec.Id).ToArray()).ToArray(); var orderIdEventTestIdPairs = _eventTestRepository.GetEventTestIdForOrders(orderIdEventCustomerIdPairs.Select(pair => pair.FirstValue).ToArray()).ToArray(); var eventTests = _eventTestRepository.GetbyIds(orderIdEventTestIdPairs.Select(pair => pair.SecondValue).ToArray()); var eventTestIds = eventTests.Where(et => et.TestId == (long)TestType.Liver || et.TestId == (long)TestType.Lipid).Select(et => et.Id).ToArray(); var eventCustomerIdsFromTest = (from oet in orderIdEventTestIdPairs join oec in orderIdEventCustomerIdPairs on oet.FirstValue equals oec.FirstValue where eventTestIds.Contains(oet.SecondValue) select oec.SecondValue).ToArray(); var orderIdEventPackageIdPairs = _eventPackageRepository.GetEventPackageIdsForOrder(orderIdEventCustomerIdPairs.Select(pair => pair.FirstValue).ToArray()); var eventPackages = _eventPackageRepository.GetByIds(orderIdEventPackageIdPairs.Select(pair => pair.SecondValue).ToArray()).ToArray(); var eventPackageIds = eventPackages.Where(ep => ep.Tests.Where(t => t.TestId == (long)TestType.Liver || t.TestId == (long)TestType.Lipid || t.TestId == (long)TestType.Crp || t.TestId == (long)TestType.Thyroid || t.TestId == (long)TestType.Psa || t.TestId == (long)TestType.Testosterone).Count() > 0).Select(ep => ep.Id).ToArray(); var eventCustomerIdsFromPackage = (from oep in orderIdEventPackageIdPairs join oec in orderIdEventCustomerIdPairs on oep.FirstValue equals oec.FirstValue where eventPackageIds.Contains(oep.SecondValue) select oec.SecondValue).ToArray(); eventCustomers = eventCustomers.Where( ec => eventCustomerIdsFromTest.Contains(ec.Id) || eventCustomerIdsFromPackage.Contains(ec.Id)). Select(ec => ec).ToArray(); var customers = _customerRepository.GetCustomers(eventCustomers.Select(ec => ec.CustomerId).ToArray()); var eventData = _eventRepository.GetById(eventId); return(_bloodworksLabelViewModelFactory.Create(customers, eventData)); }
public void GetbyIds_ValidId_Tester() { var eventPackages = _eventPackageRepository.GetByIds(new long[] { 73563, 73562 }); Assert.IsNotNull(eventPackages); Assert.IsNotEmpty(eventPackages.ToArray()); var eventPackageIds = eventPackages.Select(ep => ep.Id).ToArray(); var packageIds = eventPackages.Select(ep => ep.PackageId).ToArray(); var eventIds = eventPackages.Select(ep => ep.EventId).ToArray(); Assert.IsTrue(eventPackageIds.Contains(73563)); Assert.IsTrue(eventPackageIds.Contains(73562)); Assert.IsTrue(packageIds.Contains(124)); Assert.IsTrue(packageIds.Contains(107)); Assert.IsTrue(eventIds.Contains(24759)); Assert.IsNotNull(eventPackages.First().Tests); Assert.IsNotEmpty(eventPackages.First().Tests.ToArray()); }
public IEnumerable <EventCusomerAdjustOrderViewModel> MarkcustomerForAdjustOrder(CorporateCustomerEditModel model, IEnumerable <EventCustomer> eventCustomers, long createdByOrgRoleUserId, long customerId, long?corporateUploadId) { var pairs = TestType.A1C.GetNameValuePairs(); var preApprovedTestIds = model.PreApprovedTest.IsNullOrEmpty() ? new long[0] : pairs.Where(x => model.PreApprovedTest.Contains(x.SecondValue.ToLower())).Select(x => (long)x.FirstValue).ToArray(); preApprovedTestIds = _corporateUploadHelper.RemoveFocFromPreApprovedTest(preApprovedTestIds.ToList()).ToArray(); var eventIds = eventCustomers.Select(x => x.EventId); var events = ((IUniqueItemRepository <Event>)_eventRepository).GetByIds(eventIds); var orders = _orderRepository.GetAllOrdersByEventCustomerIds(eventCustomers.Select(x => x.Id)); var orderIds = orders.Select(o => o.Id).ToArray(); var orderEventPackageIdPairs = _eventPackageRepository.GetEventPackageIdsForOrder(orderIds); // orderId, EventPackaegId var eventPacakageTestIds = _eventPackageRepository.GetOrderIdEventPackageTestIdPairsForOrder(orderIds); //orderId, TestId(package test) var orderIdTestIdPairs = _eventTestRepository.GetOrderIdTestIdPairsForOrders(orderIds); // orderId, TestId var eventPackageIds = orderEventPackageIdPairs.Select(pair => pair.SecondValue).ToArray(); var eventPackages = _eventPackageRepository.GetByIds(eventPackageIds).ToArray(); var list = new List <EventCusomerAdjustOrderViewModel>(); foreach (var eventCustomer in eventCustomers) { var order = orders.FirstOrDefault(x => x.CustomerId == eventCustomer.CustomerId && x.EventId == eventCustomer.EventId); if (order == null) { continue; } var theEvent = events.First(s => s.Id == eventCustomer.EventId); var eventPackagePair = orderEventPackageIdPairs.FirstOrDefault(x => x.FirstValue == order.Id); var preApprovedPackageUpdated = IsPreApprovedPackageUpdated(eventPackagePair, eventPackages, order, model.PreApprovedPackageId); var testIdInPackage = new List <long>(); if (eventPackagePair != null) { testIdInPackage = eventPacakageTestIds.Where(x => x.FirstValue == eventPackagePair.FirstValue).Select(s => s.SecondValue).ToList(); } var preApprovedTestNotInOrder = PreApprovedTestUpdated(orderIdTestIdPairs, order, preApprovedTestIds, testIdInPackage); var preApprovedTestToUpdate = string.Empty; if (preApprovedTestNotInOrder != null) { preApprovedTestToUpdate = string.Join(",", preApprovedTestNotInOrder.Select(x => ((TestType)x).ToString())); } if (preApprovedPackageUpdated || !preApprovedTestNotInOrder.IsNullOrEmpty()) { list.Add(new EventCusomerAdjustOrderViewModel { CustomerId = eventCustomer.CustomerId, EventId = eventCustomer.EventId, FirstName = model.FirstName, MiddleName = model.MiddleName, LastName = model.LastName, MemberId = model.MemberId, EventDate = theEvent.EventDate, PreApprovedPackageToAdjust = preApprovedPackageUpdated ? model.PreApprovedPackage : string.Empty, PreApprovedTestsToAdjust = preApprovedTestToUpdate }); long newPackageId = 0; long oldPackageId = 0; if (preApprovedPackageUpdated) { newPackageId = model.PreApprovedPackageId; } if (eventPackagePair != null) { var package = eventPackages.First(x => x.Id == eventPackagePair.SecondValue).Package; oldPackageId = package.Id; } var orderedTestIds = orderIdTestIdPairs.Where(x => x.FirstValue == order.Id).Select(x => x.SecondValue); AdjustCustomerOrder(eventCustomer, order, newPackageId, oldPackageId, createdByOrgRoleUserId, customerId, orderedTestIds, preApprovedTestIds, testIdInPackage, corporateUploadId.HasValue ? corporateUploadId.Value : 0); } } return(list.IsNullOrEmpty() ? null : list); }