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); }
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); }
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()); }
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)); }
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)); }
/// <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; } }
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)); }
// 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)); // } }
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); }
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)); }
public Consultation Create(Consultation Consultation) { var result = _context.Add <Consultation>(Consultation); _context.SaveChanges(); return(result.Entity); }
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(); } }
public Consultation Save(Consultation xonsultation) { var newConsultation = context.Consultations.Add(xonsultation); context.SaveChanges(); return(newConsultation); }
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); }
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)); }
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)); }
/// <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++; } }
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 })); }
public Consultation Delete(Consultation Consultation) { var result = _context.Remove(Consultation); _context.SaveChanges(); return(result.Entity); }
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; }
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 })); }
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); }
/// <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); }
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); }