Example #1
0
        protected override void OnModelCreating(ModelBuilder builder)
        {
            base.OnModelCreating(builder);

            var consultation1 = new Consultation
            {
                Id            = 1000,
                PatientId     = "1000",
                LabTestResult = true
            };

            var consultation2 = new Consultation
            {
                Id        = 1001,
                PatientId = "1001"
            };

            builder.Entity <Consultation>().HasData(consultation1, consultation2);

            builder.Entity <Patient>().HasData(
                new Patient
            {
                Id          = "1000",
                Name        = "Shay Rojansky",
                DateOfBirth = new DateTime(1979, 5, 1),
            },
                new Patient
            {
                Id          = "1001",
                Name        = "Brar Piening",
                DateOfBirth = new DateTime(1979, 5, 1),
                IsHighRisk  = true
            });
        }
        public async Task <IActionResult> Create([Bind("Id,PatientId,DoctorId,Title,Type,Date,Symptoms,Diagnosis,Temperature,BloodPressure,Cost,Treatment")] Consultation consultation)
        {
            if (ModelState.IsValid)
            {
                Consultation con = new Consultation();
                var          d   = _context.Users.Where(u => u.UserName.Contains(consultation.DoctorId)).FirstOrDefault();
                var          p   = _context.Users.Where(u => u.UserName.Contains(consultation.PatientId)).FirstOrDefault();
                var          doc = await _context.Doctor.FindAsync(d.Id);

                var patient = await _context.Patient.FindAsync(p.Id);

                con.Doctor        = doc;
                con.Patient       = patient;
                con.Id            = consultation.Id;
                con.Title         = consultation.Title;
                con.Treatment     = consultation.Treatment;
                con.Date          = consultation.Date;
                con.Symptoms      = consultation.Symptoms;
                con.Type          = consultation.Type;
                con.Temperature   = consultation.Temperature;
                con.Diagnosis     = consultation.Diagnosis;
                con.Cost          = consultation.Cost;
                con.BloodPressure = consultation.BloodPressure;

                _context.Add(con);
                await _context.SaveChangesAsync();

                return(Redirect("/Reports/Create"));
            }
            ViewData["DoctorId"]  = new SelectList(_context.Doctor, "Id", "Id", consultation.DoctorId);
            ViewData["PatientId"] = new SelectList(_context.Patient, "Id", "Id", consultation.PatientId);
            return(View(consultation));
        }
        public async Task <bool> ChangeConsultationState([FromBody] Consultation consultation)
        {
            if (consultation == null || consultation.User == null)
            {
                return(false);
            }

            User user = await _context.Users.Include(x => x.Consultations).FirstOrDefaultAsync(x => x.Email == consultation.User.Email && x.Password == consultation.User.Password && x.Token == consultation.User.Token);

            if (consultation == null || consultation.User == null)
            {
                return(false);
            }

            var exists = user.Consultations.FirstOrDefault(x => x.ID == consultation.ID);

            if (exists != null)
            {
                exists.State = consultation.State;
                exists.SetCurrentDate();
                await _context.SaveChangesAsync();

                return(true);
            }

            return(false);
        }
Example #4
0
        public Notification <bool> CreateConsultation(Consultation consultation)
        {
            consultation.SetId(GetMaxId() + 1);
            consultation.SetDoctorId(consultation.GetDoctor().Id);
            consultation.SetPatientId(consultation.GetPatient().Id);
            consultation.SetDoctor(userRepo.FindById(consultation.GetDoctorId()));
            consultation.SetPatient(patientRepo.FindById(consultation.GetPatientId()));
            ConsultationValidator validator = new ConsultationValidator(consultation);
            Notification <bool>   notifier  = new Notification <bool>();
            bool validity = validator.Validate();

            if (!validity)
            {
                foreach (var error in validator.GetErrors())
                {
                    notifier.AddError(error);
                }
                notifier.SetResult(false);
            }
            else
            {
                consultationRepo.Create(consultation);
            }
            return(notifier);
        }
