Beispiel #1
0
 public void SetDiscount(PriceRate discount)
 {
     if (_order.buyVehicle == null)
     {
         throw new ArgumentNullException("Can't apply discount to null vehicle");
     }
     _order.buyVehicle.Price *= ((int)discount * 0.01);
 }
Beispiel #2
0
        //change le prix réel en fonction de la pièce sélectionnée dans ajoutReprésentation
        private void cbModifPiece_TextChanged(object sender, EventArgs e)
        {
            //on affiche le prix
            TheaterPiece maPiece = ModulePiecesTheatre.GetOneTheaterPiece(cbModifPiece.Text);

            if (maPiece != null)
            {
                lblPrixFixeModifRep.Text = maPiece.TheaterPiece_seatsPrice.ToString() + " €";
                //on récupère date saisie et heure à mettre en datetime
                string   mesdates = dateTimePickerModifDate.Text.ToString() + " " + textBoxModifHeure.Text.ToString();
                DateTime parsedDate;
                bool     retConv = DateTime.TryParse(mesdates, out parsedDate);
                if (retConv == true && dateTimePickerModifDate.Text.Trim() != "" && textBoxModifHeure.Text.Trim() != "")
                {
                    //on vérifie l'heure pour voir dans quelle tranche de pricerate on va
                    List <PriceRate> Lestaux = new List <PriceRate>();
                    Lestaux = ModuleRepresentations.GetPriceRate();
                    List <PriceRate> LestauxdansLHeure = new List <PriceRate>();
                    PriceRate        monTaux           = null;
                    foreach (PriceRate unTaux in Lestaux)
                    {
                        TimeSpan debutHeure = unTaux.PriceRate_startTime;
                        TimeSpan finHeure   = unTaux.PriceRate_endTime;
                        TimeSpan monHeure   = TimeSpan.Parse(textBoxModifHeure.Text.ToString());
                        if (debutHeure <= monHeure && monHeure <= finHeure)
                        {
                            LestauxdansLHeure.Add(unTaux);
                        }
                    }
                    //on vérifie le jour et on a le pricerate !!!!
                    string monJour = parsedDate.ToString("dddd");

                    foreach (PriceRate unTaux in LestauxdansLHeure)
                    {
                        foreach (WeekDays unJour in unTaux.PriceRate_weekDays)
                        {
                            if (unJour.WeekDays_name == monJour)
                            {
                                monTaux = unTaux;
                            }
                        }
                    }
                    if (monTaux != null)
                    {
                        float seatPrice = maPiece.TheaterPiece_seatsPrice;
                        float prixReel  = seatPrice + (seatPrice * monTaux.PriceRate_rate);
                        lblPrixReelModifRep.Text = prixReel.ToString() + " €";
                    }
                }
            }
        }
