public Consulta AcceeConsultationId(int Id) { List <string> radio = new List <string>(); List <Traite> traitement = new List <Traite>(); Consultation cnslt = (from cns in Globals.DataClass.Consultation where cns.Id == Id select cns).First <Consultation>(); IQueryable <Radio> rdi = (from radi in Globals.DataClass.Radio where radi.IdConsultation == cnslt.Id select radi); foreach (Radio p in rdi) { radio.Add(p.chemin); } IQueryable <Traitement> trait = (from traitemen in Globals.DataClass.Traitement where traitemen.IdConsultation == cnslt.Id select traitemen); foreach (Traitement p in trait) { Medicaments Med = (from med in Globals.DataClass.Medicaments where med.Id == p.IdMedicament select med).First <Medicaments>(); Traite q = new Traite(p.Dose, p.Indication, Med.nom); traitement.Add(q); } Consulta consultation = new Consulta((DateTime)cnslt.date, cnslt.diagnostic, cnslt.description, cnslt.cheminCertificat, cnslt.cheminLettreOrientation, cnslt.cheminScanner, cnslt.cheminBilan, cnslt.cheminOrdo, traitement, radio); return(consultation); }
public IActionResult Edit(PatientDiseaseMedicaments patientDiseaseMedicaments) { bool MedicamentExisted = _context.Medicaments.Any(x => x.Name.ToLower().Equals(patientDiseaseMedicaments.MedicamentName.ToLower())); if (MedicamentExisted) { patientDiseaseMedicaments.MedicamentId = _context.Medicaments.Where(x => x.Name.ToLower().Equals(patientDiseaseMedicaments.MedicamentName.ToLower())).FirstOrDefault().MedicamentId; } else { Medicaments medicaments = new Medicaments() { Name = patientDiseaseMedicaments.MedicamentName }; _context.Medicaments.Add(medicaments); _context.SaveChanges(); patientDiseaseMedicaments.MedicamentId = medicaments.MedicamentId; } PatientDiseaseMedicaments oldPDM = _context.PatientDiseaseMedicaments.Where(x => x.PatientDiseaseMedicamentId == patientDiseaseMedicaments.PatientDiseaseMedicamentId).FirstOrDefault(); oldPDM.MedicamentId = patientDiseaseMedicaments.MedicamentId; oldPDM.PatientDiseaseId = patientDiseaseMedicaments.PatientDiseaseId; oldPDM.TimesPerDay = patientDiseaseMedicaments.TimesPerDay; oldPDM.Dose = patientDiseaseMedicaments.Dose; oldPDM.DateStart = patientDiseaseMedicaments.DateStart; oldPDM.DateFinish = patientDiseaseMedicaments.DateFinish; _context.SaveChanges(); return(RedirectToAction("Create", new { id = oldPDM.PatientDiseaseId })); }
public IActionResult Create(PatientDiseaseMedicaments patientDiseaseMedicaments) { //check if medicament existed //if existed get his id //if not add it to medicaments and add it to list if (patientDiseaseMedicaments.MedicamentName == null) { return(RedirectToAction("Create")); } bool MedicamentExisted = _context.Medicaments.Any(x => x.Name.ToLower().Equals(patientDiseaseMedicaments.MedicamentName.ToLower())); if (MedicamentExisted) { patientDiseaseMedicaments.MedicamentId = _context.Medicaments.Where(x => x.Name.ToLower().Equals(patientDiseaseMedicaments.MedicamentName.ToLower())).FirstOrDefault().MedicamentId; } else { Medicaments medicaments = new Medicaments() { Name = patientDiseaseMedicaments.MedicamentName }; _context.Medicaments.Add(medicaments); _context.SaveChanges(); patientDiseaseMedicaments.MedicamentId = medicaments.MedicamentId; } _context.PatientDiseaseMedicaments.Add(patientDiseaseMedicaments); _context.SaveChanges(); return(RedirectToAction("Create")); }
private static MedicamentsModel MapToModel(Medicaments medicaments) => new MedicamentsModel { Id = medicaments.Id, Name = medicaments.Name, Amount = medicaments.Amount, Description = medicaments.Description, ExpirationDate = medicaments.ExpirationDate, UserId = medicaments.UserId };
private async void LvMedicaments_Selected(object sender, SelectedItemChangedEventArgs e) { if (lvMedicaments.SelectedItem != null) { Medicaments leMedicamentSelectionner = (lvMedicaments.SelectedItem as Medicaments); Pages.PageModifierMedoc page = new Pages.PageModifierMedoc(leMedicamentSelectionner); await Navigation.PushModalAsync(page); } }
public void AfficherInfoMedoc(Medicaments unMedicament) { txtDepotLegal.Text = unMedicament.Depot; txtNomCommercial.Text = unMedicament.NomCom; txtComposition.Text = unMedicament.Compo; txtEffets.Text = unMedicament.Effets; txtContreIndic.Text = unMedicament.ContreIndic; txtPrix.Text = unMedicament.Prix.ToString(); txtCodeFamille.Text = unMedicament.CodeFam.ToString(); }
public async Task <bool> Update(Medicaments medicaments) { var updateResult = await _context .Medicaments .ReplaceOneAsync( filter : g => g.Id == medicaments.Id, replacement : medicaments); return(updateResult.IsAcknowledged && updateResult.ModifiedCount > 0); }
public void Validation_Test() { //Arrange bool expected = false; Medicaments med = new Medicaments(); //Act bool actual = med.Validation(); //Assert Assert.AreEqual(expected, actual, "Zwraca Prawdę"); }
public async Task <ActionResult <MedicamentsModel> > Create(MedicamentsModel foodModel) { var food = new Medicaments { Name = foodModel.Name, Amount = foodModel.Amount, Description = foodModel.Description, ExpirationDate = foodModel.ExpirationDate, UserId = User.GetLoggedInUserId() }; await medicamentsRepository.Create(food); return(new ObjectResult(MapToModel(food))); }
public void If_Med_Ex_2() { //Arrange bool expected = true; // ShareSqlCom sqlCo = new ShareSqlCom(); SqlConnection con2 = new SqlConnection("Data Source=DESKTOP-BQITBQR\\SQLEXPRESS;Initial Catalog=MedkitDB;Integrated Security=True"); Medicaments med2 = new Medicaments(); //Act bool actual = med2.IfMedExists(con2, "1"); //Assert Assert.AreEqual(expected, actual, "Zwraca false"); }
private void AddMedicamentsEntities2(Prescription prescription) { var medicament = new Medicament() { //IdMedicament = 2, Name = "Eurespal", Type = "Liquid", Description = "Throat treatment" }; var mediacamentPrescription = new MedicamentPrescription() { Medicament = medicament, Prescription = prescription, Dose = 10, Details = "Not necessary" }; Medicaments.Add(medicament); MedicamentPrescriptions.Add(mediacamentPrescription); }
private void AddMedicamentsEntities1(Prescription prescription) { var medicament = new Medicament() { //IdMedicament = 1, Name = "Paracetamol", Type = "Pill", Description = "Headache" }; var mediacamentPrescription = new MedicamentPrescription() { Medicament = medicament, Prescription = prescription, Dose = 20, Details = "Obligatory" }; Medicaments.Add(medicament); MedicamentPrescriptions.Add(mediacamentPrescription); }
public MedicamentsController(Medicaments view) { this.view = view; this.medicamentModel = new Models.Medicament(); }
public void AddConsult(string nomPatient, string prenomPatient, string nomMedecin, string prenomMedecin, string diagnostic, string description, string cheminCertificat, string cheminLettreOrientation, string cheminScanner, string cheminBilan, string cheminOrdo, List <string> cheminRadio, List <Traite> traitement, string label, int age) { nomPatient = nomPatient.ToUpper(); prenomMedecin = prenomMedecin.ToUpper(); Consultation table = new Consultation { date = DateTime.Today, diagnostic = diagnostic, description = description, cheminCertificat = cheminCertificat, cheminLettreOrientation = cheminLettreOrientation, cheminScanner = cheminScanner, cheminBilan = cheminBilan, cheminOrdo = cheminOrdo, age = age, label = label }; Globals.DataClass.Consultation.InsertOnSubmit(table); Globals.DataClass.SubmitChanges(); foreach (var chemin in cheminRadio) { Radio tableRadio = new Radio(); tableRadio.chemin = chemin; tableRadio.IdConsultation = table.Id; Globals.DataClass.Radio.InsertOnSubmit(tableRadio); Globals.DataClass.SubmitChanges(); } foreach (var trait in traitement) { Traitement tableTraitement = new Traitement(); tableTraitement.Dose = trait.Dose; tableTraitement.Indication = trait.Indication; tableTraitement.IdConsultation = table.Id; Medicaments medTraitement = (from medicament in Globals.DataClass.Medicaments where trait.NomMed == medicament.nom select medicament).First <Medicaments>(); tableTraitement.IdMedicament = medTraitement.Id; Globals.DataClass.Traitement.InsertOnSubmit(tableTraitement); Globals.DataClass.SubmitChanges(); } Patient patientConsultation = (from personne in Globals.DataClass.Personne where nomPatient == personne.nom && prenomPatient == personne.prenom join patient in Globals.DataClass.Patient on personne.Id equals patient.IdPersonne select patient).First <Patient>(); Medecin medecinConsultation = (from personne in Globals.DataClass.Personne where nomMedecin == personne.nom && prenomMedecin == personne.prenom join medecin in Globals.DataClass.Medecin on personne.Id equals medecin.IdPersonne select medecin).First <Medecin>(); MPConsultation tableMPC = new MPConsultation { IdConsultation = table.Id, IdPatient = patientConsultation.Id, IdMedecin = medecinConsultation.Id }; Globals.DataClass.MPConsultation.InsertOnSubmit(tableMPC); Globals.DataClass.SubmitChanges(); }
public PageModifierMedoc(Medicaments unMedicament) { InitializeComponent(); AfficherInfoMedoc(unMedicament); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(MainForm)); this.SuspendLayout(); // // Panels // LogInPanel logInPanel = new LogInPanel(); ManagerMainPanel managerMainPanel = new ManagerMainPanel(); ManagerAnalytics managerAnalyticsPanel = new ManagerAnalytics(managerMainPanel.Panel); DoctorInCharge managerDICPanel = new DoctorInCharge(managerMainPanel.Panel); Medicaments managerMedicamentsPanel = new Medicaments(managerMainPanel.Panel); Services managerServicesPanel = new Services(managerMainPanel.Panel); Timetables managerTimetablesPanel = new Timetables(managerMainPanel.Panel); Users managerUsersPanel = new Users(managerMainPanel.Panel); OperatorMainPanel operatorMainPanel = new OperatorMainPanel(); OperatorPatientCharts operatorPatientChartsPanel = new OperatorPatientCharts(operatorMainPanel.Panel); Patients operatorPatientsPanel = new Patients(operatorMainPanel.Panel); Reservations operatorReservationsPanel = new Reservations(operatorMainPanel.Panel); OperatorTimetables operatorTimeTablesPanel = new OperatorTimetables(operatorMainPanel.Panel); DoctorMainPanel doctorMainPanel = new DoctorMainPanel(); TimeTablesDoc doctorTimeTablesDocPanel = new TimeTablesDoc(doctorMainPanel.Panel); ReservationsDoc doctorReservationsDocPanel = new ReservationsDoc(doctorMainPanel.Panel); Prescription doctorPrescriptionPanel = new Prescription(doctorMainPanel.Panel); NurseMainPanel nurseMainPanel = new NurseMainPanel(); Schedule nurseSchedulePanel = new Schedule(nurseMainPanel.Panel); ReservationsNurse nurseReservationsNursePanel = new ReservationsNurse(nurseMainPanel.Panel); AnalysisNurse nurseAnalysisPanel = new AnalysisNurse(nurseMainPanel.Panel); logInPanel.initNextPanels( managerMainPanel, operatorMainPanel, doctorMainPanel, nurseMainPanel ); managerMainPanel.initNextPanels( managerUsersPanel, managerTimetablesPanel, managerServicesPanel, managerMedicamentsPanel, managerDICPanel, managerAnalyticsPanel, logInPanel ); operatorMainPanel.initNextPanels( operatorPatientsPanel, operatorPatientChartsPanel, operatorReservationsPanel, operatorTimeTablesPanel, logInPanel ); doctorMainPanel.initNextPanels( doctorTimeTablesDocPanel, doctorReservationsDocPanel, doctorPrescriptionPanel, logInPanel ); nurseMainPanel.initNextPanels( nurseSchedulePanel, logInPanel, nurseReservationsNursePanel, nurseAnalysisPanel ); // // MainForm // this.AutoScaleMode = AutoScaleMode.Font; this.Icon = ((Icon)(resources.GetObject("$this.Icon"))); this.Left = this.Top = 0; this.MaximumSize = new Size(Dimensions.VIEW_WIDTH, Dimensions.VIEW_HEIGHT); this.MinimumSize = this.MaximumSize; this.Name = "MainForm"; this.MaximizeBox = false; this.StartPosition = FormStartPosition.CenterScreen; this.Text = "E-Pacient GG"; this.ResumeLayout(false); this.PerformLayout(); this.Controls.Add(logInPanel.Panel); this.Controls.Add(managerMainPanel.Panel); this.Controls.Add(managerAnalyticsPanel.Panel); this.Controls.Add(managerDICPanel.Panel); this.Controls.Add(managerMedicamentsPanel.Panel); this.Controls.Add(managerTimetablesPanel.Panel); this.Controls.Add(managerUsersPanel.Panel); this.Controls.Add(managerServicesPanel.Panel); this.Controls.Add(operatorMainPanel.Panel); this.Controls.Add(operatorPatientsPanel.Panel); this.Controls.Add(operatorPatientChartsPanel.Panel); this.Controls.Add(operatorReservationsPanel.Panel); this.Controls.Add(operatorTimeTablesPanel.Panel); this.Controls.Add(doctorMainPanel.Panel); this.Controls.Add(doctorTimeTablesDocPanel.Panel); this.Controls.Add(doctorReservationsDocPanel.Panel); this.Controls.Add(doctorPrescriptionPanel.Panel); this.Controls.Add(nurseMainPanel.Panel); this.Controls.Add(nurseSchedulePanel.Panel); this.Controls.Add(nurseAnalysisPanel.Panel); this.Controls.Add(nurseReservationsNursePanel.Panel); }
public MedicamentViewModel() { DownloadMedicaments(); EditMedicament = new DelegateCommand(() => { editoradd = false; selectedMedicament?.BeginEdit(); var w = new MedicamentEdit(); w.DataContext = this; w.ShowDialog(); }, () => selectedMedicament != null); AddMedicament = new DelegateCommand(() => { editoradd = true; Medicament medicament = new Medicament(); SelectedMedicament = medicament; var w = new MedicamentEdit(); w.DataContext = this; w.ShowDialog(); }); SaveMedicament = new DelegateCommand(() => { if (editoradd == true) { context.Medicament.Add(selectedMedicament); context.SaveChanges(); Medicaments.Add(SelectedMedicament); } else { context.Entry(SelectedMedicament).State = EntityState.Modified; context.SaveChanges(); } }); RemoveMedicament = new DelegateCommand(() => { if (MessageBox.Show("Удалить?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { context.Entry(selectedMedicament).State = EntityState.Deleted; context.SaveChanges(); Medicaments.Remove(selectedMedicament); } else { return; } }, () => selectedMedicament != null); CanselEdit = new DelegateCommand(() => { if (editoradd == false) { if (selectedMedicament == null) { return; } SelectedMedicament.CancelEdit(); } else { return; } }); }
public async Task <Medicaments> Create(Medicaments medicaments) { await _context.Medicaments.InsertOneAsync(medicaments); return(medicaments); }