public bool AddNewAllergy(string allergy)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
//Allergy newAllergy = new Allergy(allergy);
// var resultSet = database.Allergies.Add(newAllergy);
return(true);
}
public string GetVisitationByDoctorID(long doctor_id)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
var resultSet = database.Scheduled_visitations.Where(visitation => visitation.doctor_id == doctor_id).ToList();
Hospital.Models.ScheduledVisitation findedVisitation = new Hospital.Models.ScheduledVisitation();
if (resultSet.Count > 0)
{
findedVisitation.Map(resultSet.FirstOrDefault());
return(JsonConvert.SerializeObject(findedVisitation));
}
return(JsonConvert.SerializeObject(new { }));
}
public string GetVisitationByDate(string date)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
var ResultSet = database.Scheduled_visitations.Where(history => history.plan_date.ToShortDateString().Equals(date)).ToList();
Hospital.Models.ScheduledVisitation requestedVisitation = new Hospital.Models.ScheduledVisitation();
if (ResultSet.Count == 1)
{
requestedVisitation.Map(ResultSet.FirstOrDefault());
return(JsonConvert.SerializeObject(requestedVisitation));
}
return(JsonConvert.SerializeObject(new { }));
}
public string GetHospital(long hospital_id)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
var resultSet = database.Hospitals.Where(hospital => hospital.hospital_id == hospital_id).ToList();
Hospital.Models.HospitalModel findedHospital = new Hospital.Models.HospitalModel();
if (resultSet.Count == 1)
{
findedHospital.Map(resultSet.FirstOrDefault());
return(JsonConvert.SerializeObject(findedHospital));
}
return(JsonConvert.SerializeObject(new { }));;
}
public string GetPatientByEGNAndPassword(string egn, string password)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
var resultSet = database.Patients.Where(patient => patient.username.Equals(egn) && patient.password.Equals(password)).ToList();
Hospital.Models.Patient returnedPatient = new Hospital.Models.Patient();
if (resultSet.Count == 1)
{
returnedPatient.Map(resultSet.FirstOrDefault());
return(JsonConvert.SerializeObject(returnedPatient));
}
return(JsonConvert.SerializeObject(new { }));
}
public string GetPatient(long patient_id)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
var resultSet = database.Patients.Where(patient => patient.patient_id == patient_id).ToList();
Hospital.Models.Patient returnedPatient = new Hospital.Models.Patient();
if (resultSet.Count == 1)
{
returnedPatient.Map(resultSet.FirstOrDefault());
return(JsonConvert.SerializeObject(returnedPatient));
}
return(JsonConvert.SerializeObject(new { }));
}
public string GetHistoryByDate(string date)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
var ResultSet = database.Histories.Where(history => history.date.ToShortDateString().Equals(date)).ToList();
Hospital.Models.History requestedHistory = new Hospital.Models.History();
if (ResultSet.Count == 1)
{
requestedHistory.Map(ResultSet.FirstOrDefault());
return(JsonConvert.SerializeObject(requestedHistory));
}
return(JsonConvert.SerializeObject(new { }));
}
public string GetHistoryByPatientId(long patient_id)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
var ResultSet = database.Histories.Where(history => history.patient_id == patient_id).ToList();
Hospital.Models.History requestedHistory = new Hospital.Models.History();
if (ResultSet.Count == 1)
{
requestedHistory.Map(ResultSet.FirstOrDefault());
return(JsonConvert.SerializeObject(requestedHistory));
}
return(JsonConvert.SerializeObject(new { }));
}
public string GetDoctor(long doctor_id)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
var resultSet = database.Doctors.Where(doctor => doctor.doctor_id == doctor_id).ToList();
Hospital.Models.Doctor findedDoctor = new Hospital.Models.Doctor();
if (resultSet.Count == 1)
{
findedDoctor.Map(resultSet.FirstOrDefault());
return(JsonConvert.SerializeObject(findedDoctor));
}
return(JsonConvert.SerializeObject(new { }));
}
public string GetHistoryByDoctorId(long doctor_id)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
List <Hospital.Models.History> histories = new List <Hospital.Models.History>();
var resultSet = database.Histories.Where(history => history.doctor_id == doctor_id).ToList();
if (resultSet.Count > 0)
{
foreach (var history in resultSet)
{
Hospital.Models.History temp = new Hospital.Models.History();
temp.Map(history);
histories.Add(temp);
}
return(JsonConvert.SerializeObject(histories));
}
return(JsonConvert.SerializeObject(new { }));
}
public string GetAllHospitals()
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
List <Hospital.Models.HospitalModel> hospitals = new List <Hospital.Models.HospitalModel>();
var resultSet = database.Hospitals.ToList();
if (resultSet.Count > 0)
{
foreach (var hospital in resultSet)
{
Hospital.Models.HospitalModel tempHospital = new Hospital.Models.HospitalModel();
tempHospital.Map(hospital);
hospitals.Add(tempHospital);
}
return(JsonConvert.SerializeObject(hospitals));
}
return(JsonConvert.SerializeObject(new { }));
}
public string getAllAllergies()
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
List <Hospital.Models.Allergy> allergies = new List <Hospital.Models.Allergy>();
var resultSet = database.Allergies.Select(allergy => allergy).ToList();
if (resultSet.Count > 0)
{
foreach (var history in resultSet)
{
Hospital.Models.Allergy allergy = new Hospital.Models.Allergy();
allergy.Map(history);
allergies.Add(allergy);
}
return(JsonConvert.SerializeObject(allergies));
}
return(JsonConvert.SerializeObject(new { }));
}
public string GetAllDoctors()
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
List <Hospital.Models.Doctor> doctors = new List <Hospital.Models.Doctor>();
var resultSet = database.Doctors.ToList();
if (resultSet.Count > 0)
{
foreach (var doctor in resultSet)
{
Hospital.Models.Doctor temp = new Hospital.Models.Doctor();
temp.Map(doctor);
doctors.Add(temp);
}
return(JsonConvert.SerializeObject(doctors));
}
return(JsonConvert.SerializeObject(new { }));
}
