/// connexion Posseder public static void ChargerNumero() { string requete = "SELECT * FROM posseder"; MySqlCommand commande = new MySqlCommand(requete, GetConnexion()); MySqlDataReader dataReader = commande.ExecuteReader(); while (dataReader.Read()) { int id_contact = dataReader.GetInt32("ID_contact"); int id_type_numero = dataReader.GetInt32("ID_type_numero"); string numero = dataReader.GetString("numero"); Contact contact = Program.retournerContactParID(id_contact); Posseder posseder = new Posseder(contact, (EnumTypeNumero)id_type_numero, numero); contact.ListPosseder.Add(posseder); } dataReader.Close(); }
private void BtnInserePosseder_Click(object sender, EventArgs e) { if (txtCoef.Text != "" && txtDiplome.Text != "") { var coefConvert = Convert.ToDouble(txtCoef.Text); Posseder checkP = new Posseder() { codeSPE = speSelectione.codeSPE, idPRT = praSelectione.idPRA, coefPOS = coefConvert, diplomePOS = txtDiplome.Text, libelleSPE = speSelectione.libelleSPE }; var t = allPosseders.Find(x => x.idPRT == praSelectione.idPRA); var check = ""; if (t != null) { check = allPosseders.Find(x => x.idPRT == praSelectione.idPRA).codeSPE; } if (check == speSelectione.codeSPE) { Toast.MakeText(this, "Praticien " + praSelectione.prenomPRA + " " + praSelectione.nomPRA + " a deja cette specialite", ToastLength.Short).Show(); } else { Uri url = new Uri("http://" + GetString(Resource.String.ip) + "insertPosseder.php?codeSPE=" + speSelectione.codeSPE + "&codePRA=" + praSelectione.idPRA + "&coef=" + txtCoef.Text + "&diplome=" + txtDiplome.Text); ws.DownloadStringAsync(url); Intent intent = new Intent(this, typeof(SpecialiteDePraticien)); StartActivity(intent); ws.DownloadDataCompleted += Ws_DownloadDataCompleted; } } else { Toast.MakeText(this, "Veuillez saisir les données", ToastLength.Short).Show(); } }