Example #5
0
        public async Task <IActionResult> PutConsultation([FromRoute] int id, [FromBody] Consultation consultation)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != consultation.Id)
            {
                return(BadRequest());
            }

            _context.Entry(consultation).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!ConsultationExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
Example #6
0
        public async Task <IActionResult> Edit(string id, [Bind("cons_id,ins_pat,cons_title,cons_type,cons_d,cons_symptoms,cons_diagnosis,cons_temp,cons_blood_presure,cons_cost,cons_treatment,ins_ref")] Consultation consultation)
        {
            if (id != consultation.cons_id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(consultation);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!ConsultationExists(consultation.cons_id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(consultation));
        }
Example #7
0
        public ConsultationForm(int testid, DateTime date, int sel_type, mode _m)
        {
            InitializeComponent();


            ctx = new TubDataBaseEntities();
            m   = _m;
            ctx.ConsultationType.Load();
            consultationTypeBindingSource.DataSource = ctx.ConsultationType.Local.ToBindingList();
            test = testid;
            typeCB.SelectedValue = sel_type;
            typeCB.Enabled       = false;
            con = (from c in ctx.Consultation where (c.cons_id == testid) select c).FirstOrDefault();
            if (m == mode.Redact)
            {
                this.StatusL.Text = "Завершено " + date.ToShortDateString();
                LoadTest(testid);
            }
            else if (m == mode.Create)
            {
                this.StatusL.Text = "Закінчити тест за " + date.ToShortDateString();
            }
            else if (m == mode.Losed)
            {
                this.StatusL.Text = "Пропущений тест за " + date.ToShortDateString();
            }
        }
        public async Task <IActionResult> PatientNewConsultation([Bind(Prefix = "Item2")] ConsultationViewModel vm)
        {
            var doctor = await doctroRepo.GetDoctorByUserNameAsync(User.Identity.Name);

            var patient = await patientRepo.GetPatientByIdAsync(vm.PatientId);

            if (!doctor.Patients.Contains(patient))
            {
                return(new RedirectResult("/Denied"));
            }

            var consultation = new Consultation()
            {
                Header      = vm.Header,
                Description = vm.Description,
                Time        = vm.Time,
                DoctorId    = doctor.Id,
                Doctor      = doctor,
                PatientId   = vm.PatientId,
                Patient     = patient,
                Drugs       = new HashSet <Drug>()
            };

            patient.Consultations = patient.Consultations ?? new HashSet <Consultation>();

            patient.Consultations.Add(consultation);

            patient.Consultations = patient.Consultations.OrderByDescending(x => x.Time).ToList();

            patientRepo.UpdatePatient(patient);
            await doctroRepo.SaveChangesAsync();

            return(PartialView("PatientHistory", patient));
        }
Example #9
0
        /// <summary>
        /// Чтение данных из файла
        /// </summary>
        public void ParseData(string db)
        {
            consultation = new Consultation();
            ConsultationFiller cf = new ConsultationFiller(consultation);

            cf.ReadData(db);

            if (!cf.HasErrorOccured)
            {
                Dialog = Phrases.PressStart;
                Title  = "";

                foreach (string str in consultation.Title)
                {
                    Title += str + "\n";
                }

                fillHypotheses();
                fillQuestions();
            }
            else
            {
                Dialog = consultation.Dialog;
            }
        }
Example #10
0
        public IHttpActionResult PutConsultation(int id, Consultation consultation)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != consultation.Id)
            {
                return(BadRequest());
            }

            db.Entry(consultation).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!ConsultationExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Example #11
