public string SearchNewVisitProperties() { clinicDataSet = ClinicSetTables.ClinicDataSet; Patient[] patientsList = PatientMethods.Instance.GetPatients(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); foreach (var patient in patientsList) { PatientsRow patientRow = clinicDataSet.Patients.NewPatientsRow(); patientRow.Id = patient.Id; patientRow.Mrn = patient.Mrn; patientRow.FirstName = patient.FirstName; patientRow.LastName = patient.LastName; clinicDataSet.Patients.AddPatientsRow(patientRow); } Doctor[] doctorsList = DoctorMethods.Instance.GetDoctors(string.Empty, string.Empty, string.Empty); foreach (var doctor in doctorsList) { DoctorsRow doctorRow = clinicDataSet.Doctors.NewDoctorsRow(); doctorRow.Id = doctor.Id; doctorRow.Code = doctor.Code; doctorRow.FirstName = doctor.FirstName; doctorRow.LastName = doctor.LastName; clinicDataSet.Doctors.AddDoctorsRow(doctorRow); } Apartment[] apartmentsList = ApartmentMethods.Instance.GetAllApartments(); foreach (var apartment in apartmentsList) { ApartmentsRow apartmentRow = clinicDataSet.Apartments.NewApartmentsRow(); apartmentRow.Id = apartment.Id; apartmentRow.ClinicId = apartment.Clinic.Id; apartmentRow.RoomId = apartment.RoomId; apartmentRow.BedId = apartment.BedId; clinicDataSet.Apartments.AddApartmentsRow(apartmentRow); } Clinic1[] clinicsList = ClinicMethods.Instance.GetClinics(string.Empty, string.Empty); foreach (var clinic in clinicsList) { ClinicsRow clinicRow = clinicDataSet.Clinics.NewClinicsRow(); clinicRow.Id = clinic.Id; clinicRow.Code = clinic.Code; clinicRow.Name = clinic.Name; clinicRow.DoctorId = DoctorMethods.Instance.GetDoctorByClinic(clinic.Code).Id; clinicDataSet.Clinics.AddClinicsRow(clinicRow); } XmlSerializer serializer = new XmlSerializer(typeof(ClinicDataSet)); StringWriter writer = new StringWriter(); serializer.Serialize(writer, clinicDataSet); writer.Close(); return(writer.ToString()); }
public string SearchVisits(string searchMrn, string searchPatientFirstName, string searchBllingNumber) { clinicDataSet = ClinicSetTables.ClinicDataSet; Visit[] visitsList = VisitMethods.Instance.GetVisits(searchMrn, searchPatientFirstName, searchBllingNumber); foreach (var visit in visitsList) { VisitsRow visitRow = clinicDataSet.Visits.NewVisitsRow(); visitRow.BillingNumber = visit.BillingNumber; visitRow.PatientId = visit.Patient.Id; visitRow.ApartmentId = visit.Apartment.Id; clinicDataSet.Visits.AddVisitsRow(visitRow); if (clinicDataSet.Patients.SingleOrDefault <PatientsRow>(row => row.Id == visit.Patient.Id) == null) { PatientsRow patientRow = clinicDataSet.Patients.NewPatientsRow(); patientRow.Id = visit.Patient.Id; patientRow.Mrn = visit.Patient.Mrn; patientRow.FirstName = visit.Patient.FirstName; patientRow.LastName = visit.Patient.LastName; clinicDataSet.Patients.AddPatientsRow(patientRow); } if (clinicDataSet.Apartments.SingleOrDefault <ApartmentsRow>(row => row.Id == visit.Apartment.Id) == null) { ApartmentsRow apartmentRow = clinicDataSet.Apartments.NewApartmentsRow(); apartmentRow.Id = visit.Apartment.Id; apartmentRow.ClinicId = visit.Apartment.Clinic.Id; apartmentRow.RoomId = visit.Apartment.RoomId; apartmentRow.BedId = visit.Apartment.BedId; clinicDataSet.Apartments.AddApartmentsRow(apartmentRow); } if (clinicDataSet.Doctors.SingleOrDefault <DoctorsRow>(row => row.Id == visit.Doctor.Id) == null) { DoctorsRow doctorRow = clinicDataSet.Doctors.NewDoctorsRow(); doctorRow.Id = visit.Doctor.Id; doctorRow.Code = visit.Doctor.Code; doctorRow.FirstName = visit.Doctor.FirstName; doctorRow.LastName = visit.Doctor.LastName; clinicDataSet.Doctors.AddDoctorsRow(doctorRow); } if (clinicDataSet.Clinics.SingleOrDefault <ClinicsRow>(row => row.Id == visit.Apartment.Clinic.Id) == null) { ClinicsRow clinicRow = clinicDataSet.Clinics.NewClinicsRow(); clinicRow.Id = visit.Apartment.Clinic.Id; clinicRow.Code = visit.Apartment.Clinic.Code; clinicRow.Name = visit.Apartment.Clinic.Name; clinicRow.DoctorId = visit.Doctor.Id; clinicDataSet.Clinics.AddClinicsRow(clinicRow); } } XmlSerializer serializer = new XmlSerializer(typeof(ClinicDataSet)); StringWriter writer = new StringWriter(); serializer.Serialize(writer, clinicDataSet); writer.Close(); return(writer.ToString()); }