public bool UpdatePatient(CommonPatient patient)
{
var sqlParams = new
{
PatientId = patient.Id,
Title = patient.Title,
Given = patient.FirstName,
Surname = patient.LastName,
BirthDate = patient.DateOfBirth,
Address1 = patient.ResidentialAddress,
Suburb = patient.ResidentialSuburb,
State = patient.ResidentialState,
Postcode = patient.ResidentialPostCode,
Phone_Mob = patient.Mobile,
Email = patient.Email,
Phone_Ah = patient.Phone,
Sex = patient.Gender,
IsInActive = patient.InActive,
HealthFund = patient.HealthFundName,
MemberNum = patient.HealthFundMemberNumber,
Medicare = patient.MedicareMemberNumber,
MedRef = patient.MeidcareReferenceNumber,
Expiry = patient.MedicareExpiryDate?.ToString(),
//HealthFundRefNo = patient.HealthFundReferenceNumber,
//NoHealthFund = !patient.HasHealthFund,
//DVANumber = patient.DVAPensionNumber,
//PostalAddress = patient.PostalAddress,
//PostalSuburb = patient.PostalSuburb,
//PostalState = patient.PostalState,
//PostalPostCode = patient.PostalPostCode,
};
return(ExecConn($"{SetPassWordQuery} {UpdatePatientQuery}", sqlParams) > 0);
}
public int InsertPatient(CommonPatient patient)
{
var sqlParams = new
{
Title = patient.Title,
FirstName = patient.FirstName,
LastName = patient.LastName,
BirthDate = patient.DateOfBirth,
Gender = patient.Gender,
InActive = false,
ResidentAddress = patient.ResidentialAddress,
ResidentSuburb = patient.ResidentialSuburb,
ResidentState = patient.ResidentialState,
ResidentPostCode = patient.ResidentialPostCode,
PostalAddress = patient.PostalAddress,
PostalSuburb = patient.PostalSuburb,
PostalState = patient.PostalState,
PostalPostCode = patient.PostalPostCode,
Mobile = patient.Mobile,
Email = patient.Email,
Phone = patient.Phone,
HealthFundIdentifier = patient.HealthFundName,
MemberNumber = patient.HealthFundMemberNumber,
HealthFundRefNo = patient.HealthFundReferenceNumber,
NoHealthFund = !patient.HasHealthFund,
MedicareNumber = patient.MedicareMemberNumber,
MedicareRefNo = patient.MeidcareReferenceNumber,
MedicareExpiry = patient.MedicareExpiryDate,
DVANumber = patient.DVAPensionNumber
};
return(ExecScalarConn(InsertPatientQuery, sqlParams));
}
public int InsertPatient(CommonPatient patient)
{
try
{
return(_repo.InsertPatient(patient));
}
catch (Exception ex)
{
Log.Error(ex.Message);
}
return(0);
}
public bool UpdatePatient(CommonPatient patient)
{
try
{
return(_repo.UpdatePatient(patient));
}
catch (Exception ex)
{
Log.Error(ex.Message);
}
return(false);
}
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);
}
public bool UpdatePatient(string PMS, CommonPatient patient)
{
try
{
if (!string.IsNullOrEmpty(PMS))
{
_connectionString = _configuration.GetValue <string>("ConnectionStrings:" + PMS);
_patientService = new PatientService(myContainer.Resolve <IRepository>(PMS, new ResolverOverride[]
{
new ParameterOverride("ConnectionString", _connectionString)
}), logger);
return(_patientService.UpdatePatient(patient));
}
}
catch (Exception ex)
{
Log.Error(ex.Message);
}
return(false);
}
