public HttpResponseMessage GetAllAppointementForPatient(int id /*patient id*/)
{
List <Appointment_Bocking> av = null;
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
//get list of prescription for the patient
var entity = entities.Prescriptions.Where(p => p.Id_Patient == id).ToList();
if (entity != null)
{
av = new List <Appointment_Bocking>();
foreach (Prescription pi in entity)
{
//get the book appointement foreach prescription
var e = entities.Appointment_Bocking.Where(ap => ap.Id_Prescription == pi.Id_Prescription).ToList();
if (e != null)
{
av.AddRange(e);
}
}
return(Request.CreateResponse(HttpStatusCode.OK, av));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Patient with id " + id + " does not have any appointments"));
}
}
}
public HttpResponseMessage putProfile(int id /*patient id*/, P_Personal_Infomation patient)
{
try{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.P_Personal_Infomation.FirstOrDefault(p => p.Id_Patient == id);
if (entity != null)
{
entity.Patient_Account = patient.Patient_Account;
entity.Patient_Allergy = patient.Patient_Allergy;
entity.Prescriptions = patient.Prescriptions;
entity.SocialStatus = patient.SocialStatus;
entity.Length_p = patient.Length_p;
entity.weight_p = patient.weight_p;
entity.Emergencies = patient.Emergencies;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Patient with id =" + id.ToString() + " not found to update"));
}
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage PutMedicine(int prescription_id, Medicine medicine)
{
try
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities())
{
var entity = entities.Prescriptions.FirstOrDefault(p => p.Id_Prescription == prescription_id);
if (entity != null)
{
//add new medcine to the prescription
entity.Medicines.Add(medicine);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Prescription with id =" + prescription_id.ToString() + " not found to update symptom in it"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage GetAllMedicineForPrescription(int id /*prescription id*/)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Medicines.Where(m => m.Id_Prescription == id).ToList();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Prescription with id " + id + " does not have any medicine yet"));
}
}
}
public HttpResponseMessage GetAccountDetails(int id /*account id*/)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Patient_Account.FirstOrDefault(ac => ac.Id_Account == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Account with id " + id + " Not found"));
}
}
}
public HttpResponseMessage SearchDoctorByCiy(string city)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Doctors.Where(d => d.Address.ToLower().Contains(city.ToLower())).ToList();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "There is no Doctor in city " + city));
}
}
}
public HttpResponseMessage SearchDoctorByName(string name)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Doctors.Where(d => (d.FirstName + d.LastName).ToLower().Contains(name.ToLower())).ToList();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "There is no Doctor with name " + name));
}
}
}
public HttpResponseMessage GetDetails(int id /*doctor id*/)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Doctors.FirstOrDefault(d => d.Id_Doctor == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Doctor with id " + id + " Not Found"));
}
}
}
public HttpResponseMessage GetPatient(int id /*patient id*/)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
var entity = entities.P_Personal_Infomation.FirstOrDefault(p => p.Id_Patient == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Patient with id: " + id + "not found"));
}
}
}
public HttpResponseMessage GetHealthyRecordForPatient(int id /*patient id*/)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Prescriptions.Where(p => p.Id_Patient == id).ToList();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "patient with id " + id + " Does not have record yet"));
}
}
}
public HttpResponseMessage GetPrescription(int id /*presription id*/)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Prescriptions.FirstOrDefault(p => p.Id_Prescription == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "prescription with id " + id + " Not Found"));
}
}
}
public HttpResponseMessage GetEmergency(int id /*patient id*/)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
var entity = entities.Emergencies.Where(e => e.Id_Patient == id).ToList();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "patient with id " + id + " Not found"));
}
}
}
//display list of appointements
public HttpResponseMessage GetAppointmentsDetails(int Id)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
var entity = entities.Available_Appointment.Select(ap => ap.Id_Doctor == Id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Appointement for Doctor with id = " + Id.ToString() + " not found"));
}
}
}
public HttpResponseMessage GetProfileDetails(int Id)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
var entity = entities.Doctors.FirstOrDefault(d => d.Id_Doctor == Id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Doctor with id = " + Id.ToString() + " not found"));
}
}
}
public HttpResponseMessage GetAccountDetails(string phoneNumber)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
var entity = entities.Patient_Account.FirstOrDefault(p => p.Phone_Number.Equals(phoneNumber));
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Account with phone = " + phoneNumber + " not found"));
}
}
}
public HttpResponseMessage GetProfileDetails(int Id)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
var entity = entities.P_Personal_Infomation.FirstOrDefault(p => p.Id_Patient == Id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Profile with id = " + Id.ToString() + " not found"));
}
}
}
public HttpResponseMessage PostPrescription(Prescription newPrescription)
{
try {
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
entities.Prescriptions.Add(newPrescription);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, newPrescription);
message.Headers.Location = new Uri(Request.RequestUri + newPrescription.Id_Prescription.ToString());
return(message);
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage PostNewAccount([FromBody] Patient_Account newAccount)
{
try {
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
entities.Patient_Account.Add(newAccount);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, newAccount);
message.Headers.Location = new Uri(Request.RequestUri + newAccount.Id_Account.ToString());
return(message);
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage GetfirstAid(int id /*disease id*/)
{
try {
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.First_Aid.Where(f => f.Id_Diseases == id).ToList();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Disease with id: " + id + "not found"));
}
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage GetAllMedicineForPatient(int id /*patient id*/)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Prescriptions.Where(p => p.Id_Patient == id).ToList();
if (entity != null)
{
List <Medicine> medi = new List <Medicine>();
foreach (var e in entity)
{
medi.AddRange(e.Medicines);
}
return(Request.CreateResponse(HttpStatusCode.OK, medi));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "patient with id " + id + " does not have medicines "));
}
}
}
public HttpResponseMessage DeleteAccount(string phoneNumber)
{
try {
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
var entity = entities.Patient_Account.FirstOrDefault(p => p.Phone_Number == phoneNumber);
if (entity != null)
{
entities.Patient_Account.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Account with phone = " + phoneNumber + " not found to delete"));
}
}
} catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage DeleteAppointment(int id)
{
try{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
var entity = entities.Available_Appointment.FirstOrDefault(ap => ap.Id_Available_Appointment == id);
if (entity != null)
{
entities.Available_Appointment.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Appointement with id = " + id.ToString() + " not found to delete"));
}
}
}catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage DeleteAppointementBooking(int id)
{
try {
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Appointment_Bocking.FirstOrDefault(ap => ap.Id_Appointment_Bocking == id);
if (entity != null)
{
entities.Appointment_Bocking.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Booking Appointement with id " + id + " Not Found to delete"));
}
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage DeletePateint(int id)
{
try {
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
var entity = entities.P_Personal_Infomation.FirstOrDefault(p => p.Id_Patient == id);
if (entity != null)
{
entities.P_Personal_Infomation.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Patient with id = " + id + " not found to delete"));
}
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage DeleteDoctor(int id /*docotor id*/)
{
try {
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Doctors.FirstOrDefault(d => d.Id_Doctor == id);
if (entity != null)
{
entities.Doctors.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Doctor with id " + id + " not found to delete"));
}
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
//test...
public HttpResponseMessage PutAccount(int id, Patient_Account newAccount)
{
try {
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Patient_Account.FirstOrDefault(p => p.Id_Account == id);
if (entity != null)
{
entity.Phone_Number = newAccount.Phone_Number;
entity.P_Personal_Infomation.Add((P_Personal_Infomation)newAccount.P_Personal_Infomation);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Account with id =" + id.ToString() + " not found to update"));
}
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage PutAvailableAppointment(int apointement_id, Available_Appointment availableAppointment)
{
try {
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()){
var entity = entities.Available_Appointment.FirstOrDefault(ap => ap.Id_Available_Appointment == apointement_id);
if (entity != null)
{
entity.Available_Time = availableAppointment.Available_Time;
entity.Prescriptions = availableAppointment.Prescriptions;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "apointement with id =" + apointement_id.ToString() + " not found to update"));
}
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage GetAllAppointementForDoctor(int id /*doctor id*/)
{
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
List <Appointment_Bocking> av = null;
var entity = entities.Available_Appointment.Where(ap => ap.Id_Doctor == id).ToList();
if (entity != null)
{
av = new List <Appointment_Bocking>();
foreach (Available_Appointment ap in entity)
{
var e = entities.Appointment_Bocking.Where(apB => apB.Id_Available_Appointment == ap.Id_Available_Appointment).ToList();
if (e != null)
{
av.AddRange(e);
}
}
return(Request.CreateResponse(HttpStatusCode.OK, av));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Doctor with id " + id + " does not have any appointment"));
}
}
}
public HttpResponseMessage PutProfile(int id, Doctor doctor)
{
try {
using (Medical_Assistant_System_Entities entities = new Medical_Assistant_System_Entities()) {
var entity = entities.Doctors.FirstOrDefault(d => d.Id_Doctor == id);
if (entity != null)
{
entity.Phone_Number = doctor.Phone_Number;
entity.Syndicate_num = doctor.Syndicate_num;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Doctor with id =" + id.ToString() + " not found to update"));
}
}
}
catch (Exception ex) {
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
