public async Task <Result <AddPersonOccupationLevelResponse> > Handle(PersonOccupationLevelCommand request, CancellationToken cancellationToken)
{
try
{
PersonOccupationService personOccupationService = new PersonOccupationService(_unitOfWork);
List <PersonOccupation> personOccupations = await personOccupationService.GetCurrentOccupation(request.PersonId);
PersonOccupation personOccupation = new PersonOccupation();
if (personOccupations.Count > 0)
{
personOccupations[0].Occupation = request.Occupation;
personOccupation = await personOccupationService.Update(personOccupations[0]);
}
else
{
PersonOccupation pc = new PersonOccupation()
{
PersonId = request.PersonId,
Occupation = request.Occupation,
CreateDate = DateTime.Now,
CreatedBy = request.UserId,
Active = false,
DeleteFlag = false
};
personOccupation = await personOccupationService.Add(pc);
}
return(Result <AddPersonOccupationLevelResponse> .Valid(new AddPersonOccupationLevelResponse()
{
Message = "Success",
OccupationId = personOccupation.Id
}));
}
catch (Exception e)
{
return(Result <AddPersonOccupationLevelResponse> .Invalid(e.Message));
}
}
public async Task <Result <string> > Handle(SynchronizeFamilyCommand request, CancellationToken cancellationToken)
{
using (_htsUnitOfWork)
using (_unitOfWork)
{
string afyaMobileId = string.Empty;
string indexClientAfyaMobileId = string.Empty;
RegisterPersonService registerPersonService = new RegisterPersonService(_unitOfWork);
EncounterTestingService encounterTestingService = new EncounterTestingService(_unitOfWork, _htsUnitOfWork);
PersonOccupationService pocc = new PersonOccupationService(_unitOfWork);
EducationLevelService educationLevelService = new EducationLevelService(_unitOfWork);
var facilityId = request.MESSAGE_HEADER.SENDING_FACILITY;
for (int i = 0; i < request.FAMILY.Count; i++)
{
for (int j = 0; j < request.FAMILY[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID.Count; j++)
{
if (request.FAMILY[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].IDENTIFIER_TYPE ==
"AFYA_MOBILE_ID")
{
afyaMobileId = request.FAMILY[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].ID;
}
if (request.FAMILY[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].IDENTIFIER_TYPE ==
"INDEX_CLIENT_AFYAMOBILE_ID")
{
indexClientAfyaMobileId =
request.FAMILY[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].ID;
}
}
var afyaMobileMessage = await registerPersonService.AddAfyaMobileInbox(DateTime.Now, request.MESSAGE_HEADER.MESSAGE_TYPE, indexClientAfyaMobileId, JsonConvert.SerializeObject(request), false);
try
{
string firstName = request.FAMILY[i].PATIENT_IDENTIFICATION.PATIENT_NAME.FIRST_NAME;
string middleName = request.FAMILY[i].PATIENT_IDENTIFICATION.PATIENT_NAME.MIDDLE_NAME;
string lastName = request.FAMILY[i].PATIENT_IDENTIFICATION.PATIENT_NAME.LAST_NAME;
int sex = request.FAMILY[i].PATIENT_IDENTIFICATION.SEX;
string nickName = (request.FAMILY[i].PATIENT_IDENTIFICATION.PATIENT_NAME.NICK_NAME == null) ? "" : request.FAMILY[i].PATIENT_IDENTIFICATION.PATIENT_NAME.NICK_NAME.ToString();
int ward = request.FAMILY[i].PATIENT_IDENTIFICATION.PATIENT_ADDRESS.PHYSICAL_ADDRESS.WARD;
int county = request.FAMILY[i].PATIENT_IDENTIFICATION.PATIENT_ADDRESS.PHYSICAL_ADDRESS.COUNTY;
int subcounty = request.FAMILY[i].PATIENT_IDENTIFICATION.PATIENT_ADDRESS.PHYSICAL_ADDRESS.SUB_COUNTY;
string educationlevel = (request.FAMILY[i].PATIENT_IDENTIFICATION.EDUCATIONLEVEL == null) ? "" : request.FAMILY[i].PATIENT_IDENTIFICATION.EDUCATIONLEVEL.ToString();
string educationoutcome = (request.FAMILY[i].PATIENT_IDENTIFICATION.EDUCATIONOUTCOME == null) ? "" : request.FAMILY[i].PATIENT_IDENTIFICATION.EDUCATIONOUTCOME.ToString();
string occupation = (request.FAMILY[i].PATIENT_IDENTIFICATION.OCCUPATION == null) ? "" : request.FAMILY[i].PATIENT_IDENTIFICATION.OCCUPATION.ToString();
DateTime dateOfBirth = DateTime.ParseExact(request.FAMILY[i].PATIENT_IDENTIFICATION.DATE_OF_BIRTH, "yyyyMMdd", null);
int providerId = request.FAMILY[i].PATIENT_IDENTIFICATION.USER_ID;
int maritalStatusId = request.FAMILY[i].PATIENT_IDENTIFICATION.MARITAL_STATUS;
string mobileNumber = request.FAMILY[i].PATIENT_IDENTIFICATION.PHONE_NUMBER;
string landmark = request.FAMILY[i].PATIENT_IDENTIFICATION.PATIENT_ADDRESS.PHYSICAL_ADDRESS
.LANDMARK;
int relationshipType = request.FAMILY[i].PATIENT_IDENTIFICATION.RELATIONSHIP_TYPE;
int Userid = request.FAMILY[i].PATIENT_IDENTIFICATION.USER_ID;
Facility clientFacility = await _unitOfWork.Repository <Facility>().Get(x => x.PosID == facilityId).FirstOrDefaultAsync();
if (clientFacility == null)
{
clientFacility = await _unitOfWork.Repository <Facility>().Get(x => x.DeleteFlag == 0).FirstOrDefaultAsync();
}
var indexClientIdentifiers = await registerPersonService.getPersonIdentifiers(indexClientAfyaMobileId, 10);
if (indexClientIdentifiers.Count > 0)
{
//Get Index client
var indexClient = await registerPersonService.GetPatientByPersonId(indexClientIdentifiers[0].PersonId);
var partnetPersonIdentifiers = await registerPersonService.getPersonIdentifiers(afyaMobileId, 10);
if (partnetPersonIdentifiers.Count > 0)
{
await registerPersonService.UpdatePerson(partnetPersonIdentifiers[0].PersonId, firstName, middleName, lastName, sex, dateOfBirth, clientFacility.FacilityID, NickName : nickName);
//update maritalstatus id
await registerPersonService.UpdateMaritalStatus(partnetPersonIdentifiers[0].PersonId, maritalStatusId);
if (!string.IsNullOrWhiteSpace(mobileNumber))
{
await registerPersonService.UpdatePersonContact(partnetPersonIdentifiers[0].PersonId, null, mobileNumber);
}
if (!string.IsNullOrWhiteSpace(landmark) || (county > 0) || (subcounty > 0) || (ward > 0))
{
var personlocation = await registerPersonService.UpdatePersonLocation(partnetPersonIdentifiers[0].PersonId, landmark, ward, county, subcounty, Userid);
}
if (!string.IsNullOrWhiteSpace(educationlevel))
{
var personeducation = await educationLevelService.UpdatePersonEducation(partnetPersonIdentifiers[0].PersonId, educationlevel, educationoutcome, Userid);
}
if (!string.IsNullOrWhiteSpace(occupation))
{
var personoccupation = await pocc.Update(partnetPersonIdentifiers[0].PersonId, occupation, Userid);
}
var getPersonRelationship = await registerPersonService.GetPersonRelationshipByPatientIdPersonId(indexClient.Id, partnetPersonIdentifiers[0].PersonId);
if (getPersonRelationship != null)
{
getPersonRelationship.RelationshipTypeId = relationshipType;
var updatedRelationship = await registerPersonService.UpdatePersonRelationship(getPersonRelationship);
}
else
{
//Add PersonRelationship
var personRelationship = await registerPersonService.addPersonRelationship(partnetPersonIdentifiers[0].PersonId, indexClient.Id, relationshipType, providerId);
}
/***
* Encounter
*/
if (request.FAMILY[i].ENCOUNTER != null)
{
if (request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING != null)
{
DateTime screeningDate = DateTime.ParseExact(request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING.SCREENING_DATE, "yyyyMMdd", null);
int hivStatus = request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING.HIV_STATUS;
int eligible = request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING.ELIGIBLE_FOR_HTS;
DateTime bookingDate = DateTime.ParseExact(request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING.BOOKING_DATE, "yyyyMMdd", null);
string remarks = request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING.REMARKS;
var familyScreenings = await _unitOfWork.Repository <LookupItemView>().Get(x => x.MasterName == "FamilyScreening")
.ToListAsync();
List <Screening> familyScreeningList = new List <Screening>();
for (int j = 0; j < familyScreenings.Count; j++)
{
if (familyScreenings[j].ItemName == "EligibleTesting")
{
Screening screening = new Screening()
{
ScreeningCategoryId = familyScreenings[j].ItemId,
ScreeningTypeId = familyScreenings[j].MasterId,
ScreeningValueId = eligible
};
familyScreeningList.Add(screening);
}
else if (familyScreenings[j].ItemName == "ScreeningHivStatus")
{
Screening screening = new Screening()
{
ScreeningCategoryId = familyScreenings[j].ItemId,
ScreeningTypeId = familyScreenings[j].MasterId,
ScreeningValueId = hivStatus
};
familyScreeningList.Add(screening);
}
}
var patientMasterVisitEntity = await _unitOfWork.Repository <PatientMasterVisit>()
.Get(x => x.PatientId == indexClient.Id && x.ServiceId == 2).ToListAsync();
int patientMasterVisitId = patientMasterVisitEntity.OrderBy(x => x.Id).FirstOrDefault().Id;
var familyScreeningReturnValue =
await encounterTestingService.AddPartnerScreening(partnetPersonIdentifiers[0].PersonId, indexClient.Id, patientMasterVisitId, null,
screeningDate, bookingDate, familyScreeningList, providerId);
}
for (int j = 0; j < request.FAMILY[i].ENCOUNTER.TRACING.Count; j++)
{
var lookupitem = await _unitOfWork.Repository <LookupItemView>()
.Get(x => x.MasterName == "TracingType" && x.ItemName == "Family").ToListAsync();
int tracingType = lookupitem[0].ItemId;
DateTime tracingDate = DateTime.ParseExact(request.FAMILY[i].ENCOUNTER.TRACING[j].TRACING_DATE, "yyyyMMdd", null);
int mode = request.FAMILY[i].ENCOUNTER.TRACING[j].TRACING_MODE;
int outcome = request.FAMILY[i].ENCOUNTER.TRACING[j].TRACING_OUTCOME;
DateTime?reminderDate = null;
if (!string.IsNullOrWhiteSpace(request.FAMILY[i].ENCOUNTER.TRACING[j].REMINDER_DATE))
{
reminderDate = DateTime.ParseExact(request.FAMILY[i].ENCOUNTER.TRACING[j].REMINDER_DATE, "yyyyMMdd", null);
}
DateTime?tracingBookingDate = null;
if (!string.IsNullOrWhiteSpace(request.FAMILY[i].ENCOUNTER.TRACING[j].BOOKING_DATE))
{
tracingBookingDate = DateTime.ParseExact(request.FAMILY[i].ENCOUNTER.TRACING[j].BOOKING_DATE, "yyyyMMdd", null);
}
int consent = request.FAMILY[i].ENCOUNTER.TRACING[j].CONSENT;
int? ReasonNotContacted = request.FAMILY[i].ENCOUNTER.TRACING[j].REASONNOTCONTACTED;
string reasonnotcontactedOther = request.FAMILY[i].ENCOUNTER.TRACING[j].REASONNOTCONTACTEDOTHER;
var trace = await encounterTestingService.addTracing(partnetPersonIdentifiers[0].PersonId, tracingType, tracingDate, mode, outcome,
providerId, null, consent, tracingBookingDate, reminderDate, ReasonNotContacted, reasonnotcontactedOther);
}
}
}
else
{
//Register family
var person = await registerPersonService.RegisterPerson(firstName, middleName, lastName, sex, providerId, clientFacility.FacilityID, dateOfBirth, nickName : nickName);
//Add afyamobile Id as an Id of the family
var personIdentifier = await registerPersonService.addPersonIdentifiers(person.Id, 10, afyaMobileId, providerId);
//Add family marital status
var partnerMaritalStatus = await registerPersonService.AddMaritalStatus(person.Id, maritalStatusId, providerId);
//add family contacts
if (string.IsNullOrWhiteSpace(mobileNumber))
{
var partnerContacts = await registerPersonService.addPersonContact(person.Id, null, mobileNumber, null, null, providerId);
}
//add family location
/* if (!string.IsNullOrWhiteSpace(landmark))
* {
* var partnerLocation = await registerPersonService.addPersonLocation(person.Id, 0, 0, 0, "", landmark, providerId);
* }*/
if (!string.IsNullOrWhiteSpace(landmark) || (county > 0) || (subcounty > 0) || (ward > 0))
{
var partnerLocation = await registerPersonService.UpdatePersonLocation(person.Id, landmark, ward, county, subcounty, Userid);
}
if (!string.IsNullOrWhiteSpace(educationlevel))
{
var partnereducation = await educationLevelService.UpdatePersonEducation(person.Id, educationlevel, educationoutcome, Userid);
}
if (!string.IsNullOrWhiteSpace(occupation))
{
var partneroccupation = await pocc.Update(person.Id, occupation, Userid);
}
//Add PersonRelationship
var personRelationship = await registerPersonService.addPersonRelationship(person.Id, indexClient.Id, relationshipType, providerId);
/***
* Encounter
*/
if (request.FAMILY[i].ENCOUNTER != null)
{
if (request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING != null)
{
DateTime screeningDate = DateTime.ParseExact(request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING.SCREENING_DATE, "yyyyMMdd", null);
int hivStatus = request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING.HIV_STATUS;
int eligible = request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING.ELIGIBLE_FOR_HTS;
DateTime bookingDate = DateTime.ParseExact(request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING.BOOKING_DATE, "yyyyMMdd", null);
string remarks = request.FAMILY[i].ENCOUNTER.FAMILY_SCREENING.REMARKS;
var familyScreenings = await _unitOfWork.Repository <LookupItemView>().Get(x => x.MasterName == "FamilyScreening")
.ToListAsync();
List <Screening> familyScreeningList = new List <Screening>();
for (int j = 0; j < familyScreenings.Count; j++)
{
if (familyScreenings[j].ItemName == "EligibleTesting")
{
Screening screening = new Screening()
{
ScreeningCategoryId = familyScreenings[j].ItemId,
ScreeningTypeId = familyScreenings[j].MasterId,
ScreeningValueId = eligible
};
familyScreeningList.Add(screening);
}
else if (familyScreenings[j].ItemName == "ScreeningHivStatus")
{
Screening screening = new Screening()
{
ScreeningCategoryId = familyScreenings[j].ItemId,
ScreeningTypeId = familyScreenings[j].MasterId,
ScreeningValueId = hivStatus
};
familyScreeningList.Add(screening);
}
}
var patientMasterVisitEntity = await _unitOfWork.Repository <PatientMasterVisit>()
.Get(x => x.PatientId == indexClient.Id && x.ServiceId == 2).ToListAsync();
int patientMasterVisitId = patientMasterVisitEntity.OrderBy(x => x.Id).FirstOrDefault().Id;
var familyScreeningReturnValue =
await encounterTestingService.AddPartnerScreening(person.Id, indexClient.Id, patientMasterVisitId, null,
screeningDate, bookingDate, familyScreeningList, providerId);
}
for (int j = 0; j < request.FAMILY[i].ENCOUNTER.TRACING.Count; j++)
{
var lookupitem = await _unitOfWork.Repository <LookupItemView>()
.Get(x => x.MasterName == "TracingType" && x.ItemName == "Family").ToListAsync();
int tracingType = lookupitem[0].ItemId;
DateTime tracingDate = DateTime.ParseExact(request.FAMILY[i].ENCOUNTER.TRACING[j].TRACING_DATE, "yyyyMMdd", null);
int mode = request.FAMILY[i].ENCOUNTER.TRACING[j].TRACING_MODE;
int outcome = request.FAMILY[i].ENCOUNTER.TRACING[j].TRACING_OUTCOME;
DateTime?reminderDate = null;
if (!string.IsNullOrWhiteSpace(request.FAMILY[i].ENCOUNTER.TRACING[j].REMINDER_DATE))
{
reminderDate = DateTime.ParseExact(request.FAMILY[i].ENCOUNTER.TRACING[j].REMINDER_DATE, "yyyyMMdd", null);
}
DateTime?tracingBookingDate = null;
if (!string.IsNullOrWhiteSpace(request.FAMILY[i].ENCOUNTER.TRACING[j].BOOKING_DATE))
{
tracingBookingDate = DateTime.ParseExact(request.FAMILY[i].ENCOUNTER.TRACING[j].BOOKING_DATE, "yyyyMMdd", null);
}
int consent = request.FAMILY[i].ENCOUNTER.TRACING[j].CONSENT;
int? reasonnotcontacted = request.FAMILY[i].ENCOUNTER.TRACING[j].REASONNOTCONTACTED;
string reasonnotcontactedother = request.FAMILY[i].ENCOUNTER.TRACING[j].REASONNOTCONTACTEDOTHER;
var trace = await encounterTestingService.addTracing(person.Id, tracingType, tracingDate, mode, outcome,
providerId, null, consent, tracingBookingDate, reminderDate, reasonnotcontacted, reasonnotcontactedother);
}
}
}
}
// update message as processed
await registerPersonService.UpdateAfyaMobileInbox(afyaMobileMessage.Id, indexClientAfyaMobileId, true, DateTime.Now, "success");
return(Result <string> .Valid(afyaMobileId));
}
catch (Exception e)
{
Log.Error(e.Message);
Log.Error(e.InnerException.ToString());
// update message as processed
await registerPersonService.UpdateAfyaMobileInbox(afyaMobileMessage.Id, indexClientAfyaMobileId, false, DateTime.Now, e.Message + " " + e.InnerException.ToString());
return(Result <string> .Invalid(e.Message));
}
}
return(Result <string> .Valid(afyaMobileId));
}
}
public async Task <Result <string> > Handle(AfyaMobileSynchronizeClientsCommand request, CancellationToken cancellationToken)
{
string afyaMobileId = String.Empty;
using (var trans = _unitOfWork.Context.Database.BeginTransaction())
{
RegisterPersonService registerPersonService = new RegisterPersonService(_unitOfWork);
LookupLogic lookupLogic = new LookupLogic(_unitOfWork);
PersonOccupationService pocc = new PersonOccupationService(_unitOfWork);
EducationLevelService educationLevelService = new EducationLevelService(_unitOfWork);
for (int i = 0; i < request.CLIENTS.Count; i++)
{
for (int j = 0; j < request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID.Count; j++)
{
if (request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].IDENTIFIER_TYPE == "AFYA_MOBILE_ID" &&
request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].ASSIGNING_AUTHORITY == "AFYAMOBILE")
{
afyaMobileId = request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].ID;
}
}
}
var afyaMobileMessage = await registerPersonService.AddAfyaMobileInbox(DateTime.Now, request.MESSAGE_HEADER.MESSAGE_TYPE, afyaMobileId, JsonConvert.SerializeObject(request), false);
try
{
var facilityId = request.MESSAGE_HEADER.SENDING_FACILITY;
for (int i = 0; i < request.CLIENTS.Count; i++)
{
string firstName = request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_NAME.FIRST_NAME;
string middleName = string.IsNullOrWhiteSpace(request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_NAME.MIDDLE_NAME) ? "" : request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_NAME.MIDDLE_NAME;
string lastName = request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_NAME.LAST_NAME;
string nickName = (request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_NAME.NICK_NAME == null) ? "" : request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_NAME.NICK_NAME.ToString();
int sex = request.CLIENTS[i].PATIENT_IDENTIFICATION.SEX;
//Try to parse dateOfBirth
DateTime dateOfBirth = DateTime.Now;
try
{
dateOfBirth = DateTime.ParseExact(request.CLIENTS[i].PATIENT_IDENTIFICATION.DATE_OF_BIRTH, "yyyyMMdd", null);
}
catch (Exception e)
{
Log.Error($"Could not parse DateOfBirth: {request.CLIENTS[i].PATIENT_IDENTIFICATION.DATE_OF_BIRTH} as a valid date. Incorrect format, date should be in the following format yyyyMMdd");
throw new Exception($"Could not parse DateOfBirth: {request.CLIENTS[i].PATIENT_IDENTIFICATION.DATE_OF_BIRTH} as a valid date. Incorrect format, date should be in the following format yyyyMMdd");
}
string dobPrecision = request.CLIENTS[i].PATIENT_IDENTIFICATION.DATE_OF_BIRTH_PRECISION;
//Try to parse DateOfEnrollment
DateTime dateEnrollment = DateTime.Now;
try
{
dateEnrollment = DateTime.ParseExact(request.CLIENTS[i].PATIENT_IDENTIFICATION.REGISTRATION_DATE, "yyyyMMdd", null);
}
catch (Exception e)
{
Log.Error($"Could not parse DateOfEnrollment: {request.CLIENTS[i].PATIENT_IDENTIFICATION.REGISTRATION_DATE} as a valid date: Incorrect format, date should be in the following format yyyyMMdd");
throw new Exception($"Could not parse DateOfEnrollment: {request.CLIENTS[i].PATIENT_IDENTIFICATION.REGISTRATION_DATE} as a valid date: Incorrect format, date should be in the following format yyyyMMdd");
}
int maritalStatusId = request.CLIENTS[i].PATIENT_IDENTIFICATION.MARITAL_STATUS;
string landmark = request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_ADDRESS.PHYSICAL_ADDRESS
.LANDMARK;
int ward = request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_ADDRESS.PHYSICAL_ADDRESS.WARD;
int county = request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_ADDRESS.PHYSICAL_ADDRESS.COUNTY;
int subcounty = request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_ADDRESS.PHYSICAL_ADDRESS.SUB_COUNTY;
string educationlevel = (request.CLIENTS[i].PATIENT_IDENTIFICATION.EDUCATIONLEVEL == null) ? "" : request.CLIENTS[i].PATIENT_IDENTIFICATION.EDUCATIONLEVEL.ToString();
string educationoutcome = (request.CLIENTS[i].PATIENT_IDENTIFICATION.EDUCATIONOUTCOME == null) ? "" : request.CLIENTS[i].PATIENT_IDENTIFICATION.EDUCATIONOUTCOME.ToString();
string occupation = (request.CLIENTS[i].PATIENT_IDENTIFICATION.OCCUPATION == null) ? "" : request.CLIENTS[i].PATIENT_IDENTIFICATION.OCCUPATION.ToString();
string physicalAddress = request.CLIENTS[i].PATIENT_IDENTIFICATION.PATIENT_ADDRESS.POSTAL_ADDRESS;
string mobileNumber = request.CLIENTS[i].PATIENT_IDENTIFICATION.PHONE_NUMBER;
string enrollmentNo = string.Empty;
int userId = request.CLIENTS[i].PATIENT_IDENTIFICATION.USER_ID;
string maritalStatusName = String.Empty;
string gender = String.Empty;
var maritalStatusList = await lookupLogic.GetLookupNameByGroupNameItemId(maritalStatusId, "HTSMaritalStatus");
var genderList = await lookupLogic.GetLookupNameByGroupNameItemId(sex, "Gender");
if (maritalStatusList.Count > 0)
{
maritalStatusName = maritalStatusList[0].ItemName;
}
if (genderList.Count > 0)
{
gender = genderList[0].ItemName;
}
for (int j = 0; j < request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID.Count; j++)
{
if (request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].ASSIGNING_AUTHORITY ==
"HTS" && request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].IDENTIFIER_TYPE == "HTS_SERIAL")
{
enrollmentNo = request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].ID;
}
if (request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].IDENTIFIER_TYPE == "AFYA_MOBILE_ID" &&
request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].ASSIGNING_AUTHORITY == "AFYAMOBILE")
{
afyaMobileId = request.CLIENTS[i].PATIENT_IDENTIFICATION.INTERNAL_PATIENT_ID[j].ID;
}
}
Facility clientFacility = await _unitOfWork.Repository <Facility>().Get(x => x.PosID == facilityId).FirstOrDefaultAsync();
if (clientFacility == null)
{
clientFacility = await _unitOfWork.Repository <Facility>().Get(x => x.DeleteFlag == 0).FirstOrDefaultAsync();
}
//check if person already exists
var identifiers = await registerPersonService.getPersonIdentifiers(afyaMobileId, 10);
if (identifiers.Count > 0)
{
var registeredPerson = await registerPersonService.GetPerson(identifiers[0].PersonId);
if (registeredPerson != null)
{
var updatedPerson = await registerPersonService.UpdatePerson(identifiers[0].PersonId,
firstName, middleName, lastName, sex, dateOfBirth, clientFacility.FacilityID, registrationDate : dateEnrollment, NickName : nickName);
}
else
{
var person = await registerPersonService.RegisterPerson(firstName, middleName, lastName,
sex, userId, clientFacility.FacilityID, dateOfBirth, nickName : nickName);
}
var patient = await registerPersonService.GetPatientByPersonId(identifiers[0].PersonId);
if (patient != null)
{
var updatedPatient = await registerPersonService.UpdatePatient(patient.Id, dateOfBirth, facilityId);
}
else
{
//Add Person to mst_patient
var mstResult = await registerPersonService.InsertIntoBlueCard(firstName, lastName,
middleName, dateEnrollment, " ", 283, maritalStatusName, physicalAddress, mobileNumber, gender, dobPrecision, dateOfBirth, userId, facilityId);
if (mstResult.Count > 0)
{
patient = await registerPersonService.AddPatient(identifiers[0].PersonId, userId, facilityId);
// Person is enrolled state
var enrollmentAppState = await registerPersonService.AddAppStateStore(identifiers[0].PersonId, patient.Id, 7, null, null);
// Enroll patient
var patientIdentifier = await registerPersonService.EnrollPatient(enrollmentNo, patient.Id, 2, userId, dateEnrollment);
//Add PersonIdentifiers
var personIdentifier = await registerPersonService.addPersonIdentifiers(identifiers[0].PersonId, 10, afyaMobileId, userId);
}
}
var updatedPersonPopulations = await registerPersonService.UpdatePersonPopulation(identifiers[0].PersonId,
request.CLIENTS[i].PATIENT_IDENTIFICATION.KEY_POP, userId);
//Location
if (!string.IsNullOrWhiteSpace(landmark) || (county > 0) || (subcounty > 0) || (ward > 0))
{
var updatedLocation = await registerPersonService.UpdatePersonLocation(identifiers[0].PersonId, landmark, ward, county, subcounty, userId);
}
if (!string.IsNullOrWhiteSpace(educationlevel))
{
var personeducation = await educationLevelService.UpdatePersonEducation(identifiers[0].PersonId, educationlevel, educationoutcome, userId);
}
if (!string.IsNullOrWhiteSpace(occupation))
{
var personoccupation = await pocc.Update(identifiers[0].PersonId, occupation, userId);
}
if (!string.IsNullOrWhiteSpace(mobileNumber) || !string.IsNullOrWhiteSpace(physicalAddress))
{
//add Person Contact
var personContact =
await registerPersonService.UpdatePersonContact(identifiers[0].PersonId,
physicalAddress, mobileNumber);
}
// update message as processed
await registerPersonService.UpdateAfyaMobileInbox(afyaMobileMessage.Id, afyaMobileId, true, DateTime.Now, "success", true);
}
else
{
// Add Person
var person = await registerPersonService.RegisterPerson(firstName, middleName, lastName, sex,
userId, clientFacility.FacilityID, dateOfBirth, nickName : nickName);
//Add Person to mst_patient
var mstResult = await registerPersonService.InsertIntoBlueCard(firstName, lastName, middleName, dateEnrollment, " ", 283, maritalStatusName, physicalAddress, mobileNumber, gender, dobPrecision, dateOfBirth, userId, facilityId);
if (mstResult.Count > 0)
{
//Add PersonIdentifiers
var personIdentifier = await registerPersonService.addPersonIdentifiers(person.Id, 10, afyaMobileId, userId);
// Add Patient
var patient = await registerPersonService.AddPatient(person.Id, userId, mstResult[0].Ptn_Pk, facilityId);
// Person is enrolled state
var enrollmentAppState = await registerPersonService.AddAppStateStore(person.Id, patient.Id, 7, null, null);
// Enroll patient
var patientIdentifier = await registerPersonService.EnrollPatient(enrollmentNo, patient.Id, 2, userId, dateEnrollment);
// Add Marital Status
var maritalStatus = await registerPersonService.AddMaritalStatus(person.Id, maritalStatusId, userId);
// Add Person Key pop
var population = await registerPersonService.addPersonPopulation(person.Id, request.CLIENTS[i].PATIENT_IDENTIFICATION.KEY_POP, userId);
// Add Person Location
if (!string.IsNullOrWhiteSpace(landmark) || (county > 0) || (subcounty > 0) || (ward > 0))
{
var personLocation = await registerPersonService.UpdatePersonLocation(person.Id, landmark, ward, county, subcounty, userId);
}
if (!string.IsNullOrWhiteSpace(educationlevel))
{
var personeducation = await educationLevelService.UpdatePersonEducation(person.Id, educationlevel, educationoutcome, userId);
}
if (!string.IsNullOrWhiteSpace(occupation))
{
var personoccupation = await pocc.Update(person.Id, occupation, userId);
}
if (!string.IsNullOrWhiteSpace(mobileNumber) || !string.IsNullOrWhiteSpace(physicalAddress))
{
//add Person Contact
var personContact = await registerPersonService.addPersonContact(person.Id, physicalAddress,
mobileNumber, string.Empty, string.Empty, userId);
}
//update message has been processed
await registerPersonService.UpdateAfyaMobileInbox(afyaMobileMessage.Id, afyaMobileId, true, DateTime.Now, $"Successfully synchronized demographics for afyamobileid: {afyaMobileId}", true);
}
}
}
//update message has been processed
await registerPersonService.UpdateAfyaMobileInbox(afyaMobileMessage.Id, afyaMobileId, true, DateTime.Now, $"Successfully synchronized demographics for afyamobileid: {afyaMobileId}", true);
trans.Commit();
return(Result <string> .Valid($"Successfully synchronized demographics for afyamobileid: {afyaMobileId}"));
}
catch (Exception ex)
{
trans.Rollback();
Log.Error($"Error syncronizing afyamobileid: {afyaMobileId}. Exception Message: {ex.Message}, Inner Exception {ex.InnerException}");
return(Result <string> .Invalid($"Failed to synchronize clientId: {afyaMobileId} " + ex.Message + " " + ex.InnerException));
}
}
}