public bool AppointmentBooking(string patientName, string doctorName, DateTime appointmentTime, string clinicName) { string[] patientNames = patientName.Split(' '); string[] doctorNames = doctorName.Split(' '); if (patientNames.Length != 2 || doctorNames.Length != 2) { return false; } Patient patient = GetPatientInfo(patientNames[0], patientNames[1]); Doctor doctor = GetDoctorInfo(doctorNames[0], doctorNames[1]); Appointment a = new Appointment() { HealthInsuranceNo = patient.HealthInsuranceNo, MedicalRegistrationNo = doctor.MedicalRegistrationNo, AppointmentTime = appointmentTime, ClinicName = clinicName }; string sql = String.Format("INSERT INTO Appointments VALUES('{0}', '{1}', '{2}', '{3}')", a.HealthInsuranceNo, a.MedicalRegistrationNo, a.AppointmentTime, a.ClinicName); SqlCommand command = new SqlCommand(sql, conn); conn.Open(); int num; try { num = command.ExecuteNonQuery(); conn.Close(); } catch (Exception e) { conn.Close(); throw new FaultException(e.Message); } if (num > 0) return true; else return false; }
public bool AppointmentReschedule(string patientName, string doctorName, DateTime newTime) { string[] patientNames = patientName.Split(' '); string[] doctorNames = doctorName.Split(' '); if (patientNames.Length != 2 || doctorNames.Length != 2) { return false; } Patient patient = GetPatientInfo(patientNames[0], patientNames[1]); Doctor doctor = GetDoctorInfo(doctorNames[0], doctorNames[1]); Appointment a = new Appointment() { HealthInsuranceNo = patient.HealthInsuranceNo, MedicalRegistrationNo = doctor.MedicalRegistrationNo, AppointmentTime = newTime, }; string sql = String.Format("UPDATE Appointments SET AppointmentTime='{0}' WHERE HealthInsuranceNo='{1}' AND MedicalRegistrationNo='{2}'", a.AppointmentTime, a.HealthInsuranceNo, a.MedicalRegistrationNo); SqlCommand command = new SqlCommand(sql, conn); conn.Open(); int num; try { num = command.ExecuteNonQuery(); conn.Close(); } catch (Exception e) { conn.Close(); throw new FaultException(e.Message); } if (num > 0) return true; else return false; }
public Models.Appointment GetAppointment(string patientName, string doctorName) { string[] patientNames = patientName.Split(' '); string[] doctorNames = doctorName.Split(' '); if (patientNames.Length != 2 || doctorNames.Length != 2) { return null; } Patient patient = GetPatientInfo(patientNames[0], patientNames[1]); Doctor doctor = GetDoctorInfo(doctorNames[0], doctorNames[1]); string sql = String.Format("SELECT * FROM Appointments WHERE HealthInsuranceNo = '{0}' AND MedicalRegistrationNo = '{1}'", patient.HealthInsuranceNo, doctor.MedicalRegistrationNo); SqlCommand command = new SqlCommand(sql, conn); conn.Open(); SqlDataReader reader; try { reader = command.ExecuteReader(); } catch (Exception e) { conn.Close(); throw new FaultException(e.Message); } if (reader.HasRows) { reader.Read(); Appointment result = new Appointment() { HealthInsuranceNo = reader.GetString(0), MedicalRegistrationNo = reader.GetString(1), AppointmentTime = reader.GetDateTime(2), ClinicName = reader.GetString(3) }; reader.Close(); conn.Close(); return result; } else conn.Close(); reader.Close(); return null; }
public Models.Appointment GetAppointment(string patientName, string doctorName) { string[] patientNames = patientName.Split(' '); string[] doctorNames = doctorName.Split(' '); if (patientNames.Length != 2 || doctorNames.Length != 2) { return null; } Patient patient = GetPatientInfo(patientNames[0], patientNames[1]); Doctor doctor = GetDoctorInfo(doctorNames[0], doctorNames[1]); AppointmentData aData = (from a in db.AppointmentDatas where a.HealthInsuranceNo == patient.HealthInsuranceNo && a.MedicalRegistrationNo == doctor.MedicalRegistrationNo select a).FirstOrDefault(); if (aData == null) { return null; } Appointment aModel = new Appointment() { HealthInsuranceNo = aData.HealthInsuranceNo, MedicalRegistrationNo = aData.MedicalRegistrationNo, AppointmentTime = aData.AppointmentTime, ClinicName = aData.ClinicName }; return aModel; }