public CommonPatient GetPatient(int patientId)
{
var sqlParams = new DynamicParameters(new { patientId = patientId });
OptomatePatient patient = QueryConn <OptomatePatient>($"{SetPassWordQuery} {GetPatientQuery}",
sqlParams).FirstOrDefault();
return(ToCommonPatient(patient));
}
public int InsertPatient(CommonPatient patient)
{
int rowsrfected = 0;
int nextId = GetClientNextId();
int recordsWithNextId = GetClientCount(nextId);
while (recordsWithNextId > 0)
{
nextId = nextId + 1;
recordsWithNextId = GetClientCount(nextId);
}
bool nextIdSet = SetClientNextId(nextId);
OptomatePatient newPatient = new OptomatePatient()
{
Number = nextId,
Given = patient.FirstName,
Surname = patient.LastName,
Address1 = patient.ResidentialAddress,
Suburb = patient.ResidentialSuburb,
State = patient.ResidentialState,
Postcode = patient.ResidentialPostCode,
Phone_Ah = patient.Phone,
Phone_Mob = patient.Mobile,
Email = patient.Email,
BirthDate = patient.DateOfBirth,
Title = patient.Title,
Sex = patient.Gender,
IsInActive = false,
HealthFund = patient.HealthFundName,
MemberNum = patient.HealthFundMemberNumber,
Medicare = patient.MedicareMemberNumber,
MedRef = patient.MeidcareReferenceNumber,
Expiry = patient.MedicareExpiryDate?.ToString()
};
rowsrfected = ExecConn($"{SetPassWordQuery} {InsertPatientQuery}", newPatient);
if (rowsrfected > 0)
{
return(nextId);
}
return(0);
}
private CommonPatient ToCommonPatient(OptomatePatient optomatePatient)
{
if (optomatePatient == null)
{
return(null);
}
return(new CommonPatient()
{
Id = optomatePatient.Number,
Title = optomatePatient.Title,
FirstName = optomatePatient.Given,
LastName = optomatePatient.Surname,
DateOfBirth = optomatePatient.BirthDate,
Gender = optomatePatient.Sex,
Mobile = optomatePatient.Phone_Mob,
Email = optomatePatient.Email,
Phone = optomatePatient.Phone_Ah,
ResidentialAddress = optomatePatient.Address1,
ResidentialSuburb = optomatePatient.Suburb,
ResidentialPostCode = optomatePatient.State,
ResidentialState = optomatePatient.Postcode,
HealthFundName = optomatePatient.HealthFund,
HealthFundMemberNumber = optomatePatient.MemberNum,
MedicareMemberNumber = optomatePatient.Medicare,
HasHealthFund = !(string.IsNullOrEmpty(optomatePatient.HealthFund)),
MeidcareReferenceNumber = optomatePatient.MedRef
//PostAddressSameAsResidentialAddress = optomatePatient.Title,
//PostalAddress = optomatePatient.Title,
//PostalSuburb = optomatePatient.Title,
//PostalPostCode = optomatePatient.Title,
//PostalState = optomatePatient.Title,
//HealthFundReferenceNumber = optomatePatient.,
//MedicareExpiryDate = optomatePatient.Expiry,
//DVAPensionNumber = optomatePatient.DVAPensionNumber
});
}
