Beispiel #1
0
        public Form_Modifier_Echantillon(int idMedicament, int idRapport, int qte)
        {
            InitializeComponent();
            using (DataGSB bdd = new DataGSB())
            {
                // Récupération du medicament
                var requeteMedicament =
                    from med in bdd.medicaments
                    where (med.id_medicament == idMedicament)
                    select med;

                foreach (medicament med in requeteMedicament)
                {
                    _medicament = med;
                }
                // Récupération de la famille du medicament
                var requeteFamille =
                    from fam in bdd.familles
                    where (fam.id_famille == _medicament.id_famille)
                    select fam;

                foreach (famille fam in requeteFamille)
                {
                    _famille = fam;
                }
            }
            _idRapport = idRapport;
            // Remplissage des textBoxes
            tb_Famille.Text    = _famille.lib_famille;
            tb_Medicament.Text = _medicament.nom_commercial;
            tb_qte.Text        = qte.ToString();
        }
 private void cb_medicament_SelectedIndexChanged(object sender, EventArgs e)
 {
     lb_deja_enregistre.Visible = false;
     if (cb_medicament.SelectedIndex != 0)
     {
         ListBoxMedicamentItem selectedMedicament = (ListBoxMedicamentItem)cb_medicament.SelectedItem;
         _selectedMedicament = (medicament)selectedMedicament.Value;
         tb_qte.Clear();
         tb_qte.Enabled = true;
     }
     else
     {
         tb_qte.Clear();
         tb_qte.Enabled = false;
     }
 }
        private bool dejaOffert(medicament ceMedicament)
        {
            bool reponse = false;

            using (DataGSB bdd = new DataGSB())
            {
                var requete =
                    from off in bdd.offrirs
                    where (off.id_rapport == _rapport.id_rapport && off.id_medicament == ceMedicament.id_medicament)
                    select off;

                foreach (offrir off in requete)
                {
                    reponse = true;
                }
            }
            return(reponse);
        }