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) { }