public static void DeleteDiagnosisById(int diagnosisId)
        {
            SystemMedContainer context = new SystemMedContainer();
            var diagnosis = context.Diagnoses.Where(p => p.DiagnoseId == diagnosisId).FirstOrDefault();

            context.Diagnoses.DeleteObject(diagnosis);
            context.SaveChanges();
        }
        public static void UpdateDoctor(Doctor doctor)
        {
            SystemMedContainer context = new SystemMedContainer();

            context.Doctors.AddObject(doctor);
            context.ObjectStateManager.ChangeObjectState(doctor, EntityState.Modified);
            context.SaveChanges();
        }
        public static void UpdateDiagnosis(Diagnosis diagnosis)
        {
            SystemMedContainer context = new SystemMedContainer();

            context.Diagnoses.AddObject(diagnosis);
            context.ObjectStateManager.ChangeObjectState(diagnosis, EntityState.Modified);
            context.SaveChanges();
        }
        public static void UpdateUser(User user)
        {
            SystemMedContainer context = new SystemMedContainer();

            context.Users.AddObject(user);
            context.ObjectStateManager.ChangeObjectState(user, EntityState.Modified);
            context.SaveChanges();
        }
        public static void DeleteUserById(int userId)
        {
            SystemMedContainer context = new SystemMedContainer();
            var user = context.Users.Where(p => p.UserId == userId).FirstOrDefault();

            context.Users.DeleteObject(user);
            context.SaveChanges();
        }
        public static void DeleteDoctorById(int doctorId)
        {
            SystemMedContainer context = new SystemMedContainer();
            var doctor = context.Doctors.Where(p => p.DoctorId == doctorId).FirstOrDefault();

            context.Doctors.DeleteObject(doctor);
            context.SaveChanges();
        }
Exemplo n.º 7
0
        public static void DeletePatientById(int patientId)
        {
            SystemMedContainer context = new SystemMedContainer();
            var patient = context.Patients.Where(p => p.PatientId == patientId).FirstOrDefault();

            context.Patients.DeleteObject(patient);
            context.SaveChanges();
        }
        public static void DeleteConsultationById(int consultationId)
        {
            SystemMedContainer context = new SystemMedContainer();
            var consultation           = context.Consultations.Where(p => p.ConsultationId == consultationId).FirstOrDefault();

            context.Consultations.DeleteObject(consultation);
            context.SaveChanges();
        }
Exemplo n.º 9
0
        public static void UpdatePatient(Patient patient)
        {
            SystemMedContainer context = new SystemMedContainer();

            context.Patients.AddObject(patient);
            context.ObjectStateManager.ChangeObjectState(patient, EntityState.Modified);
            context.SaveChanges();

            //detach because object is stateless
            context.Detach(patient);
        }
        public static void DeleteUser(User user)
        {
            SystemMedContainer context = new SystemMedContainer();

            if (user.EntityState == EntityState.Detached)
            {
                context.Users.Attach(user);
            }
            context.Users.DeleteObject(user);
            context.SaveChanges();
        }
        public static void DeleteDoctor(Doctor doctor)
        {
            SystemMedContainer context = new SystemMedContainer();

            if (doctor.EntityState == EntityState.Detached)
            {
                context.Doctors.Attach(doctor);
            }
            context.Doctors.DeleteObject(doctor);
            context.SaveChanges();
        }
Exemplo n.º 12
0
        public static void DeletePatient(Patient patient)
        {
            SystemMedContainer context = new SystemMedContainer();

            if (patient.EntityState == EntityState.Detached)
            {
                context.Patients.Attach(patient);
            }
            context.Patients.DeleteObject(patient);
            context.SaveChanges();
        }
        public static void UpdateConsultation(Consultation consultation)
        {
            SystemMedContainer context = new SystemMedContainer();

            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 void DeleteConsultation(Consultation consultation)
        {
            SystemMedContainer context = new SystemMedContainer();

            if (consultation.EntityState == EntityState.Detached)
            {
                context.Consultations.Attach(consultation);
            }
            context.Consultations.DeleteObject(consultation);
            context.SaveChanges();
        }
        public static void DeleteDiagnosis(Diagnosis diagnosis)
        {
            SystemMedContainer context = new SystemMedContainer();

            if (diagnosis.EntityState == EntityState.Detached)
            {
                context.Diagnoses.Attach(diagnosis);
            }
            context.Diagnoses.DeleteObject(diagnosis);
            context.SaveChanges();
        }
        public static void InsertDoctor(Doctor doctor)
        {
            SystemMedContainer context = new SystemMedContainer();

            if (doctor.EntityState != EntityState.Detached)
            {
                context.ObjectStateManager.ChangeObjectState(doctor, EntityState.Added);
            }
            else
            {
                context.Doctors.AddObject(doctor);
            }
            context.SaveChanges();
        }
        public static void InsertUser(User user)
        {
            SystemMedContainer context = new SystemMedContainer();

            if (user.EntityState != EntityState.Detached)
            {
                context.ObjectStateManager.ChangeObjectState(user, EntityState.Added);
            }
            else
            {
                context.Users.AddObject(user);
            }
            context.SaveChanges();
        }
        public static void InsertDiagnosis(Diagnosis diagnosis)
        {
            SystemMedContainer context = new SystemMedContainer();

            if (diagnosis.EntityState != EntityState.Detached)
            {
                context.ObjectStateManager.ChangeObjectState(diagnosis, EntityState.Added);
            }
            else
            {
                context.Diagnoses.AddObject(diagnosis);
            }
            context.SaveChanges();
        }
        public static void InsertConsultation(Consultation consultation)
        {
            SystemMedContainer context = new SystemMedContainer();

            if (consultation.EntityState != EntityState.Detached)
            {
                context.ObjectStateManager.ChangeObjectState(consultation, EntityState.Added);
            }
            else
            {
                context.Consultations.AddObject(consultation);
            }
            context.SaveChanges();
            //detaching the object - ablity to share between different contexts
            context.Detach(consultation);
        }
Exemplo n.º 20
0
        public static void InsertPatient(Patient patient)
        {
            SystemMedContainer context = new SystemMedContainer();

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