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