public void Save(PhysicianRecordRequestSignature domain)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var entity = Mapper.Map <PhysicianRecordRequestSignature, PhysicianRecordRequestSignatureEntity>(domain);
DeactivateAll(domain.EventCustomerId);
if (!adapter.SaveEntity(entity))
{
throw new PersistenceFailureException("Unable to save physician record request signature.");
}
}
}
public IEnumerable <CallQueueCriteria> GetAllByCallQueueId(long callQueueId)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var entities = (from cqc in linqMetaData.CallQueueCriteria
where cqc.CallQueueId == callQueueId
orderby cqc.Sequence
select cqc).ToArray();
return(Mapper.Map <IEnumerable <CallQueueCriteriaEntity>, IEnumerable <CallQueueCriteria> >(entities));
}
}
public List <EventCustomerRegistrationViewData> GetEventCustomerOrdersForEvent(long eventId)
{
var customerOrderBasicInfoTypedView = new CustomerOrderBasicInfoTypedView();
var bucket = new RelationPredicateBucket(CustomerOrderBasicInfoFields.EventId == eventId);
using (var myAdapter = PersistenceLayer.GetDataAccessAdapter())
{
myAdapter.CommandTimeOut = CommandTimeOut;
myAdapter.FetchTypedView(customerOrderBasicInfoTypedView, bucket, false);
}
var eventCustomerIds = customerOrderBasicInfoTypedView.Select(vw => vw.EventCustomerId).ToArray();
return(_factory.Create(customerOrderBasicInfoTypedView, _physicianAssignmentService.GetPhysicianAssignments(eventId, eventCustomerIds)));
}
public CallQueueCustomerLock SaveCallQueueCustomerLock(CallQueueCustomerLock callQueueCustomerLock)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var entity = Mapper.Map <CallQueueCustomerLock, CallQueueCustomerLockEntity>(callQueueCustomerLock);
if (!adapter.SaveEntity(entity, true))
{
throw new PersistenceFailureException();
}
return(Mapper.Map <CallQueueCustomerLockEntity, CallQueueCustomerLock>(entity));
}
}
public void Save(EventCustomerGiftCard domain)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var entity = Mapper.Map <EventCustomerGiftCard, EventCustomerGiftCardEntity>(domain);
DeactivateAll(domain.EventCustomerId);
if (!adapter.SaveEntity(entity))
{
throw new PersistenceFailureException("Unable to save gift card answer and signature.");
}
}
}
public bool SaveScreeningAuthorizations(List <ScreeningAuthorization> screeningAuthorizations)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var entitiesToSave = _mapper.MapMultiple(screeningAuthorizations);
var entities = new EntityCollection <ScreeningAuthorizationEntity>();
entities.AddRange(entitiesToSave);
if (adapter.SaveEntityCollection(entities) == 0)
{
throw new PersistenceFailureException();
}
return(true);
}
}
public void ActivateGiftCertificate(long id)
{
using (var myAdapter = PersistenceLayer.GetDataAccessAdapter())
{
var entity = new GiftCertificateEntity {
IsActive = true
};
var bucket = new RelationPredicateBucket(GiftCertificateFields.GiftCertificateId == id);
if (myAdapter.UpdateEntitiesDirectly(entity, bucket) == 0)
{
throw new PersistenceFailureException();
}
}
}
public FluConsentTemplate Save(FluConsentTemplate domain)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var entity = Mapper.Map <FluConsentTemplate, FluConsentTemplateEntity>(domain);
if (!adapter.SaveEntity(entity, true))
{
throw new PersistenceFailureException();
}
return(Mapper.Map <FluConsentTemplateEntity, FluConsentTemplate>(entity));
}
}
public Script Save(Script domain)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var entity = Mapper.Map <Script, ScriptsEntity>(domain);
if (!adapter.SaveEntity(entity, true))
{
throw new PersistenceFailureException();
}
return(Mapper.Map <ScriptsEntity, Script>(entity));
}
}
public string GetTestNamesByPackageId(long packageId)
{
using (var myAdapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(myAdapter);
var testNames = (from pt in linqMetaData.PackageTest
join t in linqMetaData.Test on pt.TestId equals t.TestId
where pt.PackageId == packageId
select t.Name).ToArray();
return(string.Join(",", testNames));
}
}
public List <Test> GetPermittedTestsForaPhysician(long orgRoleUserId)
{
var testEntities = new EntityCollection <TestEntity>();
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.Add(TestEntity.Relations.PhysicianPermittedTestEntityUsingTestId);
bucket.PredicateExpression.Add(PhysicianPermittedTestFields.OrganizationRoleUserId == orgRoleUserId);
using (var myAdapter = PersistenceLayer.GetDataAccessAdapter())
{
myAdapter.FetchEntityCollection(testEntities, bucket);
}
return(Mapper.MapMultiple(testEntities).ToList());
}
public List <string> GetAliasListByTestIdList(IEnumerable <long> testIds)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var entities = (from t in linqMetaData.Test
where testIds.Contains(t.TestId) && t.IsActive
select t.Alias);
var aliases = entities.ToList();
return(aliases);
}
}
public IEnumerable <long> GetEventIdsForHospitalFacility(long hospitalFacilityId)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
return((from ehf in linqMetaData.EventHospitalFacility
join e in linqMetaData.Events on ehf.EventId equals e.EventId
where ehf.HospitalFacilityId == hospitalFacilityId &&
e.EventStatus.HasValue &&
e.EventStatus.Value == (int)EventStatus.Active
select e.EventId).ToList());
}
}
public IEnumerable <HospitalFacility> GetByHospitalPartnerId(long hospitalPartnerId)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var entities = (from hf in linqMetaData.HospitalFacility
join hphf in linqMetaData.HospitalPartnerHospitalFacility on hf.HospitalFacilityId equals hphf.HospitalFacilityId
where hphf.HospitalPartnerId == hospitalPartnerId
select hf).ToArray();
return(_hospitalFacilityFactory.CreateHospitalFacilities(entities));
}
}
public IEnumerable <string> GetScreenedEventHostNames(string prefixText)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
return
((from e in linqMetaData.Events
join he in linqMetaData.HostEventDetails on e.EventId equals he.EventId
join p in linqMetaData.Prospects on he.HostId equals p.ProspectId
where p.OrganizationName.Contains(prefixText)
select p.OrganizationName
).ToArray());
}
}
public List <PaymentInstrument> GetPaymentInstrumentsForPayment(long medicalVendorPaymentId)
{
var checkEntities = new EntityCollection <CheckEntity>();
var bucket = new RelationPredicateBucket();
bucket.Relations.Add(CheckEntity.Relations.MVPaymentCheckDetailsEntityUsingCheckId);
bucket.Relations.Add(MVPaymentCheckDetailsEntity.Relations.PhysicianPaymentEntityUsingMvpaymentId);
bucket.PredicateExpression.Add(PhysicianPaymentFields.PhysicianPaymentId == medicalVendorPaymentId);
using (var myAdapter = PersistenceLayer.GetDataAccessAdapter())
{
myAdapter.FetchEntityCollection(checkEntities, bucket);
}
return(_paymentInstrumentFactory.CreatePaymentInstruments(checkEntities));
}
public IEnumerable <AccessControlObject> GetAllowedAccessControlObjectsByRoleId(long roleId)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var entities = (from raco in linqMetaData.RoleAccessControlObject
join aco in linqMetaData.AccessControlObject on raco.AccessControlObjectId equals aco.Id
where raco.RoleId == roleId && raco.PermissionTypeId == (long)PermissionType.Allow
select aco).WithPath(prefetch => prefetch.Prefetch(p => p.AccessControlObjectUrl).Prefetch(p => p.RoleAccessControlObject).Prefetch(p => p.AccessObjectScopeOption));
return(Mapper.Map <IEnumerable <AccessControlObjectEntity>, IEnumerable <AccessControlObject> >(entities));
}
}
public PreQualificationTestTemplate GetByName(string templateName)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var entity = (from q in linqMetaData.PreQualificationTestTemplate where q.TemplateName.ToLower() == templateName select q).FirstOrDefault();
if (entity == null)
{
return(null);
}
return(Mapper.Map <PreQualificationTestTemplateEntity, PreQualificationTestTemplate>(entity));
}
}
public decimal GetAmountUsedonGiftCertificate(long id)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var gcPayments = linqMetaData.GiftCertificatePayment.Where(gcp => gcp.GiftCertificateId == id).ToArray();
if (gcPayments.IsNullOrEmpty())
{
return(0);
}
return(gcPayments.Sum(gcp => gcp.Amount));
}
}
public IEnumerable <ZipData> GetZipData(string zipCode, string stateCode)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var entities = (from zd in linqMetaData.ZipData where zipCode == zd.ZipCode && stateCode == zd.State select zd).ToArray();
if (entities != null && entities.Any())
{
return(Mapper.Map <IEnumerable <ZipDataEntity>, IEnumerable <ZipData> >(entities));
}
return(null);
}
}
public CustomerCallQueueCallAttempt Save(CustomerCallQueueCallAttempt domain, bool refatch = true)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var entity = Mapper.Map <CustomerCallQueueCallAttempt, CustomerCallQueueCallAttemptEntity>(domain);
if (!adapter.SaveEntity(entity, refatch))
{
throw new PersistenceFailureException();
}
return(!refatch
? domain
: Mapper.Map <CustomerCallQueueCallAttemptEntity, CustomerCallQueueCallAttempt>(entity));
}
}
public PcpAppointment GetByCustomerIdEventId(long customerId, long eventId)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var entity = (from pa in linqMetaData.PcpAppointment
join ec in linqMetaData.EventCustomers on pa.EventCustomerId equals ec.EventCustomerId
where ec.EventId == eventId && ec.CustomerId == customerId
select pa).SingleOrDefault();
return(Mapper.Map <PcpAppointmentEntity, PcpAppointment>(entity));
}
}
public bool Save(ZipRadiusDistance zipRadiusDistance)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var entity = Mapper.Map <ZipRadiusDistance, ZipRadiusDistanceEntity>(zipRadiusDistance);
if (!adapter.SaveEntity(entity, false))
{
throw new PersistenceFailureException();
}
return(true);
}
}
public State GetState(string stateName)
{
using (var myAdapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(myAdapter);
var stateEntity = linqMetaData.State.Where(state => state.Name == stateName).SingleOrDefault();
if (stateEntity == null)
{
throw new Exception("Invalid State Name:" + stateName);
}
return(_mapper.Map(stateEntity));
}
}
public List <TestHcpcsCode> GetAll()
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var entity = (from h in linqMetaData.TestHcpcsCode
where h.IsActive
select h).ToArray();
return((List <TestHcpcsCode>)Mapper.Map <IEnumerable <TestHcpcsCodeEntity>, IEnumerable <TestHcpcsCode> >(entity));
}
}
public EventNotesLog SaveEventNotesLog(EventNotesLog domain)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var entity = Mapper.Map <EventNotesLog, EventNotesLogEntity>(domain);
if (!adapter.SaveEntity(entity, true))
{
throw new PersistenceFailureException();
}
return(Mapper.Map <EventNotesLogEntity, EventNotesLog>(entity));
}
}
public CallQueueCriteria GetById(long id)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var entity = (from cqc in linqMetaData.CallQueueCriteria where cqc.CallQueueCriteriaId == id select cqc).SingleOrDefault();
if (entity == null)
{
return(null);
}
return(Mapper.Map <CallQueueCriteriaEntity, CallQueueCriteria>(entity));
}
}
public bool UpdateHostTaxIdNumber(long hostId, string taxIdNumber)
{
var host = new ProspectsEntity(hostId)
{
TaxIdNumber = taxIdNumber
};
IRelationPredicateBucket relationPredicateBucket =
new RelationPredicateBucket(ProspectsFields.ProspectId == hostId);
using (IDataAccessAdapter myAdapter = PersistenceLayer.GetDataAccessAdapter())
{
return(myAdapter.UpdateEntitiesDirectly(host, relationPredicateBucket) > 0);
}
}
public IEnumerable <OrderedPair <long, string> > GetBySearchText(string serachText)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var ndcs = (from ec in linqMetaData.Ndc
where ec.ProductName.Contains(serachText)
select ec).ToArray();
return(ndcs.Select(x => new OrderedPair <long, string> {
FirstValue = x.Id, SecondValue = x.ProductName
}));
}
}
public HealthPlanFillEventCallQueue Save(HealthPlanFillEventCallQueue healthPlanFillEventCallQueue)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var entity = Mapper.Map <HealthPlanFillEventCallQueue, HealthPlanFillEventCallQueueEntity>(healthPlanFillEventCallQueue);
if (!adapter.SaveEntity(entity, true))
{
throw new PersistenceFailureException();
}
return(Mapper.Map <HealthPlanFillEventCallQueueEntity, HealthPlanFillEventCallQueue>(entity));
}
}