private void btn_save_Click(object sender, EventArgs e)
        {
            Diagnostique diag = new Diagnostique();

            diag.Id_doc      = Medecin.Id_doc;
            diag.Description = Description_text.Text;
            diag.Date_diag   = DateTimePicker1.Value;
            diag.Id_patient  = int.Parse(Patient_combobox.SelectedValue.ToString());
            DiagnostiqueController.AddDiag(diag);
            OperationDone_Form op = new OperationDone_Form();

            op.ShowDialog();
        }
        public static void AddDiag(Diagnostique diag)
        {
            using (var connection = new SqlConnection(ConnectionString))
            {
                if (connection.State != ConnectionState.Closed)
                {
                    connection.Open();
                }

                connection.Execute("AddDiagnostic", new { Description = diag.Description, Date_diag = diag.Date_diag, Id_patient = diag.Id_patient, Id_doc = diag.Id_doc }, commandType: CommandType.StoredProcedure);

                connection.Close();
            }
        }