/// <summary>
        /// Ajout d'un utilisateur
        /// </summary>
        /// <param name="user">Utilisateur à ajouter</param>
        /// <returns>Vrai si tous c'est bien passé faux sinon</returns>
        public bool Add(User user)
        {
            if(user == null || mailExist(user.Email))
            {
                return false;
            }
            string query = "INSERT INTO user (first_name,last_name,gender,birth_date,email,phone,pwd,image,role) VALUES (@first_name,@last_name,@gender,@birth,@email,@phone,@pwd,@image,@role)";

            List<MySqlParameter> parms = new List<MySqlParameter>();
            parms.Add(new MySqlParameter("first_name", user.FirstName));
            parms.Add(new MySqlParameter("last_name", user.LastName));
            parms.Add(new MySqlParameter("gender", user.Gender));
            parms.Add(new MySqlParameter("birth", user.BirthDate));
            parms.Add(new MySqlParameter("email", user.Email));
            parms.Add(new MySqlParameter("phone", user.Phone));
            parms.Add(new MySqlParameter("pwd", CreateSHAHash(user.Password)));
            parms.Add(new MySqlParameter("image", user.Image));
            parms.Add(new MySqlParameter("role", user.Role));

            MySqlHelper.ExecuteNonQuery(connexion, query, parms.ToArray());

            Mail send = new Mail();
            send.SendSimpleMessage(user.Email,"Inscription","Vous êtes maintenant inscrit à dance coach");

            return true;
        }
        /// <summary>
        /// Ajoute un utilisateur à la lesson
        /// </summary>
        /// <param name="userId">Id utilisateur</param>
        /// <param name="lessonId">Id de la lesson</param>
        /// <returns>Vrai si tout c'est bien passer, fauw sinon</returns>
        public bool Book(int userId, int lessonId)
        {
            string email = null;
            UserRepository _repositoryUser = new UserRepository();
            if(_repositoryUser.GetPublic(userId).FirstName != "" && this.Get(lessonId).Title != "")
            {
                //We add the user in the lesson
                string query = "INSERT INTO booking (user_id,lesson_id) VALUES (@user,@lesson)";

                List<MySqlParameter> parms = new List<MySqlParameter>();
                parms.Add(new MySqlParameter("user", userId));
                parms.Add(new MySqlParameter("lesson", lessonId));

                MySqlHelper.ExecuteNonQuery(connexion, query, parms.ToArray());

                //We update the nb_free and nb_booked
                string queryIncrementeLesson = "UPDATE lesson SET nb_free-=1, nb_booked+=1 WHERE id=@lessonid";
                List<MySqlParameter> parmsIncre = new List<MySqlParameter>();
                parmsIncre.Add(new MySqlParameter("lessonid", lessonId));

                MySqlHelper.ExecuteNonQuery(connexion, queryIncrementeLesson, parmsIncre.ToArray());

                string queryUserForEmail = "SELECT email FROM user WHERE id ="+userId;

                using (MySqlDataReader reader = MySqlHelper.ExecuteReader(connexion, queryUserForEmail))
                {
                    // Check if the reader returned any rows
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            email = reader.GetString(0);
                        }
                    }
                }

                Mail send = new Mail();
                send.SendSimpleMessage(email, "Inscription à une leçon", "Vous êtes maintenant inscrit à une leçon");
                return true;
            }
            return false;
        }