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 void GetDataSet()
{
string serializableString = VisitService.SearchNewVisitProperties();
var serializer = new XmlSerializer(typeof(ClinicDataSet));
var reader = new StringReader(serializableString);
clinicDataSet = serializer.Deserialize(reader) as ClinicDataSet;
reader.Close();
}
public BindingList <VisitForGrid> SearchVisits(string mrn, string patientFirstName, string billingNumber)
{
string serializableString = new VisitServiceClient().SearchVisits(mrn, patientFirstName, billingNumber);
var serializer = new XmlSerializer(typeof(ClinicDataSet));
var reader = new StringReader(serializableString);
ClinicDataSet clinicDataSet = serializer.Deserialize(reader) as ClinicDataSet;
reader.Close();
var visitList = new BindingList <VisitForGrid>();
visitList = new BindingList <VisitForGrid>(clinicDataSet.Visits.Join(clinicDataSet.Apartments, visitRow => visitRow.ApartmentId, apartmentRow => apartmentRow.Id, (visitRow, apartmentRow) => new
{
BillingNumber = visitRow.BillingNumber,
Room = apartmentRow.RoomId,
Bed = apartmentRow.BedId,
PatientId = visitRow.PatientId,
ClinicId = apartmentRow.ClinicId
}).Join(clinicDataSet.Clinics, visitRow => visitRow.ClinicId, clinicRow => clinicRow.Id, (visitRow, clinicRow) => new
{
BillingNumber = visitRow.BillingNumber,
Room = visitRow.Room,
Bed = visitRow.Bed,
PatientId = visitRow.PatientId,
Clinic = clinicRow.Name,
DoctorId = clinicRow.DoctorId
}).Join(clinicDataSet.Doctors, visitRow => visitRow.DoctorId, doctorRow => doctorRow.Id, (visitRow, doctorRow) => new
{
BillingNumber = visitRow.BillingNumber,
Room = visitRow.Room,
Bed = visitRow.Bed,
PatientId = visitRow.PatientId,
Clinic = visitRow.Clinic,
DoctorFirstName = doctorRow.FirstName,
DoctorLastName = doctorRow.LastName
}).Join(clinicDataSet.Patients, visitRow => visitRow.PatientId, patientRow => patientRow.Id, (visitRow, patientRow) => new VisitForGrid
{
BillingNumber = visitRow.BillingNumber,
Room = visitRow.Room,
Bed = visitRow.Bed,
ClinicName = visitRow.Clinic,
DoctorFirstName = visitRow.DoctorFirstName,
DoctorLastName = visitRow.DoctorLastName,
PatientFirstName = patientRow.FirstName,
PatientLastName = patientRow.LastName
}).ToArray());
return(visitList);
}
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());
}
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();
}
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();
}