0
        // GET: Consultations/GetAppointments
        public ActionResult GetAppointments()
        {
            Consultation consultation = new Consultation();

            var id = User.Identity.GetUserId();
            //ApplicationUser user = HttpContext.GetOwinContext().GetUserManager<ApplicationUserManager>().FindById(id);

            int userId = 1;

            foreach (User userTble in db.Users.ToList())
            {
                if (userTble.Email == User.Identity.Name)
                {
                    userId = userTble.UserId;
                    break;
                }
            }
            //Consultation matchId = db.Consultations.FirstOrDefault(i => i.UserId == userId);
            //var items = db.Items.Where(i => i.typeID == 1);
            return(Json(db.Consultations.Where(i => i.UserUserId == userId).AsEnumerable().Select(e => new
            {
                id = e.ConsultationId,
                title = e.RDescription,
                start = Convert.ToDateTime(e.StartDT),
                end = Convert.ToDateTime(e.EndDT),
                description = (e.Status)
            }).ToList(), JsonRequestBehavior.AllowGet));

            // }
        }
Example #12
0
        public List <Consultation> selectConsultationsFromIdPatient(string p_id_patient)
        {
            MySqlCommand cmd = connection.CreateCommand();

            cmd.CommandText = "SELECT * FROM consultation WHERE id_patient='" + p_id_patient + "'";

            MySqlDataReader reader = cmd.ExecuteReader();

            List <Consultation> lst_consultations = new List <Consultation>();

            Consultation consultation = null;

            if (reader.Read())
            {
                new Consultation();

                consultation.id_consult        = Convert.ToString(reader["id_consult"]);
                consultation.date_consultation = Convert.ToDateTime(reader["date_consultation"]);
                consultation.ecg      = Convert.ToString(reader["ecg"]);
                consultation.phono    = Convert.ToString(reader["phono"]);
                consultation.foyer    = Convert.ToString(reader["foyer"]);
                consultation.poids    = Convert.ToDouble(reader["poids"]);
                consultation.pression = Convert.ToDouble(reader["pression"]);
                consultation.pression_arterielle_systolique  = Convert.ToDouble(reader["pression_arterielle_systolique"]);
                consultation.pression_arterielle_diastolique = Convert.ToDouble(reader["pression_arterielle_diastolique"]);
                consultation.obeservation = Convert.ToString(reader["obeservation"]);

                lst_consultations.Add(consultation);
            }

            connection.Close();

            return(lst_consultations);
        }
