public static void UpdateDiagnosis(Diagnosis diagnosis)
{
MedicalCardEntities context = new MedicalCardEntities();
context.Diagnoses.AddObject(diagnosis);
context.ObjectStateManager.ChangeObjectState(diagnosis, EntityState.Modified);
context.SaveChanges();
}
public static IQueryable<Diagnosis> GetDiagnosesByPatientId(int patientId)
{
MedicalCardEntities context = new MedicalCardEntities();
var diagnoses = context.Diagnoses.Include("Doctor").Where(d => d.PatientId == patientId);
return diagnoses;
}
public static void UpdateDoctor(Doctor doctor)
{
MedicalCardEntities context = new MedicalCardEntities();
context.Doctors.AddObject(doctor);
context.ObjectStateManager.ChangeObjectState(doctor, EntityState.Modified);
context.SaveChanges();
}
/// <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 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 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 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 IQueryable<Consultation> GetConsultationsByPatientId(int patientId)
{
MedicalCardEntities context = new MedicalCardEntities();
var consultations = context.Consultations
.Include("Doctor")
.Where(p => p.PatientId == patientId);
return consultations;
}
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();
}
/// <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 DeleteDoctorById(int doctorId)
{
MedicalCardEntities context = new MedicalCardEntities();
var doctor = context.Doctors.Where(p => p.DoctorId == doctorId).FirstOrDefault();
context.Doctors.DeleteObject(doctor);
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 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 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 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 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 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 DeletePatient(Patient patient)
{
MedicalCardEntities context = new MedicalCardEntities();
if (patient.EntityState == EntityState.Detached)
{
context.Patients.Attach(patient);
}
context.Patients.DeleteObject(patient);
context.SaveChanges();
}
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 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 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();
}
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 InsertPatient(Patient patient)
{
MedicalCardEntities context = new MedicalCardEntities();
if (patient.EntityState != EntityState.Detached)
{
context.ObjectStateManager.ChangeObjectState(patient, EntityState.Added);
}
else
{
context.Patients.AddObject(patient);
}
context.SaveChanges();
//detach because object is stateless
context.Detach(patient);
}
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 IQueryable<Patient> GetPatients()
{
MedicalCardEntities context = new MedicalCardEntities();
return context.Patients;
}
public static void UpdateUser(User user)
{
MedicalCardEntities context = new MedicalCardEntities();
context.Users.AddObject(user);
context.ObjectStateManager.ChangeObjectState(user, EntityState.Modified);
context.SaveChanges();
}
public static IQueryable<Diagnosis> GetDiagnoses()
{
MedicalCardEntities context = new MedicalCardEntities();
return context.Diagnoses;
}
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();
}