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); } }
/// <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); }