public User GetUserById(int id) { using (var context = new ApteanClinicContext()) { return(context.Users.Where(user => user.Id == id).FirstOrDefault()); } }
public List <Patient> GetAllPatients(string role, int id) { try { using (var context = new ApteanClinicContext()) { if (role == "Doctor") { Doctor doctor = context.Doctors.Include(d => d.DoctorUser).Where(d => d.DoctorUser.Id == id).FirstOrDefault(); List <int> PatientsId = context.Appointments.Where(s => s.DoctorId == doctor.Id).Select(s => s.PatientId).Distinct().ToList(); List <Patient> list = new List <Patient>(); foreach (int Id in PatientsId) { list.Add(context.Patients.Include(p => p.PatientUser).Where(a => a.Id == Id).FirstOrDefault()); } return(list); } else { return(context.Patients.Include(p => p.PatientUser).ToList()); } } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public int?GetAvailableNurse(DateTime date, int time) { try { using (var context = new ApteanClinicContext()) { List <int> TotalNurse = context.Nurses .Select(n => n.Id).ToList(); if (TotalNurse.Count == 0) { return(null); } List <int> BusyNurse = context.Appointments .Where(d => d.Date == date && d.Time == time) .Select(n => n.NurseId).ToList(); var list = TotalNurse.Except(BusyNurse); int?AvailableNurse = list.FirstOrDefault(); return(AvailableNurse); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public void ChangePassword(string newPassword, int id) { using (var context = new ApteanClinicContext()) { User user = context.Users.Select(a => a).Where(a => a.Id == id).SingleOrDefault(); user.Password = user.ConfirmPassword = newPassword; context.Entry(user).State = EntityState.Modified; context.SaveChanges(); } }
public List <Appointment> GetDoctorAppointments(int doctorId) { try { using (var context = new ApteanClinicContext()) { return(context.Appointments.Where(a => a.DoctorId == doctorId).OrderByDescending(a => a.Date).OrderByDescending(a => a.Time).ToList()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public Doctor GetDoctorById(int id) { try { using (var context = new ApteanClinicContext()) { return(context.Doctors.Include(d => d.DoctorUser).Where(d => d.Id == id).FirstOrDefault()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
//Returns a list of doctor of particular speciality public List <Doctor> GetDoctorsBySpeciality(Speciality speciality) { try { using (var context = new ApteanClinicContext()) { return(context.Doctors.Include(d => d.DoctorUser).Where(d => d.Speciality == speciality).ToList()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public List <Doctor> GetAllDoctors() { try { using (var context = new ApteanClinicContext()) { return(context.Doctors.Include(d => d.DoctorUser).ToList()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public List <Appointment> GetDoctorUpcomingAppointments(int docId) { try { using (var context = new ApteanClinicContext()) { return(context.Appointments.Where(a => a.DoctorId == docId).Where(a => a.Status == AppointmentStatus.Approved).ToList()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public List <int> GetDocotorBookedSlots(int id, DateTime date) { try { using (var context = new ApteanClinicContext()) { return(context.Appointments.Where(a => a.DoctorId == id).Where(a => a.Date == date && (a.Status == AppointmentStatus.Pending || a.Status == AppointmentStatus.Approved)).Select(a => a.Time).ToList()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public List <DoctorTime> GetDoctorTimeSlot(int id) { try { using (var context = new ApteanClinicContext()) { return(context.DoctorTimes.Where(t => t.Doctor.Id == id).ToList()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public void UpdateAdminInfo(User user) { using (var context = new ApteanClinicContext()) { User userTemp = context.Users.Where(u => u.Id == user.Id).FirstOrDefault(); userTemp.Gender = user.Gender; userTemp.Name = user.Name; userTemp.BloodGroup = user.BloodGroup; userTemp.Email = user.Email; userTemp.Contact = user.Contact; context.Entry(userTemp).State = EntityState.Modified; context.SaveChanges(); } }
public MedicinesQuantity GetInvoiceByAppointmentId(int appointmentId) { try { using (var context = new ApteanClinicContext()) { return(context.Medicine_Quantity.Where(d => d.Appointment_Id == appointmentId).FirstOrDefault()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public List <Nurse> GetAllNurses() { try { using (var context = new ApteanClinicContext()) { return(context.Nurses.Include(n => n.NurseUser).ToList()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public List <Appointment> GetAppointmentsById(int patientId, int appointmtnId) { try { using (var context = new ApteanClinicContext()) { return(context.Appointments.Where(a => a.Id == appointmtnId).Where(a => a.PatientId == patientId).ToList()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public Nurse GetNurseById(int id) { try { using (var context = new ApteanClinicContext()) { return(context.Nurses.Include(n => n.NurseUser).Where(n => n.Id == id).FirstOrDefault()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public Appointment GetAppointmentsById(int appointmtnId) { try { using (var context = new ApteanClinicContext()) { return(context.Appointments.Where(a => a.Id == appointmtnId).FirstOrDefault()); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public void Dispose() { try { using (var context = new ApteanClinicContext()) { context.Dispose(); } }catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public void RemovePatient(Patient patient) { try { using (var context = new ApteanClinicContext()) { //Remove appointments of patient List <Appointment> appointments = context.Appointments.Where(a => a.PatientId == patient.Id).ToList(); foreach (var appointment in appointments) { //Remove medical history of patient List <MedicalHistory> medicalHistories = context.MedicalHistories.Where(a => a.AppointmentId == appointment.Id).ToList(); foreach (var medicalHistory in medicalHistories) { context.Entry(medicalHistory).State = EntityState.Deleted; context.MedicalHistories.Remove(medicalHistory); } //Remove Medicines quantity related to patient List <MedicinesQuantity> medicines = context.Medicine_Quantity.Where(a => a.Appointment_Id == appointment.Id).ToList(); foreach (var medicine in medicines) { context.Entry(medicine).State = EntityState.Deleted; context.Medicine_Quantity.Remove(medicine); } //Remove invoices of patient List <Invoice> invoices = context.Invoices.Where(a => a.Appointment_Id == appointment.Id).ToList(); foreach (var invoice in invoices) { context.Entry(invoice).State = EntityState.Deleted; context.Invoices.Remove(invoice); } context.Entry(appointment).State = EntityState.Deleted; context.Appointments.Remove(appointment); } //Remove patient User patientBasicDetials = patient.PatientUser; context.Entry(patient).State = EntityState.Deleted; context.Patients.Remove(patient); context.SaveChanges(); UserDataLayer userData = new UserDataLayer(); userData.DeleteUser(patientBasicDetials); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public int GetTotalAppointments(DateTime date, int Time, int Doctor) { try { using (var context = new ApteanClinicContext()) { return(context.Appointments.Where(a => a.Date == date).Where(a => a.Time == Time).Where(a => a.DoctorId == Doctor).Count()); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public List <MedicalHistory> GetPatientMedicalHistory(int patientId) { try { using (var context = new ApteanClinicContext()) { return(context.MedicalHistories.Where(m => m.PatientId == patientId).ToList()); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public int GetNumberOfInvoices() { try { using (var context = new ApteanClinicContext()) { return(context.Invoices.Count()); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public List <Appointment> GetAppointments() { try { using (var context = new ApteanClinicContext()) { return(context.Appointments.ToList()); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public int GetAppointmentDetailsByInvoiceId(int InvoiceId) { try { using (var context = new ApteanClinicContext()) { return(context.Invoices.Where(m => m.Id == InvoiceId).Select(m => m.Appointment_Id).FirstOrDefault()); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public int GetMedicineCost(int MedicineId) { try { using (var context = new ApteanClinicContext()) { return(Convert.ToInt32(context.Medicines.Include(m => m.Cost).Where(m => m.Id == MedicineId).Select(m => m.Cost).FirstOrDefault())); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public MedicinesQuantity CheckIdInList(int Appointment_Id) { try { using (var context = new ApteanClinicContext()) { return(context.Medicine_Quantity.Where(m => m.Appointment_Id == Appointment_Id).FirstOrDefault()); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public List <MedicinesQuantity> GetPatientMedicines(int AppointmentId) { try { using (var context = new ApteanClinicContext()) { return(context.Medicine_Quantity.Where(m => m.Appointment_Id == AppointmentId).ToList()); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public Patient GetPatienById(int id) { try { using (var context = new ApteanClinicContext()) { return(context.Patients.Include(p => p.PatientUser).Where(p => p.Id == id).FirstOrDefault()); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public int GetPatientIdByAppointmentId(int Appointment_Id) { try { using (var context = new ApteanClinicContext()) { return(context.Appointments.Where(a => a.Id == Appointment_Id).Select(a => a.PatientId).FirstOrDefault()); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }
public string GetMedicineName(int MedicineId) { try { using (var context = new ApteanClinicContext()) { return(context.Medicines.Where(a => a.Id == MedicineId).Select(a => a.Name).FirstOrDefault()); } } catch (Exception e) { ExceptionHandler.PrintException(e, new StackTrace(true)); throw e; } }