public static bool ReinscriptionActivite(Activite uneActivite)
{
if (Utilisateur.EstVacancier())
{
string dateInscript = DateTime.Now.ToString("yyyy-MM-dd");
string dateAct = Convert.ToDateTime(uneActivite.DateAct).ToString("yyyy-MM-dd");
string dateAnnul = Convert.ToDateTime(uneActivite.DateAnnuleAct).ToString("yyyy-MM-dd");
string reqUpdte;
int nbMaj;
MySqlCommand cmd = conn.CreateCommand();
reqUpdte = "UPDATE inscription SET DATEANNULE = null " +
"WHERE DATEACT = '" + dateAct + "' " +
"AND USER = '******' " +
"AND CODEANIM = '" + uneActivite.CodeAnim + "' ;";
cmd.CommandText = reqUpdte;
nbMaj = cmd.ExecuteNonQuery();
if (nbMaj == 1)
{
return(true);
}
return(false);
}
return(false);
}
public static bool InscriptionVacancier(Activite uneActivite) // TO DO INSCRIPTION NE FONCTIONNE PAS
{
if (Utilisateur.EstVacancier())
{
string dateInscript = DateTime.Now.ToString("yyyy-MM-dd");
string dateAct = Convert.ToDateTime(uneActivite.DateAct).ToString("yyyy-MM-dd");
string dateAnnul = Convert.ToDateTime(uneActivite.DateAnnuleAct).ToString("yyyy-MM-dd");
string reqI;
int nbMaj;
MySqlCommand cmd = conn.CreateCommand();
reqI = "INSERT INTO INSCRIPTION(NOINSCRIP, USER, CODEANIM, DATEACT, DATEINSCRIP, DATEANNULE) " +
" VALUES(null ," +
"'" + Utilisateur.GetPseudo() + "', '" + uneActivite.CodeAnim + "', " +
"'" + dateAct + "' ," +
" '" + dateInscript + "'" +
", null )"; //to do
cmd.CommandText = reqI;
nbMaj = cmd.ExecuteNonQuery();
if (nbMaj == 1)
{
return(true);
}
return(false);
}
return(false);
}
public static bool estCreneauValide(Activite uneActivite)
{
List <Activite> lesActivites = new List <Activite>();
DateTime dateActi = Convert.ToDateTime(uneActivite.DateAct);
string sTous = "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.DATEACT = '" + dateActi.ToString("yyyy-MM-dd") + "' " +
"AND i.USER = '******' " +
"GROUP BY a.CODEANIM";
string codeAnim;
string dateAct;
string codeEtatAct;
string hrRdvAct;
Decimal prixActe;
string hrDebutAct;
string hrFinAct;
string dateAnnuleAct;
string nomResp;
string prenomRes;
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sTous;
MySqlDataReader rdrActivite = cmd.ExecuteReader();
if (rdrActivite.HasRows)
{
while (rdrActivite.Read())
{
codeAnim = (string)rdrActivite["CODEANIM"];
dateAct = Convert.ToString(rdrActivite["DATEACT"]).Substring(0, 11); // Récupere seulement la date et vire l'heure chiante (hh:mm:ss)
codeEtatAct = (string)rdrActivite["CODEETATACT"];
hrRdvAct = Convert.ToString(rdrActivite["HRRDVACT"]).Substring(0, 5);
prixActe = (Decimal)rdrActivite["PRIXACT"];
hrDebutAct = Convert.ToString(rdrActivite["HRDEBUTACT"]).Substring(0, 5);
hrFinAct = Convert.ToString(rdrActivite["HRFINACT"]).Substring(0, 5);
dateAnnuleAct = Convert.ToString(rdrActivite["DATEANNULEACT"]);
nomResp = Convert.ToString(rdrActivite["NOMRESP"]);
prenomRes = Convert.ToString(rdrActivite["PRENOMRESP"]);
Activite testActivite = new Activite(codeAnim, dateAct, codeEtatAct, hrRdvAct, prixActe,
hrDebutAct, hrFinAct, dateAnnuleAct, nomResp, prenomRes);
lesActivites.Add(testActivite);
}
rdrActivite.Close();
}
foreach (Activite a in lesActivites)
{
}
rdrActivite.Close();
return(true);
}
public static List <Activite> GetLesActivitesInscripVacancier()
{
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";
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;
if (rdrActivite.HasRows)
{
while (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"];
Activite uneActivite = new Activite(codeAnim, dateAct, codeEtatAct, hrRdvAct, prixActe,
hrDebutAct, hrFinAct, dateAnnuleAct, nomResp, prenomRes);
listeActivite.Add(uneActivite);
}
}
rdrActivite.Close();
return(listeActivite);
}
public static int GetNoInscrip(Activite uneActivite)
{
string reqNbInscrip;
DateTime dateActi = Convert.ToDateTime(uneActivite.DateAct);
Object nbMaj;
MySqlCommand cmd = conn.CreateCommand();
reqNbInscrip = "SELECT NOINSCRIP " +
"FROM inscription I " +
"WHERE I.DATEACT = '" + dateActi.ToString("yyyy-MM-dd") + "' " +
"AND I.CODEANIM = '" + uneActivite.CodeAnim + "'" +
"AND I.USER = '******';";
cmd.CommandText = reqNbInscrip;
nbMaj = cmd.ExecuteScalar();
return(Convert.ToInt32(nbMaj));
}
public static bool VerifierInscription(Activite uneActivite)
{
string reqNbInscrip;
DateTime dateActi = Convert.ToDateTime(uneActivite.DateAct);
Object nbMaj;
MySqlCommand cmd = conn.CreateCommand();
reqNbInscrip = "SELECT COUNT(I.USER)AS NBINSCRIP " +
"FROM inscription I " +
"WHERE I.DATEACT = '" + dateActi.ToString("yyyy-MM-dd") + "' " +
"AND I.CODEANIM = '" + uneActivite.CodeAnim + "'" +
"AND I.USER = '******';";
cmd.CommandText = reqNbInscrip;
nbMaj = cmd.ExecuteScalar();
if (Convert.ToInt32(nbMaj) == 0) //si le vacancier n'est pas déjà inscrit, retourne faux, s'il est déjà inscrit
{
return(false); // retourne vrai
}
return(true);
}