Beispiel #3
0
        public string CreateSale(PriceRate discount)
        {
            if (_vehicle == null || _compatibleAddons == null || _selectedAddons == null)
            {
                return("Missing key sales details");
            }

            OrderBuilder oBuild = new OrderBuilder();

            oBuild.Add(_vehicle, VehicleType.New);
            oBuild.Add(_tradeIn, VehicleType.Trade);
            oBuild.SetDiscount(discount);
            oBuild.Add(_selectedAddons, _compatibleAddons);
            Order orders = oBuild.Prepare();

            InvoiceBuilder iBuild = new InvoiceBuilder();

            iBuild.Staff = _saleRep;
            iBuild.Order = orders;
            _sInvoice    = iBuild.Prepare() as Sale;

            return(_manager["Invoice"].Add(_sInvoice));
        }
        //GetPriceRateWeeksDays renvoie la liste des taux en fonction de la semaine
        public static List <PriceRate> GetPriceRateWeeksDays()
        {
            List <PriceRate> lesTaux         = new List <PriceRate>();
            List <WeekDays>  lesJoursSemaine = new List <WeekDays>();
            SqlConnection    maConnexion     = ConnexionBD.GetConnexionBD().GetSqlConnexion();

            //récupération de la liste des semaines
            SqlCommand cmd2 = new SqlCommand();

            cmd2.Connection  = maConnexion;
            cmd2.CommandText = "SELECT * FROM Week_days";
            SqlDataReader monReader2 = cmd2.ExecuteReader();
            int           idJour;
            string        nomJour;
            WeekDays      leJour = null;

            // Remplissage de la liste
            while (monReader2.Read())
            {
                idJour  = Int32.Parse(monReader2["weekDays_id"].ToString());
                nomJour = monReader2["weekDays_name"].ToString();

                leJour = new WeekDays(idJour, nomJour);

                lesJoursSemaine.Add(leJour);
            }
            monReader2.Close();

            //récupération de la liste des priceRate en fonction du jour de la semaine
            SqlCommand cmd = new SqlCommand();

            cmd.Connection = maConnexion;
            int       idTaux;
            string    nomTaux;
            TimeSpan  debutHeure;
            TimeSpan  finHeure;
            float     tauxApplique;
            PriceRate leTaux;


            cmd.CommandText = "SELECT * from Price_rate";

            SqlCommand cmdConcern = new SqlCommand();

            cmdConcern.Connection  = maConnexion;
            cmdConcern.CommandText = "SELECT * FROM To_concern";

            SqlDataReader monReader = cmd.ExecuteReader();

            while (monReader.Read())
            {
                List <WeekDays> lesJoursTaux = new List <WeekDays>();
                idTaux       = Int32.Parse(monReader["priceRate_id"].ToString());
                nomTaux      = monReader["priceRate_name"].ToString();
                debutHeure   = (TimeSpan)monReader["priceRate_startTime"];
                finHeure     = (TimeSpan)monReader["priceRate_endTime"];
                tauxApplique = float.Parse(monReader["priceRate_rate"].ToString());

                SqlDataReader readerConcern = cmdConcern.ExecuteReader();
                while (readerConcern.Read())
                {
                    int idConcernTaux = Int32.Parse(readerConcern["toConcern_priceRate"].ToString());

                    if (idTaux == idConcernTaux)
                    {
                        int idConcernJour = Int32.Parse(readerConcern["toConcern_weekDays"].ToString());

                        bool trouve = false;
                        int  ind    = 0;

                        while (trouve == false && ind < lesJoursSemaine.Count)
                        {
                            if (lesJoursSemaine[ind].WeekDays_id == idConcernJour)
                            {
                                lesJoursTaux.Add(lesJoursSemaine[ind]);
                                trouve = true;
                            }
                            else
                            {
                                ind++;
                            }
                        }
                    }
                }
                readerConcern.Close();

                leTaux = new PriceRate(idTaux, nomTaux, debutHeure, finHeure, tauxApplique, lesJoursTaux);
                lesTaux.Add(leTaux);
            }
            monReader.Close();
            // Fermeture de la connexion
            maConnexion.Close();
            return(lesTaux);
        }
        // Renvoie la liste des représentations correspondant à la pièce de théatres ayant lieu durant une période passée en paramètres
        public static List <Show> GetFilterShows(int idTheaterPiece, DateTime dateDebutChoisie, DateTime dateFinChoisie)
        {
            //variables
            int          idShow;
            DateTime     uneDateHeure; //besoin de date et heure
            int          nbPlaces;
            int          idTaux;
            int          idPiece;
            TheaterPiece laPiece = null; //besoin de nomPiece, durée
            PriceRate    letaux  = null; //calcul du prix pour date, heure, semaine
            Show         uneRepresentation;
            // Récupération de la liste des pièces de théâtre
            List <TheaterPiece> lesPiecesDeTheatre = PiecesTheatreDAO.GetTheaterPieces();
            // Récupération de la liste des taux
            List <PriceRate> lesTaux = GetPriceRateWeeksDays();
            // Connexion à la BD
            SqlConnection maConnexion = ConnexionBD.GetConnexionBD().GetSqlConnexion();
            // Création d'une liste vide d'objets lesRepresentations
            List <Show> lesRepresentations = new List <Show>();

            SqlCommand cmd = new SqlCommand();

            cmd.Connection = maConnexion;
            //paramètres

            SqlParameter paramIdPiece = new SqlParameter("@idPiece", SqlDbType.Int);

            paramIdPiece.Value = idTheaterPiece;
            SqlParameter paramDateDeb = new SqlParameter("@dateDeb", SqlDbType.VarChar);
            string       date1;

            date1 = dateDebutChoisie.ToString("yyyy/MM/dd");
            paramDateDeb.Value = date1;
            SqlParameter paramDateFin = new SqlParameter("@dateFin", SqlDbType.VarChar);
            string       date2;

            date2 = dateFinChoisie.ToString("yyyy/MM/dd");
            paramDateFin.Value = date2;
            //requête
            cmd.CommandText = "SELECT show_id,show_dateTime, show_seats, show_priceRate, show_theaterPiece FROM Show, Theater_piece WHERE show_theaterPiece = theaterPiece_id AND theaterPiece_id = @idPiece AND CAST(show_dateTime as DATE) BETWEEN @dateDeb AND @dateFin";
            //ajout params
            cmd.Parameters.Add(paramIdPiece);
            cmd.Parameters.Add(paramDateDeb);
            cmd.Parameters.Add(paramDateFin);


            SqlDataReader monReader = cmd.ExecuteReader();

            // Remplissage de la liste
            while (monReader.Read())
            {
                idShow       = Int32.Parse(monReader["show_id"].ToString());
                uneDateHeure = (DateTime)monReader["show_dateTime"];
                nbPlaces     = Int32.Parse(monReader["show_seats"].ToString());
                idTaux       = Int32.Parse(monReader["show_priceRate"].ToString());
                idPiece      = Int32.Parse(monReader["show_theaterPiece"].ToString());
                bool trouve = false;
                int  i      = 0;
                while (trouve == false && i < lesPiecesDeTheatre.Count)
                {
                    if (lesPiecesDeTheatre[i].TheaterPiece_id == idPiece)
                    {
                        // Si on l'a, on l'ajoute
                        laPiece = lesPiecesDeTheatre[i];
                        trouve  = true;
                    }
                    else
                    {
                        i++;
                    }
                }
                // On trouve dans la liste des pièces de théâtres celle correspondant à l'id
                bool trouve2 = false;
                int  i2      = 0;
                while (trouve2 == false && i2 < lesTaux.Count)
                {
                    if (lesTaux[i2].PriceRate_id == idTaux)
                    {
                        // Si on l'a, on l'ajoute
                        letaux  = lesTaux[i2];
                        trouve2 = true;
                    }
                    else
                    {
                        i2++;
                    }
                }
                uneRepresentation = new Show(idShow, uneDateHeure, nbPlaces, letaux, laPiece);
                lesRepresentations.Add(uneRepresentation);
            }
            monReader.Close();
            // Fermeture de la connexion
            maConnexion.Close();
            return(lesRepresentations);
        }
        // Renvoie la liste des représentations
        // Utilise la DAO PiecesTheatres pour avoir la liste des pièces
        // besoin du taux (et donc des jours)
        public static List <Show> GetShows()
        {
            //variables
            int          idShow            = 0;
            DateTime     uneDateHeure      = new DateTime(2018, 01, 01, 00, 00, 00); //besoin de date et heure
            int          nbPlaces          = 0;
            TheaterPiece laPiece           = null;                                   //besoin de nomPiece, durée
            PriceRate    letaux            = null;                                   //calcul du prix pour date, heure, semaine
            Show         uneRepresentation = null;


            // Création d'une liste vide d'objets lesRepresentations
            List <Show> lesRepresentations = new List <Show>();

            // Récupération de la liste des pièces de théâtre
            List <TheaterPiece> lesPiecesDeTheatre = PiecesTheatreDAO.GetTheaterPieces();

            // Récupération de la liste des taux
            List <PriceRate> lesTaux = GetPriceRateWeeksDays();

            // Connexion à la BD
            SqlConnection maConnexion = ConnexionBD.GetConnexionBD().GetSqlConnexion();

            SqlCommand cmd = new SqlCommand();

            cmd.Connection  = maConnexion;
            cmd.CommandText = "SELECT * FROM Show";


            SqlDataReader monReader = cmd.ExecuteReader();

            // Remplissage de la liste
            while (monReader.Read())
            {
                idShow       = Int32.Parse(monReader["show_id"].ToString());
                uneDateHeure = (DateTime)monReader["show_dateTime"];
                nbPlaces     = Int32.Parse(monReader["show_seats"].ToString());
                int idDutaux = Convert.ToInt32(monReader["show_priceRate"].ToString());
                int idPiece  = Convert.ToInt32(monReader["show_theaterPiece"].ToString());

                // On trouve dans la liste des pièces de théâtres celle correspondant à l'id
                bool trouve = false;
                int  i      = 0;
                while (trouve == false && i < lesPiecesDeTheatre.Count)
                {
                    if (lesPiecesDeTheatre[i].TheaterPiece_id == idPiece)
                    {
                        // Si on l'a, on l'ajoute
                        laPiece = lesPiecesDeTheatre[i];
                        trouve  = true;
                    }
                    else
                    {
                        i++;
                    }
                }
                bool trouve2 = false;
                int  i2      = 0;
                while (trouve2 == false && i2 < lesTaux.Count)
                {
                    if (lesTaux[i2].PriceRate_id == idDutaux)
                    {
                        // Si on l'a, on l'ajoute
                        letaux  = lesTaux[i2];
                        trouve2 = true;
                    }
                    else
                    {
                        i2++;
                    }
                }
                uneRepresentation = new Show(idShow, uneDateHeure, nbPlaces, letaux, laPiece);
                lesRepresentations.Add(uneRepresentation);
            }

            monReader.Close();

            // Fermeture de la connexion
            maConnexion.Close();
            return(lesRepresentations);
        }
