Ejemplo n.º 1
0
        public static bool CreateDonnees(string filePath, string NomVague)
        {
            var extension = Path.GetExtension(filePath);
            var stream = File.Open(filePath, FileMode.Open, FileAccess.Read);
            var excelReader = extension == ".xlsx" ? ExcelReaderFactory.CreateOpenXmlReader(stream) : ExcelReaderFactory.CreateBinaryReader(stream);
            excelReader.IsFirstRowAsColumnNames = true;
            var collectionBase = excelReader.AsDataSet().Tables[0].AsEnumerable();

            var Vide = collectionBase.Where(p => (string) p["annee"] == "2012");
            //Assert.AreEqual(extension, ".xlsx");

            var distincts = collectionBase.Select(p => p["Matricule"]).Distinct();

            foreach (var distinct in distincts)
            {
                var ind = new Individu();
                var convdistinct = int.Parse(distinct.ToString());
                
                

                var individuRepository = new IndividuRepository();
                var indivCriterion = new Criterion("IdQuest",convdistinct.ToString(),CriteriaOperator.Equal);
                var indivQuery = new Query();
                indivQuery.Add(indivCriterion);
                if (individuRepository.FindBy(indivQuery).Any())continue ;

                ind.IdQuest = int.Parse(distinct.ToString());

                ind.Sexe = (int)((collectionBase.First(d => d["Matricule"] == ind.IdQuest.ToString()))["Sexe"]);
                
            }


            return default(Boolean);
        }
Ejemplo n.º 2
0
        public void CanCreateACompaign()
        {
            var Criterion = new Criterion("Libelle", "LaMortQuiTue", CriteriaOperator.Equal);
            var Query = new Query();
            Query.Add(Criterion);
            var vague = new VagueRepository().FindBy(Query).First();

            var comp = CompaignFactory.CreateCompaign(AnnonceurFactory.CreateAnnonceur("annonceur"), TypeCompaign.CourteDuree, vague);
            Assert.IsNotNull(comp);

               // var comp2 = CompaignFactory.CreateCompaign(AnnonceurFactory.CreateAnnonceur("annonceur"), TypeCompaign.CourteDuree, vague, marque: AnnonceurFactory.CreateMarque("marque", AnnonceurFactory.CreateAnnonceur("annonceur"), TypeMarque.Lessive));
            /*Assert.IsNotNull(comp2);
            Assert.AreEqual(comp2.Annonceur.Name,"annonceur");
            Assert.AreEqual(comp2.Marque.Name, "marque");
            Assert.AreEqual(comp2.TypeCompaign, TypeCompaign.CourteDuree);
            Assert.AreEqual(comp2.Marque.Type, TypeMarque.Lessive);*/

            var comp3 = CompaignFactory.CreateCompaign(AnnonceurFactory.CreateAnnonceur("annonceur"), TypeCompaign.CourteDuree,vague);
            Assert.IsNotNull(comp3);
            Assert.AreEqual(comp3.TypeCompaign, TypeCompaign.CourteDuree);
            Assert.AreEqual(comp3.Annonceur.Name, "annonceur");
        }
Ejemplo n.º 3
0
        public void Start()
        {
            var Criterion = new Criterion("Libelle", "LaMortQuiTue", CriteriaOperator.Equal);
            var Query = new Query();
            Query.Add(Criterion);
            var vague = new VagueRepository().FindBy(Query).First();
            /*
            mock = new Mock<IRepository<Compaign, Guid>>();
            mock.Setup(e => e.FindBy(It.IsAny<Guid>())).Returns(CompaignFactory.CreateCompaign(AnnonceurFactory.CreateAnnonceur("annonceur"), TypeCompaign.CourteDuree, vague));

            mockSignalitique = new Mock<IRepository<Signalitique, Guid>>();
            mock.Setup(e => e.FindBy(It.IsAny<Guid>())).Returns(CompaignFactory.CreateCompaign(AnnonceurFactory.CreateAnnonceur("annonceur"), TypeCompaign.CourteDuree, vague));
            */
            InitDAL.Init();
               /* const string nomVague = "LaMortQuiTue";
            string ConnectionString;
            using (
                var xpoSession = new Session()
                {
                    ConnectionString =
                        @"data source=REX-PC\Entretien;integrated security=true;initial catalog=Audience;"
                })
            {
                Map.initSupport(xpoSession);
            }
            const string filePath = @"C:\Users\Administrator\Desktop\upload.xlsx";
            //var vagueFacade = new CreationVagueFacade(new CreateVagueClientProxy());
            var resultat = DonneesFactory.CreateDonnees(filePath, "LaMortQuiTue", new IndividuRepository(), new VagueRepository(), new RepositoryTvCache(), new RepositoryRadioCache(), new RepositoryPresseCache());
             */
        }
