public static string Update(string firstName, string middleName, string lastName, int personSex, int personId, int patientId, int?ptn_pk, DateTime dateOfBirth, bool DOB_Precision, string nationalId, int facilityId,
int entryPointId, DateTime enrollmentDate, string cccNumber, PatientLookup patient, string godsNumber, int matStatusId,
string village, int wardId, int subCountyId, int countyId, string nearestLandMark, string postalAdress, string phoneNumber, DateTime?deathDate,
List <NEXTOFKIN> nextofkin, int userId)
{
try
{
//todo: fetch assigning facility from the message
string assigning_Facility = "";
PersonManager personManager = new PersonManager();
var patientManager = new PatientManager();
var patientEntryPointManager = new PatientEntryPointManager();
var patientIdentifierManager = new PatientIdentifierManager();
var patientEnrollmentManager = new PatientEnrollmentManager();
var personIdentifierManager = new PersonIdentifierManager();
PersonMaritalStatusManager personMaritalStatusManager = new PersonMaritalStatusManager();
PersonLocationManager locationManager = new PersonLocationManager();
PersonContactManager contactManager = new PersonContactManager();
var personContactLookUp = new PersonContactLookUpManager();
var patientTreatmentlookupManager = new PatientTreatmentSupporterLookupManager();
var treatmentSupporterManager = new PatientTreatmentSupporterManager();
personManager.UpdatePerson(firstName, middleName, lastName, personSex, userId, patient.PersonId, dateOfBirth, DOB_Precision);
if (!string.IsNullOrWhiteSpace(godsNumber))
{
IdentifierManager identifierManager = new IdentifierManager();
Identifier identifier = identifierManager.GetIdentifierByCode("GODS_NUMBER");
var personIdentifiers = personIdentifierManager.GetPersonIdentifiers(personId, identifier.Id);
if (personIdentifiers.Count == 0)
{
personIdentifierManager.AddPersonIdentifier(personId, identifier.Id, godsNumber, userId, assigning_Facility);
}
}
if (matStatusId > 0)
{
var currentMaritalStatus = personMaritalStatusManager.GetCurrentPatientMaritalStatus(personId);
if (currentMaritalStatus != null)
{
currentMaritalStatus.MaritalStatusId = matStatusId;
personMaritalStatusManager.UpdatePatientMaritalStatus(currentMaritalStatus);
}
else
{
personMaritalStatusManager.AddPatientMaritalStatus(personId, matStatusId, userId);
}
}
if (wardId > 0 && subCountyId > 0 && countyId > 0)
{
var currentLocation = locationManager.GetCurrentPersonLocation(personId);
if (currentLocation.Count > 0)
{
currentLocation[0].DeleteFlag = true;
locationManager.UpdatePersonLocation(currentLocation[0]);
}
locationManager.AddPersonLocation(personId, countyId, subCountyId, wardId, village, "", "", nearestLandMark, nearestLandMark, userId);
}
if (postalAdress != null || phoneNumber != null)
{
var contacts = personContactLookUp.GetPersonContactByPersonId(personId);
if (contacts.Count > 0)
{
PersonContact perContact = new PersonContact();
perContact.Id = contacts[0].Id;
perContact.PersonId = contacts[0].PersonId;
perContact.PhysicalAddress = (postalAdress);
perContact.MobileNumber = (phoneNumber);
perContact.AlternativeNumber = "";
perContact.EmailAddress = "";
contactManager.UpdatePatientContact(perContact);
}
else
{
contactManager.AddPersonContact(personId, postalAdress, phoneNumber, "", "", userId);
}
}
if (nextofkin.Count > 0)
{
foreach (var kin in nextofkin)
{
if (kin.CONTACT_ROLE == "T")
{
//Get Gender
string gender = kin.SEX == "F" ? "Female" : "Male";
//IQCare Sex
LookupLogic lookupLogic = new LookupLogic();
int sex = lookupLogic.GetItemIdByGroupAndItemName("Gender", gender)[0].ItemId;
var listPatientTreatmentSupporter = patientTreatmentlookupManager.GetAllPatientTreatmentSupporter(personId);
if (listPatientTreatmentSupporter.Count > 0)
{
personManager.UpdatePerson(kin.NOK_NAME.FIRST_NAME, kin.NOK_NAME.MIDDLE_NAME, kin.NOK_NAME.LAST_NAME, sex, userId, listPatientTreatmentSupporter[0].SupporterId);
if (listPatientTreatmentSupporter[0].SupporterId > 0)
{
var treatmentSupporter = patientTreatmentlookupManager.GetAllPatientTreatmentSupporter(personId);
if (treatmentSupporter.Count > 0)
{
PatientTreatmentSupporter supporter = new PatientTreatmentSupporter()
{
Id = treatmentSupporter[0].Id,
PersonId = personId,
SupporterId = listPatientTreatmentSupporter[0].SupporterId,
MobileContact = kin.PHONE_NUMBER,
CreatedBy = treatmentSupporter[0].CreatedBy,
DeleteFlag = treatmentSupporter[0].DeleteFlag
};
treatmentSupporterManager.UpdatePatientTreatmentSupporter(supporter);
}
}
}
else
{
int supporterId = personManager.AddPersonTreatmentSupporterUiLogic(kin.NOK_NAME.FIRST_NAME, kin.NOK_NAME.MIDDLE_NAME, kin.NOK_NAME.LAST_NAME, sex, userId);
if (supporterId > 0)
{
treatmentSupporterManager.AddPatientTreatmentSupporter(personId, supporterId, kin.PHONE_NUMBER, userId);
}
}
}
}
}
List <PatientLookup> patientLookups = new List <PatientLookup>();
patientLookups.Add(patient);
var entity = patientLookups.ConvertAll(x => new PatientEntity {
Id = x.Id, Active = x.Active, DateOfBirth = x.DateOfBirth, ptn_pk = x.ptn_pk, PatientType = x.PatientType, PatientIndex = x.PatientIndex, NationalId = x.NationalId, FacilityId = x.FacilityId
});
var patientAuditData = AuditDataUtility.AuditDataUtility.Serializer(entity);
PatientEntity updatePatient = new PatientEntity();
updatePatient.ptn_pk = ptn_pk;
updatePatient.DateOfBirth = dateOfBirth;
updatePatient.DobPrecision = DOB_Precision;
updatePatient.NationalId = nationalId;
updatePatient.FacilityId = facilityId;
updatePatient.AuditData = patientAuditData;
patientManager.UpdatePatient(updatePatient, patientId);
List <PatientEntryPoint> entryPoints = patientEntryPointManager.GetPatientEntryPoints(patient.Id, 1);
if (entryPoints.Count > 0)
{
string entryPointAuditData = null;
entryPointAuditData = AuditDataUtility.AuditDataUtility.Serializer(entryPoints);
entryPoints[0].EntryPointId = entryPointId;
entryPoints[0].AuditData = entryPointAuditData;
patientEntryPointManager.UpdatePatientEntryPoint(entryPoints[0]);
}
else
{
patientEntryPointManager.addPatientEntryPoint(patientId, entryPointId, userId);
}
var identifiersByPatientId = patientIdentifierManager.GetPatientEntityIdentifiersByPatientId(patientId, 1);
if (identifiersByPatientId.Count > 0)
{
foreach (var entityIdentifier in identifiersByPatientId)
{
int enrollmentId = entityIdentifier.PatientEnrollmentId;
PatientEntityEnrollment entityEnrollment = patientEnrollmentManager.GetPatientEntityEnrollment(enrollmentId);
List <PatientEntityEnrollment> listEnrollment = new List <PatientEntityEnrollment>();
listEnrollment.Add(entityEnrollment);
var enrollmentAuditData = AuditDataUtility.AuditDataUtility.Serializer(listEnrollment);
entityEnrollment.EnrollmentDate = enrollmentDate;
entityEnrollment.AuditData = enrollmentAuditData;
patientEnrollmentManager.updatePatientEnrollment(entityEnrollment);
var entityIdentifierAuditData = AuditDataUtility.AuditDataUtility.Serializer(identifiersByPatientId);
entityIdentifier.IdentifierValue = cccNumber;
entityIdentifier.AuditData = entityIdentifierAuditData;
patientIdentifierManager.UpdatePatientIdentifier(entityIdentifier, facilityId, false);
if (deathDate.HasValue)
{
PatientMasterVisitManager masterVisitManager = new PatientMasterVisitManager();
PatientCareEndingManager careEndingManager = new PatientCareEndingManager();
LookupLogic lookupLogic = new LookupLogic();
int itemId = lookupLogic.GetItemIdByGroupAndItemName("CareEnded", "Death")[0].ItemId;
int patientMasterVisitId = masterVisitManager.GetLastPatientVisit(patientId).Id;
careEndingManager.AddPatientCareEndingDeath(patientId, patientMasterVisitId, enrollmentId, itemId, deathDate.Value, deathDate.Value, "", null, null);
PatientEntityEnrollment entityEnrollmentCareEnded = patientEnrollmentManager.GetPatientEntityEnrollment(enrollmentId);
entityEnrollmentCareEnded.CareEnded = true;
patientEnrollmentManager.updatePatientEnrollment(entityEnrollmentCareEnded);
}
}
}
else
{
var assigningFacility = cccNumber.Substring(0, 5);
int patientEnrollmentId = patientEnrollmentManager.addPatientEnrollment(patientId, enrollmentDate.ToString(), userId);
int patientEntryPointId = patientEntryPointManager.addPatientEntryPoint(patientId, entryPointId, userId);
int patientIdentifierId = patientIdentifierManager.addPatientIdentifier(patientId, patientEnrollmentId, 1, cccNumber, facilityId, assigningFacility, false);
if (deathDate.HasValue)
{
PatientMasterVisitManager masterVisitManager = new PatientMasterVisitManager();
PatientCareEndingManager careEndingManager = new PatientCareEndingManager();
LookupLogic lookupLogic = new LookupLogic();
int itemId = lookupLogic.GetItemIdByGroupAndItemName("CareEnded", "Death")[0].ItemId;
int patientMasterVisitId = masterVisitManager.GetLastPatientVisit(patientId).Id;
careEndingManager.AddPatientCareEndingDeath(patientId, patientMasterVisitId, patientEnrollmentId, itemId, deathDate.Value, deathDate.Value, "", null, null);
PatientEntityEnrollment entityEnrollmentCareEnded = patientEnrollmentManager.GetPatientEntityEnrollment(patientEnrollmentId);
entityEnrollmentCareEnded.CareEnded = true;
patientEnrollmentManager.updatePatientEnrollment(entityEnrollmentCareEnded);
}
}
return("Successfully updated patient");
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public static string Add(string firstName, string middleName, string lastName, int sex, int userId, DateTime dob, bool dobPrecision, int facilityId,
int patientType, string nationalId, int visitType, DateTime dateOfEnrollment, string cccNumber, int entryPointId, string godsNumber, int matStatusId,
string village, int wardId, int subCountyId, int countyId, string nearestLandMark, string postalAdress, string phoneNumber, DateTime?deathDate,
List <NEXTOFKIN> nextofkin)
{
try
{
PersonManager personManager = new PersonManager();
PatientManager patientManager = new PatientManager();
PatientMasterVisitManager patientMasterVisitManager = new PatientMasterVisitManager();
PatientEnrollmentManager patientEnrollmentManager = new PatientEnrollmentManager();
PatientEntryPointManager patientEntryPointManager = new PatientEntryPointManager();
PersonLookUpManager personLookUp = new PersonLookUpManager();
PersonContactLookUpManager personContactLookUpManager = new PersonContactLookUpManager();
MstPatientLogic mstPatientLogic = new MstPatientLogic();
PatientIdentifierManager patientIdentifierManager = new PatientIdentifierManager();
PersonMaritalStatusManager personMaritalStatusManager = new PersonMaritalStatusManager();
PersonLocationManager locationManager = new PersonLocationManager();
PersonContactManager contactManager = new PersonContactManager();
var treatmentSupporterManager = new PatientTreatmentSupporterManager();
LookupLogic lookupLogic = new LookupLogic();
var personIdentifierManager = new PersonIdentifierManager();
//todo: fetch assigning facility from the message
string assigning_Facility = "";
var personContacts = new List <PersonContactLookUp>();
int ptn_Pk = 0;
//Start Saving
int personId = personManager.AddPersonUiLogic(firstName, middleName, lastName, sex, userId, dob, dobPrecision);
if (matStatusId > 0)
{
personMaritalStatusManager.AddPatientMaritalStatus(personId, matStatusId, userId);
}
if (wardId > 0 && subCountyId > 0 && countyId > 0)
{
locationManager.AddPersonLocation(personId, countyId, subCountyId, wardId, village, "", "", nearestLandMark, nearestLandMark, userId);
}
if (postalAdress != null || phoneNumber != null)
{
contactManager.AddPersonContact(personId, postalAdress, phoneNumber, "", "", userId);
}
String sDate = DateTime.Now.ToString();
DateTime datevalue = Convert.ToDateTime(sDate);
var patientIndex = datevalue.Year.ToString() + '-' + personId;
if (!string.IsNullOrWhiteSpace(godsNumber))
{
IdentifierManager identifierManager = new IdentifierManager();
Identifier identifier = identifierManager.GetIdentifierByCode("GODS_NUMBER");
var personIdentifiers = personIdentifierManager.GetPersonIdentifiers(personId, identifier.Id);
if (personIdentifiers.Count == 0)
{
personIdentifierManager.AddPersonIdentifier(personId, identifier.Id, godsNumber, userId, assigning_Facility);
}
}
if (nextofkin.Count > 0)
{
foreach (var kin in nextofkin)
{
if (kin.CONTACT_ROLE == "T")
{
//Get Gender
string gender = kin.SEX == "F" ? "Female" : "Male";
//IQCare Sex
int sexT = lookupLogic.GetItemIdByGroupAndItemName("Gender", gender)[0].ItemId;
int supporterId = personManager.AddPersonTreatmentSupporterUiLogic(kin.NOK_NAME.FIRST_NAME, kin.NOK_NAME.MIDDLE_NAME, kin.NOK_NAME.LAST_NAME, sexT, 1);
if (supporterId > 0)
{
treatmentSupporterManager.AddPatientTreatmentSupporter(personId, supporterId, kin.PHONE_NUMBER, userId);
}
}
}
}
PatientEntity patientEntity = new PatientEntity();
patientEntity.PersonId = personId;
patientEntity.ptn_pk = 0;
patientEntity.FacilityId = facilityId;
patientEntity.PatientType = patientType;
patientEntity.PatientIndex = patientIndex;
patientEntity.DateOfBirth = dob;
patientEntity.NationalId = (nationalId);
patientEntity.Active = true;
patientEntity.CreatedBy = 1;
patientEntity.CreateDate = DateTime.Now;
patientEntity.DeleteFlag = false;
patientEntity.DobPrecision = dobPrecision;
int patientId = patientManager.AddPatient(patientEntity);
var facility = lookupLogic.GetFacility();
//Add enrollment visit
int patientMasterVisitId = patientMasterVisitManager.AddPatientMasterVisit(patientId, userId, visitType, facility.FacilityID);
//Enroll Patient to service
int patientEnrollmentId = patientEnrollmentManager.addPatientEnrollment(patientId, dateOfEnrollment.ToString(), userId);
//Add enrollment entry point
int patientEntryPointId = patientEntryPointManager.addPatientEntryPoint(patientId, entryPointId, userId);
if (deathDate.HasValue)
{
PatientCareEndingManager careEndingManager = new PatientCareEndingManager();
int itemId = lookupLogic.GetItemIdByGroupAndItemName("CareEnded", "Death")[0].ItemId;
careEndingManager.AddPatientCareEndingDeath(patientId, patientMasterVisitId, patientEnrollmentId, itemId, deathDate.Value, deathDate.Value, "", null, null);
PatientEntityEnrollment entityEnrollment = patientEnrollmentManager.GetPatientEntityEnrollment(patientEnrollmentId);
entityEnrollment.CareEnded = true;
patientEnrollmentManager.updatePatientEnrollment(entityEnrollment);
}
//Get User Details to be used in BLUE CARD
var patient_person_details = personLookUp.GetPersonById(personId);
var greencardlookup = new PersonGreenCardLookupManager();
var greencardptnpk = greencardlookup.GetPtnPkByPersonId(personId);
if (patient_person_details != null)
{
var maritalStatus = new PersonMaritalStatusManager().GetCurrentPatientMaritalStatus(personId);
personContacts = personContactLookUpManager.GetPersonContactByPersonId(personId);
var address = "";
var phone = "";
if (personContacts.Count > 0)
{
address = personContacts[0].PhysicalAddress;
phone = personContacts[0].MobileNumber;
}
var MaritalStatusId = 0;
if (maritalStatus != null)
{
MaritalStatusId = maritalStatus.MaritalStatusId;
}
var sexBluecard = 0;
var enrollmentBlueCardId = "";
if (LookupLogic.GetLookupNameById(patient_person_details.Sex) == "Male")
{
sexBluecard = 16;
}
else if (LookupLogic.GetLookupNameById(patient_person_details.Sex) == "Female")
{
sexBluecard = 17;
}
enrollmentBlueCardId = cccNumber;
if (greencardptnpk.Count == 0)
{
ptn_Pk = mstPatientLogic.InsertMstPatient((patient_person_details.FirstName), (patient_person_details.LastName), (patient_person_details.MiddleName), facilityId, enrollmentBlueCardId, entryPointId, dateOfEnrollment, sexBluecard, dob, 1, MaritalStatusId, address, phone, 1, facilityId.ToString(), 203, dateOfEnrollment, DateTime.Now);
patientEntity.ptn_pk = ptn_Pk;
patientManager.UpdatePatient(patientEntity, patientId);
}
else
{
ptn_Pk = greencardptnpk[0].Ptn_Pk;
patientEntity.ptn_pk = greencardptnpk[0].Ptn_Pk;
patientManager.UpdatePatient(patientEntity, patientId);
}
}
if (patientMasterVisitId > 0)
{
var assigningFacility = cccNumber.Substring(0, 5);
int patientIdentifierId = patientIdentifierManager.addPatientIdentifier(patientId, patientEnrollmentId, 1, cccNumber, facilityId, assigningFacility, false);
if (greencardptnpk.Count == 0)
{
mstPatientLogic.AddOrdVisit(ptn_Pk, facilityId, DateTime.Now, 110, userId, DateTime.Now, 203);
}
}
return("successfully saved");
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public string AddPatientTreatmentSupporter(int patientId, string firstName, string middleName, string lastName, int gender, string mobile, int userId)
{
var patientLogic = new PatientLookupManager();
var patient = patientLogic.GetPatientDetailSummary(patientId);
var personId = patient.PersonId;
var personLogic = new PersonManager();
var personTreatmentSupporterId = personLogic.AddPersonTreatmentSupporterUiLogic(firstName,
middleName,
lastName, gender, userId);
Session["PersonTreatmentSupporterId"] = personTreatmentSupporterId;
if (personTreatmentSupporterId > 0)
{
msg += "<p>New Treatment Supporter Person Added Successfully!</p>";
var treatmentSupporter = new PatientTreatmentSupporterManager();
//var treatment = treatmentSupporter.GetPatientTreatmentSupporter(personId);
var treatmentSupporterLookup = new PatientTreatmentSupporterLookupManager();
var treatmentlookup = treatmentSupporterLookup.GetAllPatientTreatmentSupporter(personId);
if (treatmentlookup.Count > 0)
{
//treatmentlookup[0].DeleteFlag = true;
PatientTreatmentSupporter treatment = new PatientTreatmentSupporter();
treatment.DeleteFlag = true;
treatment.Id = treatmentlookup[0].Id;
treatment.MobileContact = treatmentlookup[0].MobileContact;
treatment.SupporterId = treatmentlookup[0].SupporterId;
treatment.PersonId = treatmentlookup[0].PersonId;
treatmentSupporter.UpdatePatientTreatmentSupporter(treatment);
}
var result = treatmentSupporter.AddPatientTreatmentSupporter(personId, personTreatmentSupporterId,
mobile, userId);
if (result > 0)
{
msg += "<p>Person Treatement Supported Added Successfully!</p>";
}
if (patient != null)
{
MessageEventArgs args = new MessageEventArgs()
{
PatientId = patient.Id,
EntityId = patient.Id,
MessageType = MessageType.UpdatedClientInformation,
EventOccurred = "Patient Enrolled Identifier = ",
FacilityId = patient.FacilityId
};
Publisher.RaiseEventAsync(this, args).ConfigureAwait(false);
}
}
return(msg);
}