/// 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();
}
}
