private void cbx_numrap_SelectedIndexChanged(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
showItem();
string praticien = "";
string dateRapport = "";
string bilan = "";
string dateVisi = "";
string motif = "";
string praticienRemp = "";
string coef = "";
CURS cs = new CURS(LoginPage.ChaineConnexion);
cs.DefFonctStockee("getRapport");
cs.ajouteparametreCol("IdVisiteur", LoginPage.Id);
cs.directionparametreCol("IdVisiteur", ParameterDirection.InputOutput);
cs.ajouteparametreCol("IdRapport", cbx_numrap.SelectedItem.ToString());
cs.directionparametreCol("IdRapport", ParameterDirection.InputOutput);
cs.ajouteparametreCol("idPraticien", praticien);
cs.directionparametreCol("idPraticien", ParameterDirection.Output);
cs.ajouteparametreCol("dateRapport", dateRapport);
cs.directionparametreCol("dateRapport", ParameterDirection.Output);
cs.ajouteparametreCol("bilan", bilan);
cs.directionparametreCol("bilan", ParameterDirection.Output);
cs.ajouteparametreCol("dateVisite", dateVisi);
cs.directionparametreCol("dateVisite", ParameterDirection.Output);
cs.ajouteparametreCol("idMotif", motif);
cs.directionparametreCol("idMotif", ParameterDirection.Output);
cs.ajouteparametreCol("idPraticienRemp", praticienRemp);
cs.directionparametreCol("idPraticienRemp", ParameterDirection.Output);
cs.ajouteparametreCol("coef", coef);
cs.directionparametreCol("coef", ParameterDirection.Output);
cs.Appelfonctstockee();
txtbox_prac.Text = getPrac(Convert.ToString(cs.getCol()[2].Value));
//string req = "SELECT * FROM `rapport_visite` WHERE `COL_MATRICULE` = '" + LoginPage.Id + "' AND RAP_NUM = '" + cbx_numrap.SelectedItem.ToString() +"';";
//cs.ReqSelect(req);
/*while (!cs.Fin())
* {*/
//txtbox_prac.Text = getPrac(cs.champ("PRA_NUM").ToString());
if (Convert.ToString(cs.getCol()[3].Value) == "")
{
chackDateRap.Checked = false;
}
else
{
chackDateRap.Checked = true;
datebox.Text = Convert.ToString(cs.getCol()[3].Value);
}
if (Convert.ToString(cs.getCol()[7].Value) == "")
{
chackPratRemp.Checked = false;
}
else
{
chackPratRemp.Checked = true;
txtbox_PraRemp.Text = getPrac(Convert.ToString(cs.getCol()[7].Value));
}
tbar_coef.Value = Int32.Parse(Convert.ToString(cs.getCol()[8].Value));
txt_coef.Text = Convert.ToString(cs.getCol()[8].Value);
dateVisite.Text = Convert.ToString(cs.getCol()[5].Value);
txtbox_motif.Text = getMotif(Convert.ToString(cs.getCol()[6].Value));
richTextBox1.Text = Convert.ToString(cs.getCol()[4].Value);
CURS cs1 = new CURS(LoginPage.ChaineConnexion);
string med = "SELECT `MED_DEPOTLEGAL`, `OFF_QTE` FROM `offrir` WHERE `COL_MATRICULE` = '" + LoginPage.Id + "' AND `RAP_NUM` = '" + cbx_numrap.SelectedItem.ToString() + "';";
cs1.ReqSelect(med);
while (!cs1.Fin())
{
CURS cs2 = new CURS(LoginPage.ChaineConnexion);
string reqmed = "SELECT `MED_NOMCOMMERCIAL` FROM `medicament` WHERE `MED_DEPOTLEGAL` = '" + cs1.champ("MED_DEPOTLEGAL") + "';";
cs2.ReqSelect(reqmed);
while (!cs2.Fin())
{
dataGridView1.Rows.Add(cs2.champ("MED_NOMCOMMERCIAL"), cs1.champ("OFF_QTE"));
cs2.suivant();
}
cs1.suivant();
}
cs1.fermer();
}