Пример #1
0
        private static void ParseShopElement(XElement shopElement, LISAEntities entities, Catalogue catalogue)
        {
            MagasinCatalogue result  = null;
            Magasin          magasin = null;

            DateTime shopStartDateTime = UnixTimeStampToDateTime(double.Parse(shopElement.Element(XName.Get("displayStartDate")).Value));
            DateTime shopEndDateTime   = UnixTimeStampToDateTime(double.Parse(shopElement.Element(XName.Get("displayEndDate")).Value));

            magasin = ParseShopElement_Magasin(shopElement, entities);

            result = entities.MagasinCatalogues.FirstOrDefault(mc => mc.IdMagasin == magasin.Id && mc.IdCatalogue == catalogue.Id);

            if (result == null)
            {
                result = new MagasinCatalogue()
                {
                    Magasin   = magasin,
                    Catalogue = catalogue,
                    DateDebut = shopStartDateTime,
                    DateFin   = shopEndDateTime
                };

                entities.MagasinCatalogues.Add(result);
            }
        }
Пример #2
0
        /// <summary>
        /// Importe un #<see cref="MagasinCatalogue"/> du fichier XML. Si le MagasinCatalogue est déjà en base de données,
        /// le supprime et le restaure avec les nouvelles données.
        /// </summary>
        /// <param name="shopElement">Element de magasin</param>
        /// <param name="entities">Gestionnaire DB</param>
        /// <param name="catalog">Catalogue en liaison avec la table MagasinCatalogue</param>
        /// <param name="shop">Magasin en liaison avec la table MagasinCatalogue</param>
        private static MagasinCatalogue ParseShopCatalogElement(XElement shopElement, LISAEntities entities, Catalogue catalog, Magasin shop)
        {
            DateTime shopStartdate        = UnixTimeStampToDateTime(double.Parse(shopElement.Element(XName.Get("startDate")).Value));
            DateTime shopDisplaystartdate = UnixTimeStampToDateTime(double.Parse(shopElement.Element(XName.Get("displayStartDate")).Value));
            DateTime shopDisplayenddate   = UnixTimeStampToDateTime(double.Parse(shopElement.Element(XName.Get("displayEndDate")).Value));


            MagasinCatalogue result = entities.MagasinCatalogues.FirstOrDefault(c => c.IdCatalogue == catalog.ImportId && c.IdMagasin == shop.Id);

            if (result != null)
            {
                entities.MagasinCatalogues.Remove(result);
            }

            result = new MagasinCatalogue()
            {
                DateDebut = shopDisplaystartdate,
                DateFin   = shopDisplayenddate,
                Catalogue = catalog,
                Magasin   = shop
            };

            entities.MagasinCatalogues.Add(result);

            return(result);
        }