public IEnumerable <Call> GetCallDetails(IEnumerable <long> customerIds) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); IEnumerable <CallsEntity> entities; var query = from cl in linqMetaData.Calls where customerIds.Contains(cl.CalledCustomerId.Value) && cl.IsUploaded == false select cl; entities = query.ToArray(); return(Mapper.Map <IEnumerable <CallsEntity>, IEnumerable <Call> >(entities)); } }
public void Save(IEnumerable <WellMedAttestation> attestations) { var wellMedAttestations = attestations as WellMedAttestation[] ?? attestations.ToArray(); using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var entities = new EntityCollection <WellMedAttestationEntity>(); foreach (var criteria in wellMedAttestations) { entities.Add(Mapper.Map <WellMedAttestation, WellMedAttestationEntity>(criteria)); } if (adapter.SaveEntityCollection(entities) == 0) { throw new PersistenceFailureException(); } } }
public CustomerBillingAccount GetByCustomerIdBillingAccountId(long customerId, long billingAccountId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var entity = (from cba in linqMetaData.CustomerBillingAccount where cba.CustomerId == customerId && cba.BillingAccountId == billingAccountId select cba).SingleOrDefault(); if (entity == null) { return(null); } return(Mapper.Map <CustomerBillingAccountEntity, CustomerBillingAccount>(entity)); } }
public IEnumerable <OrderedPair <long, long> > GetOrderEventCustomerIdPairforEventCustomerIds(IEnumerable <long> eventCustomerIds) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); return((from pair in (from od in linqMetaData.OrderDetail join ecod in linqMetaData.EventCustomerOrderDetail on od.OrderDetailId equals ecod.OrderDetailId where eventCustomerIds.Contains(ecod.EventCustomerId) select new { od.OrderId, ecod.EventCustomerId }) group pair by pair.OrderId into grp select new OrderedPair <long, long>(grp.Key, grp.Max(p => p.EventCustomerId))).ToArray()); } }
public PhysicianCustomerAssignment GetAssignedPhysicians(long eventCustomerId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var assignedPhysicianEntity = (from pc in linqMetaData.PhysicianCustomerAssignment where pc.EventCustomerId == eventCustomerId && pc.IsActive select pc).FirstOrDefault(); if (assignedPhysicianEntity != null) { return(_mapper.Map(assignedPhysicianEntity)); } return(null); } }
public ActivityType GetById(long id) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var entity = (from q in linqMetaData.ActivityType where q.Id == id select q).FirstOrDefault(); if (entity == null) { return(null); } return(Mapper.Map <ActivityTypeEntity, ActivityType>(entity)); } }
public List <OrderedPair <long, List <Core.Finance.Domain.Order> > > GetCallCenterRepActiveOrderPairs(DateTime startDate, DateTime endDate) { var callCenterRepOrderPairs = new List <OrderedPair <long, List <Core.Finance.Domain.Order> > >(); using (var myAdapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(myAdapter); var eventCustomers = linqMetaData.EventCustomers.Join(linqMetaData.OrganizationRoleUser.Where(o => GetParentRoleIdByRoleId(o.RoleId) == (long)Roles.CallCenterRep), ec => ec.CreatedByOrgRoleUserId, oru => oru.OrganizationRoleUserId, (ec, oru) => ec).Where(ec => ec.DateCreated >= startDate && ec.DateCreated <= endDate && !ec.NoShow && ec.AppointmentId.HasValue).ToList(); var filteredOrderIds = eventCustomers.Join(linqMetaData.EventCustomerOrderDetail, ec => ec.EventCustomerId, ecod => ecod.EventCustomerId, (ec, ecod) => new { ecod.OrderDetailId, ecod.IsActive }).Join( linqMetaData.OrderDetail, @t => @t.OrderDetailId, od => od.OrderDetailId, (@t, od) => new { @t.IsActive, od.OrderId }).Where(@t => @t.IsActive).Select(@t => new { @t.OrderId }); var callCenterRepOrderGroups = filteredOrderIds.Join(linqMetaData.Order, @t => @t.OrderId, o => o.OrderId, (@t, o) => o).Where( o => o.DateCreated >= startDate && o.DateCreated <= endDate).GroupBy( o => o.OrganizationRoleUserCreatorId); foreach (var callCenterRepOrderGroup in callCenterRepOrderGroups) { if (callCenterRepOrderGroup != null && !callCenterRepOrderGroup.IsEmpty()) { var groupOrderIds = callCenterRepOrderGroup.Select(group => group.OrderId).Distinct(); var orders = new List <Core.Finance.Domain.Order>(); foreach (var orderId in groupOrderIds) { orders.Add(GetOrder(orderId)); } callCenterRepOrderPairs.Add( new OrderedPair <long, List <Core.Finance.Domain.Order> >( callCenterRepOrderGroup.Key, orders)); } } return(callCenterRepOrderPairs); } }
public bool IsSourceCodeAppliedforGivenEventCustomer(long sourceCodeId, long eventId, long customerId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var eventCustomerId = (from ec in linqMetaData.EventCustomers join ecod in linqMetaData.EventCustomerOrderDetail on ec.EventCustomerId equals ecod.EventCustomerId join od in linqMetaData.SourceCodeOrderDetail on ecod.OrderDetailId equals od.OrderDetailId where ec.EventId == eventId && ec.CustomerId == customerId && ecod.IsActive && od.IsActive && od.SourceCodeId == sourceCodeId select ec.EventCustomerId).SingleOrDefault(); return(eventCustomerId > 0); } }
public Encounter GetByEventCustomerId(long eventCustomerId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var entity = (from e in linqMetaData.Encounter join ee in linqMetaData.EventCustomerEncounter on e.EncounterId equals ee.EncounterId where ee.EventCustomerId == eventCustomerId select e).SingleOrDefault(); if (entity == null) { return(null); } return(Mapper.Map <EncounterEntity, Encounter>(entity)); } }
private void Save(AccountCallQueueSetting accountCallQueueSetting) { if (accountCallQueueSetting == null) { return; } var entity = Mapper.Map <AccountCallQueueSetting, AccountCallQueueSettingEntity>(accountCallQueueSetting); using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { if (!adapter.SaveEntity(entity, true)) { throw new PersistenceFailureException(); } } }
public bool UpdateAmount(long sourceCodeId, long orderDetailId, decimal amount, long organizationRoleUserCreatorId) { var sourceCodeOrderDetailEntity = new SourceCodeOrderDetailEntity { Amount = amount, OrganizationRoleUserCreatorId = organizationRoleUserCreatorId }; IRelationPredicateBucket bucket = new RelationPredicateBucket(SourceCodeOrderDetailFields.OrderDetailId == orderDetailId); bucket.PredicateExpression.AddWithAnd(SourceCodeOrderDetailFields.SourceCodeId == sourceCodeId); using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { return(adapter.UpdateEntitiesDirectly(sourceCodeOrderDetailEntity, bucket) > 0); } }
public bool UpdateCalledCustomerId(long customerId, long callId, long?healthPlanId, long?ProductTypeId = null) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var callEntity = new CallsEntity() { CalledCustomerId = customerId, HealthPlanId = healthPlanId, ProductTypeId = ProductTypeId }; var bucket = new RelationPredicateBucket(CallsFields.CallId == callId); if (adapter.UpdateEntitiesDirectly(callEntity, bucket) == 0) { throw new PersistenceFailureException("CallId doesn't exist"); } } return(true); }
public bool UpdateCallCenterCallEvent(long eventId, long callId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var callEntity = new CallsEntity() { EventId = eventId }; var bucket = new RelationPredicateBucket(CallsFields.CallId == callId); if (adapter.UpdateEntitiesDirectly(callEntity, bucket) == 0) { throw new PersistenceFailureException("CallId doesn't exist"); } } return(true); }
public bool UpdateCallersPhoneNumber(long callId, string patientPhoneNumber) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var callEntity = new CallsEntity() { CallersPhoneNumber = patientPhoneNumber, CallBackNumber = patientPhoneNumber }; var bucket = new RelationPredicateBucket(CallsFields.CallId == callId); if (adapter.UpdateEntitiesDirectly(callEntity, bucket) == 0) { throw new PersistenceFailureException("CallId doesn't exist"); } } return(true); }
public IEnumerable <OrderedPair <long, string> > GetIdNamePairofAllUsersByRole(Roles role) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var roleIds = (from r in linqMetaData.Role where ((r.ParentId.HasValue && r.ParentId.Value == (long)role) || r.RoleId == (long)role) select r.RoleId); return((from u in linqMetaData.User join oru in linqMetaData.OrganizationRoleUser on u.UserId equals oru.UserId where roleIds.Contains(oru.RoleId) select new OrderedPair <long, string>(oru.OrganizationRoleUserId, u.FirstName + " " + u.LastName)).OrderBy(op => op.SecondValue) .ToList()); } }
public IEnumerable <EventCustomerEncounter> GetEventCustomerEncounterByEventCustomerIds(IEnumerable <long> eventCustomerIds) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var entities = (from ece in linqMetaData.EventCustomerEncounter where eventCustomerIds.Contains(ece.EventCustomerId) select ece).ToArray(); if (entities != null && entities.Any()) { return(Mapper.Map <IEnumerable <EventCustomerEncounterEntity>, IEnumerable <EventCustomerEncounter> >(entities)); } return(null); } }
public ActivityType GetByAlias(string alias) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var entity = (from q in linqMetaData.ActivityType where q.Alias.ToLower() == alias.ToLower() && q.IsActive select q).FirstOrDefault(); if (entity == null) { return(null); } return(Mapper.Map <ActivityTypeEntity, ActivityType>(entity)); } }
public IEnumerable <HospitalPartnerCustomer> GetHospitalPartnerCustomersByHospitalPartnerId(long hospitalPartnerId, ResultInterpretation resultInterpretation, int validityPeriod = 0) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var entities = (from hpc in linqMetaData.VwHospitalPartnerCustomers join ehp in linqMetaData.EventHospitalPartner on hpc.EventId equals ehp.EventId join ecr in linqMetaData.EventCustomerResult on new { hpc.EventId, hpc.CustomerId } equals new { ecr.EventId, ecr.CustomerId } join e in linqMetaData.Events on ecr.EventId equals e.EventId where ehp.HospitalPartnerId == hospitalPartnerId && ecr.ResultSummary == (long)resultInterpretation && (validityPeriod < 1 || e.EventDate >= DateTime.Now.Date.AddDays(-1 * validityPeriod)) select hpc).ToArray(); return(Mapper.Map <IEnumerable <VwHospitalPartnerCustomersEntity>, IEnumerable <HospitalPartnerCustomer> >(entities)); } }
public EventCustomerNotification GetByEventCustomerId(long eventCustomerId, string notificationType) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var entity = (from ecn in linqMetaData.EventCustomerNotification join nt in linqMetaData.NotificationType on ecn.NotificationTypeId equals nt.NotificationTypeId where nt.NotificationTypeNameAlias == notificationType && ecn.EventCustomerId == eventCustomerId select ecn).FirstOrDefault(); if (entity == null) { return(null); } return(Mapper.Map <EventCustomerNotificationEntity, EventCustomerNotification>(entity)); } }
public IEnumerable <ShippingDetail> GetEventCustomerShippingDetailForFilter(int pageNumber, int pageSize, PcpSummaryLogReportModelFilter filter, IEnumerable <long> shippingOptions, out int totalRecords) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var query = (from ec in linqMetaData.EventCustomers join ecod in linqMetaData.EventCustomerOrderDetail on ec.EventCustomerId equals ecod.EventCustomerId join sdod in linqMetaData.ShippingDetailOrderDetail on ecod.OrderDetailId equals sdod.OrderDetailId join sd in linqMetaData.ShippingDetail on sdod.ShippingDetailId equals sd.ShippingDetailId join ea in linqMetaData.EventAccount on ec.EventId equals ea.EventId where ec.AppointmentId.HasValue && !ec.NoShow && ec.LeftWithoutScreeningReasonId == null && ea.AccountId == filter.HealthPlanId && ecod.IsActive && sdod.IsActive && sd.ShipmentDate.HasValue && (sd.Status == (long)ShipmentStatus.Delivered || sd.Status == (long)ShipmentStatus.Shipped) && (shippingOptions.Contains(sd.ShippingOptionId)) select new { ec, sd }); if (filter.DateFrom.HasValue || filter.DateTo.HasValue) { var fromDate = filter.DateFrom.HasValue ? filter.DateFrom.Value : DateTime.Now; var toDate = filter.DateTo.HasValue ? filter.DateTo.Value : DateTime.Now; query = from q in query where q.sd.ShipmentDate >= fromDate && q.sd.ShipmentDate <= toDate select q; } if (!string.IsNullOrWhiteSpace(filter.Tag)) { var customerIds = (from cp in linqMetaData.CustomerProfile where cp.Tag == filter.Tag select cp.CustomerId); query = (from q in query where customerIds.Contains(q.ec.CustomerId) select q); } var queryForShipping = from q in query orderby q.sd.ShipmentDate ascending, q.ec.EventId ascending, q.ec.CustomerId ascending select q.sd; totalRecords = queryForShipping.Count(); var entities = queryForShipping.TakePage(pageNumber, pageSize).ToArray(); return(Mapper.MapMultiple(entities)); } }
public IEnumerable <Core.Finance.Domain.Order> GetAllOrders(int pageNumber, int pageSize) { IEnumerable <OrderEntity> orderEntities; var orders = new List <Core.Finance.Domain.Order>(); using (var myAdapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(myAdapter); orderEntities = linqMetaData.Order.Skip((pageNumber - 1) * pageSize). Take(pageSize).ToList(); } foreach (var orderEntity in orderEntities) { orders.Add(GetOrder(orderEntity.OrderId)); } return(orders); }
public bool UpdateMemberUploadLog(long oldCustomerId, long newCustomerId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var memberUploadLogBucket = new RelationPredicateBucket(MemberUploadLogFields.CustomerId == oldCustomerId); var entities = new EntityCollection <MemberUploadLogEntity>(); adapter.FetchEntityCollection(entities, memberUploadLogBucket); foreach (var cba in entities) { cba.CustomerId = newCustomerId; adapter.SaveEntity(cba); } } return(true); }
public int GetPinExpireInDays(long technicianId, int pinExpirationDays) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var technician = linqMetaData.TechnicianProfile.SingleOrDefault(x => x.OrganizationRoleUserId == technicianId); if (technician == null || !technician.PinChangeDate.HasValue) { return(0); } var totalDaysLastPinChage = (technician.PinChangeDate.Value.AddDays(pinExpirationDays).Date - DateTime.Today.Date).TotalDays + 1; return(Convert.ToInt32(totalDaysLastPinChage)); } }
public bool UpdateEventCustomerQuestionAnswer(long oldCustomerId, long newCustomerId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var eventCustomerQuestionAnswerBucket = new RelationPredicateBucket(EventCustomerQuestionAnswerFields.CustomerId == oldCustomerId); var entities = new EntityCollection <EventCustomerQuestionAnswerEntity>(); adapter.FetchEntityCollection(entities, eventCustomerQuestionAnswerBucket); foreach (var cba in entities) { cba.CustomerId = newCustomerId; adapter.SaveEntity(cba); } } return(true); }
public void Save(HealthPlanEventZip healthPlanEventZip) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { if (healthPlanEventZip != null && healthPlanEventZip.AccountID > 0) { Delete(healthPlanEventZip.AccountID); var entity = Mapper.Map <HealthPlanEventZip, HealthPlanEventZipEntity>(healthPlanEventZip); if (!adapter.SaveEntity(entity, true)) { throw new PersistenceFailureException(); } } } }
public bool UpdateCareCodingOutbound(long oldCustomerId, long newCustomerId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var careCodingOutboundBucket = new RelationPredicateBucket(CareCodingOutboundFields.CustomerId == oldCustomerId); var entities = new EntityCollection <CareCodingOutboundEntity>(); adapter.FetchEntityCollection(entities, careCodingOutboundBucket); foreach (var cba in entities) { cba.CustomerId = newCustomerId; adapter.SaveEntity(cba); } } return(true); }
public IEnumerable <EventCustomerQuestionAnswer> GetEventCustomerQuestionAnswer(long customerId, long templateId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var questionIds = linqMetaData.PreQualificationTemplateQuestion.Where(x => x.TemplateId == templateId).Select(x => x.QuestionId).ToArray(); var maxVersion = linqMetaData.EventCustomerQuestionAnswer.Where(x => x.CustomerId == customerId && questionIds.Contains(x.QuestionId) && x.IsActive == true).Max(x => x.Version); var entities = (from q in linqMetaData.EventCustomerQuestionAnswer where q.CustomerId == customerId && q.Version == maxVersion && q.IsActive select q).ToArray(); return(Mapper.Map <IEnumerable <EventCustomerQuestionAnswerEntity>, IEnumerable <EventCustomerQuestionAnswer> >(entities)); } }
public IEnumerable <OrderedPair <long, string> > GetIdNamePairofUsersByRoles(long[] roles) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var roleIds = (from role in linqMetaData.Role where (role.ParentId.HasValue && roles.Contains(role.ParentId.Value) || roles.Contains(role.RoleId)) select role.RoleId); return((from u in linqMetaData.User join oru in linqMetaData.OrganizationRoleUser on u.UserId equals oru.UserId where roleIds.Contains(oru.RoleId) && oru.IsActive && u.IsActive select new OrderedPair <long, string>(oru.OrganizationRoleUserId, u.FirstName + " " + u.LastName + " (" + oru.Role.Name + ")")).OrderBy(op => op.SecondValue) .ToList()); } }
public CheckListTemplate GetById(long id) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); try { var query = (from clt in linqMetaData.CheckListTemplate where clt.Id == id select clt).First(); return(Mapper.Map <CheckListTemplateEntity, CheckListTemplate>(query)); } catch (InvalidOperationException) { throw new ObjectNotFoundInPersistenceException <CheckListTemplate>(id); } } }
public List <ZipCode> GetAllZipCodesByCounteryId(long counterId) { List <ZipEntity> zipEntities; using (var myAdapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(myAdapter); zipEntities = (from zip in linqMetaData.Zip join c in linqMetaData.City on zip.CityId equals c.CityId join s in linqMetaData.State on c.StateId equals s.StateId where s.CountryId == counterId select zip).ToList(); //zipEntities = linqMetaData.Zip.Where(z => z.IsActive).ToList(); } return(_mapper.MapMultiple(zipEntities).ToList()); }