public HospitalPartnerNotScheduledOutcomeViewModel GetHospitalFacilityNotScheduledOutcome(long hospitalFacilityId, int abnormalCustomers, int criticalCustomers, int urgentCustomers)
{
using (var t = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions {
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
var hospitalPartnerId = _hospitalFacilityRepository.GetHospitalPartnerId(hospitalFacilityId);
HospitalPartner hospitalPartner = null;
if (hospitalPartnerId > 0)
{
hospitalPartner = _hospitalPartnerRepository.GetHospitalPartnerforaVendor(hospitalPartnerId);
}
var eventIds = _hospitalFacilityRepository.GetEventIdsForHospitalFacility(hospitalFacilityId);
if (eventIds.IsNullOrEmpty())
{
return(null);
}
var hospitalPartnerCustomers = new List <HospitalPartnerCustomer>();
hospitalPartnerCustomers.AddRange(_hospitalPartnerCustomerRepository.GetHospitalFacilityCustomersByHospitalFacilityId(hospitalFacilityId, ResultInterpretation.Abnormal, hospitalPartner != null ? hospitalPartner.AbnormalResultValidityPeriod : 0));
hospitalPartnerCustomers.AddRange(_hospitalPartnerCustomerRepository.GetHospitalFacilityCustomersByHospitalFacilityIdForCritical(hospitalFacilityId, ResultInterpretation.Critical, hospitalPartner != null ? hospitalPartner.CriticalResultValidityPeriod : 0));
hospitalPartnerCustomers.AddRange(_hospitalPartnerCustomerRepository.GetHospitalFacilityCustomersByHospitalFacilityId(hospitalFacilityId, ResultInterpretation.Urgent, hospitalPartner != null ? hospitalPartner.CriticalResultValidityPeriod : 0));
t.Complete();
return(_hospitalPartnerViewModelFactory.CreateNotScheduledOutcome(abnormalCustomers, criticalCustomers, urgentCustomers, hospitalPartnerCustomers));
}
}
public void MapMapsEntityNameToAssociatedMedicalVendorBusinessName()
{
const string expectedName = "Hospital Partner Name";
var hospitalPartnerEntity = GetValidHospitalPartnerEntity(0, expectedName);
HospitalPartner hospitalPartner = _mapper.Map(hospitalPartnerEntity);
Assert.AreEqual(expectedName, hospitalPartner.Name,
"Hospital Partner name was not mapped correctly.");
}
public ListModelBase <HospitalPartnerCustomerViewModel, HospitalPartnerCustomerListModelFilter> GetHospitalPartnerEventCustomers(int pageNumber, int pageSize, ModelFilterBase filter, out int totalRecords)
{
using (var t = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions {
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
var normalValidityPeriod = 0;
var abnormalValidityPeriod = 0;
var criticalValidityPeriod = 0;
var customerFilter = (filter as HospitalPartnerCustomerListModelFilter);
HospitalPartner hospitalPartner = null;
if (customerFilter != null)
{
if (customerFilter.HospitalPartnerId > 0)
{
hospitalPartner = _hospitalPartnerRepository.GetHospitalPartnerforaVendor(customerFilter.HospitalPartnerId);
normalValidityPeriod = hospitalPartner.NormalResultValidityPeriod;
abnormalValidityPeriod = hospitalPartner.AbnormalResultValidityPeriod;
criticalValidityPeriod = hospitalPartner.CriticalResultValidityPeriod;
}
else if (customerFilter.HospitalFacilityId > 0)
{
var hospitalPartnerId = _hospitalFacilityRepository.GetHospitalPartnerId(customerFilter.HospitalFacilityId);
if (hospitalPartnerId > 0)
{
hospitalPartner = _hospitalPartnerRepository.GetHospitalPartnerforaVendor(hospitalPartnerId);
normalValidityPeriod = hospitalPartner.NormalResultValidityPeriod;
abnormalValidityPeriod = hospitalPartner.AbnormalResultValidityPeriod;
criticalValidityPeriod = hospitalPartner.CriticalResultValidityPeriod;
}
}
}
var eventCustomers = _eventCustomerRepository.EventCustomersForHospitalPartner(pageNumber, pageSize, filter as HospitalPartnerCustomerListModelFilter, out totalRecords, normalValidityPeriod, abnormalValidityPeriod, criticalValidityPeriod);
var model = eventCustomers.IsNullOrEmpty() ? null : GetCustomers(eventCustomers, hospitalPartner);
t.Complete();
return(model);
}
}
public ListModelBase <HospitalPartnerCustomerViewModel, HospitalPartnerCustomerListModelFilter> GetCustomerAggregateResultSummary(int pageNumber, int pageSize, ModelFilterBase filter, out int totalRecords)
{
using (var t = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions {
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
var customerFilter = filter as HospitalPartnerCustomerListModelFilter;
var eventCustomers = _eventCustomerRepository.GetEventCustomersForAggregateResultSummary(pageNumber, pageSize, customerFilter, out totalRecords);
HospitalPartner hospitalPartner = null;
if (customerFilter != null && customerFilter.HospitalPartnerId > 0)
{
hospitalPartner = _hospitalPartnerRepository.GetHospitalPartnerforaVendor(customerFilter.HospitalPartnerId);
}
var model = eventCustomers.IsNullOrEmpty() ? null : GetCustomers(eventCustomers, hospitalPartner);
t.Complete();
return(model);
}
}
public HospitalPartnerCustomerListModel Create(IEnumerable <EventCustomer> eventCustomers, IEnumerable <Order> orders, IEnumerable <Customer> customers, IEnumerable <OrderedPair <long, string> > packages, IEnumerable <OrderedPair <long, string> > tests,
IEnumerable <HospitalPartnerCustomer> hospitalPartnerCustomers, IEnumerable <OrderedPair <long, string> > idNamePairs, IEnumerable <Event> events, IEnumerable <ShippingDetail> shippingDetails,
IEnumerable <CustomerResultStatusViewModel> resultStatuses, ShippingOption cdShippingOption, IEnumerable <Pod> pods, IEnumerable <OrderedPair <long, string> > eventHospitalPartnerNamePairs,
IEnumerable <OrderedPair <long, string> > eventIdCorporateAccounrNamePairs, IEnumerable <PrimaryCarePhysician> primaryCarePhysicians, IEnumerable <HealthAssessmentQuestion> healthAssessmentQuestions,
IEnumerable <HealthAssessmentAnswer> healthAssessmentAnswers, IEnumerable <EventCustomerResult> eventCustomerResults, HospitalPartner hospitalPartner, IEnumerable <CustomerCallNotes> notes,
IEnumerable <EventCustomerNotification> eventCustomerNotifications, IEnumerable <EventHospitalPartner> eventHospitalPartners, IEnumerable <OrderedPair <long, string> > eventCustomerIdHospitalFacilityNamePairs,
IEnumerable <HospitalFacility> hospitalFacilities, IEnumerable <long> showScannedDocumentHospitalPartnerIds, IEnumerable <Language> languages)
{
var model = new HospitalPartnerCustomerListModel();
var customerModels = new List <HospitalPartnerCustomerViewModel>();
eventCustomers.ToList().ForEach(ec =>
{
var order = orders.Where(o => o.EventId == ec.EventId && o.CustomerId == ec.CustomerId).FirstOrDefault();
var customer =
customers.Where(c => c.CustomerId == ec.CustomerId).FirstOrDefault();
var package = order == null ? null :
packages.Where(p => p.FirstValue == order.Id).FirstOrDefault();
var test = order == null ? null : tests.Where(p => p.FirstValue == order.Id).ToList();
var productPurchased = string.Empty;
if (package != null && !test.IsNullOrEmpty())
{
productPurchased =
package.SecondValue + " + " + string.Join(" + ", test.Select(t => t.SecondValue).ToArray());
}
else if (!test.IsNullOrEmpty())
{
productPurchased = string.Join(" + ", test.Select(t => t.SecondValue).ToArray());
}
else if (package != null)
{
productPurchased =
package.SecondValue;
}
ShippingDetail shippingDetail = null;
string cdPurhased = "N/A";
if (order != null)
{
var shippingDetailIds = order.OrderDetails.SelectMany(od => od.ShippingDetailOrderDetails.Select(sdod => sdod.ShippingDetailId)).ToArray();
shippingDetail = shippingDetails.Where(sd => shippingDetailIds.Contains(sd.Id) && sd.ShippingOption.Id != (cdShippingOption != null ? cdShippingOption.Id : 0)).FirstOrDefault();
var cdShippingDetail = shippingDetails.Where(sd => shippingDetailIds.Contains(sd.Id) && sd.ShippingOption.Id == (cdShippingOption != null ? cdShippingOption.Id : 0)).FirstOrDefault();
var cdOrderDetail = order.OrderDetails.Where(od => od.IsCompleted && od.DetailType == OrderItemType.ProductItem).ToArray();
if (cdOrderDetail != null && cdOrderDetail.Count() > 0 && cdShippingDetail != null)
{
cdPurhased = "CD";
}
else if (cdOrderDetail != null && cdOrderDetail.Count() > 0 && cdShippingDetail == null)
{
cdPurhased = "Online";
}
}
var isEvaluated = false;
var isPdfGenerated = false;
var evenCustomerResult = eventCustomerResults.Where(ecr => ecr.Id == ec.Id).FirstOrDefault();
var result = "Not Processed";
var recommendation = "Not Processed";
if (evenCustomerResult != null)
{
isEvaluated = true;
isPdfGenerated = evenCustomerResult.IsClinicalFormGenerated && evenCustomerResult.IsResultPdfGenerated;
result = evenCustomerResult.ResultSummary.HasValue ? ((ResultInterpretation)evenCustomerResult.ResultSummary.Value).GetDescription() : "Not Available";
recommendation = evenCustomerResult.PathwayRecommendation.HasValue ? ((PathwayRecommendation)evenCustomerResult.PathwayRecommendation.Value).GetDescription() : "Not Available";
}
HospitalPartnerCustomer hospitalPartnerCustomer = null;
var customerActivities = hospitalPartnerCustomers.Where(hpc => hpc.EventId == ec.EventId && hpc.CustomerId == ec.CustomerId).ToArray();
if (customerActivities.Count() > 0)
{
customerActivities = customerActivities.OrderBy(hpc => hpc.Id).ToArray();
hospitalPartnerCustomer = customerActivities.Last();
}
var care = "N/A";
if (hospitalPartnerCustomer != null)
{
care =
idNamePairs.Where(
cc =>
cc.FirstValue ==
hospitalPartnerCustomer.CareCoordinatorOrgRoleUserId).
First().SecondValue;
}
var resultStatus = resultStatuses != null ? resultStatuses.Where(rs => rs.EventCustomerId == ec.Id).SingleOrDefault() : null;
IEnumerable <OrderedPair <long, string> > pairTestSummary = null;
if (resultStatus != null && resultStatus.TestResults != null)
{
pairTestSummary = resultStatus.TestResults.Select(tr => new OrderedPair <long, string>(tr.TestId, tr.TestInterpretation.HasValue ? ((ResultInterpretation)tr.TestInterpretation.Value).ToString() : ""));
}
var eventData = events.Where(e => e.Id == ec.EventId).FirstOrDefault();
var eventPods =
pods.Where(p => eventData.PodIds.Contains(p.Id)).ToArray();
DateTime?initialCallDate = null;
if (evenCustomerResult != null && evenCustomerResult.ResultState == (int)TestResultStateNumber.ResultDelivered && (hospitalPartnerCustomer == null || ((HospitalPartnerCustomerStatus)hospitalPartnerCustomer.Status) == HospitalPartnerCustomerStatus.NotCalled))
{
if (shippingDetail != null && shippingDetail.Status == ShipmentStatus.Shipped)
{
initialCallDate = (shippingDetail.ShipmentDate ?? DateTime.Now).AddDays(1).AddDays(hospitalPartner != null && hospitalPartner.MailTransitDays != null ? hospitalPartner.MailTransitDays.Value : 0);
}
else if (shippingDetail == null)
{
initialCallDate = (evenCustomerResult.DataRecorderMetaData.DateModified ?? evenCustomerResult.DataRecorderMetaData.DateCreated).AddDays(1);
}
}
var hospitalPartnername = eventHospitalPartnerNamePairs.Where(ehp => ehp.FirstValue == eventData.Id).Select(ehp => ehp.SecondValue).SingleOrDefault();
var corporateAccountName = eventIdCorporateAccounrNamePairs.Where(ecan => ecan.FirstValue == eventData.Id).Select(ecan => ecan.SecondValue).SingleOrDefault();
var primaryCarePhysician = primaryCarePhysicians.Where(pcp => pcp.CustomerId == ec.CustomerId).SingleOrDefault();
var customerHealthAnswers = healthAssessmentAnswers.Where(haa => haa.EventCustomerId == ec.Id).ToArray();
var primaryCareAnswer = "No";
var mammogramProstateScreeningAnswer = "No";
var colonoscopyAnswer = "No";
var cancerAnswer = "No";
var weightBariatricAnswer = "No";
if (customerHealthAnswers.Count() > 0)
{
var primaryCareQuestionId = healthAssessmentQuestions.Where(haq => haq.Label == HealthAssessmentQuestionLabel.PrimaryCare.GetDescription()).Select(haq => haq.Id).SingleOrDefault();
if (primaryCareQuestionId > 0)
{
var healthassessmentAnswer = customerHealthAnswers.Where(cha => cha.QuestionId == primaryCareQuestionId).FirstOrDefault();
if (healthassessmentAnswer != null)
{
primaryCareAnswer = healthassessmentAnswer.Answer;
}
}
var mammogramProstateScreeningQuestionId = healthAssessmentQuestions.Where(haq => haq.Label == HealthAssessmentQuestionLabel.MammogramProstateScreening.GetDescription()).Select(haq => haq.Id).SingleOrDefault();
if (mammogramProstateScreeningQuestionId > 0)
{
var healthassessmentAnswer = customerHealthAnswers.Where(cha => cha.QuestionId == mammogramProstateScreeningQuestionId).SingleOrDefault();
if (healthassessmentAnswer != null)
{
mammogramProstateScreeningAnswer = healthassessmentAnswer.Answer;
}
}
var colonoscopyQuestionId = healthAssessmentQuestions.Where(haq => haq.Label == HealthAssessmentQuestionLabel.Colonoscopy.GetDescription()).Select(haq => haq.Id).SingleOrDefault();
if (colonoscopyQuestionId > 0)
{
var healthassessmentAnswer = customerHealthAnswers.Where(cha => cha.QuestionId == colonoscopyQuestionId).SingleOrDefault();
if (healthassessmentAnswer != null)
{
colonoscopyAnswer = healthassessmentAnswer.Answer;
}
}
var cancerQuestionId = healthAssessmentQuestions.Where(haq => haq.Label == HealthAssessmentQuestionLabel.Cancer.GetDescription()).Select(haq => haq.Id).SingleOrDefault();
if (cancerQuestionId > 0)
{
var healthassessmentAnswer = customerHealthAnswers.Where(cha => cha.QuestionId == cancerQuestionId).SingleOrDefault();
if (healthassessmentAnswer != null)
{
cancerAnswer = healthassessmentAnswer.Answer;
}
}
var weightBariatricQuestionId = healthAssessmentQuestions.Where(haq => haq.Label == HealthAssessmentQuestionLabel.WeightBariatric.GetDescription()).Select(haq => haq.Id).SingleOrDefault();
if (weightBariatricQuestionId > 0)
{
var healthassessmentAnswer = customerHealthAnswers.Where(cha => cha.QuestionId == weightBariatricQuestionId).SingleOrDefault();
if (healthassessmentAnswer != null)
{
weightBariatricAnswer = healthassessmentAnswer.Answer;
}
}
}
//var notes = _customerCallNotesRepository.GetCustomerNotes(eventData.Id, new[] { customer.CustomerId });
var customerNotes = notes.Where(n => n.CustomerId == customer.CustomerId && n.EventId == eventData.Id).Select(n => n).ToArray();
string postScreeningNotes = string.Empty;
if (!customerNotes.IsNullOrEmpty())
{
//postScreeningNotes = string.Join("\\n\\n", notes.Where(n => n.NotesType == CustomerRegistrationNotesType.PostScreeningFollowUpNotes).Select(n => n.Notes).ToArray());
postScreeningNotes = string.Join("\\n\\n", customerNotes.Select(n => n.Notes).ToArray());
}
EventCustomerNotification eventCustomerNotification = null;
if (eventCustomerNotifications != null && eventCustomerNotifications.Count() > 0)
{
eventCustomerNotification = eventCustomerNotifications.FirstOrDefault(ecn => ecn.EventCustomerId == ec.Id);
}
var eventHospitalPartner = eventHospitalPartners.SingleOrDefault(ehp => ehp.EventId == eventData.Id);
var showScannedDocumentUrl = false;
var scannedDocumentUrl = string.Empty;
if (eventHospitalPartner != null && showScannedDocumentHospitalPartnerIds != null)
{
showScannedDocumentUrl = showScannedDocumentHospitalPartnerIds.Contains(eventHospitalPartner.HospitalPartnerId);
if (showScannedDocumentUrl)
{
var mediaLocScannedDocs = _mediaRepository.GetScannedDocumentStorageFileLocation(eventHospitalPartner.EventId);
var filesScannedDocs = Directory.GetFiles(mediaLocScannedDocs.PhysicalPath);
if (filesScannedDocs.Any())
{
var filename = filesScannedDocs.Where(fsd => !string.IsNullOrEmpty(fsd) && Path.GetFileName(fsd).StartsWith(customer.CustomerId.ToString())).Select(Path.GetFileName).FirstOrDefault();
if (!string.IsNullOrEmpty(filename))
{
scannedDocumentUrl = mediaLocScannedDocs.Url + filename;
}
}
}
}
HospitalFacility hospitalFacility = null;
var hospitalFacilityName = string.Empty;
if (ec.HospitalFacilityId.HasValue)
{
if (hospitalFacilities != null && hospitalFacilities.Any())
{
hospitalFacility = hospitalFacilities.FirstOrDefault(hf => hf.Id == ec.HospitalFacilityId);
}
if (eventCustomerIdHospitalFacilityNamePairs != null && eventCustomerIdHospitalFacilityNamePairs.Any())
{
hospitalFacilityName = eventCustomerIdHospitalFacilityNamePairs.Where(ehp => ehp.FirstValue == ec.Id).Select(ehp => ehp.SecondValue).FirstOrDefault();
}
}
var preferredLanguage = "N/A";
if (customer.LanguageId.HasValue)
{
var language = languages.FirstOrDefault(x => x.Id == customer.LanguageId);
if (language != null)
{
preferredLanguage = language.Name;
}
}
customerModels.Add(new HospitalPartnerCustomerViewModel
{
CustomerName = customer.Name,
Phone = customer.HomePhoneNumber != null ? customer.HomePhoneNumber.FormatPhoneNumber : string.Empty,
PhoneCell = customer.MobilePhoneNumber != null ? customer.MobilePhoneNumber.FormatPhoneNumber : string.Empty,
PhoneOffice = customer.OfficePhoneNumber != null ? customer.OfficePhoneNumber.FormatPhoneNumber : string.Empty,
PhoneOfficeExtn = customer.PhoneOfficeExtension,
DateofBirth = customer.DateOfBirth,
Package = productPurchased,
CdPurchased = cdPurhased,
EventDate = eventData.EventDate,
CustomerId = customer.CustomerId,
EventId = ec.EventId,
Gender = customer.Gender.ToString(),
Height = customer.Height != null && customer.Height.TotalInches > 0 ? customer.Height.TotalInches.ToString() : "N/A",
Weight = customer.Weight != null && customer.Weight.Pounds > 0 ? customer.Weight.Pounds.ToString() : "N/A",
Pod = string.Join(", ", eventPods.Select(ep => ep.Name)),
IsEvaluated = isEvaluated,
IsPdfGenerated = isPdfGenerated,
Status = hospitalPartnerCustomer != null ? ((HospitalPartnerCustomerStatus)hospitalPartnerCustomer.Status).GetDescription() : HospitalPartnerCustomerStatus.NotCalled.GetDescription(),
Outcome = hospitalPartnerCustomer != null ? ((HospitalPartnerCustomerOutcome)hospitalPartnerCustomer.Outcome).GetDescription() : HospitalPartnerCustomerOutcome.NotCalled.GetDescription(),
Care = care,
LastModified = hospitalPartnerCustomer != null ? hospitalPartnerCustomer.DataRecorderMetaData.DateModified : null,
Result = result,
Recommendation = recommendation,
Email = customer.Email != null ? customer.Email.ToString() : string.Empty,
Address = Mapper.Map <Address, AddressViewModel>(customer.Address),
ShippingMode = shippingDetail != null ? "Paper" : "Online",
MailedStatus = shippingDetail != null ? shippingDetail.Status.ToString() : "Online",
MailedOn = shippingDetail != null ? shippingDetail.ShipmentDate : null,
HospitalPartnerName = hospitalPartnername ?? "N/A",
CorporateSponsor = corporateAccountName ?? "N/A",
TestSummary = pairTestSummary,
PrimaryCarePhysicianName = primaryCarePhysician != null ? primaryCarePhysician.Name.FullName : "N/A",
Activities = GetHospitalPartnerCustomerActivities(customerActivities, idNamePairs),
PrimaryCare = primaryCareAnswer,
MammogramProstateScreening = mammogramProstateScreeningAnswer,
Colonoscopy = colonoscopyAnswer,
Cancer = cancerAnswer,
InitialCallDate = initialCallDate,
WeightBariatric = weightBariatricAnswer,
PostScreeningFollowUpNotes = postScreeningNotes,
// PreferredLanguage = string.IsNullOrEmpty(customer.PreferredLanguage) ? "N/A" : customer.PreferredLanguage,
PreferredLanguage = preferredLanguage,
BestTimeToCall = customer.BestTimeToCall.HasValue && customer.BestTimeToCall.Value > 0 ? ((BestTimeToCall)customer.BestTimeToCall).GetDescription() : "N/A",
EventCustomerId = ec.Id,
HasCannedMessage = (hospitalPartner != null && !string.IsNullOrEmpty(hospitalPartner.CannedMessage) || hospitalFacility != null && !string.IsNullOrEmpty(hospitalFacility.CannedMessage)),
IsCannedMessageSent = eventCustomerNotification != null,
Ssn = (eventHospitalPartner != null && eventHospitalPartner.CaptureSsn && !string.IsNullOrEmpty(customer.Ssn) && customer.Ssn.Length >= 9)
? customer.Ssn.Substring(0, 3) + "-" + customer.Ssn.Substring(3, 2) + "-" + customer.Ssn.Substring(customer.Ssn.Length - 4) //"XXX-XX-" + customer.Ssn.Substring(customer.Ssn.Length - 4)
: string.Empty, //"N/A"
HospitalFacility = string.IsNullOrEmpty(hospitalFacilityName) ? "N/A" : hospitalFacilityName,
ShowScannedDocumentUrl = showScannedDocumentUrl,
ScannedDocumentUrl = scannedDocumentUrl,
MemberId = string.IsNullOrEmpty(customer.InsuranceId) ? "N/A" : customer.InsuranceId
});
});
model.Collection = customerModels;
return(model);
}
private HospitalPartnerCustomerListModel GetCustomers(IEnumerable <EventCustomer> eventCustomers, HospitalPartner hospitalPartner)
{
var eventCustomerIds = eventCustomers.Select(ec => ec.Id).ToArray();
var eventIds = eventCustomers.Select(ec => ec.EventId).Distinct().ToArray();
var customers = _customerRepository.GetCustomers(eventCustomers.Select(ec => ec.CustomerId).ToArray());
var orders = _orderRepository.GetAllOrdersByEventCustomerIds(eventCustomerIds, true);
var orderPackageIdNamePair = _eventPackageRepository.GetPackageNamesForOrder(orders.Select(o => o.Id).ToList());
var orderTestIdNamePair = _eventTestRepository.GetTestNamesForOrders(orders.Select(o => o.Id).ToList());
var hospitalPartnerCustomers = _hospitalPartnerCustomerRepository.GetHospitalPartnerCustomers(eventIds);
var orgRoleUserIds = new List <long>();
orgRoleUserIds.AddRange(hospitalPartnerCustomers.Select(hpc => hpc.CareCoordinatorOrgRoleUserId).ToArray());
orgRoleUserIds.AddRange(hospitalPartnerCustomers.Select(hpc => hpc.DataRecorderMetaData.DataRecorderCreator.Id).ToArray());
orgRoleUserIds.AddRange(hospitalPartnerCustomers.Where(hpc => hpc.DataRecorderMetaData.DataRecorderModifier != null).Select(hpc => hpc.DataRecorderMetaData.DataRecorderModifier.Id).ToArray());
orgRoleUserIds = orgRoleUserIds.Select(oru => oru).Distinct().ToList();
var idNamePairs = _organizationRoleUserRepository.GetNameIdPairofUsers(orgRoleUserIds.ToArray());
var eventCustomerResults = _eventCustomerResultRepository.GetByIds(eventCustomerIds);
eventCustomerResults = eventCustomerResults.Where(ecr => ecr.ResultState >= (long)TestResultStateNumber.Evaluated).ToArray();
var pods = _podRepository.GetPodsForEvents(eventIds);
var events = _eventRepository.GetEventswithPodbyIds(eventIds);
var shippingDetailIds = orders.SelectMany(o => o.OrderDetails.SelectMany(od => od.ShippingDetailOrderDetails.Select(sdod => sdod.ShippingDetailId))).ToArray();
var resultStatuses = _eventCustomerResultRepository.GetTestResultStatus(eventCustomerIds);
var shippingDetails = _shippingDetailRepository.GetByIds(shippingDetailIds);
var cdShippingOption = _shippingOptionRepository.GetShippingOptionByProductId((long)Product.UltraSoundImages);
//var eventIdHospitalPartnerIdPairs = _hospitalPartnerRepository.GetEventAndHospitalPartnerOrderedPair(eventIds);
var eventHospitalPartners = _hospitalPartnerRepository.GetEventHospitalPartnersByEventIds(eventIds).ToArray();
var organizationIds = eventHospitalPartners.Select(ehp => ehp.HospitalPartnerId).Distinct().ToArray();
var hospitalFacilityIds = eventCustomers.Where(ec => ec.HospitalFacilityId.HasValue && ec.HospitalFacilityId.Value > 0).Select(ec => ec.HospitalFacilityId.Value).ToArray();
organizationIds = organizationIds.Concat(hospitalFacilityIds).ToArray();
var organizations = _organizationRepository.GetOrganizations(organizationIds);
var eventIdHospitalPartnerNamePairs = (from ehp in eventHospitalPartners
join org in organizations on ehp.HospitalPartnerId equals org.Id
select new OrderedPair <long, string>(ehp.EventId, org.Name)).ToArray();
var eventIdCorporateAccounrNamePairs = _corporateAccountRepository.GetEventIdCorporateAccountNamePair(eventIds);
var primaryCarePhysicians = _primaryCarePhysicianRepository.GetByCustomerIds(eventCustomers.Select(ec => ec.CustomerId).ToArray());
var healthAssessmentQuestions = _healthAssessmentRepository.GetAllQuestions();
var healthAssessmentAnswers = _healthAssessmentRepository.GetByCustomerIds(eventCustomers.Select(ec => ec.CustomerId).ToArray());
var notes = _customerCallNotesRepository.GetNotes(eventCustomers.Select(ec => ec.CustomerId).ToArray(), CustomerRegistrationNotesType.PostScreeningFollowUpNotes);
var eventCustomerNotifications = _eventCustomerNotificationRepository.GetByEventCustomerIds(eventCustomerIds, NotificationTypeAlias.CannedMessageNotification);
var hospitalFacilities = hospitalFacilityIds.Any() ? _hospitalFacilityRepository.GetByIds(hospitalFacilityIds) : null;
var eventCustomerIdHospitalFacilityNamePairs = (from ec in eventCustomers
join org in organizations on ec.HospitalFacilityId equals org.Id
select new OrderedPair <long, string>(ec.Id, org.Name)).ToArray();
var showScannedDocumentHospitalPartnerIds = _settings.ShowScannedDocumentHospitalPartnerIds;
var languages = _languageRepository.GetAll();
return(_hospitalPartnerCustomerViewModelFactory.Create(eventCustomers, orders, customers, orderPackageIdNamePair, orderTestIdNamePair, hospitalPartnerCustomers, idNamePairs, events, shippingDetails,
resultStatuses, cdShippingOption, pods, eventIdHospitalPartnerNamePairs, eventIdCorporateAccounrNamePairs, primaryCarePhysicians,
healthAssessmentQuestions, healthAssessmentAnswers, eventCustomerResults, hospitalPartner, notes, eventCustomerNotifications, eventHospitalPartners,
eventCustomerIdHospitalFacilityNamePairs, hospitalFacilities, showScannedDocumentHospitalPartnerIds, languages));
}
public HospitalPartnerDashboardViewModel GetHospitalFacilityDashboardModel(long hospitalFacilityId)
{
var hospitalPartnerId = _hospitalFacilityRepository.GetHospitalPartnerId(hospitalFacilityId);
HospitalPartner hospitalPartner = null;
if (hospitalPartnerId > 0)
{
hospitalPartner = _hospitalPartnerRepository.GetHospitalPartnerforaVendor(hospitalPartnerId);
}
var eventIds = _hospitalFacilityRepository.GetEventIdsForHospitalFacility(hospitalFacilityId);
if (eventIds.IsNullOrEmpty())
{
return(new HospitalPartnerDashboardViewModel());
}
var reccentContactedEventId = _hospitalPartnerCustomerRepository.GetMostRecentContactedEventForHospitalFacility(hospitalFacilityId);
var recentMailedEvents = _shippingDetailRepository.GetRecentMailedHospitalFacilityEvents(hospitalFacilityId).ToList();
var recentCriticalCustomers = _eventCustomerResultRepository.GetRecentCriticalAndUrgentCustomersForHospitalFacility(hospitalFacilityId, 1, 8, hospitalPartner != null ? hospitalPartner.CriticalResultValidityPeriod : 0);
var getEventIds = recentMailedEvents.Count() > 0 ? recentMailedEvents.Select(me => me.FirstValue).ToList() : new List <long>();
if (reccentContactedEventId > 0)
{
getEventIds.Add(reccentContactedEventId);
}
IEnumerable <Customer> customers = null;
IEnumerable <Event> events = null;
IEnumerable <Host> hosts = null;
IEnumerable <CustomerResultStatusViewModel> customerResultStatusViewModels = null;
if (recentCriticalCustomers != null && recentCriticalCustomers.Count() > 0)
{
getEventIds.AddRange(recentCriticalCustomers.Select(rcc => rcc.EventId).ToArray());
customers = _customerRepository.GetCustomers(recentCriticalCustomers.Select(rcc => rcc.CustomerId).ToArray());
customerResultStatusViewModels = _eventCustomerResultRepository.GetTestResultStatus(recentCriticalCustomers.Select(rcc => rcc.Id).ToArray());
}
if (getEventIds.Count > 0)
{
events = _eventRepository.GetEventswithPodbyIds(getEventIds.ToArray());
hosts = _hostRepository.GetEventHosts(events.Select(e => e.Id).ToArray());
}
var totalCustomers = _eventRepository.GetCustomersWithAppointmentByHospitalFacilityId(hospitalFacilityId);
var customersAttended = _eventRepository.GetAttendedCustomersByHospitalFacilityId(hospitalFacilityId);
var normalCustomers = _eventCustomerResultRepository.GetResultSummaryEventIdCustomersCountForHospitalFacility(hospitalFacilityId, ResultInterpretation.Normal, true, hospitalPartner != null ? hospitalPartner.NormalResultValidityPeriod : 0);
var abnormalCustomers = _eventCustomerResultRepository.GetResultSummaryEventIdCustomersCountForHospitalFacility(hospitalFacilityId, ResultInterpretation.Abnormal, true, hospitalPartner != null ? hospitalPartner.AbnormalResultValidityPeriod : 0);
var criticalCustomers = _eventCustomerResultRepository.GetCriticalEventIdCustomersCountForHospitalFacility(hospitalFacilityId, ResultInterpretation.Critical, true, hospitalPartner != null ? hospitalPartner.CriticalResultValidityPeriod : 0);
var urgentCustomers = _eventCustomerResultRepository.GetResultSummaryEventIdCustomersCountForHospitalFacility(hospitalFacilityId, ResultInterpretation.Urgent, true, hospitalPartner != null ? hospitalPartner.CriticalResultValidityPeriod : 0);
var mailedDate = _shippingDetailRepository.MailedDateForEvent(reccentContactedEventId, hospitalFacilityId);
return(_hospitalPartnerViewModelFactory.Create(eventIds.Count(), totalCustomers, customersAttended,
criticalCustomers, normalCustomers, abnormalCustomers,
events, hosts,
reccentContactedEventId, recentMailedEvents, mailedDate,
recentCriticalCustomers, customers, customerResultStatusViewModels, urgentCustomers));
}
