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(); }