Beispiel #7
0
        protected override void Seed(waHaylliCore.DataModel.ApplicationDbContext context)
        {
            //  This method will be called after migrating to the latest version.

            //  You can use the DbSet<T>.AddOrUpdate() helper extension method
            //  to avoid creating duplicate seed data.



            Currency currency1 = new Currency {
                currencyId = 1, shortName = "PEN", largeName = "NUevo Sol", country = "Peru"
            };
            Currency currency2 = new Currency {
                currencyId = 2, shortName = "USA", largeName = "American Dollar", country = "United States"
            };
            Currency currency3 = new Currency {
                currencyId = 3, shortName = "EUR", largeName = "Euro", country = "Europa"
            };
            Currency currency4 = new Currency {
                currencyId = 4, shortName = "CNY", largeName = "Yuanes", country = "China"
            };
            Currency currency5 = new Currency {
                currencyId = 5, shortName = "CAD", largeName = "Canadian Dollar", country = "Canada"
            };

            var currencies = new List <Currency>();

            currencies.Add(currency1);
            currencies.Add(currency2);
            currencies.Add(currency3);
            currencies.Add(currency4);
            currencies.Add(currency5);

            currencies.ForEach(s => context.currencies.AddOrUpdate(p => p.currencyId, s));

            City city1 = new City {
                cityId = 1, name = "Cusco"
            };
            City city2 = new City {
                cityId = 2, name = "Urubamba"
            };
            City city3 = new City {
                cityId = 3, name = "Lima"
            };

            var cities = new List <City>();

            cities.Add(city1);
            cities.Add(city2);
            cities.Add(city3);

            cities.ForEach(s => context.cities.AddOrUpdate(p => p.cityId, s));

            Rate rate1 = new Rate {
                rateId = 1, nameRate = "Regular day"
            };
            Rate rate2 = new Rate {
                rateId = 2, nameRate = "Holidays"
            };

            var rates = new List <Rate>();

            rates.Add(rate1);
            rates.Add(rate2);

            rates.ForEach(s => context.rates.AddOrUpdate(p => p.rateId, s));

            ServiceType serviceType1 = new ServiceType {
                serviceTypeId = 1, titleServiceType = "Tour Guide", descriptionServiceType = "Tour Guide English - Spanish"
            };
            ServiceType serviceType2 = new ServiceType {
                serviceTypeId = 2, titleServiceType = "Restaurant", descriptionServiceType = "Assintant Guide Trainee"
            };
            ServiceType serviceType3 = new ServiceType {
                serviceTypeId = 3, titleServiceType = "Land Transport", descriptionServiceType = "Land Transport"
            };

            var serviceTypes = new List <ServiceType>();

            serviceTypes.Add(serviceType1);
            serviceTypes.Add(serviceType2);
            serviceTypes.Add(serviceType3);

            serviceTypes.ForEach(s => context.serviceTypes.AddOrUpdate(p => p.serviceTypeId, s));

            Service service1 = new Service {
                serviceId = 1, titleService = "Guia Bilingue", descriptionService = "Guia bilingue", serviceType = serviceType1, city = city1
            };
            Service service2 = new Service {
                serviceId = 2, titleService = "Assintant Guia", descriptionService = "Assintant Guia", serviceType = serviceType1, city = city1
            };
            Service service3 = new Service {
                serviceId = 3, titleService = "Transporte Compartido", descriptionService = "Transporte Compartido", serviceType = serviceType3, city = city1
            };

            var services = new List <Service>();

            services.Add(service1);
            services.Add(service2);
            services.Add(service3);

            services.ForEach(s => context.services.AddOrUpdate(p => p.serviceId, s));

            Price price1 = new Price {
                priceId = 1, registration = Convert.ToDateTime("9/2/2018"), expiration = Convert.ToDateTime("9/2/2019"), totalPax = 1, service = service3
            };
            Price price2 = new Price {
                priceId = 2, registration = Convert.ToDateTime("9/2/2018"), expiration = Convert.ToDateTime("9/2/2019"), totalPax = 4, service = service3
            };
            Price price3 = new Price {
                priceId = 3, registration = Convert.ToDateTime("9/2/2018"), expiration = Convert.ToDateTime("9/2/2019"), totalPax = 8, service = service3
            };
            Price price4 = new Price {
                priceId = 4, registration = Convert.ToDateTime("9/2/2018"), expiration = Convert.ToDateTime("9/2/2019"), totalPax = 14, service = service3
            };
            Price price5 = new Price {
                priceId = 5, registration = Convert.ToDateTime("9/2/2018"), expiration = Convert.ToDateTime("9/2/2019"), totalPax = 32, service = service3
            };

            Price price6 = new Price {
                priceId = 6, registration = Convert.ToDateTime("9/2/2018"), expiration = Convert.ToDateTime("9/2/2019"), totalPax = 1, service = service1
            };
            Price price7 = new Price {
                priceId = 7, registration = Convert.ToDateTime("9/2/2018"), expiration = Convert.ToDateTime("9/2/2019"), totalPax = 4, service = service1
            };
            Price price8 = new Price {
                priceId = 8, registration = Convert.ToDateTime("9/2/2018"), expiration = Convert.ToDateTime("9/2/2019"), totalPax = 8, service = service1
            };
            Price price9 = new Price {
                priceId = 9, registration = Convert.ToDateTime("9/2/2018"), expiration = Convert.ToDateTime("9/2/2019"), totalPax = 14, service = service1
            };
            Price price10 = new Price {
                priceId = 10, registration = Convert.ToDateTime("9/2/2018"), expiration = Convert.ToDateTime("9/2/2019"), totalPax = 32, service = service1
            };

            var prices = new List <Price>();

            prices.Add(price1);
            prices.Add(price2);
            prices.Add(price3);
            prices.Add(price4);
            prices.Add(price5);
            prices.Add(price6);
            prices.Add(price7);
            prices.Add(price8);
            prices.Add(price9);
            prices.Add(price10);

            prices.ForEach(s => context.prices.AddOrUpdate(p => p.priceId, s));

            PriceRate priceRate1 = new PriceRate {
                priceRateId = 1, rate = rate1, price = price1, value = Convert.ToDecimal(0.00), currency = currency2
            };
            PriceRate priceRate2 = new PriceRate {
                priceRateId = 2, rate = rate1, price = price1, value = Convert.ToDecimal(0.00), currency = currency1
            };
            PriceRate priceRate3 = new PriceRate {
                priceRateId = 3, rate = rate1, price = price2, value = Convert.ToDecimal(39.00), currency = currency2
            };
            PriceRate priceRate4 = new PriceRate {
                priceRateId = 4, rate = rate1, price = price2, value = Convert.ToDecimal(129.09), currency = currency1
            };
            PriceRate priceRate5 = new PriceRate {
                priceRateId = 5, rate = rate1, price = price3, value = Convert.ToDecimal(43.00), currency = currency2
            };
            PriceRate priceRate6 = new PriceRate {
                priceRateId = 6, rate = rate1, price = price3, value = Convert.ToDecimal(142.33), currency = currency1
            };
            PriceRate priceRate7 = new PriceRate {
                priceRateId = 7, rate = rate1, price = price4, value = Convert.ToDecimal(52.00), currency = currency2
            };
            PriceRate priceRate8 = new PriceRate {
                priceRateId = 8, rate = rate1, price = price4, value = Convert.ToDecimal(172.12), currency = currency1
            };
            PriceRate priceRate9 = new PriceRate {
                priceRateId = 9, rate = rate1, price = price5, value = Convert.ToDecimal(90.00), currency = currency2
            };
            PriceRate priceRate10 = new PriceRate {
                priceRateId = 10, rate = rate1, price = price5, value = Convert.ToDecimal(297.90), currency = currency1
            };

            PriceRate priceRate11 = new PriceRate {
                priceRateId = 11, rate = rate1, price = price6, value = Convert.ToDecimal(0.00), currency = currency2
            };
            PriceRate priceRate12 = new PriceRate {
                priceRateId = 12, rate = rate1, price = price6, value = Convert.ToDecimal(0.00), currency = currency1
            };
            PriceRate priceRate13 = new PriceRate {
                priceRateId = 13, rate = rate1, price = price7, value = Convert.ToDecimal(40.00), currency = currency2
            };
            PriceRate priceRate14 = new PriceRate {
                priceRateId = 14, rate = rate1, price = price7, value = Convert.ToDecimal(132.40), currency = currency1
            };
            PriceRate priceRate15 = new PriceRate {
                priceRateId = 15, rate = rate1, price = price8, value = Convert.ToDecimal(40.00), currency = currency2
            };
            PriceRate priceRate16 = new PriceRate {
                priceRateId = 16, rate = rate1, price = price8, value = Convert.ToDecimal(132.40), currency = currency1
            };
            PriceRate priceRate17 = new PriceRate {
                priceRateId = 17, rate = rate1, price = price9, value = Convert.ToDecimal(40.00), currency = currency2
            };
            PriceRate priceRate18 = new PriceRate {
                priceRateId = 18, rate = rate1, price = price9, value = Convert.ToDecimal(132.40), currency = currency1
            };
            PriceRate priceRate19 = new PriceRate {
                priceRateId = 19, rate = rate1, price = price10, value = Convert.ToDecimal(40.00), currency = currency2
            };
            PriceRate priceRate20 = new PriceRate {
                priceRateId = 20, rate = rate1, price = price10, value = Convert.ToDecimal(132.40), currency = currency1
            };


            var priceRates = new List <PriceRate>();

            priceRates.Add(priceRate1);
            priceRates.Add(priceRate2);
            priceRates.Add(priceRate3);
            priceRates.Add(priceRate4);
            priceRates.Add(priceRate5);
            priceRates.Add(priceRate6);
            priceRates.Add(priceRate7);
            priceRates.Add(priceRate8);
            priceRates.Add(priceRate9);
            priceRates.Add(priceRate10);
            priceRates.Add(priceRate11);
            priceRates.Add(priceRate12);
            priceRates.Add(priceRate13);
            priceRates.Add(priceRate14);
            priceRates.Add(priceRate15);
            priceRates.Add(priceRate16);
            priceRates.Add(priceRate17);
            priceRates.Add(priceRate18);
            priceRates.Add(priceRate19);
            priceRates.Add(priceRate20);

            priceRates.ForEach(s => context.priceRates.AddOrUpdate(p => p.priceRateId, s));

            context.SaveChanges();
        }
