public static IQueryable <Consultation> GetConsultations()
{
MedicalCardEntities context = new MedicalCardEntities();
var consultations = context.Consultations.Include("Doctor").Include("Patient");
return(consultations);
}
/// <summary>
/// Get all users in the database
/// </summary>
/// <returns></returns>
public static IQueryable <User> GetAllUsers()
{
MedicalCardEntities context = new MedicalCardEntities();
var users = context.Users;
return(users.AsQueryable());
}
public static IQueryable <Diagnosis> GetDiagnosesByDoctorId(int doctorId)
{
MedicalCardEntities context = new MedicalCardEntities();
var diagnoses = context.Diagnoses.Include("Patient").Where(d => d.DoctorId == doctorId);
return(diagnoses);
}
/// <summary>
/// Get user by name from the database
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static User GetUserByName(string username)
{
MedicalCardEntities context = new MedicalCardEntities();
var user = context.Users.Where(u => u.UserName == username).FirstOrDefault();
var doctor = user.Doctor;
return(user);
}
public static void DeleteUserById(int userId)
{
MedicalCardEntities context = new MedicalCardEntities();
var user = context.Users.Where(p => p.UserId == userId).FirstOrDefault();
context.Users.DeleteObject(user);
context.SaveChanges();
}
public static void UpdateDiagnosis(Diagnosis diagnosis)
{
MedicalCardEntities context = new MedicalCardEntities();
context.Diagnoses.AddObject(diagnosis);
context.ObjectStateManager.ChangeObjectState(diagnosis, EntityState.Modified);
context.SaveChanges();
}
public static void UpdateUser(User user)
{
MedicalCardEntities context = new MedicalCardEntities();
context.Users.AddObject(user);
context.ObjectStateManager.ChangeObjectState(user, EntityState.Modified);
context.SaveChanges();
}
public static void DeleteDoctorById(int doctorId)
{
MedicalCardEntities context = new MedicalCardEntities();
var doctor = context.Doctors.Where(p => p.DoctorId == doctorId).FirstOrDefault();
context.Doctors.DeleteObject(doctor);
context.SaveChanges();
}
public static void DeleteConsultationById(int consultationId)
{
MedicalCardEntities context = new MedicalCardEntities();
var consultation = context.Consultations.Where(p => p.ConsultationId == consultationId).FirstOrDefault();
context.Consultations.DeleteObject(consultation);
context.SaveChanges();
}
public static void DeleteDiagnosisById(int diagnosisId)
{
MedicalCardEntities context = new MedicalCardEntities();
var diagnosis = context.Diagnoses.Where(p => p.DiagnoseId == diagnosisId).FirstOrDefault();
context.Diagnoses.DeleteObject(diagnosis);
context.SaveChanges();
}
public static Diagnosis GetDiagnosisById(int diagnosisId)
{
MedicalCardEntities context = new MedicalCardEntities();
var diagnosis = context.Diagnoses.Where(p => p.DiagnoseId == diagnosisId).FirstOrDefault();
context.Detach(diagnosis);
return(diagnosis);
}
public static void DeletePatientById(int patientId)
{
MedicalCardEntities context = new MedicalCardEntities();
var patient = context.Patients.Where(p => p.PatientId == patientId).FirstOrDefault();
context.Patients.DeleteObject(patient);
context.SaveChanges();
}
public static void UpdateDoctor(Doctor doctor)
{
MedicalCardEntities context = new MedicalCardEntities();
context.Doctors.AddObject(doctor);
context.ObjectStateManager.ChangeObjectState(doctor, EntityState.Modified);
context.SaveChanges();
}
/// <summary>
/// Get user by name from the database
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static User GetUserById(int userId)
{
MedicalCardEntities context = new MedicalCardEntities();
var user = context.Users.Include("Doctor")
.Include("Patient")
.Where(u => u.UserId == userId).FirstOrDefault();
return(user);
}
public static IQueryable <Consultation> GetConsultationsByDoctorId(int doctorId)
{
MedicalCardEntities context = new MedicalCardEntities();
var consultations = context.Consultations
.Include("Patient")
.Where(p => p.DoctorId == doctorId);
return(consultations);
}
public static void DeleteDiagnosis(Diagnosis diagnosis)
{
MedicalCardEntities context = new MedicalCardEntities();
if (diagnosis.EntityState == EntityState.Detached)
{
context.Diagnoses.Attach(diagnosis);
}
context.Diagnoses.DeleteObject(diagnosis);
context.SaveChanges();
}
public static void DeleteUser(User user)
{
MedicalCardEntities context = new MedicalCardEntities();
if (user.EntityState == EntityState.Detached)
{
context.Users.Attach(user);
}
context.Users.DeleteObject(user);
context.SaveChanges();
}
public static void DeletePatient(Patient patient)
{
MedicalCardEntities context = new MedicalCardEntities();
if (patient.EntityState == EntityState.Detached)
{
context.Patients.Attach(patient);
}
context.Patients.DeleteObject(patient);
context.SaveChanges();
}
public static void UpdatePatient(Patient patient)
{
MedicalCardEntities context = new MedicalCardEntities();
context.Patients.AddObject(patient);
context.ObjectStateManager.ChangeObjectState(patient, EntityState.Modified);
context.SaveChanges();
//detach because object is stateless
context.Detach(patient);
}
public static Doctor GetDoctorById(int doctorId)
{
MedicalCardEntities context = new MedicalCardEntities();
var doctor = context.Doctors.Where(p => p.DoctorId == doctorId).FirstOrDefault();
if (doctor != null)
{
context.Detach(doctor);
}
return(doctor);
}
public static void DeleteConsultation(Consultation consultation)
{
MedicalCardEntities context = new MedicalCardEntities();
if (consultation.EntityState == EntityState.Detached)
{
context.Consultations.Attach(consultation);
}
context.Consultations.DeleteObject(consultation);
context.SaveChanges();
}
public static void DeleteDoctor(Doctor doctor)
{
MedicalCardEntities context = new MedicalCardEntities();
if (doctor.EntityState == EntityState.Detached)
{
context.Doctors.Attach(doctor);
}
context.Doctors.DeleteObject(doctor);
context.SaveChanges();
}
public static void UpdateConsultation(Consultation consultation)
{
MedicalCardEntities context = new MedicalCardEntities();
context.Consultations.AddObject(consultation);
context.ObjectStateManager.ChangeObjectState(consultation, EntityState.Modified);
context.SaveChanges();
//detaching the object - ablity to share between different contexts
context.Detach(consultation);
}
public static IQueryable <Consultation> GetConsultationsInNextDays(int patientId, int days)
{
MedicalCardEntities context = new MedicalCardEntities();
DateTime fromDate = DateTime.Now;
DateTime toDate = DateTime.Now.AddDays(3);
var consultations = context.Consultations
.Include("Patient")
.Where(c => c.PatientId == patientId)
.Where(c => c.ScheduleDate >= fromDate && c.ScheduleDate <= toDate);
return(consultations);
}
public static Patient GetPatientWithConsultationsAndDiagnosesById(int patientId)
{
MedicalCardEntities context = new MedicalCardEntities();
var patient = context.Patients
.Include("Consultations")
.Include("Diagnoses")
.Where(p => p.PatientId == patientId)
.FirstOrDefault();
context.Detach(patient);
return(patient);
}
public static void InsertUser(User user)
{
MedicalCardEntities context = new MedicalCardEntities();
if (user.EntityState != EntityState.Detached)
{
context.ObjectStateManager.ChangeObjectState(user, EntityState.Added);
}
else
{
context.Users.AddObject(user);
}
context.SaveChanges();
}
/// <summary>
/// Validates login details
/// </summary>
/// <param name="username">Username of the user to log in</param>
/// <param name="password">Password of the user to logi in</param>
/// <returns></returns>
public static bool IsValidLoginData(string username, string password)
{
MedicalCardEntities context = new MedicalCardEntities();
var user = context.Users.Where(u => u.UserName == username && u.Password == password).FirstOrDefault();
if (user == null)
{
return(false);
}
else
{
return(true);
}
}
public static Consultation GetConsultationById(int consultationId)
{
MedicalCardEntities context = new MedicalCardEntities();
var consultation = context
.Consultations
.Include("Doctor")
.Include("Patient")
.Where(p => p.ConsultationId == consultationId)
.FirstOrDefault();
//detaching the object - ablity to share between different contexts
context.Detach(consultation);
return(consultation);
}
public static void InsertDiagnosis(Diagnosis diagnosis)
{
MedicalCardEntities context = new MedicalCardEntities();
if (diagnosis.EntityState != EntityState.Detached)
{
context.ObjectStateManager.ChangeObjectState(diagnosis, EntityState.Added);
}
else
{
context.Diagnoses.AddObject(diagnosis);
}
context.SaveChanges();
}
public static void InsertDoctor(Doctor doctor)
{
MedicalCardEntities context = new MedicalCardEntities();
if (doctor.EntityState != EntityState.Detached)
{
context.ObjectStateManager.ChangeObjectState(doctor, EntityState.Added);
}
else
{
context.Doctors.AddObject(doctor);
}
context.SaveChanges();
}
