static void Main(string[] args)
{
TableAnniversaire ta = new TableAnniversaire();
/*int comptage = ta.CompteOccurences();
* Console.WriteLine(comptage);
* Console.WriteLine("quelle annee ?");
* int annee = Convert.ToInt32(Console.ReadLine());
* int comptageAnnee = ta.CompteOccurences(annee);
* Console.WriteLine("il y a {0} anniversaire cette annee",comptageAnnee);
* Console.WriteLine("donner les trois premiere lettre du nom : ");
* string lettreNom = Convert.ToString(Console.ReadLine());
* List<Anniversaire> anniv = new List<Anniversaire>(ta.leNomPatronymeCommencePar(lettreNom));
*
* foreach (Anniversaire s in anniv)
* {
*
* Console.WriteLine(s.ToString());
*
* }
* Console.WriteLine("donner un jour : ");
* int jour = Convert.ToInt32(Console.ReadLine());
* Console.WriteLine("donner un mois : ");
* int mois = Convert.ToInt32(Console.ReadLine());
* List<Anniversaire> anniv2 = new List<Anniversaire>(ta.QuiEstNeCeJour(jour, mois));
* foreach (Anniversaire s in anniv2)
* {
* Console.WriteLine(s.ToString());
* }
*
* Console.WriteLine("donner un age : ");
* int age = Convert.ToInt32(Console.ReadLine());
* List<Anniversaire> anniv3 = new List<Anniversaire>(ta.PLusAgesQue(age));
* foreach (Anniversaire s in anniv3)
* {
* Console.WriteLine(s.ToString());
* }*/
Console.WriteLine("date Anniversaire : ");
DateTime dateAnniversaire = Convert.ToDateTime(Console.ReadLine());
Console.WriteLine("Prenom : ");
string Prenom = Convert.ToString(Console.ReadLine());
Console.WriteLine("nom : ");
string nom = Convert.ToString(Console.ReadLine());
Console.WriteLine("prenom pseudonyme : ");
string PrenomPseudonyme = Convert.ToString(Console.ReadLine());
Console.WriteLine("nom pseudonyme: ");
string nomPseudonyme = Convert.ToString(Console.ReadLine());
Anniversaire annivFinal = new Anniversaire(dateAnniversaire, Prenom, nom, PrenomPseudonyme, nomPseudonyme);
Console.ReadLine();
}
public int Insert(Anniversaire nouvelAnniversaire)
{
this.cnx.Open();
MySqlCommand cmdSql = new MySqlCommand("Insert into Anniversaire (dateAnniversaire,nomPseudonyme, prenomPseudonyme, nom ,prenom) values (@date , @nompseudo ,@prenompseudo , @nom , @prenom)", this.cnx);
cmdSql.Parameters.Add(new MySqlParameter("@date", MySqlDbType.DateTime));
cmdSql.Parameters.Add(new MySqlParameter("@nompseudo", MySqlDbType.String));
cmdSql.Parameters.Add(new MySqlParameter("@prenompseudo", MySqlDbType.String));
cmdSql.Parameters.Add(new MySqlParameter("@nom", MySqlDbType.String));
cmdSql.Parameters.Add(new MySqlParameter("@prenom", MySqlDbType.String));
MySqlDataReader reader = cmdSql.ExecuteNonQuery();
{
this.cnx.Close();
return(0);
}
}
public List <Anniversaire> PLusAgesQue(int age)
{
List <Anniversaire> annivList = new List <Anniversaire>();
age = DateTime.Now.Year - age;
this.cnx.Open();
MySqlCommand cmdSql = new MySqlCommand("Select Year(dateAnniversaire),Month(dateAnniversaire),Day(dateAnniversaire), id , prenomPseudonyme, nomPseudonyme ,prenom, nom from anniversaire where Year(dateAnniversaire) < @age", this.cnx);
cmdSql.Parameters.Add(new MySqlParameter("@age", MySqlDbType.Int32));
cmdSql.Parameters["@age"].Value = age;
MySqlDataReader reader = cmdSql.ExecuteReader();
while (reader.Read())
{
DateTime dateAnniv = new DateTime(Convert.ToInt32(reader.GetValue(0)), Convert.ToInt32(reader.GetValue(1)), Convert.ToInt32(reader.GetValue(2)));
Anniversaire anniv = new Anniversaire(Convert.ToInt32(reader.GetValue(3)), dateAnniv, Convert.ToString(reader.GetValue(4)), Convert.ToString(reader.GetValue(5)), Convert.ToString(reader.GetValue(6)), Convert.ToString(reader.GetValue(7)));
annivList.Add(anniv);
}
this.cnx.Close();
return(annivList);
}
public List <Anniversaire> leNomPatronymeCommencePar(string debutNom)
{
List <Anniversaire> annivList = new List <Anniversaire>();
this.cnx.Open();
MySqlCommand cmdSql = new MySqlCommand("Select Year(dateAnniversaire),Month(dateAnniversaire),Day(dateAnniversaire), id , prenomPseudonyme, nomPseudonyme ,prenom, nom from anniversaire where nom like @lettreNom", this.cnx);
cmdSql.Parameters.Add(new MySqlParameter("@lettreNom", MySqlDbType.String));
cmdSql.Parameters["@lettreNom"].Value = debutNom + "%";
MySqlDataReader reader = cmdSql.ExecuteReader();
while (reader.Read())
{
DateTime dateAnniv = new DateTime(Convert.ToInt32(reader.GetValue(0)), Convert.ToInt32(reader.GetValue(1)), Convert.ToInt32(reader.GetValue(2)));
Anniversaire anniv = new Anniversaire(Convert.ToInt32(reader.GetValue(3)), dateAnniv, Convert.ToString(reader.GetValue(4)), Convert.ToString(reader.GetValue(5)), Convert.ToString(reader.GetValue(6)), Convert.ToString(reader.GetValue(7)));
annivList.Add(anniv);
}
this.cnx.Close();
return(annivList);
}
public List <Anniversaire> QuiEstNeCeJour(int jour, int mois)
{
List <Anniversaire> annivList = new List <Anniversaire>();
this.cnx.Open();
MySqlCommand cmdSql = new MySqlCommand("Select Year(dateAnniversaire),Month(dateAnniversaire),Day(dateAnniversaire), id , prenomPseudonyme, nomPseudonyme ,prenom, nom from anniversaire where Day(dateAnniversaire) = @Intjour and Month(dateAnniversaire) = @Intmois", this.cnx);
cmdSql.Parameters.Add(new MySqlParameter("@Intjour", MySqlDbType.Int32));
cmdSql.Parameters["@Intjour"].Value = jour;
cmdSql.Parameters.Add(new MySqlParameter("@Intmois", MySqlDbType.Int32));
cmdSql.Parameters["@Intmois"].Value = mois;
MySqlDataReader reader = cmdSql.ExecuteReader();
while (reader.Read())
{
DateTime dateAnniv = new DateTime(Convert.ToInt32(reader.GetValue(0)), Convert.ToInt32(reader.GetValue(1)), Convert.ToInt32(reader.GetValue(2)));
Anniversaire anniv = new Anniversaire(Convert.ToInt32(reader.GetValue(3)), dateAnniv, Convert.ToString(reader.GetValue(4)), Convert.ToString(reader.GetValue(5)), Convert.ToString(reader.GetValue(6)), Convert.ToString(reader.GetValue(7)));
annivList.Add(anniv);
}
this.cnx.Close();
return(annivList);
}
public void Update(Anniversaire unAnniversaire)
{
}