Beispiel #8
0
        //bouton valider
        private void button5_Click(object sender, EventArgs e)
        {
            if (dateTimePickerModifDate.Text.Trim() != "" && textBoxModifHeure.Text.Trim() != "" && textBoxModifPlaces.Text.Trim() != "" && cbModifPiece.Text.Trim() != "")
            {
                //on récupère date saisie et heure à mettre en datetime
                string   mesdates   = dateTimePickerModifDate.Text.ToString() + " " + textBoxModifHeure.Text.ToString();
                DateTime parsedDate = DateTime.Parse(mesdates);
                //on vérifie l'heure pour voir dans quelle tranche de pricerate on va
                List <PriceRate> Lestaux = new List <PriceRate>();
                Lestaux = ModuleRepresentations.GetPriceRate();
                List <PriceRate> LestauxdansLHeure = new List <PriceRate>();
                PriceRate        monTaux           = null;
                foreach (PriceRate unTaux in Lestaux)
                {
                    TimeSpan debutHeure = unTaux.PriceRate_startTime;
                    TimeSpan finHeure   = unTaux.PriceRate_endTime;
                    TimeSpan monHeure   = TimeSpan.Parse(textBoxModifHeure.Text.ToString());
                    if (debutHeure <= monHeure && monHeure <= finHeure)
                    {
                        LestauxdansLHeure.Add(unTaux);
                    }
                }
                //on vérifie le jour et on a le pricerate !!!!
                int monJour = (int)parsedDate.DayOfWeek;
                if (monJour == 0)
                {
                    monJour = 7;
                }
                foreach (PriceRate unTaux in LestauxdansLHeure)
                {
                    foreach (WeekDays unJour in unTaux.PriceRate_weekDays)
                    {
                        if (unJour.WeekDays_id == monJour)
                        {
                            monTaux = unTaux;
                        }
                    }
                }
                //on récupère nb places
                int mesPlaces = int.Parse(textBoxModifPlaces.Text.ToString());
                //on récupère la pièce de théâtre
                TheaterPiece maPiece = ModulePiecesTheatre.GetOneTheaterPiece(cbModifPiece.Text);
                float        duree   = maPiece.TheaterPiece_duration;
                //on récupère l'id
                dgvListeRepresentations.CurrentRow.Selected = true;
                int indexRow = dgvListeRepresentations.CurrentRow.Index;
                if (dgvListeRepresentations.Rows[indexRow].Cells[0].Value != DBNull.Value)
                {
                    Show laRepres = (Show)dgvListeRepresentations.Rows[indexRow].Cells[0].Value;
                    int  idShow   = laRepres.Show_id;

                    // Création de l'objet Show
                    Show show = new Show(idShow, parsedDate, mesPlaces, monTaux, maPiece);

                    //TimeSpan madureeShowFin = TimeSpan.FromHours((double)duree) + show.Show_dateTime.TimeOfDay;
                    //récupérer les datetime de toutes représentations
                    bool        trouve             = false;
                    List <Show> lesRepresentations = ModuleRepresentations.GetShows();
                    //s'il existe déjà une représentation à la date afficher message d'erreur
                    foreach (Show uneRepresentation in lesRepresentations)
                    {
                        TimeSpan madureeFin = TimeSpan.FromHours((double)duree) + uneRepresentation.Show_dateTime.TimeOfDay;


                        if (uneRepresentation.Show_dateTime.Date == show.Show_dateTime.Date && uneRepresentation.Show_id != idShow)
                        {
                            if (uneRepresentation.Show_dateTime.TimeOfDay <= show.Show_dateTime.TimeOfDay && show.Show_dateTime.TimeOfDay < madureeFin)
                            {
                                trouve = true;
                            }
                        }
                    }
                    if (trouve == true)
                    {
                        MessageBox.Show("Vous ne pouvez pas ajouter 2 représentations au même moment.", "Modification de la représentation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                    else
                    {
                        DialogResult result1 = MessageBox.Show("Etes vous sur de vouloir modifier cette représentation ?", "Modification de la représentation", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                        if (result1 == DialogResult.Yes)
                        {
                            // Appel de la méthode ModifierUtilisateur de la couche BLL
                            ModuleRepresentations.EditShow(show);
                            MessageBox.Show("La représentation a bien été modifiée.", "Modification de la représentation", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            grbModifRepresentation.Visible = false;
                            grbDetails.Visible             = true;
                            textBoxModifHeure.Text         = "";
                            textBoxModifPlaces.Text        = "";
                            DateTime today = DateTime.Today;
                            dateTimePickerModifDate.Text = today.ToString();
                            afficherRepresentations();


                            grbFiltres.Enabled = true;
                            dgvListeRepresentations.Enabled = true;
                        }
                    }
                }
            }
        }