Ejemplo n.º 4
0
        public void InsertPassage()
        {
            /*   var compagne = mock.Object.FindBy(Guid.NewGuid());
            CompaignFactory.CreatePlanTv(name: "MonPlanTv", compaign: compagne);
            Assert.AreEqual(compagne.PlanTvs.Count, 1);
            Assert.AreEqual(compagne.PlanTvs.First().Name, "MonPlanTv");

            CompaignFactory.CreatePlanRadio(name: "MonPlanRadio", compaign: compagne);
            Assert.AreEqual(compagne.PlanRadios.Count, 1);
            Assert.AreEqual(compagne.PlanRadios.First().Name, "MonPlanRadio");

            CompaignFactory.CreatePlanPresse(name: "MonPlanPresse", compaign: compagne);
            Assert.AreEqual(compagne.PlanPresses.Count, 1);
            Assert.AreEqual(compagne.PlanPresses.First().Name, "MonPlanPresse");

            CompaignFactory.CreatePlanPresse(name: "MonPlanPresse2", compaign: compagne);
            Assert.AreEqual(compagne.PlanPresses.Count, 2);

            /* •————————————————————————————————————————————————————————————————————————————————————————————————•
               | string connectionString;                                                                       |
               | using (                                                                                        |
               |     var xpoSession = new Session()                                                             |
               |     {                                                                                          |
               |         ConnectionString =                                                                     |
               |             @"data source=REX-PC\Entretien;integrated security=true;initial catalog=Audience;" |
               |     })                                                                                         |
               | {                                                                                              |
               |     var liste = new XPCollection<XpoSupportTV>(xpoSession);                                    |
               | }                                                                                              |
               •————————————————————————————————————————————————————————————————————————————————————————————————• */

            var Criterion = new Criterion("Libelle", "El Watan", CriteriaOperator.Equal);
            var Query = new Query();
            Query.Add(Criterion);
            var titreDePresse=new SupportPresseRepository().FindBy(Query);

            var CriterionTv = new Criterion("Libelle", "AN Nahar TV", CriteriaOperator.Equal);
            var QueryTv = new Query();
            QueryTv.Add(CriterionTv);
            var mediaTv = new SupportTvRepository().FindBy(QueryTv);

            var CriterionRadio = new Criterion("Libelle", "Chaine 3", CriteriaOperator.Equal);
            var QueryRadio = new Query();
            QueryRadio.Add(CriterionRadio);
            var mediaRadio = new SupportRadioRepository().FindBy(QueryRadio);

            const int numQuart = 2;
            var date = DateTime.Now;
             /*   CompaignFactory.CreateInsertionPresse(compagne.PlanPresses.FirstOrDefault(), 5, titreDePresse.First(), date);
            CompaignFactory.CreateInsertionRadio(compagne.PlanRadios.FirstOrDefault(), numQuart, mediaRadio.First(), date);
            CompaignFactory.CreateInsertionTv(compagne.PlanTvs.FirstOrDefault(), numQuart, mediaTv.First(), date);

            var orDefault = compagne.PlanTvs.FirstOrDefault();
            /*
            PlanTV nullPlanTV = null;
            if (orDefault != nullPlanTV)
                */
               /*     Assert.AreEqual(orDefault.InsertionTvs.Count, 1);
            var planPresse = compagne.PlanPresses.FirstOrDefault();
            /*
            PlanPresse planPresseNull = null;
            if (planPresse != planPresseNull)

                */
            /*        Assert.AreEqual(planPresse.InsertionPresses.Count, 1);
            var planRadio = compagne.PlanRadios.FirstOrDefault();
            PlanRadio planRadioNull = null;
            /*if (planRadio != planRadioNull)*/
             /*       Assert.AreEqual(planRadio.InsertionRadios.Count, 1);

            var planTv = compagne.PlanTvs.FirstOrDefault();
            /*if (planTv != null)*/
             /*       Assert.AreEqual(planTv.InsertionTvs.First().SupportTv.Libelle, "AN Nahar TV");
            //TODO: verifier que les plan ramené de la base ne sont pas null

            var firstOrDefault = compagne.PlanTvs.FirstOrDefault();
            */
        }