Example #13
0
 public ResponseModel Save(Consultation entity)
 {
     if (entity.Valid)
     {
         var hasAvailableTime = _uow.ConsultationRepository.AddCheckingForAvailableTime(entity);
         if (hasAvailableTime)
         {
             return(new ResponseModel
             {
                 Status = Domain.DataContext.Enums.EResultStatus.Success,
                 Data = entity,
                 Location = $"/api/consultations/{entity.Id}",
                 Message = "Consulta marcada com sucesso"
             });
         }
         else
         {
             return(new ResponseModel
             {
                 Status = Domain.DataContext.Enums.EResultStatus.Failure,
                 Message = "Não há horário disponível"
             });
         }
     }
     else
     {
         return(new ResponseModel
         {
             Status = Domain.DataContext.Enums.EResultStatus.Failure,
             Message = "Falha ao tentar marcar consulta",
             Notifications = entity.Notifications
         });
     }
 }
        public async Task <IActionResult> Edit(int id, [Bind("Id,Title,Type,Date,Symptoms,Diagnosis,Temp,BloodPressure,Cost,Treatment,InsuranceConfirmation,PatientId,DoctorId")] Consultation consultation)
        {
            if (id != consultation.Id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(consultation);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!ConsultationExists(consultation.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(consultation));
        }
Example #15
0
        public Consultation Create(Consultation Consultation)
        {
            var result = _context.Add <Consultation>(Consultation);

            _context.SaveChanges();
            return(result.Entity);
        }
Example #16
0
        public void LoadDB()
        {
            _dbContext.Database.EnsureDeleted();
            if (_dbContext.Database.EnsureCreated())
            {
                User sadik = new User("SadikDev", "*****@*****.**", Convert.ToBase64String(Encoding.UTF8.GetBytes("1974sadik")));

                string   birth1 = "1974/12/04";
                DateTime date1  = DateTime.Parse(birth1);

                string   birth2 = "1988/08/12";
                DateTime date2  = DateTime.Parse(birth2);

                Customer ahmed = new Customer("Ahmed Sadik", "*****@*****.**", "singes", "male", 97120415301, date1);
                Customer lisa  = new Customer("Lisa Marzouki", "*****@*****.**", "lisa123lisa", "female", 88081212345, date2);

                string   dateString = "2020/12/04 16:54";
                DateTime oDate      = DateTime.Parse(dateString);

                Consultation rdv1 = new Consultation(ahmed, oDate, "consultation");
                Consultation rdv2 = new Consultation(lisa, oDate, "consultation");



                UpdateLog updateLog = new UpdateLog(DateTime.UtcNow.AddHours(1));

                _dbContext.UpdateLogs.AddRange(updateLog);
                _dbContext.Customers.AddRange(ahmed, lisa);
                _dbContext.Users.AddRange(sadik);
                _dbContext.Appointments.AddRange(rdv1, rdv2);

                _dbContext.FirstSave();
            }
        }
Example #17
0
        public Consultation Save(Consultation xonsultation)
        {
            var newConsultation = context.Consultations.Add(xonsultation);

            context.SaveChanges();
            return(newConsultation);
        }
Example #18
0
        public Consultation Ajouter(Facture facture, Veterinaire veto, Animal animal, DateTime dateConsultation, Consultation.eConsultationEtat etat, string commentaire, bool archive)
        {
            Consultation consultation = new Consultation(Guid.NewGuid(), facture, veto, animal, dateConsultation, etat, commentaire, archive);

            Database.Instance.insert(consultation);
            return(consultation);
        }
Example #19
0
        public ActionResult Create([Bind(Include = "PatientId,PatientName,AdmittedBy,DateOfConsult,PreviousConsultDate,PreviousConsult,ChiefComplaint,Age,BPFirstReading,BPSecondReading,BPAverage,RaisedBP,PulseRate,RR,Temperature,WeightInKgms,HeightInCm,WaistCircumferenceInCm,CentralAdiposity,History,PhysicalExam,DiagnosisLabResult,ManagementTreatment,Recommendation,Pharmacy,PhysicianID")] CreateConsultViewModel createConsultationViewModel)
        {
            if (ModelState.IsValid)
            {
                Person patient = db.Patient.Single(d => d.PersonID == createConsultationViewModel.PatientId);
                var    consult = new Consultation();
                consult.AdmittedBy          = createConsultationViewModel.AdmittedBy;
                consult.DateOfConsult       = createConsultationViewModel.DateOfConsult;
                consult.PreviousConsultDate = createConsultationViewModel.PreviousConsultDate;
                consult.PreviousConsult     = (Entity.PlaceOfPreviousConsult)createConsultationViewModel.PreviousConsult;
                consult.ChiefComplaint      = createConsultationViewModel.ChiefComplaint;
                consult.Age             = createConsultationViewModel.Age;
                consult.BPFirstReading  = createConsultationViewModel.BPFirstReading;
                consult.BPSecondReading = createConsultationViewModel.BPSecondReading;
                consult.BPAverage       = createConsultationViewModel.BPAverage;
                consult.RaisedBP        = createConsultationViewModel.RaisedBP;
                consult.RR                     = createConsultationViewModel.RR;
                consult.Temperature            = createConsultationViewModel.Temperature;
                consult.WeightInKgms           = createConsultationViewModel.WeightInKgms;
                consult.HeightInCm             = createConsultationViewModel.HeightInCm;
                consult.WaistCircumferenceInCm = createConsultationViewModel.WaistCircumferenceInCm;
                consult.CentralAdiposity       = createConsultationViewModel.CentralAdiposity;
                if ((createConsultationViewModel.WeightInKgms > 0) | (createConsultationViewModel.HeightInCm > 0))
                {
                    var heightsquare = (createConsultationViewModel.HeightInCm / 100) * (createConsultationViewModel.HeightInCm / 100);
                    var bmi          = createConsultationViewModel.WeightInKgms / heightsquare;
                    consult.BMI = bmi;
                    if (bmi <= (18.5m))
                    {
                        consult.BMIStatus = BMIStatus.Underweight;
                    }
                    else if (bmi <= (25))
                    {
                        consult.BMIStatus = BMIStatus.Normal;
                    }
                    else if (bmi <= 30)
                    {
                        consult.BMIStatus = BMIStatus.Overweight;
                    }
                    else
                    {
                        consult.BMIStatus = BMIStatus.Obese;
                    }
                }
                consult.History             = createConsultationViewModel.History;
                consult.PhysicalExam        = createConsultationViewModel.PhysicalExam;
                consult.DiagnosisLabResult  = createConsultationViewModel.DiagnosisLabResult;
                consult.ManagementTreatment = createConsultationViewModel.ManagementTreatment;
                consult.Recommendation      = createConsultationViewModel.Recommendation;
                consult.Pharmacy            = createConsultationViewModel.Pharmacy;
                consult.PhysicianID         = createConsultationViewModel.PhysicianID;

                patient.Consultations.Add(consult);
                db.SaveChanges();

                return(RedirectToAction("Details", "Patient", new { Id = createConsultationViewModel.PatientId }));
            }

            return(View(createConsultationViewModel));
        }
Example #20
0
        public async Task <IActionResult> Edit(int id, [Bind("IdDocteur,IdDossierpatient,DateC,Diagnostic,IdOrdonnance,Id")] Consultation consultation)
        {
            if (id != consultation.Id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    CliniqueDbContext context = _contextFactory.CreateDbContext();
                    context.Update(consultation);
                    await context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!ConsultationExists(consultation.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(consultation));
        }
Example #21
0
        /// <summary>
        /// Parcours et Affichage des actes de la Consultation (Type, Libellé)
        /// </summary>
        /// <param name="uneConsultation"> Consultation en cours d'affichage </param>
        private void AfficherActes(Consultation uneConsultation)
        {
            int i = 1;

            uneConsultation.actes = MgtActe.GetActesByConsultation(uneConsultation.codeConsultation);

            foreach (Acte unActe in uneConsultation.actes)
            {
                richTBox_Dossier.AppendText(Environment.NewLine);
                richTBox_Dossier.AppendText("   ", Color.Black, 12, false, false, false);
                richTBox_Dossier.AppendText("  - Acte ", Color.Black, 12, false, false, false);
                richTBox_Dossier.AppendText(" : ", Color.Black, 12, false, false, false);
                richTBox_Dossier.AppendText(i.ToString(), Color.Navy, 12, false, true, false);
                richTBox_Dossier.AppendText(Environment.NewLine);

                richTBox_Dossier.AppendText("     ", Color.Black, 12, false, false, false);
                richTBox_Dossier.AppendText("    Type de l'Acte : ", Color.Black, 12, false, false, false);
                richTBox_Dossier.AppendText(unActe.typeActe, Color.Navy, 12, false, true, false);
                richTBox_Dossier.AppendText("   -  ", Color.Black, 12, false, false, false);
                richTBox_Dossier.AppendText(unActe.libelle, Color.Navy, 12, false, true, false);
                richTBox_Dossier.AppendText(Environment.NewLine);

                i++;
            }
        }
Example #22
0
        public async Task <IActionResult> CreateConsultation(Consultation c)
        {
            int drId = c.DoctorId;

            if (drId == null || c == null)
            {
                return(NotFound());
            }
            Patient pat = _context.Patients.Where(s => s.Id == c.PatientId).First();
            Doctor  dr  = _context.Doctors.Where(s => s.Id == drId).First();

            //c.Patient = pat;
            //c.Doctor = dr;
            try
            {
                _context.Consultations.Add(c);
                await _context.SaveChangesAsync();

                return(RedirectToAction("ManageConsultation", new { id = drId }));
            }
            catch (DbUpdateException)
            {
                ModelState.AddModelError("", "Unable to save changes. " +
                                         "Try again, and if the problem persists " +
                                         "see your system administrator.");
            }
            return(RedirectToAction("ManageConsultation", new { id = drId }));
        }
Example #23
0
        public Consultation Delete(Consultation Consultation)
        {
            var result = _context.Remove(Consultation);

            _context.SaveChanges();
            return(result.Entity);
        }
Example #24
0
        public void AjouterConsultation()
        {
            // Consult = null;



            // modele.ConsultationSet.Add(Consult);
            try
            {
                Consultation x = Consult;
                PatientFiche.Consultation.Add(x);
                PatientFiche.DateDernConsult = DateTime.Now;
                modele.SaveChanges();
            }
            catch (Exception e)
            {
                MessageBox.Show("Veillez verifiez vos informations");
            }
            // PatientFiche.Consultation = modele.ConsultationSet.Where(u => u.PatientID == PatientFiche.PatientID).ToList();

            Patient p = PatientFiche;

            PatientFiche = null;
            PatientFiche = p;
        }
Example #25
0
        public async Task <IActionResult> UpdateConsultation(int drId, int ptId, int conId, String Symptoms, String Diagnoses, String Temp, String BloodPressure, String Treatment)
        {
            Consultation c  = _context.Consultations.Where(s => s.Id == conId).Include(s => s.Patient).First();
            Doctor       dr = _context.Doctors.Where(s => s.Id == c.DoctorId).First();
            Patient      pt = _context.Patients.Where(s => s.Id == c.PatientId).First();

            c.Symptoms      = Symptoms;
            c.Diagnoses     = Diagnoses;
            c.Temp          = Temp;
            c.BloodPressure = BloodPressure;
            c.Treatment     = Treatment;
            try
            {
                _context.Consultations.Update(c);
                await _context.SaveChangesAsync();

                return(RedirectToAction("ManageConsultation", new { id = drId }));
            }
            catch (DbUpdateException)
            {
                ModelState.AddModelError("", "Unable to save changes. " +
                                         "Try again, and if the problem persists, " +
                                         "see your system administrator.");
            }

            return(RedirectToAction("ManageConsultation", new { id = drId }));
        }
Example #26
0
        public void UpdateConsultationRepositoryTest()
        {
            //Arrange
            IConsultationRepository repository   = new ConsultationRepository();
            Consultation            Consultation = _contextForTest.Consultations.Find(1);

            Consultation.Name = "Teste";
            Consultation.Age  = 20;
            Consultation.Cpf  = "0000";
            Consultation.Rg   = "0000";
            Consultation.Date = DateTime.Now;
            Consultation.Type = " SAUHSAHUSUAS";

            //Action
            var updatedConsultation = repository.Update(Consultation);

            //Assert
            var persistedConsultation = _contextForTest.Consultations.Find(1);

            Assert.IsNotNull(updatedConsultation);
            Assert.AreEqual(updatedConsultation.Id, persistedConsultation.Id);
            Assert.AreEqual(updatedConsultation.Name, persistedConsultation.Name);
            Assert.AreEqual(updatedConsultation.Cpf, persistedConsultation.Cpf);
            Assert.AreEqual(updatedConsultation.Rg, persistedConsultation.Rg);
            Assert.AreEqual(updatedConsultation.Type, persistedConsultation.Type);
            Assert.AreEqual(updatedConsultation.Date, persistedConsultation.Date);
        }
Example #27
0
        /// <summary>
        /// New patient registration
        /// </summary>
        /// <param name="patient"></param>
        /// <returns>true if patient is registered successfully; otherwise false</returns>
        public bool RegisterPatient(Patient patient)
        {
            ValidationRules rule = new ValidationRules();

            if (!rule.PatientValidation(patient))
            {
                return(false);
            }

            if (PatientSchedulerContext.Patients == null)
            {
                PatientSchedulerContext.Patients = new List <Patient>();
            }

            PatientSchedulerContext.Patients.Add(patient);

            ConsultationScheduler scheduler    = new ConsultationScheduler();
            Consultation          consultation = scheduler.SchedulePatientConsultation(patient);

            if (consultation == null)
            {
                return(false);
            }

            if (PatientSchedulerContext.Consultations == null)
            {
                PatientSchedulerContext.Consultations = new List <Consultation>();
            }

            PatientSchedulerContext.Consultations.Add(consultation);

            return(true);
        }
Example #28
0
        public ActionResult Create(CreateViewModel createView)
        {
            try
            {
                if (!ModelState.IsValid)
                {
                    return(View());
                }

                Consultation consultation = new Consultation();

                consultation.Name = createView.Name;
                consultation.Age  = createView.Age;
                consultation.Cpf  = createView.Cpf;
                consultation.Rg   = createView.Rg;
                consultation.Type = createView.Type;
                consultation.Date = createView.Date;

                _service.Create(consultation);

                return(RedirectToAction("Index"));
            }
            catch
            {
                return(View("Error"));
            }
        }
        public IList <Consultation> RetrieveConsultation()
        {
            IList <Consultation> consultationList = new List <Consultation>();

            using (MySqlConnection conn = new MySqlConnection(connString))
            {
                conn.Open();
                string statement = "SELECT * FROM consultation";

                MySqlCommand    cmd    = new MySqlCommand(statement, conn);
                MySqlDataReader reader = cmd.ExecuteReader();
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        Consultation consultation = new Consultation();
                        consultation.id          = reader.GetInt32("id");
                        consultation.appointment = reader.GetDateTime("appointment");
                        consultation.doctor_id   = reader.GetInt32("doctor_id");
                        consultation.patient_identityCardNumber = reader.GetInt32("patient_identityCardNumber");

                        consultationList.Add(consultation);
                    }
                }
            }

            return(consultationList);
        }
        public Consultation AddDrugToConsult(Consultation consut, string id)
        {
            var Consultation = da.Consultations.ToList().Find(x => x.ConsultId == id);
            var PatientName  = da.Patients.ToList().Find(x => x.PatientId == Consultation.PatientId);

            Consultation.patientfullname = PatientName.FullName + " " + PatientName.Surname;
            //DosageViewModel model = new DosageViewModel();
            //DrugRespo respo = new DrugRespo();
            //foreach (var item in collection.Drugs)
            //{
            //    model.DrugName = item.DrugName;
            //    model.PaymentType = item.Price*quantity;
            //    model.Quantity = quantity;
            //    model.PatientID = collection.PatientID;
            //    model.PatientName = collection.PatientName;
            //    da.DosageViewModel.Add(model);
            //    Drug update = respo.GetById(item.DrugId);
            //    update.Quantity -= quantity;
            //    respo.Update(update);
            //    da.SaveChanges();

            //}
            //foreach (var item in Drugs)
            //{
            //    var drugstoadd = da.Drugs.Find(int.Parse(item));
            //    collection.Drugs.Add(drugstoadd);
            //}
            //da.SaveChanges();
            return(Consultation);
        }
        public ActionResult Consultation( int id,ConsultationViewModel consultationVM)
        {
            if (ModelState.IsValid )
            {

                Consultation cs = new Consultation();

                 cs.Appontmentid = Convert.ToInt32(id);
                cs.Recommendation = consultationVM.Recommendation;
                cs.Symptoms = consultationVM.Symptoms;
                cs.Diagnosis = consultationVM.Diagnosis;

                consultationRepository.Add(cs);

                consultationVM.FeedBack = "Consultation addedd successfully";
                return View(consultationVM);
            }
            return View(new ConsultationViewModel());
        }
 public void Add(Consultation consultation)
 {
     context.Consultations.Add(consultation);
 }