public LienConditionnementContext() : base() { Core.Temp.ListF_CONDITION = new Model.Sage.F_CONDITIONRepository().List(); Core.Temp.ListPsAttributeLang = new Model.Prestashop.PsAttributeLangRepository().ListLang(Core.Global.Lang).AsParallel().ToList(); Core.Temp.ListP_CONDITIONNEMENT = new Model.Sage.P_CONDITIONNEMENTRepository().ListIntituleNotNull(); this.ConditioningArticleRepository = new Model.Local.ConditioningArticleRepository(); ListConditioningArticle = new ObservableCollection <Model.Local.ConditioningArticle>(this.ConditioningArticleRepository.List()); }
internal void SaveReplace() { foreach (Model.Local.ConditioningArticle item in ListConditioningArticle) { if (item.Replace && item.EnumereF_CONDITIONSageNew.cbMarq > 0) { item.Sag_Id = item.EnumereF_CONDITIONSageNew.cbMarq; } } this.ConditioningArticleRepository.Save(); // reload this.ConditioningArticleRepository = new Model.Local.ConditioningArticleRepository(); ListConditioningArticle = new ObservableCollection <Model.Local.ConditioningArticle>(this.ConditioningArticleRepository.List()); }
private void ExecConditioning(Model.Local.Article Article, Model.Prestashop.PsProduct PsProduct, Model.Sage.F_TAXE TaxeTVA, Model.Prestashop.PsProductRepository PsProductRepository) { try { Model.Sage.F_ARTICLERepository F_ARTICLERepository = new Model.Sage.F_ARTICLERepository(); if (F_ARTICLERepository.ExistArticle(Article.Sag_Id)) { Model.Sage.F_ARTICLE F_ARTICLE = F_ARTICLERepository.ReadArticle(Article.Sag_Id); Model.Local.ConditioningGroupRepository ConditioningGroupRepository = new Model.Local.ConditioningGroupRepository(); Model.Prestashop.PsAttributeGroupRepository PsAttributeGroupRepository = new Model.Prestashop.PsAttributeGroupRepository(); Boolean isProductAttribute; if (F_ARTICLE.AR_Condition != null && F_ARTICLE.AR_Condition != 0 && ConditioningGroupRepository.ExistSage((int)F_ARTICLE.AR_Condition) && PsAttributeGroupRepository.ExistAttributeGroup((uint)ConditioningGroupRepository.ReadSage((int)F_ARTICLE.AR_Condition).Pre_Id)) { Model.Local.ConditioningArticleRepository ConditioningArticleRepository = new Model.Local.ConditioningArticleRepository(); List <Model.Local.ConditioningArticle> ListConditioningArticle = ConditioningArticleRepository.ListArticleSync(Article.Art_Id, true); Model.Prestashop.PsProductAttributeRepository PsProductAttributeRepository = new Model.Prestashop.PsProductAttributeRepository(); Model.Prestashop.PsProductAttribute PsProductAttribute; int stockmaxunity = 0; foreach (Model.Local.ConditioningArticle ConditioningArticle in ListConditioningArticle) { if (ConditioningArticle.EnumereF_CONDITION != null) { PsProductAttribute = new Model.Prestashop.PsProductAttribute(); isProductAttribute = false; if (ConditioningArticle.Pre_Id != null && ConditioningArticle.Pre_Id != 0) { if (PsProductAttributeRepository.ExistProductAttribute((UInt32)ConditioningArticle.Pre_Id)) { PsProductAttribute = PsProductAttributeRepository.ReadProductAttribute((UInt32)ConditioningArticle.Pre_Id); isProductAttribute = true; } } if (Core.Global.GetConfig().MajPoidsSynchroStock) { SynchronisationArticle.ReadWeightConditioning(PsProduct, PsProductAttribute, ConditioningArticle.EnumereF_CONDITION); } SynchronisationArticle.ReadQuantityConditioning(PsProductAttribute, F_ARTICLE, ConditioningArticle.EnumereF_CONDITION); if (Core.Global.GetConfig().LimiteStockConditionnement&& PsProductAttribute.Quantity >= stockmaxunity) { stockmaxunity = PsProductAttribute.Quantity; PsProduct.Quantity = stockmaxunity; PsProductRepository.Save(); } // <JG> 03/06/2016 if (Article.Art_SyncPrice) { SynchronisationArticle.ReadPriceConditioning(PsProduct, PsProductAttribute, F_ARTICLE, ConditioningArticle.EnumereF_CONDITION, TaxeTVA); } //PsProductAttribute.DefaultOn = (ConditioningArticle.ConArt_Default) ? (byte)1 : (byte)0; if (isProductAttribute == true) { PsProductAttributeRepository.Save(); SynchronisationArticle.ExecShopProductAttribute(PsProductAttribute); SynchronisationArticle.WriteStockAvailableProductAttribute(PsProduct, PsProductAttribute); } } } PsProductAttributeRepository.WriteDate(PsProduct.IDProduct); } } } catch (Exception ex) { Core.Error.SendMailError(ex.ToString()); } }
private void RecoveryDataProductAttribute(Model.Prestashop.PsProduct Product) { Model.Prestashop.PsProductAttributeRepository PsProductAttributeRepository = new Model.Prestashop.PsProductAttributeRepository(); Model.Prestashop.PsProductAttributeShopRepository PsProductAttributeShopRepository = new Model.Prestashop.PsProductAttributeShopRepository(); Model.Prestashop.PsProductAttributeImageRepository PsProductAttributeImageRepository = new Model.Prestashop.PsProductAttributeImageRepository(); Model.Local.AttributeArticleRepository AttributeArticleRepository = new Model.Local.AttributeArticleRepository(); Model.Local.ConditioningArticleRepository ConditioningArticleRepository = new Model.Local.ConditioningArticleRepository(); Model.Local.CompositionArticleRepository CompositionArticleRepository = new Model.Local.CompositionArticleRepository(); Model.Local.AttributeArticleImageRepository AttributeArticleImageRepository = new Model.Local.AttributeArticleImageRepository(); Model.Local.CompositionArticleImageRepository CompositionArticleImageRepository = new Model.Local.CompositionArticleImageRepository(); Model.Local.ArticleImageRepository ArticleImageRepository = new Model.Local.ArticleImageRepository(); Model.Local.AttributeArticle AttributeArticle; Model.Local.ConditioningArticle ConditioningArticle; Model.Local.CompositionArticle CompositionArticle; Model.Local.ArticleImage ArticleImage; List <Model.Prestashop.PsProductAttribute> ListPsProductAttribute = PsProductAttributeRepository.List(Product.IDProduct); //parcours déclinaisons PrestaShop foreach (Model.Prestashop.PsProductAttribute PsProductAttribute in ListPsProductAttribute) { // test si déclinaison en gamme dans PrestaConnect if (AttributeArticleRepository.ExistPrestashop((int)PsProductAttribute.IDProductAttribute)) { AttributeArticle = AttributeArticleRepository.ReadPrestashop((int)PsProductAttribute.IDProductAttribute); Model.Prestashop.PsProductAttributeShop PsProductAttributeShop = (PsProductAttributeShopRepository.ExistPsProductAttributeShop(PsProductAttribute.IDProductAttribute, Core.Global.CurrentShop.IDShop)) ? PsProductAttributeShopRepository.ReadPsProductAttributeShop(PsProductAttribute.IDProductAttribute, Core.Global.CurrentShop.IDShop) : null; bool defaut = (PsProductAttributeShop != null) ? PsProductAttributeShop.DefaultOn == 1 : PsProductAttribute.DefaultOn == 1; if (AttributeArticle.AttArt_Default != defaut) { AttributeArticle.AttArt_Default = defaut; AttributeArticleRepository.Save(); if (defaut) { List <Model.Local.AttributeArticle> ListAttributeArticle = AttributeArticleRepository.ListArticle(AttributeArticle.Art_Id); if (ListAttributeArticle.Count(i => i.AttArt_Default == true && i.AttArt_Id != AttributeArticle.AttArt_Id) > 0) { foreach (Model.Local.AttributeArticle AttributeArticleDefault in ListAttributeArticle.Where(i => i.AttArt_Default == true && i.AttArt_Id != AttributeArticle.Art_Id)) { AttributeArticleDefault.AttArt_Default = false; AttributeArticleRepository.Save(); } } } } // attribution images gammes if (PsProductAttributeImageRepository.ExistProductAttribute(PsProductAttribute.IDProductAttribute)) { List <Model.Prestashop.PsProductAttributeImage> ListPsProductAttributeImage = PsProductAttributeImageRepository.ListProductAttribute(PsProductAttribute.IDProductAttribute); // étape 1 attachement dans PrestaConnect des images affectées a la déclinaison PrestaShop foreach (Model.Prestashop.PsProductAttributeImage PsProductAttributeImage in ListPsProductAttributeImage) { // si l'image existe dans PrestaConnect if (ArticleImageRepository.ExistPre_Id((int)PsProductAttributeImage.IDImage)) { ArticleImage = ArticleImageRepository.ReadPrestaShop((int)PsProductAttributeImage.IDImage); if (!AttributeArticleImageRepository.ExistAttributeArticleImage(AttributeArticle.AttArt_Id, ArticleImage.ImaArt_Id)) { AttributeArticleImageRepository.Add(new Model.Local.AttributeArticleImage() { AttArt_Id = AttributeArticle.AttArt_Id, ImaArt_Id = ArticleImage.ImaArt_Id, }); } } } // étape 2 détachement List <uint> list_prestashop = ListPsProductAttributeImage.Select(pai => pai.IDImage).ToList(); foreach (Model.Local.AttributeArticleImage AttributeArticleImage in AttributeArticleImageRepository.ListAttributeArticle(AttributeArticle.AttArt_Id)) { if (AttributeArticleImage.ArticleImage.Pre_Id != null && !list_prestashop.Contains((uint)AttributeArticleImage.ArticleImage.Pre_Id.Value)) { AttributeArticleImageRepository.Delete(AttributeArticleImage); } } } else if (AttributeArticleImageRepository.ExistAttributeArticle(AttributeArticle.AttArt_Id)) { // absence de lien gamme déclinaison dans Prestashop donc suppression des liens dans PrestaConnect AttributeArticleImageRepository.DeleteAll(AttributeArticleImageRepository.ListAttributeArticle(AttributeArticle.AttArt_Id)); } } // test si déclinaison en conditionnement dans PrestaConnect else if (ConditioningArticleRepository.ExistPrestashop((int)PsProductAttribute.IDProductAttribute)) { ConditioningArticle = ConditioningArticleRepository.ReadPrestashop((int)PsProductAttribute.IDProductAttribute); Model.Prestashop.PsProductAttributeShop PsProductAttributeShop = (PsProductAttributeShopRepository.ExistPsProductAttributeShop(PsProductAttribute.IDProductAttribute, Core.Global.CurrentShop.IDShop)) ? PsProductAttributeShopRepository.ReadPsProductAttributeShop(PsProductAttribute.IDProductAttribute, Core.Global.CurrentShop.IDShop) : null; bool defaut = (PsProductAttributeShop != null) ? PsProductAttributeShop.DefaultOn == 1 : PsProductAttribute.DefaultOn == 1; if (ConditioningArticle.ConArt_Default != defaut) { ConditioningArticle.ConArt_Default = defaut; ConditioningArticleRepository.Save(); if (defaut) { List <Model.Local.ConditioningArticle> ListConditioningArticle = ConditioningArticleRepository.ListArticle(ConditioningArticle.Art_Id); if (ListConditioningArticle.Count(i => i.ConArt_Default == true && i.ConArt_Id != ConditioningArticle.ConArt_Id) > 0) { foreach (Model.Local.ConditioningArticle ConditioningArticleDefault in ListConditioningArticle.Where(i => i.ConArt_Default == true && i.ConArt_Id != ConditioningArticle.Art_Id)) { ConditioningArticleDefault.ConArt_Default = false; ConditioningArticleRepository.Save(); } } } } } // test si déclinaison composition dans PrestaConnect else if (CompositionArticleRepository.ExistPrestaShop((int)PsProductAttribute.IDProductAttribute)) { CompositionArticle = CompositionArticleRepository.ReadPrestaShop((int)PsProductAttribute.IDProductAttribute); Model.Prestashop.PsProductAttributeShop PsProductAttributeShop = (PsProductAttributeShopRepository.ExistPsProductAttributeShop(PsProductAttribute.IDProductAttribute, Core.Global.CurrentShop.IDShop)) ? PsProductAttributeShopRepository.ReadPsProductAttributeShop(PsProductAttribute.IDProductAttribute, Core.Global.CurrentShop.IDShop) : null; bool defaut = (PsProductAttributeShop != null) ? PsProductAttributeShop.DefaultOn == 1 : PsProductAttribute.DefaultOn == 1; if (CompositionArticle.ComArt_Default != defaut) { CompositionArticle.ComArt_Default = defaut; CompositionArticleRepository.Save(); if (defaut) { List <Model.Local.CompositionArticle> ListCompositionArticle = CompositionArticleRepository.ListArticle(CompositionArticle.ComArt_ArtId); if (ListCompositionArticle.Count(i => i.ComArt_Default == true && i.ComArt_Id != CompositionArticle.ComArt_Id) > 0) { foreach (Model.Local.CompositionArticle CompositionArticleDefault in ListCompositionArticle.Where(i => i.ComArt_Default == true && i.ComArt_Id != CompositionArticle.ComArt_ArtId)) { CompositionArticleDefault.ComArt_Default = false; ConditioningArticleRepository.Save(); } } } } // attribution images gammes if (PsProductAttributeImageRepository.ExistProductAttribute(PsProductAttribute.IDProductAttribute)) { List <Model.Prestashop.PsProductAttributeImage> ListPsProductAttributeImage = PsProductAttributeImageRepository.ListProductAttribute(PsProductAttribute.IDProductAttribute); // étape 1 attachement dans PrestaConnect des images affectées a la déclinaison PrestaShop foreach (Model.Prestashop.PsProductAttributeImage PsProductAttributeImage in ListPsProductAttributeImage) { // si l'image existe dans PrestaConnect if (ArticleImageRepository.ExistPre_Id((int)PsProductAttributeImage.IDImage)) { ArticleImage = ArticleImageRepository.ReadPrestaShop((int)PsProductAttributeImage.IDImage); if (!CompositionArticleImageRepository.ExistCompositionArticleImage(CompositionArticle.ComArt_Id, ArticleImage.ImaArt_Id)) { CompositionArticleImageRepository.Add(new Model.Local.CompositionArticleImage() { ComArt_Id = CompositionArticle.ComArt_Id, ImaArt_Id = ArticleImage.ImaArt_Id, }); } } } // étape 2 détachement List <uint> list_prestashop = ListPsProductAttributeImage.Select(pai => pai.IDImage).ToList(); foreach (Model.Local.CompositionArticleImage CompositionArticleImage in CompositionArticleImageRepository.ListCompositionArticle(CompositionArticle.ComArt_Id)) { if (CompositionArticleImage.ArticleImage.Pre_Id != null && !list_prestashop.Contains((uint)CompositionArticleImage.ArticleImage.Pre_Id.Value)) { CompositionArticleImageRepository.Delete(CompositionArticleImage); } } } else if (CompositionArticleImageRepository.ExistCompositionArticle(CompositionArticle.ComArt_Id)) { // absence de lien gamme déclinaison dans Prestashop donc suppression des liens dans PrestaConnect CompositionArticleImageRepository.DeleteAll(CompositionArticleImageRepository.ListCompositionArticle(CompositionArticle.ComArt_Id)); } } } }