public AccueilEncadrant()
{
InitializeComponent();
lb0NomUtilisateur.Text = Utilisateur.GetNom();
}
private void button1_Click(object sender, EventArgs e)
{
MessageBox.Show(Utilisateur.GetInfos());
}
/// <summary>
/// Récupère une activité
/// </summary>
/// <param name="testActivite"></param>
/// <returns></returns>
public static Activite GetActivite(Activite testActivite)
{
{
string testDateAct = Convert.ToDateTime(testActivite.DateAct).ToString("yyyy-MM-dd");
MySqlDataReader rdrActivite;
MySqlCommand cmd = conn.CreateCommand();
string sqlActi = "SELECT a.CODEANIM, a.DATEACT, a.CODEETATACT, a.HRRDVACT, a.PRIXACT, a.HRDEBUTACT, " +
"a.HRFINACT, a.DATEANNULEACT, a.NOMRESP, a.PRENOMRESP " +
"FROM activite a, inscription i " +
"WHERE a.CODEANIM = i.CODEANIM " +
"AND a.DATEACT = i.DATEACT AND i.USER = '******'" +
"AND a.CODEETATACT != 'AN'" +
"AND i.DATEANNULE IS NULL" +
"AND a.DATEACT = '" + testDateAct + "'" +
"AND a.CODEANIM = '" + testActivite.CodeAnim + "'";
cmd.CommandText = sqlActi;
rdrActivite = cmd.ExecuteReader();
List <Activite> listeActivite = new List <Activite>();
string codeAnim;
string dateAct; // !! format DATE dans la BDD !!
string codeEtatAct;
string hrRdvAct;
Decimal prixActe; //voir comment utiliser le type Decimal (dans le programme et la BDD)
string hrDebutAct; // !! format TIME dans la BDD !!
string hrFinAct; // !! format TIME dans la BDD
string dateAnnuleAct; // !! format DATE dans la BDD !!
string nomResp;
string prenomRes;
Activite uneActivite = null;
if (rdrActivite.HasRows)
{
if (rdrActivite.Read())
{
codeAnim = (string)rdrActivite["CODEANIM"];
dateAct = Convert.ToString(rdrActivite["DATEACT"]);
codeEtatAct = (string)rdrActivite["CODEETATACT"];
hrRdvAct = Convert.ToString(rdrActivite["HRRDVACT"]);
prixActe = (Decimal)rdrActivite["PRIXACT"];
hrDebutAct = Convert.ToString(rdrActivite["HRDEBUTACT"]);
hrFinAct = Convert.ToString(rdrActivite["HRFINACT"]);
dateAnnuleAct = Convert.ToString(rdrActivite["DATEANNULEACT"]);
nomResp = (string)rdrActivite["NOMRESP"];
prenomRes = (string)rdrActivite["PRENOMRESP"];
uneActivite = new Activite(codeAnim, dateAct, codeEtatAct, hrRdvAct, prixActe,
hrDebutAct, hrFinAct, dateAnnuleAct, nomResp, prenomRes);
return(uneActivite);
}
}
rdrActivite.Close();
return(uneActivite);
}
}