Ejemplo n.º 5
0
        //TODO : au niveau du service dans le request c'est le fichier qui doit etre transmis
        public static List<ISignalitique> CreateDonnees(string filePath, string NomVague, IRepository<Individu, Guid> individuRepositorys, IRepository<Vague, Guid> vagueRepository,IReadOnlyRepository<SupportTV,Guid>  supporttvRepository,IReadOnlyRepository<SupportRadio,Guid> supportradioRepository,IReadOnlyRepository<SupportPresse,Guid> supportpresseRepository   )
        {
            _individuRepository = individuRepositorys;
            var extension = Path.GetExtension(filePath);
            var stream = File.Open(filePath, FileMode.Open, FileAccess.Read);
            var excelReader = extension == ".xlsx"
                                  ? ExcelReaderFactory.CreateOpenXmlReader(stream)
                                  : ExcelReaderFactory.CreateBinaryReader(stream);
            excelReader.IsFirstRowAsColumnNames = true;
            var collectionBase = excelReader.AsDataSet().Tables[0].AsEnumerable();

            //var Vide = collectionBase.Where(p => (string) p["année"] == "2012");
            //Assert.AreEqual(extension, ".xlsx");

            var distincts = collectionBase.Select(p => p["Matricule"]).Distinct();
            var individuRepository = _individuRepository;
            List<Individu> individusSave = new List<Individu>();

            List<Query> queries = new List<Query>();
            foreach (var distinct in distincts)
            {
                var convdistinct = int.Parse(distinct.ToString());

                var indivCriterion = new Criterion("IdQuest", convdistinct.ToString(), CriteriaOperator.Equal);
                var indivQuery = new Query();
                indivQuery.Add(indivCriterion);
                queries.Add(indivQuery);

            }
            var IndividuExistant = individuRepository.FindAll(queries);

            foreach (var distinct in distincts)
            {
                if (IndividuExistant.Any(e => e.IdQuest == (string)distinct)) continue;
                var Tempgenre = ((collectionBase.First(d => d["Matricule"] == distinct.ToString()))["Sexe"]);
                var genre = 0;
                int.TryParse(Tempgenre.ToString(), out genre);
                var individu=IndividuFactory.Create(distinct.ToString(), genre
                    );
                //individuRepository.Save(individu);
                individusSave.Add(individu);
            }
            //individuRepository.SaveAll(individusSave);

            // on commence la sauvegarde de la vague et des signlatiques
            var vague = IndividuFactory.CreateVague(NomVague);

            var collectionIndidu = individusSave;
            var listSignalitique = new List<ISignalitique>();
            foreach (var individu in collectionIndidu)
            {

                var individuCopy = individu;
                var individuParticulier = collectionBase.First(p => (string) p["Matricule"] == individuCopy.IdQuest);
                //TODO:vérifier que individuParticulier n'est pas nul
                #region Creation instance signalitique

                System.Threading.Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("en-US");
                var signalitique = new SignalitiqueInstance();
                signalitique.Id = Guid.NewGuid();
                signalitique.Age = int.Parse(individuParticulier["AGE_CLAIR"].ToString());
                signalitique.CSE = (FiltreEnumeration.CSE)int.Parse(individuParticulier["CSE"].ToString());
                signalitique.CSP = (CSP)int.Parse(individuParticulier["OCCUPATION"].ToString());
                signalitique.Habitat = (Habitat)int.Parse(individuParticulier["Habitat"].ToString());
                signalitique.TypeHabitat =(TypeHabitation) int.Parse(individuParticulier["TYP_HABI"].ToString());
                signalitique.NbVoiture = (NbVoiture)int.Parse(individuParticulier["NB_VOIT"].ToString());
                signalitique.NbPiece = (NbChambre)int.Parse(individuParticulier["NB_PIECE"].ToString());
                signalitique.Niveau = (NiveauInstruction)int.Parse(individuParticulier["NIV"].ToString());
                signalitique.Statutfamilial =(StatutFamiliale) int.Parse(individuParticulier["STATUT"].ToString());
                signalitique.Situationmatrimoniale =(SituationMatrimonial) int.Parse(individuParticulier["SITUATION"].ToString());
                signalitique.Ville = int.Parse(individuParticulier["Ville"].ToString());
                signalitique.TrancheAge = int.Parse(individuParticulier["AGE_TRANCH"].ToString());
                signalitique.RevenueTotalFoyer =(RevenuTotalFoyer) int.Parse(individuParticulier["Revenu_Foyer"].ToString());
                string individuParticulierToString = individuParticulier["poids"].ToString();

                CultureInfo ci = (CultureInfo)CultureInfo.CurrentCulture.Clone();
                ci.NumberFormat.CurrencyDecimalSeparator = ".";
                signalitique.Poid = float.Parse(individuParticulierToString, NumberStyles.Any, ci);

                signalitique.Mois = int.Parse(individuParticulier["Mois"].ToString());
                signalitique.Jour = int.Parse(individuParticulier["Jour"].ToString());
                signalitique.Refrigirateur = individuParticulier["P1"].ToString().GetBoolean();
                signalitique.Televisionencouleur = individuParticulier["P2"].ToString().GetBoolean();
                signalitique.Lecteurradiocassette = individuParticulier["P3"].ToString().GetBoolean();
                signalitique.Decodeur = individuParticulier["P4"].ToString().GetBoolean();
                signalitique.Mobile = individuParticulier["P5"].ToString().GetBoolean();
                signalitique.Cuisiniere = individuParticulier["P6"].ToString().GetBoolean();
                signalitique.Telephone = individuParticulier["P7"].ToString().GetBoolean();
                signalitique.Fourmicroonde = individuParticulier["P8"].ToString().GetBoolean();
                signalitique.Chainestereo = individuParticulier["P9"].ToString().GetBoolean();
                signalitique.LaveLinge = individuParticulier["P10"].ToString().GetBoolean();
                signalitique.LecteurDVD = individuParticulier["P11"].ToString().GetBoolean();
                signalitique.Aspirateur = individuParticulier["P12"].ToString().GetBoolean();
                signalitique.Pcsansconnexion = individuParticulier["P13"].ToString().GetBoolean();
                signalitique.Congelateur = individuParticulier["P14"].ToString().GetBoolean();
                signalitique.AppareilPhotoNumerique = individuParticulier["P15"].ToString().GetBoolean();
                signalitique.Magnetoscope = individuParticulier["P16"].ToString().GetBoolean();
                signalitique.LecteurCD = individuParticulier["P17"].ToString().GetBoolean();
                signalitique.Climatiseur = individuParticulier["P18"].ToString().GetBoolean();
                signalitique.Camescope = individuParticulier["P19"].ToString().GetBoolean();
                signalitique.Console = individuParticulier["P20"].ToString().GetBoolean();
                signalitique.LaveVaissele = individuParticulier["P21"].ToString().GetBoolean();
                signalitique.SecheLinge = individuParticulier["P22"].ToString().GetBoolean();
                signalitique.PCConnexion = individuParticulier["P23"].ToString().GetBoolean();
                signalitique.Genre = (Genre)int.Parse(individuParticulier["SEXE"].ToString());
                if (vague.Signalitique == null) vague.Signalitique=new List<ISignalitique>();
                vague.Signalitique.Add(signalitique);
                //TODO: vérifier que la vague est unique

                #endregion

                //signalitique.matricule = int.Parse(individuParticulier.idquest.ToString());

                //var Ann = individuParticulier.Annee;
                if (individu.Signalitiques == null) individu.Signalitiques = new List<ISignalitique>();
                individu.Signalitiques.Add(signalitique);
                signalitique.Individu = individu;
                signalitique.AudienceJournals=new List<AudienceJournal>();
                signalitique.AudienceRadios = new List<AudienceRadio>();
                signalitique.AudienceTVs = new List<AudienceTV>();
                listSignalitique.Add(signalitique);

            }

               var repositoryPresse = supportpresseRepository;
               var listeTitre = repositoryPresse.FindAll().ToList();
            foreach (var signalitique in listSignalitique)
            {

                ISignalitique signalitique1 = signalitique;
                var baseValueList = collectionBase.Where(p => (string) p["Matricule"] == signalitique1.Individu.IdQuest);
                foreach (var baseValue in baseValueList)
                {

                    if (int.Parse(baseValue["S5"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                            {
                            NumJournal = 5,
                            NombreOccurence = int.Parse(baseValue["S5"].ToString()) ,
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse=listeTitre.Find(e=>e.Code==5)
                        });

                    if (int.Parse(baseValue["S17"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                            {
                            NumJournal = 17,
                            NombreOccurence = int.Parse(baseValue["S17"].ToString()) ,
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 17)

                        });

                    if (int.Parse(baseValue["S1"].ToString())  != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 1,
                            NombreOccurence = int.Parse(baseValue["S1"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 1)

                        });

                    if (int.Parse(baseValue["S2"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 2,
                            NombreOccurence = int.Parse(baseValue["S2"].ToString()) ,
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 2)

                        });

                    if (int.Parse(baseValue["S3"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 3,
                            NombreOccurence = int.Parse(baseValue["S3"].ToString()) ,
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 3)

                        });

                    if (int.Parse(baseValue["S4"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 4,
                            NombreOccurence = int.Parse(baseValue["S4"].ToString()) ,
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 4)

                        });

                    if (int.Parse(baseValue["S6"].ToString())  != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 6,
                            NombreOccurence = int.Parse(baseValue["S6"].ToString()) ,
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 6)

                        });

                    if (int.Parse(baseValue["S7"].ToString())  != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 7,
                            NombreOccurence = int.Parse(baseValue["S7"].ToString()) ,
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 7)

                        });

                    if (int.Parse(baseValue["S8"].ToString())  != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 8,
                            NombreOccurence = int.Parse(baseValue["S8"] .ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 8)

                        });

                    if (int.Parse(baseValue["S9"].ToString())  != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 9,
                            NombreOccurence = int.Parse(baseValue["S9"].ToString()) ,
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 9)

                        });

                    if (int.Parse(baseValue["S10"].ToString())  != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 10,
                            NombreOccurence = int.Parse(baseValue["S10"].ToString()) ,
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 10)

                        });

                    if (int.Parse(baseValue["S11"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 11,
                            NombreOccurence = int.Parse(baseValue["S11"].ToString()) ,
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 11)

                        });

                    if (int.Parse(baseValue["S12"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 12,
                            NombreOccurence = int.Parse(baseValue["S12"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 12)
                        });

                    if (int.Parse(baseValue["S13"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 13,
                            NombreOccurence = int.Parse(baseValue["S13"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 13)
                        });

                    if (int.Parse(baseValue["S14"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 14,
                            NombreOccurence = int.Parse(baseValue["S14"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 14)
                        });

                    if (int.Parse(baseValue["S15"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 15,
                            NombreOccurence = int.Parse(baseValue["S15"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 15)
                        });

                    if (int.Parse(baseValue["S16"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 16,
                            NombreOccurence = int.Parse(baseValue["S16"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 16)
                        });

                    if (int.Parse(baseValue["S18"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 18,
                            NombreOccurence = int.Parse(baseValue["S18"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 18)
                        });

                    if (int.Parse(baseValue["S19"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 19,
                            NombreOccurence = int.Parse(baseValue["S19"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 19)
                        });

                    if (int.Parse(baseValue["S20"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 20,
                            NombreOccurence =int.Parse( baseValue["S20"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 20)
                        });

                    if (int.Parse(baseValue["S21"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 21,
                            NombreOccurence = int.Parse(baseValue["S21"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 21)
                        });

                    if (int.Parse(baseValue["S22"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 22,
                            NombreOccurence = int.Parse(baseValue["S22"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 22)
                        });

                    if (int.Parse(baseValue["S23"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 23,
                            NombreOccurence = int.Parse(baseValue["S23"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 23)
                        });

                    if (int.Parse(baseValue["S24"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 24,
                            NombreOccurence = int.Parse(baseValue["S24"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 24)
                        });

                    if (int.Parse(baseValue["S25"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 25,
                            NombreOccurence = int.Parse(baseValue["S25"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 25)
                        });

                    if (int.Parse(baseValue["S26"].ToString()) != 0)
                        signalitique.AudienceJournals.Add(new AudienceJournal
                        {
                            NumJournal = 26,
                            NombreOccurence = int.Parse(baseValue["S26"].ToString()),
                            Jour = int.Parse(baseValue["Jour"].ToString()),
                            SupportPresse = listeTitre.Find(e => e.Code == 26)
                        });

                }
            }

             var repositoryTV = supporttvRepository;
            var repositoryRadio = supportradioRepository;

            var listeChaineTv= repositoryTV.FindAll().ToList();
            var listeChaineRd = repositoryRadio.FindAll().ToList();

            int i = 0;
            foreach (var signalitique in listSignalitique)
            {
                i++;

                var signalitique1 = signalitique;
                var baseValueList = collectionBase.Where(p => (string)p["Matricule"] == signalitique1.Individu.IdQuest);

                foreach (var baseValue in baseValueList)
                {

                    if (int.Parse(baseValue["Q1"].ToString()) != 0)

                        if (int.Parse(baseValue["Q1"].ToString()) < 100)

                                for (var m = 1; m <= 15; m++)
                                    signalitique.AudienceTVs.Add(new AudienceTV()
                                    {

                                        id=Guid.NewGuid(),NumeroQuertdheure = 1,
                                        NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                        /*SupportTV =
                                            repositoryTV.FindBy(
                                                new Query().Add(new Criterion("Code", int.Parse(baseValue["Q1"].ToString()),
                                                                              CriteriaOperator.Equal))).First(),*/
                                        SupportTV=listeChaineTv.Find(e=>e.Code== int.Parse(baseValue["Q1"].ToString()))
                                        //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                                    });

                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                                {
                                    id=Guid.NewGuid(),QuartHeure = 1,
                                    NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                    SupportRadio=listeChaineRd.Find(e=>e.Code== int.Parse(baseValue["Q1"].ToString()))
                                    //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                    //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                                });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q2"].ToString()) != 0)

                        if (int.Parse(baseValue["Q2"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 2,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q2"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 2,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q2"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q3"].ToString()) != 0)

                        if (int.Parse(baseValue["Q3"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 3,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q3"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 3,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q3"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q4"].ToString()) != 0)

                        if (int.Parse(baseValue["Q4"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 4,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q4"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 4,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q4"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q5"].ToString()) != 0)

                        if (int.Parse(baseValue["Q5"].ToString()) < 100)
                             for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 5,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q5"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 5,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q5"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q6"].ToString()) != 0)

                        if (int.Parse(baseValue["Q6"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 6,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q6"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 6,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q6"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q7"].ToString()) != 0)

                        if (int.Parse(baseValue["Q7"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 7,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q7"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 7,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q7"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q8"].ToString()) != 0)

                        if (int.Parse(baseValue["Q8"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 8,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q8"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 8,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q8"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q9"].ToString()) != 0)

                        if (int.Parse(baseValue["Q9"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 9,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q9"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 9,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q9"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q10"].ToString()) != 0)

                        if (int.Parse(baseValue["Q10"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 10,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q10"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 10,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q10"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q11"].ToString()) != 0)

                        if (int.Parse(baseValue["Q11"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 11,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q11"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 11,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q11"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q12"].ToString()) != 0)

                        if (int.Parse(baseValue["Q12"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 12,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q12"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 12,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q12"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q13"].ToString()) != 0)

                        if (int.Parse(baseValue["Q13"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 13,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q13"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 13,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q13"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q14"].ToString()) != 0)

                        if (int.Parse(baseValue["Q14"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 14,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q14"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 14,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q14"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q15"].ToString()) != 0)

                        if (int.Parse(baseValue["Q15"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 15,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q15"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 15,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q15"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q16"].ToString()) != 0)

                        if (int.Parse(baseValue["Q16"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 16,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q16"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 16,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q16"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q17"].ToString()) != 0)

                        if (int.Parse(baseValue["Q17"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 17,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q17"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 17,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q17"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q18"].ToString()) != 0)

                        if (int.Parse(baseValue["Q18"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 18,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q18"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 18,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q18"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q19"].ToString()) != 0)

                        if (int.Parse(baseValue["Q19"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 19,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q19"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 19,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q19"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q20"].ToString()) != 0)

                        if (int.Parse(baseValue["Q20"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 20,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q20"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 20,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q20"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q21"].ToString()) != 0)

                        if (int.Parse(baseValue["Q21"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 21,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q21"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 21,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q21"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q22"].ToString()) != 0)

                        if (int.Parse(baseValue["Q22"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 22,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q22"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 22,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q22"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q23"].ToString()) != 0)

                        if (int.Parse(baseValue["Q23"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 23,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q23"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 23,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q23"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q24"].ToString()) != 0)

                        if (int.Parse(baseValue["Q24"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 24,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q24"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 24,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q24"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q25"].ToString()) != 0)

                        if (int.Parse(baseValue["Q25"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 25,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q25"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 25,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q25"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q26"].ToString()) != 0)

                        if (int.Parse(baseValue["Q26"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 26,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q26"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 26,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q26"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q27"].ToString()) != 0)

                        if (int.Parse(baseValue["Q27"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 27,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q27"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 27,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q27"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q28"].ToString()) != 0)

                        if (int.Parse(baseValue["Q28"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 28,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q28"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 28,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q28"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q29"].ToString()) != 0)

                        if (int.Parse(baseValue["Q29"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 29,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q29"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 29,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q29"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q30"].ToString()) != 0)

                        if (int.Parse(baseValue["Q30"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 30,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q30"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 30,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q30"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q31"].ToString()) != 0)

                        if (int.Parse(baseValue["Q31"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 31,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q31"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 31,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q31"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q32"].ToString()) != 0)

                        if (int.Parse(baseValue["Q32"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 32,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q32"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 32,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q32"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q33"].ToString()) != 0)

                        if (int.Parse(baseValue["Q33"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 33,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q33"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 33,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q33"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q34"].ToString()) != 0)

                        if (int.Parse(baseValue["Q34"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 34,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q34"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 34,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q34"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q35"].ToString()) != 0)

                        if (int.Parse(baseValue["Q35"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 35,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q35"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 35,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q35"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q36"].ToString()) != 0)

                        if (int.Parse(baseValue["Q36"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 36,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q36"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 36,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q36"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q37"].ToString()) != 0)

                        if (int.Parse(baseValue["Q37"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 37,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q37"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 37,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q37"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q38"].ToString()) != 0)

                        if (int.Parse(baseValue["Q38"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 38,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q38"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 38,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q38"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q39"].ToString()) != 0)

                        if (int.Parse(baseValue["Q39"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 39,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q39"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 39,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q39"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q40"].ToString()) != 0)

                        if (int.Parse(baseValue["Q40"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 40,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q40"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 40,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q40"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q41"].ToString()) != 0)

                        if (int.Parse(baseValue["Q41"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 41,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q41"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 41,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q41"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q42"].ToString()) != 0)

                        if (int.Parse(baseValue["Q42"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 42,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q42"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 42,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q42"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q43"].ToString()) != 0)

                        if (int.Parse(baseValue["Q43"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 43,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q43"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 43,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q43"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q44"].ToString()) != 0)

                        if (int.Parse(baseValue["Q44"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 44,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q44"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 44,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q44"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q45"].ToString()) != 0)

                        if (int.Parse(baseValue["Q45"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 45,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q45"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 45,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q45"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q46"].ToString()) != 0)

                        if (int.Parse(baseValue["Q46"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 46,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q46"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 46,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q46"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q47"].ToString()) != 0)

                        if (int.Parse(baseValue["Q47"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 47,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q47"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 47,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q47"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q48"].ToString()) != 0)

                        if (int.Parse(baseValue["Q48"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 48,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q48"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 48,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q48"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q49"].ToString()) != 0)

                        if (int.Parse(baseValue["Q49"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 49,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q49"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 49,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q49"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q50"].ToString()) != 0)

                        if (int.Parse(baseValue["Q50"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 50,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q50"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 50,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q50"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q51"].ToString()) != 0)

                        if (int.Parse(baseValue["Q51"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 51,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q51"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 51,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q51"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q52"].ToString()) != 0)

                        if (int.Parse(baseValue["Q52"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 52,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q52"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 52,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q52"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q53"].ToString()) != 0)

                        if (int.Parse(baseValue["Q53"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 53,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q53"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 53,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q53"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q54"].ToString()) != 0)

                        if (int.Parse(baseValue["Q54"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 54,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q54"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 54,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q54"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q55"].ToString()) != 0)

                        if (int.Parse(baseValue["Q55"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 55,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q55"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 55,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q55"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q56"].ToString()) != 0)

                        if (int.Parse(baseValue["Q56"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 56,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q56"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 56,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q56"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q57"].ToString()) != 0)

                        if (int.Parse(baseValue["Q57"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 57,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q57"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 57,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q57"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q58"].ToString()) != 0)

                        if (int.Parse(baseValue["Q58"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 58,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q58"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 58,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q58"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q59"].ToString()) != 0)

                        if (int.Parse(baseValue["Q59"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 59,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q59"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 59,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q59"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q60"].ToString()) != 0)

                        if (int.Parse(baseValue["Q60"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 60,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q60"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 60,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q60"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q61"].ToString()) != 0)

                        if (int.Parse(baseValue["Q61"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 61,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q61"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 61,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q61"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q62"].ToString()) != 0)

                        if (int.Parse(baseValue["Q62"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 62,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q62"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 62,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q62"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q63"].ToString()) != 0)

                        if (int.Parse(baseValue["Q63"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 63,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q63"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 63,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q63"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q64"].ToString()) != 0)

                        if (int.Parse(baseValue["Q64"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 64,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q64"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 64,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q64"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q65"].ToString()) != 0)

                        if (int.Parse(baseValue["Q65"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 65,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q65"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 65,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q65"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q66"].ToString()) != 0)

                        if (int.Parse(baseValue["Q66"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 66,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q66"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 66,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q66"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q67"].ToString()) != 0)

                        if (int.Parse(baseValue["Q67"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 67,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q67"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 67,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q67"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q68"].ToString()) != 0)

                        if (int.Parse(baseValue["Q68"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 68,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q68"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 68,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q68"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q69"].ToString()) != 0)

                        if (int.Parse(baseValue["Q69"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 69,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q69"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 69,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q69"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q70"].ToString()) != 0)

                        if (int.Parse(baseValue["Q70"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 70,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q70"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 70,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q70"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q71"].ToString()) != 0)

                        if (int.Parse(baseValue["Q71"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 71,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q71"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 71,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q71"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q72"].ToString()) != 0)

                        if (int.Parse(baseValue["Q72"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 72,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q72"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 72,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q72"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q73"].ToString()) != 0)

                        if (int.Parse(baseValue["Q73"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 73,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q73"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 73,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q73"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q74"].ToString()) != 0)

                        if (int.Parse(baseValue["Q74"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 74,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q74"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 74,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q74"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q75"].ToString()) != 0)

                        if (int.Parse(baseValue["Q75"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 75,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q75"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 75,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q75"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q76"].ToString()) != 0)

                        if (int.Parse(baseValue["Q76"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 76,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q76"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 76,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q76"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q77"].ToString()) != 0)

                        if (int.Parse(baseValue["Q77"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 77,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q77"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 77,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q77"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q78"].ToString()) != 0)

                        if (int.Parse(baseValue["Q78"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 78,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q78"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 78,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q78"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q79"].ToString()) != 0)

                        if (int.Parse(baseValue["Q79"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 79,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q79"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 79,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q79"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q80"].ToString()) != 0)

                        if (int.Parse(baseValue["Q80"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 80,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q80"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 80,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q80"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q81"].ToString()) != 0)

                        if (int.Parse(baseValue["Q81"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 81,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q81"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 81,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q81"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q82"].ToString()) != 0)

                        if (int.Parse(baseValue["Q82"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 82,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q82"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 82,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q82"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q83"].ToString()) != 0)

                        if (int.Parse(baseValue["Q83"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 83,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q83"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 83,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q83"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q84"].ToString()) != 0)

                        if (int.Parse(baseValue["Q84"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 84,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q84"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 84,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q84"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q85"].ToString()) != 0)

                        if (int.Parse(baseValue["Q85"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 85,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q85"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 85,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q85"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q86"].ToString()) != 0)

                        if (int.Parse(baseValue["Q86"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 86,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q86"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 86,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q86"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q87"].ToString()) != 0)

                        if (int.Parse(baseValue["Q87"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 87,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q87"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 87,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q87"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q88"].ToString()) != 0)

                        if (int.Parse(baseValue["Q88"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 88,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q88"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 88,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q88"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q89"].ToString()) != 0)

                        if (int.Parse(baseValue["Q89"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure =89,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q89"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 89,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q89"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q90"].ToString()) != 0)

                        if (int.Parse(baseValue["Q90"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 90,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q90"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 90,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q90"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q91"].ToString()) != 0)

                        if (int.Parse(baseValue["Q91"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 91,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q91"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 91,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q91"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q92"].ToString()) != 0)

                        if (int.Parse(baseValue["Q92"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 92,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q92"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 92,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q92"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q93"].ToString()) != 0)

                        if (int.Parse(baseValue["Q93"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 93,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q93"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 93,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q93"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q94"].ToString()) != 0)

                        if (int.Parse(baseValue["Q94"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 94,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q94"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 94,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q94"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q95"].ToString()) != 0)

                        if (int.Parse(baseValue["Q95"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 95,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q95"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {
                                id=Guid.NewGuid(),QuartHeure = 95,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q95"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });
                    /***********************************************************************************************/
                    if (int.Parse(baseValue["Q96"].ToString()) != 0)

                        if (int.Parse(baseValue["Q96"].ToString()) < 100)
                            for (var m = 1; m <= 15; m++) signalitique.AudienceTVs.Add(new AudienceTV()
                            {

                                id=Guid.NewGuid(),NumeroQuertdheure = 96,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportTV = listeChaineTv.Find(e => e.Code == int.Parse(baseValue["Q96"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia

                            });
                        else
                            for (var m = 1; m <= 15; m++) signalitique.AudienceRadios.Add(new AudienceRadio()
                            {

                                id=Guid.NewGuid(),QuartHeure = 96,
                                NumeroJour = int.Parse(baseValue["Jour"].ToString()),NumeroMinute=m,
                                SupportRadio = listeChaineRd.Find(e => e.Code == int.Parse(baseValue["Q96"].ToString()))
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportMedia
                                //XpoSession.FindObject<Code>(new BinaryOperator("code1", baseValue.Q_1,BinaryOperatorType.Equal)).SupportRadio
                            });

                }

            }

            vagueRepository.Save(vague);
                      return listSignalitique;
        }
Ejemplo n.º 6
0
        public float Get_Couv(IRepositoryVague<POCO.Donnees.Vague, Guid> vagueRepository, List<InsertionViewTv> insertionViewTvs, List<InsertionViewPr> insertionViewPrs, List<InsertionViewRd> insertionViewRds,
               Filter filter, POCO.Donnees.Vague vague)
        {
            var insertions=new List<InsertionTv>();
               foreach (var insertionViewTv in insertionViewTvs)
               {
                   var insertion = new InsertionTv();
                   insertion.Date = insertionViewTv.Start;

                   int quart = int.Parse(((int)insertionViewTv.Start.TimeOfDay.TotalMinutes / 15).ToString());
                   quart = (quart + 76) % 96;
                   var jour = (int)insertionViewTv.Start.DayOfWeek;
                   jour = ((jour) % 7) + 1;
                   insertion.NumeroQuartHeure = quart;
                   insertion.SupportTv = insertionViewTv.SupportTv;
                   insertions.Add(insertion);
               }

               var planTV = new PlanTV(){
                   Name = "test",
                   InsertionTvs = insertions,
                   id = Guid.NewGuid()
               };

            var criterionTvSupport = new Criterion("planTv", planTV, CriteriaOperator.Equal);
            var criterionSignlalitiques = new Criterion("Signalitique", planTV.GetSignalitique(filter,vague), CriteriaOperator.Equal);
            var QueryTv = new Query();
            QueryTv.Add(criterionTvSupport);
            QueryTv.Add(criterionSignlalitiques);
            var indicateur=vagueRepository.GetIndicateurRadioTele(QueryTv, vague);
            return indicateur.Gouverture;
        }
Ejemplo n.º 7
0
 public void AddSubQuery(Query subQuery)
 {
     _subQueries.Add(subQuery);
 }