private void DataGridCatalogue_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     Model.Local.Catalog Catalog = this.DataGridCatalogue.SelectedItem as Model.Local.Catalog;
     if (Catalog != null && this.CheckBoxSearchOnlyCatalog.IsChecked == true)
     {
         this.SearchArticle();
     }
 }
Example #2
0
        public void ExecCatalog(Int32 CatalogueSend)
        {
            this.Semaphore.WaitOne();

            try
            {
                Model.Local.CatalogRepository CatalogRepository = new Model.Local.CatalogRepository();
                Model.Local.Catalog           Catalog           = CatalogRepository.ReadId(CatalogueSend);
                string url = Core.Global.ReadLinkRewrite(Catalog.Cat_LinkRewrite);
                if (url != Catalog.Cat_LinkRewrite)
                {
                    Catalog.Cat_LinkRewrite = url;
                    if (!this.RewritePrestaShop)
                    {
                        Catalog.Cat_Date = DateTime.Now;
                    }
                    CatalogRepository.Save();

                    if (this.RewritePrestaShop && Catalog.Pre_Id != null)
                    {
                        Model.Prestashop.PsCategoryLangRepository PsCategoryLangRepository = new Model.Prestashop.PsCategoryLangRepository();
                        if (PsCategoryLangRepository.ExistCategoryLang(Catalog.Pre_Id.Value, Core.Global.Lang, Core.Global.CurrentShop.IDShop))
                        {
                            Model.Prestashop.PsCategoryLang PsCategoryLang = PsCategoryLangRepository.ReadCategoryLang(Catalog.Pre_Id.Value, Core.Global.Lang, Core.Global.CurrentShop.IDShop);
                            PsCategoryLang.LinkRewrite = url;
                            PsCategoryLangRepository.Save();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Core.Error.SendMailError(ex.ToString());
            }

            lock (this)
            {
                this.CurrentCount += 1;
            }
            this.ReportProgressCatalogue(this.CurrentCount * 100 / this.ListCount);
            this.Semaphore.Release();
        }
        private void SearchArticle()
        {
            Model.Local.ArticleRepository ArticleRepository  = new Model.Local.ArticleRepository();
            List <Model.Local.Article>    ListArticleDisplay = new List <Model.Local.Article>();

            Model.Local.Catalog Catalog = this.DataGridCatalogue.SelectedItem as Model.Local.Catalog;
            if (Catalog != null && this.CheckBoxSearchOnlyCatalog.IsChecked == true)
            {
                this.ListArticle = ArticleRepository.ListCatalog(Catalog.Cat_Id);
                Model.Local.ArticleCatalogRepository ArticleCatalogRepository = new Model.Local.ArticleCatalogRepository();
                List <Model.Local.ArticleCatalog>    ListArticleCatalog       = ArticleCatalogRepository.ListCatalog(Catalog.Cat_Id);
                foreach (Model.Local.ArticleCatalog ArticleCatalog in ListArticleCatalog)
                {
                    Boolean Add = true;
                    foreach (Model.Local.Article Article in ListArticle)
                    {
                        if (Article.Art_Id == ArticleCatalog.Art_Id)
                        {
                            Add = false;
                            break;
                        }
                    }
                    if (Add == true)
                    {
                        this.ListArticle.Add(ArticleCatalog.Article);
                    }
                }
            }
            else
            {
                this.ListArticle = ArticleRepository.List();
            }

            Boolean isArticle;

            foreach (Model.Local.Article Article in this.ListArticle)
            {
                isArticle = true;
                if (this.TextBoxSearchArticleName.Text != "" && this.TextBoxSearchArticleName.Text.Replace("%", "") != "")
                {
                    if (this.TextBoxSearchArticleName.Text.Contains("%"))
                    {
                        if (Article.Art_Name.ToUpper().Contains(this.TextBoxSearchArticleName.Text.Replace("%", "").ToUpper()) == false)
                        {
                            isArticle = false;
                        }
                    }
                    else
                    {
                        if (Article.Art_Name.ToUpper().StartsWith(this.TextBoxSearchArticleName.Text.ToUpper()) == false)
                        {
                            isArticle = false;
                        }
                    }
                }
                if (this.TextBoxSearchArticleEan13.Text != "" && this.TextBoxSearchArticleEan13.Text.Replace("%", "") != "")
                {
                    if (Article.Art_Ean13 != null)
                    {
                        if (this.TextBoxSearchArticleEan13.Text.Contains("%"))
                        {
                            if (Article.Art_Ean13.ToUpper().Contains(this.TextBoxSearchArticleEan13.Text.Replace("%", "").ToUpper()) == false)
                            {
                                isArticle = false;
                            }
                        }
                        else
                        {
                            if (Article.Art_Ean13.ToUpper().StartsWith(this.TextBoxSearchArticleEan13.Text.ToUpper()) == false)
                            {
                                isArticle = false;
                            }
                        }
                    }
                    else
                    {
                        isArticle = false;
                    }
                }
                if (this.TextBoxSearchArticleRef.Text != "" && this.TextBoxSearchArticleRef.Text.Replace("%", "") != "")
                {
                    if (this.TextBoxSearchArticleRef.Text.Contains("%"))
                    {
                        if (Article.Art_Ref.ToUpper().Contains(this.TextBoxSearchArticleRef.Text.Replace("%", "").ToUpper()) == false)
                        {
                            isArticle = false;
                        }
                    }
                    else
                    {
                        if (Article.Art_Ref.ToUpper().StartsWith(this.TextBoxSearchArticleRef.Text.ToUpper()) == false)
                        {
                            isArticle = false;
                        }
                    }
                }

                if (Article.Art_Sync != this.CheckBoxSearchArticleSync.IsChecked)
                {
                    isArticle = false;
                }
                if (Article.Art_Active != this.CheckBoxSearchArticleActif.IsChecked)
                {
                    isArticle = false;
                }
                if (isArticle == true)
                {
                    ListArticleDisplay.Add(Article);
                }
            }
            this.DataGridArticle.ItemsSource = ListArticleDisplay;
        }
Example #4
0
        public ImportSageArticle(List <Int32> ListArticleSend, Model.Local.Catalog Catalogue)
        {
            this.InitializeComponent();
            this.ListArticle = ListArticleSend;
            this.CatId       = (Catalogue != null) ? Catalogue.Cat_Id : 0;

            Model.Sage.F_ARTICLERepository    F_ARTICLERepository = new Model.Sage.F_ARTICLERepository();
            List <Model.Sage.F_ARTICLE_Light> ListF_ARTICLE       = F_ARTICLERepository.ListLight();

            ListF_ARTICLE = ListF_ARTICLE.AsParallel().Where(a => ListArticleSend.Contains(a.cbMarq)).AsParallel().ToList();

            ListF_ARTICLE = Core.Tools.FiltreImportSage.ImportSageFilter(ListF_ARTICLE);

            List <string> list_arref = ListF_ARTICLE.Select(a => a.AR_Ref).ToList();

            // ajout pré-import gammes / conditionnements
            // !!! traitement en parallèle déconseillé !!!
            // occurences d'énumérés pouvant se recouper entre les articles

            List <short?> gammes = new List <short?>();

            gammes.AddRange(ListF_ARTICLE.Where(a => a.AR_Gamme1 != null && a.AR_Gamme1 != 0).Select(a => a.AR_Gamme1).Distinct());
            gammes.AddRange(ListF_ARTICLE.Where(a => a.AR_Gamme2 != null && a.AR_Gamme2 != 0).Select(a => a.AR_Gamme2).Distinct());

            // import gammes
            ImportSageGamme importsagegamme = new ImportSageGamme(gammes);

            importsagegamme.ShowDialog();

            // import énumérés de gammes
            List <Model.Sage.F_ARTENUMREF> declinaisons = new Model.Sage.F_ARTENUMREFRepository().List().ToList();

                        #if !(SAGE_VERSION_16 || SAGE_VERSION_17)
            declinaisons = declinaisons.Where(d => d.AE_Sommeil == 0).ToList();
                        #endif

            declinaisons = Core.Tools.FiltreImportSage.ImportSageFilter(declinaisons);

            List <Model.Sage.F_ARTGAMME> enumeres_gammes = new Model.Sage.F_ARTGAMMERepository().List();
            List <int> localAttribute = new Model.Local.AttributeRepository().List().Select(a => a.Sag_Id).AsParallel().ToList();
            enumeres_gammes = enumeres_gammes.AsParallel().Where(e => list_arref.Contains(e.AR_Ref) &&
                                                                 !localAttribute.Contains(e.cbMarq) &&
                                                                 declinaisons.Count(d => d.AG_No1 == e.AG_No || d.AG_No2 == e.AG_No) > 0).ToList();

            enumeres_gammes = Core.Tools.FiltreImportSage.ImportSageFilter(enumeres_gammes);

            ImportSageGammeEnumere importsagegammeenumere = new ImportSageGammeEnumere(enumeres_gammes);
            importsagegammeenumere.ShowDialog();

            // import conditionnements
            if (Core.Global.GetConfig().ArticleImportConditionnementActif)
            {
                List <short?>             conditionnements          = ListF_ARTICLE.Where(a => a.AR_Condition != null && a.AR_Condition != 0).Select(a => a.AR_Condition).Distinct().ToList();
                ImportSageConditionnement importsageconditionnement = new ImportSageConditionnement(conditionnements);
                importsageconditionnement.ShowDialog();

                List <Model.Sage.F_CONDITION> enumeres_conditionnement = new Model.Sage.F_CONDITIONRepository().List();
                List <int> localConditioning = new Model.Local.ConditioningRepository().List().Select(c => c.Sag_Id).AsParallel().ToList();
                enumeres_conditionnement = enumeres_conditionnement.AsParallel().Where(e => list_arref.Contains(e.AR_Ref) &&
                                                                                       !localConditioning.Contains(e.cbMarq)).ToList();

                enumeres_conditionnement = Core.Tools.FiltreImportSage.ImportSageFilter(enumeres_conditionnement);

                ImportSageConditionnementEnumere importsageconditionnementenumere = new ImportSageConditionnementEnumere(enumeres_conditionnement);
                importsageconditionnementenumere.ShowDialog();
            }
            // fin

            this.ListCount = ListF_ARTICLE.Count;
            Context        = SynchronizationContext.Current;
            this.ParallelOptions.MaxDegreeOfParallelism = MaximumThreadCount;
            this.ReportProgress(0);
            Task.Factory.StartNew(() =>
            {
                Parallel.ForEach(ListF_ARTICLE, this.ParallelOptions, Sync);
            });
        }