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);
}
