public async Task <CallsDto> UpdateCall(CallsDto call) { using (CellularCompanyContext db = new CellularCompanyContext()) { try { if (call != null) { CallsEntity entity = call.ToModel(); entity.CallId = call.CallId; db.Calls.Attach(entity); foreach (var propName in db.Entry(entity).CurrentValues.PropertyNames) { if (propName != "CallId") { db.Entry(entity).Property(propName).IsModified = true; } } await db.SaveChangesAsync(); return(entity.ToDto()); } return(null); } catch (Exception ex) { Debug.WriteLine(ex.Message); return(null); } } }
public bool UpdatePromoCode(string sourceCode, long callId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var linqMetaData = new LinqMetaData(adapter); var couponId = linqMetaData.Coupons.Where(cop => cop.CouponCode == sourceCode).Select(cop => cop.CouponId). FirstOrDefault(); if (couponId < 1) { throw new InvalidDataException("Source Code is invalid"); } var callEntity = new CallsEntity() { PromoCodeId = couponId }; var bucket = new RelationPredicateBucket(CallsFields.CallId == callId); if (adapter.UpdateEntitiesDirectly(callEntity, bucket) == 0) { throw new PersistenceFailureException("CallId doesn't exist"); } } return(true); }
/// <summary> setups the sync logic for member _calls</summary> /// <param name="relatedEntity">Instance to set as the related entity of type entityType</param> private void SetupSyncCalls(IEntity2 relatedEntity) { if (_calls != relatedEntity) { DesetupSyncCalls(true, true); _calls = (CallsEntity)relatedEntity; base.PerformSetupSyncRelatedEntity(_calls, new PropertyChangedEventHandler(OnCallsPropertyChanged), "Calls", CustomerAccountGlocomNumberEntity.Relations.CallsEntityUsingCallId, true, new string[] { }); } }
/// <summary> Initializes the class members</summary> protected virtual void InitClassMembers() { _calls = null; PerformDependencyInjection(); // __LLBLGENPRO_USER_CODE_REGION_START InitClassMembers // __LLBLGENPRO_USER_CODE_REGION_END OnInitClassMembersComplete(); }
public static CallsDto ToDto(this CallsEntity call) { return(new CallsDto() { CallId = call.CallId, DestinationNumber = call.DestinationNumber, Duration = call.Duration, ExternalPrice = call.ExternalPrice, LineId = call.LineId, //Line=call.Line.ToDto() }); }
protected CallCenterNotesEntity(SerializationInfo info, StreamingContext context) : base(info, context) { if (SerializationHelper.Optimization != SerializationOptimization.Fast) { _calls = (CallsEntity)info.GetValue("_calls", typeof(CallsEntity)); if (_calls != null) { _calls.AfterSave += new EventHandler(OnEntityAfterSave); } base.FixupDeserialization(FieldInfoProviderSingleton.GetInstance()); } // __LLBLGENPRO_USER_CODE_REGION_START DeserializationConstructor // __LLBLGENPRO_USER_CODE_REGION_END }
public void SaveCallDispositionAndIsContacted(long callId, string disposition, long callQueueCustomerId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var callEntity = new CallsEntity() { Disposition = disposition, IsContacted = callQueueCustomerId > 0 ? true : (bool?)null }; var bucket = new RelationPredicateBucket(CallsFields.CallId == callId); if (adapter.UpdateEntitiesDirectly(callEntity, bucket) == 0) { throw new PersistenceFailureException("CallId doesn't exist"); } } }
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 async Task <CallsDto> CreateCall(CallsDto call) { using (CellularCompanyContext db = new CellularCompanyContext()) { try { if (call != null) { CallsEntity entity = call.ToModel(); db.Calls.Add(entity); await db.SaveChangesAsync(); return(entity.ToDto()); } return(null); } catch (Exception ex) { Debug.WriteLine(ex.Message); return(null); } } }
/// <summary> Removes the sync logic for member _calls</summary> /// <param name="signalRelatedEntity">If set to true, it will call the related entity's UnsetRelatedEntity method</param> /// <param name="resetFKFields">if set to true it will also reset the FK fields pointing to the related entity</param> private void DesetupSyncCalls(bool signalRelatedEntity, bool resetFKFields) { base.PerformDesetupSyncRelatedEntity(_calls, new PropertyChangedEventHandler(OnCallsPropertyChanged), "Calls", CustomerAccountGlocomNumberEntity.Relations.CallsEntityUsingCallId, true, signalRelatedEntity, "CustomerAccountGlocomNumber", resetFKFields, new int[] { (int)CustomerAccountGlocomNumberFieldIndex.CallId }); _calls = null; }
/// <summary> Removes the sync logic for member _calls</summary> /// <param name="signalRelatedEntity">If set to true, it will call the related entity's UnsetRelatedEntity method</param> /// <param name="resetFKFields">if set to true it will also reset the FK fields pointing to the related entity</param> private void DesetupSyncCalls(bool signalRelatedEntity, bool resetFKFields) { base.PerformDesetupSyncRelatedEntity(_calls, new PropertyChangedEventHandler(OnCallsPropertyChanged), "Calls", CallCenterNotesEntity.Relations.CallsEntityUsingCallId, true, signalRelatedEntity, "CallCenterNotes", resetFKFields, new int[] { (int)CallCenterNotesFieldIndex.CallId }); _calls = null; }
public bool MergeCustomer(long oldCustomerId, long newCustomerId, long orgRoleId) { using (var adapter = PersistenceLayer.GetDataAccessAdapter()) { var eventCustomer = new EventCustomersEntity { CustomerId = newCustomerId }; var eventCustomerBucket = new RelationPredicateBucket(EventCustomersFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(eventCustomer, eventCustomerBucket); eventCustomer = new EventCustomersEntity { CreatedByOrgRoleUserId = newCustomerId }; eventCustomerBucket = new RelationPredicateBucket(EventCustomersFields.CreatedByOrgRoleUserId == oldCustomerId); adapter.UpdateEntitiesDirectly(eventCustomer, eventCustomerBucket); var eventAppointment = new EventAppointmentEntity { ScheduledByOrgRoleUserId = newCustomerId }; var eventAppointmentBucket = new RelationPredicateBucket(EventAppointmentFields.ScheduledByOrgRoleUserId == oldCustomerId); adapter.UpdateEntitiesDirectly(eventAppointment, eventAppointmentBucket); var customerEventTestFinding = new CustomerEventTestFindingEntity { CustomerId = newCustomerId }; var customerEventTestBucket = new RelationPredicateBucket(CustomerEventTestFindingFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerEventTestFinding, customerEventTestBucket); var hospitalPartnerCustomer = new HospitalPartnerCustomerEntity { CustomerId = newCustomerId }; var hospitalPartnerCustomerBucket = new RelationPredicateBucket(HospitalPartnerCustomerFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(hospitalPartnerCustomer, hospitalPartnerCustomerBucket); var customerPrimaryCarePhysician = new CustomerPrimaryCarePhysicianEntity { CustomerId = newCustomerId, IsActive = false, DateModified = DateTime.Now, UpdatedByOrganizationRoleUserId = orgRoleId }; var customerPrimaryCarePhysicianBucket = new RelationPredicateBucket(CustomerPrimaryCarePhysicianFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerPrimaryCarePhysician, customerPrimaryCarePhysicianBucket); var preApprovedTest = new PreApprovedTestEntity { CustomerId = newCustomerId, IsActive = false, DateEnd = DateTime.Now }; var preApprovedTestBucket = new RelationPredicateBucket(PreApprovedTestFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(preApprovedTest, preApprovedTestBucket); var preApprovedPackage = new PreApprovedPackageEntity { CustomerId = newCustomerId, IsActive = false, DateEnd = DateTime.Now }; var preApprovedPackageBucket = new RelationPredicateBucket(PreApprovedPackageFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(preApprovedPackage, preApprovedPackageBucket); var customerIcdCode = new CustomerIcdCodeEntity { CustomerId = newCustomerId, IsActive = false, DateEnd = DateTime.Now }; var customerIcdCodeBucket = new RelationPredicateBucket(CustomerIcdCodeFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerIcdCode, customerIcdCodeBucket); var currentMedication = new CurrentMedicationEntity { CustomerId = newCustomerId, IsActive = false, DateEnd = DateTime.Now }; var currentMedicationBucket = new RelationPredicateBucket(CurrentMedicationFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(currentMedication, currentMedicationBucket); var chaseOutbound = new ChaseOutboundEntity { CustomerId = newCustomerId, IsActive = false, EndDate = DateTime.Now }; var chaseOutboundBucket = new RelationPredicateBucket(ChaseOutboundFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(chaseOutbound, chaseOutboundBucket); var customerChaseCampaign = new CustomerChaseCampaignEntity { CustomerId = newCustomerId, IsActive = false }; var customerChaseCampaignBucket = new RelationPredicateBucket(CustomerChaseCampaignFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerChaseCampaign, customerChaseCampaignBucket); var customerChaseChannel = new CustomerChaseChannelEntity { CustomerId = newCustomerId }; var customerChaseChannelBucket = new RelationPredicateBucket(CustomerChaseChannelFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerChaseChannel, customerChaseChannelBucket); var customerChaseProduct = new CustomerChaseProductEntity { CustomerId = newCustomerId }; var customerChaseProductBucket = new RelationPredicateBucket(CustomerChaseProductFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerChaseProduct, customerChaseProductBucket); var orderDetail = new OrderDetailEntity { ForOrganizationRoleUserId = newCustomerId }; var orderDetailBucket = new RelationPredicateBucket(OrderDetailFields.ForOrganizationRoleUserId == oldCustomerId); adapter.UpdateEntitiesDirectly(orderDetail, orderDetailBucket); var order = new OrderEntity { OrganizationRoleUserCreatorId = newCustomerId }; var orderBucket = new RelationPredicateBucket(OrderFields.OrganizationRoleUserCreatorId == oldCustomerId); adapter.UpdateEntitiesDirectly(order, orderBucket); var eventCustomerResult = new EventCustomerResultEntity { CustomerId = newCustomerId }; var eventCustomerResultBucket = new RelationPredicateBucket(EventCustomerResultFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(eventCustomerResult, eventCustomerResultBucket); var eventCustomerResultHistory = new EventCustomerResultHistoryEntity { CustomerId = newCustomerId }; var eventCustomerResultHistoryBucket = new RelationPredicateBucket(EventCustomerResultHistoryFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(eventCustomerResultHistory, eventCustomerResultHistoryBucket); var resultArchiveUploadLog = new ResultArchiveUploadLogEntity { CustomerId = newCustomerId }; var resultArchiveUploadLogBucket = new RelationPredicateBucket(ResultArchiveUploadLogFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(resultArchiveUploadLog, resultArchiveUploadLogBucket); var customerHealthInfo = new CustomerHealthInfoEntity { CustomerId = newCustomerId }; var customerHealthInfoBucket = new RelationPredicateBucket(CustomerHealthInfoFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerHealthInfo, customerHealthInfoBucket); var customerHealthInfoArchive = new CustomerHealthInfoArchiveEntity { CustomerId = newCustomerId }; var customerHealthInfoArchiveBucket = new RelationPredicateBucket(CustomerHealthInfoArchiveFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerHealthInfoArchive, customerHealthInfoArchiveBucket); var customerTag = new CustomerTagEntity { CustomerId = newCustomerId }; var customerTagBucket = new RelationPredicateBucket(CustomerTagFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerTag, customerTagBucket); var customerRegistrationNotes = new CustomerRegistrationNotesEntity { CustomerId = newCustomerId }; var customerRegistrationNotesBucket = new RelationPredicateBucket(CustomerRegistrationNotesFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerRegistrationNotes, customerRegistrationNotesBucket); var directMail = new DirectMailEntity { CustomerId = newCustomerId }; var directMailBucket = new RelationPredicateBucket(DirectMailFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(directMail, directMailBucket); var calls = new CallsEntity { CalledCustomerId = newCustomerId }; var callsBucket = new RelationPredicateBucket(CallsFields.CalledCustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(calls, callsBucket); var callQueueCustomer = new CallQueueCustomerEntity { CustomerId = newCustomerId, Status = (int)CallQueueStatus.Removed }; var callQueueCustomerBucket = new RelationPredicateBucket(CallQueueCustomerFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(callQueueCustomer, callQueueCustomerBucket); var customerHistory = new CustomerProfileHistoryEntity() { CustomerId = newCustomerId }; var customerHistoryBucket = new RelationPredicateBucket(CustomerProfileHistoryFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerHistory, customerHistoryBucket); var preQualificationResult = new PreQualificationResultEntity { CustomerId = newCustomerId }; var preQualificationResultBucket = new RelationPredicateBucket(PreQualificationResultFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(preQualificationResult, preQualificationResultBucket); var customerCallQueueCallAttempt = new CustomerCallQueueCallAttemptEntity { CustomerId = newCustomerId }; var customerCallQueueCallAttemptBucket = new RelationPredicateBucket(CustomerCallQueueCallAttemptFields.CustomerId == oldCustomerId); adapter.UpdateEntitiesDirectly(customerCallQueueCallAttempt, customerCallQueueCallAttemptBucket); } return(true); }