public bool DeleteAppointment(ref AppointmentBDO app, ref string message) { message = "Doctor deleted successfully"; var ret = true; using (var PHEntities = new PublicHospitalEntities()) { var appId = app.id; var appointmentInDb = (from a in PHEntities.Appointment where a.id == appId select a).FirstOrDefault(); if (appointmentInDb != null) { PHEntities.Appointment.Remove(appointmentInDb); var num = PHEntities.SaveChanges(); if (num != 1) { ret = false; } } else { ret = false; message = "Appointment not found"; } return ret; } }
public PatientBDO GetPatient(int id) { PatientBDO patientBDO = null; using (var PHEntities = new PublicHospitalEntities()) { var patientObj = (from a in PHEntities.Patient where a.id == id select a).FirstOrDefault(); if (patientObj != null) patientBDO = new PatientBDO() { id = patientObj.id, firstName = patientObj.firstName, lastName = patientObj.lastName, city = patientObj.city, street = patientObj.street, streetNr = patientObj.streetNr, phoneNr = patientObj.phoneNr, zip = patientObj.zip, login = patientObj.login, pass = patientObj.pass, dateOfBirth = patientObj.dateOfBirth, RowVersion = patientObj.rowVersion }; } return patientBDO; }
public bool InsertPatient(ref PatientBDO patientBDO, ref string massage) { massage = "Patient inserted successfully"; var ret = true; Password passObj = new Password(); string[] passAndSalt = passObj.getFullyHash(patientBDO.pass); using (var PHEntities = new PublicHospitalEntities()) { PHEntities.Patient.Add(new Patient { id = GetNextID(), firstName = patientBDO.firstName, lastName = patientBDO.lastName, city = patientBDO.city, street = patientBDO.street, streetNr = patientBDO.streetNr, phoneNr = patientBDO.phoneNr, zip = patientBDO.zip, login = patientBDO.login, dateOfBirth = patientBDO.dateOfBirth, rowVersion = patientBDO.RowVersion, pass = passAndSalt[0], salt = passAndSalt[1] }); var num = PHEntities.SaveChanges(); if (num != 1) { ret = false; massage = "Patient was not inserted"; } } return ret; }
public List<VisitBDO> GetAllVisits() { List<VisitBDO> Visits = null; VisitBDO VisitBDO = null; using (var PHEntities = new PublicHospitalEntities()) { var listInDb = (from d in PHEntities.Visit select d).ToList(); if (listInDb != null) { Visits = new List<VisitBDO>(); VisitBDO = new VisitBDO(); foreach (Visit VisitObj in listInDb) { if (VisitObj != null) { VisitBDO = new VisitBDO() { id = VisitObj.Ap_Id, patientProblem = VisitObj.patientProblem, symptom = VisitObj.symptom, advice = VisitObj.advice, rowVersion = VisitObj.rowVersion }; Visits.Add(VisitBDO); } } } } return Visits; }
public AdminBDO GetAdmin(int id) { AdminBDO adminBDO = null; using (var PHEntities = new PublicHospitalEntities()) { var adminObj = (from a in PHEntities.Admin where a.id == id select a).FirstOrDefault(); if (adminObj != null) adminBDO = new AdminBDO() { id = adminObj.id, firstName = adminObj.firstName, lastName = adminObj.lastName, city = adminObj.city, street = adminObj.street, streetNr = adminObj.streetNr, phoneNr = adminObj.phoneNr, zip = adminObj.zip, login = adminObj.login, pass = adminObj.pass }; } return adminBDO; }
public List<PatientBDO> GetAllpatients() { List<PatientBDO> patientList = null; using (var PHEntities = new PublicHospitalEntities()) { var patientDatabase = from p in PHEntities.Patient select p; if ((patientDatabase.FirstOrDefault() != null)) { patientList = new List<PatientBDO>(); foreach (var patient in patientDatabase) { patientList.Add(new PatientBDO() { id = patient.id, firstName = patient.firstName, lastName = patient.lastName, city = patient.city, street = patient.street, streetNr = patient.streetNr, phoneNr = patient.phoneNr, zip = patient.zip, login = patient.login, pass = patient.pass, dateOfBirth = patient.dateOfBirth, RowVersion = patient.rowVersion }); } } } return patientList; }
public bool InsertAdmin(ref AdminBDO adminBDO, ref string massage) { massage = "Admin inserted successfully"; var ret = true; Password passObj = new Password(); string[] passAndSalt = passObj.getFullyHash(adminBDO.pass); using (var PHEntities = new PublicHospitalEntities()) { PHEntities.Admin.Add(new Admin { id = GetNextID(), firstName = adminBDO.firstName, lastName = adminBDO.lastName, city = adminBDO.city, street = adminBDO.street, streetNr = adminBDO.streetNr, phoneNr = adminBDO.phoneNr, zip = adminBDO.zip, login = adminBDO.login, pass = passAndSalt[0], salt = passAndSalt[1] }); var num = PHEntities.SaveChanges(); if (num != 1) { ret = false; massage = "Admin was not inserted"; } } return ret; }
public List<AppointmentBDO> GetAllAppointments() { List<AppointmentBDO> appointments = null; AppointmentBDO appointmentBDO = null; PatientBDO patientBDO = null; DoctorBDO doctorBDO = null; using (var PHEntities = new PublicHospitalEntities()) { var listInDb = (from Appointment in PHEntities.Appointment from Doctor in PHEntities.Doctor from Patient in PHEntities.Patient where Appointment.idDoctor == Doctor.id && Appointment.idPatient == Patient.id select new { Appointment.id, Appointment.time, Appointment.serviceType, Doctor.firstName, Doctor.lastName, DoctorId = Doctor.id, Column1 = Patient.firstName, Column2 = Patient.lastName, Column3 = Patient.id }); if (listInDb != null) { appointments = new List<AppointmentBDO>(); foreach (var mergedList in listInDb) { if (mergedList != null) { doctorBDO = new DoctorBDO(); patientBDO = new PatientBDO(); doctorBDO.firstName = mergedList.firstName; doctorBDO.lastName = mergedList.lastName; doctorBDO.id = mergedList.DoctorId; patientBDO.firstName = mergedList.Column1; patientBDO.lastName = mergedList.Column2; patientBDO.id = mergedList.Column3; appointmentBDO = new AppointmentBDO() { id = mergedList.id, time = mergedList.time, serviceType = mergedList.serviceType, doctor = doctorBDO, patient = patientBDO }; appointments.Add(appointmentBDO); } } } } return appointments; }
private string[] getPasswordSaltDB(string login) { using (var PHEntities = new PublicHospitalEntities()) { string[] person = null; var admin = PHEntities.Admin.Where(a => a.login == login); var doctor = PHEntities.Doctor.Where(d => d.login == login); var patient = PHEntities.Patient.Where(p => p.login == login); if (admin.FirstOrDefault() != null) person = new string[] { admin.First().pass, admin.First().salt, admin.First().id.ToString(), "admin" }; if (doctor.FirstOrDefault() != null) person = new string[] { doctor.First().pass, doctor.First().salt, doctor.First().id.ToString(), "doctor" }; if (patient.FirstOrDefault() != null) person = new string[] { patient.First().pass, patient.First().salt, patient.First().id.ToString(), "patient" }; return person; } }
private int GetNextID() { int nextID = -1; using (var PHEntities = new PublicHospitalEntities()) { var ids = (from a in PHEntities.Patient select a.id).ToList(); nextID = ids.Max(); }; if (nextID == -1) { throw new Exception("Patient id couldn't be generated"); } else { return nextID + 1; } }
public VisitBDO GetVisit(int id) { VisitBDO VisitBDO = null; using (var PHEntities = new PublicHospitalEntities()) { var VisitObj = (from v in PHEntities.Visit where v.Ap_Id == id select v).FirstOrDefault(); if (VisitObj != null) VisitBDO = new VisitBDO() { id = VisitObj.Ap_Id, patientProblem = VisitObj.patientProblem, symptom = VisitObj.symptom, advice = VisitObj.advice, rowVersion = VisitObj.rowVersion }; } return VisitBDO; }
public bool UpdateAdmin(ref AdminBDO adminBDO, ref string massage) { massage = "Admin updated successfully"; var ret = true; using (var PHEntites = new PublicHospitalEntities()) { var adminId = adminBDO.id; var adminInDb = (from a in PHEntites.Admin where a.id == adminId select a).FirstOrDefault(); if (adminInDb == null) { throw new Exception("No admin with id " + adminBDO.id); } adminInDb.firstName = adminBDO.firstName; adminInDb.lastName = adminBDO.lastName; adminInDb.city = adminBDO.city; adminInDb.zip = adminBDO.zip; adminInDb.street = adminBDO.street; adminInDb.streetNr = adminBDO.streetNr; adminInDb.phoneNr = adminBDO.phoneNr; adminInDb.rowVersion = adminBDO.RowVersion; //without username and pass PHEntites.Admin.Attach(adminInDb); PHEntites.Entry(adminInDb).State = System.Data.Entity.EntityState.Modified; var num = PHEntites.SaveChanges(); adminBDO.RowVersion = adminInDb.rowVersion; if (num != 1) { ret = false; massage = "Admin was not updated"; } } return ret; }
public bool UpdatePatient(ref PatientBDO patientBDO, ref string massage) { massage = "Patient updated successfully"; var ret = true; using (var PHEntites = new PublicHospitalEntities()) { var patientId = patientBDO.id; var patientInDb = (from a in PHEntites.Patient where a.id == patientId select a).FirstOrDefault(); if (patientInDb == null) { throw new Exception("No patient with id " + patientBDO.id); } patientInDb.firstName = patientBDO.firstName; patientInDb.lastName = patientBDO.lastName; patientInDb.city = patientBDO.city; patientInDb.zip = patientBDO.zip; patientInDb.street = patientBDO.street; patientInDb.streetNr = patientBDO.streetNr; patientInDb.phoneNr = patientBDO.phoneNr; patientInDb.dateOfBirth = patientBDO.dateOfBirth; //without username and pass PHEntites.Patient.Attach(patientInDb); PHEntites.Entry(patientInDb).State = System.Data.Entity.EntityState.Modified; var num = PHEntites.SaveChanges(); if (num != 1) { ret = false; massage = "Patient was not updated"; } } return ret; }
public bool InsertVisit(ref VisitBDO VisitBDO, ref string massage) { massage = "Visit inserted successfully"; var ret = true; using (var PHEntities = new PublicHospitalEntities()) { PHEntities.Visit.Add(new Visit { Ap_Id = VisitBDO.id, advice = VisitBDO.advice, symptom = VisitBDO.symptom, patientProblem = VisitBDO.patientProblem, rowVersion = VisitBDO.rowVersion }); var num = PHEntities.SaveChanges(); if (num != 1) { ret = false; massage = "Visit was not inserted"; } } return ret; }
private string setSessionIdDB(string idd, int type) { string sessionID = getSessionID(); int changes = 0; using (var PHEntities = new PublicHospitalEntities()) { int id = 0; Int32.TryParse(idd, out id); switch (type) { case 0: var admin = (from a in PHEntities.Admin where a.id == id select a).FirstOrDefault(); admin.sessionID = sessionID; changes = PHEntities.SaveChanges(); break; case 1: var doctor = (from a in PHEntities.Doctor where a.id == id select a).FirstOrDefault(); doctor.sessionID = sessionID; changes = PHEntities.SaveChanges(); break; case 2: var patient = (from a in PHEntities.Patient where a.id == id select a).FirstOrDefault(); patient.sessionID = sessionID; changes = PHEntities.SaveChanges(); break; } if (changes != 1) sessionID = null; } return sessionID; }
public List<AppointmentBDO> GetAllAppointmentsByPatient(int patientId) { List<AppointmentBDO> appointments = null; AppointmentBDO appointmentBDO = null; using (var PHEntities = new PublicHospitalEntities()) { var listInDb = (from appointment in PHEntities.Appointment where appointment.idPatient == patientId select appointment).ToList(); if (listInDb != null) { appointments = new List<AppointmentBDO>(); foreach (Appointment app in listInDb) { appointmentBDO = new AppointmentBDO() { id = app.id, time = Convert.ToDateTime(app.time), serviceType = app.serviceType, patient = new PatientBDO(), doctor = new DoctorBDO(), rowVersion = app.rowVersion }; appointmentBDO.patient.id = (int)app.idPatient; appointmentBDO.doctor.id = (int)app.idDoctor; appointments.Add(appointmentBDO); } return appointments; } else { return null; } } }
public bool UpdateVisit(ref VisitBDO VisitBDO) { var ret = true; using (var PHEntites = new PublicHospitalEntities()) { var VisitId = VisitBDO.id; var VisitInDb = (from a in PHEntites.Visit where a.Ap_Id == VisitId select a).FirstOrDefault(); if (VisitInDb == null) { throw new Exception("No Visit with id " + VisitBDO.id); } VisitInDb.Ap_Id = VisitBDO.id; VisitInDb.advice = VisitBDO.advice; VisitInDb.symptom = VisitBDO.symptom; VisitInDb.patientProblem = VisitBDO.patientProblem; VisitInDb.rowVersion = VisitBDO.rowVersion; //without username and pass PHEntites.Visit.Attach(VisitInDb); PHEntites.Entry(VisitInDb).State = System.Data.Entity.EntityState.Modified; var num = PHEntites.SaveChanges(); VisitBDO.rowVersion = VisitInDb.rowVersion; if (num != 1) { ret = false; } } return ret; }
public AppointmentBDO GetAppointment(int id) { AppointmentBDO appointmentBDO = null; using (var PHEntities = new PublicHospitalEntities()) { var appointmentObj = (from a in PHEntities.Appointment where a.id == id select a).FirstOrDefault(); if (appointmentObj != null) { patientDAO = new PatientDAO(); doctorDAO = new DoctorDAO(); appointmentBDO = new AppointmentBDO() { id = appointmentObj.id, time = Convert.ToDateTime(appointmentObj.time), serviceType = appointmentObj.serviceType, patient = patientDAO.GetPatient(appointmentObj.idPatient.Value), doctor = doctorDAO.GetDoctor(appointmentObj.idDoctor.Value), rowVersion = appointmentObj.rowVersion }; } } return appointmentBDO; }
public List<string> getAppointmentsByDocAndDate(DateTime date, int docId) { List<string> appTimes; using (var PHEntities = new PublicHospitalEntities()) { var listInDb = (from appointment in PHEntities.Appointment where appointment.idDoctor == docId && appointment.time.Year == date.Year && appointment.time.Month == date.Month && appointment.time.Day == date.Day select new { appointment.time }).ToList(); appTimes = new List<string>(); if (listInDb != null) { foreach (var d in listInDb) { appTimes.Add(d.time.ToString("HH:mm")); } } } return appTimes; }
public bool GetAppointmentsHistoryPatient(ref PatientBDO patient, ref string message) { bool succesful = false; using (var PHEntities = new PublicHospitalEntities()) { int patientID = patient.id; var appointments = PHEntities.Appointment.Where(a => a.idPatient == patientID); if (appointments.FirstOrDefault() != null) { VisitDAO visitDAO = new VisitDAO(); List<AppointmentBDO> appointmentList = new List<AppointmentBDO>(); foreach (var appointment in appointments) { appointmentList.Add(new AppointmentBDO() { id = appointment.id, time = Convert.ToDateTime(appointment.time), serviceType = appointment.serviceType, doctor = new DoctorDAO().GetDoctor(appointment.idDoctor.Value), visit = visitDAO.GetVisit(appointment.id) }); } if (appointmentList != null) { patient.appointmentsHistory = appointmentList; succesful = true; } else message = "Appointment list is empty"; } else message = "Can not get id from the database appointment"; } return succesful; }
public bool InsertAppointment(ref AppointmentBDO appointmentBDO, ref string massage) { massage = "Appointment inserted successfully"; var ret = true; using (var PHEntities = new PublicHospitalEntities()) { PHEntities.Appointment.Add(new Appointment { id = appointmentBDO.id, time = appointmentBDO.time, serviceType = appointmentBDO.serviceType, idPatient = appointmentBDO.patient.id, idDoctor = appointmentBDO.doctor.id, rowVersion = appointmentBDO.rowVersion }); var num = PHEntities.SaveChanges(); if (num != 1) { ret = false; massage = "Appointment was not inserted"; } } return ret; }
public bool Updateappointment(ref AppointmentBDO appointmentBDO, ref string massage) { massage = "appointment updated successfully"; var ret = true; using (var PHEntites = new PublicHospitalEntities()) { var appointmentId = appointmentBDO.id; var appointmentInDb = (from a in PHEntites.Appointment where a.id == appointmentId select a).FirstOrDefault(); if (appointmentInDb == null) { throw new Exception("No appointment with id " + appointmentBDO.id); } appointmentInDb.id = appointmentBDO.id; appointmentInDb.time = appointmentBDO.time.Date; appointmentInDb.serviceType = appointmentBDO.serviceType; appointmentInDb.idPatient = appointmentBDO.patient.id; appointmentInDb.idDoctor = appointmentBDO.patient.id; appointmentInDb.rowVersion = appointmentBDO.rowVersion; PHEntites.Appointment.Attach(appointmentInDb); PHEntites.Entry(appointmentInDb).State = System.Data.Entity.EntityState.Modified; var num = PHEntites.SaveChanges(); appointmentBDO.rowVersion = appointmentInDb.rowVersion; if (num != 1) { ret = false; massage = "appointment was not updated"; } } return ret; }
private string getSessionIdDB(int id) { string sessionID = null; using (var PHEntities = new PublicHospitalEntities()) { var admin = from a in PHEntities.Admin where a.id == id select a; var doctor = from a in PHEntities.Doctor where a.id == id select a; var patient = from a in PHEntities.Patient where a.id == id select a; if (admin.FirstOrDefault() != null) sessionID = admin.First().sessionID.ToString(); else if (doctor.FirstOrDefault() != null) sessionID = doctor.First().sessionID.ToString(); else if (patient.FirstOrDefault() != null) sessionID = patient.First().sessionID.ToString(); } return sessionID; }