コード例 #1
0
 public byte?ExecCover(uint pdt, bool cov, Model.Prestashop.PsImageRepository PsImageRepository, Model.Prestashop.PsImage PsImageCurrent)
 {
     if (cov)
     {
         if (PsImageRepository.ExistProductCover(pdt, Convert.ToByte(cov)))
         {
             Model.Prestashop.PsImageShopRepository PsImageShopRepository = new Model.Prestashop.PsImageShopRepository();
             Model.Prestashop.PsImageShop           PsImageShop;
             foreach (Model.Prestashop.PsImage PsImage in PsImageRepository.ListProduct(pdt))
             {
                 if (PsImage.IDImage != PsImageCurrent.IDImage)
                 {
                     PsImage.Cover = (byte?)null;
                     if (PsImageShopRepository.ExistImage(PsImage.IDImage))
                     {
                         PsImageShop       = PsImageShopRepository.ReadImage(PsImage.IDImage);
                         PsImageShop.Cover = PsImage.Cover;
                     }
                 }
             }
             PsImageShopRepository.Save();
             PsImageRepository.Save();
         }
     }
     return((cov) ? Convert.ToByte(cov) : (byte?)null);
 }
コード例 #2
0
 public byte ExecCover(uint pdt, bool cov, Model.Prestashop.PsImageRepository PsImageRepository, Model.Prestashop.PsImage PsImageCurrent)
 {
     if (cov)
     {
         if (PsImageRepository.ExistProductCover(pdt, Convert.ToByte(cov)))
         {
             Model.Prestashop.PsImageShopRepository PsImageShopRepository = new Model.Prestashop.PsImageShopRepository();
             Model.Prestashop.PsImageShop           PsImageShop;
             foreach (Model.Prestashop.PsImage PsImage in PsImageRepository.ListProduct(pdt))
             {
                 if (PsImage.IDImage != PsImageCurrent.IDImage)
                 {
                     PsImage.Cover = Convert.ToByte(false);
                     if (PsImageShopRepository.ExistImage(PsImage.IDImage))
                     {
                         PsImageShop = PsImageShopRepository.ReadImage(PsImage.IDImage);
                                                         #if (PRESTASHOP_VERSION_160)
                         PsImageShop.Cover = (sbyte)PsImage.Cover;
                                                         #else
                         PsImageShop.Cover = PsImage.Cover;
                                                         #endif
                     }
                 }
             }
             PsImageShopRepository.Save();
             PsImageRepository.Save();
         }
     }
     return(Convert.ToByte(cov));
 }
コード例 #3
0
        private void ExecImage(string FTP, string User, string Password, Model.Local.Article Article, Model.Local.ArticleImage ArticleImage, Model.Local.ArticleImageRepository ArticleImageRepository)
        {
            Model.Prestashop.PsImageRepository     PsImageRepository     = new Model.Prestashop.PsImageRepository();
            Model.Prestashop.PsImage               PsImage               = null;
            Model.Prestashop.PsImageLangRepository PsImageLangRepository = new Model.Prestashop.PsImageLangRepository();
            Model.Prestashop.PsImageLang           PsImageLang;
            Boolean isImageLang = false;

            Model.Prestashop.PsImageTypeRepository PsImageTypeRepository = new Model.Prestashop.PsImageTypeRepository();
            List <Model.Prestashop.PsImageType>    ListPsImageType       = PsImageTypeRepository.ListProduct(1);

            try
            {
                if (ArticleImage.Pre_Id == null)
                {
                    PsImage = new Model.Prestashop.PsImage();

                    PsImage.IDProduct = Convert.ToUInt32(Article.Pre_Id);
                    PsImage.Position  = (ushort)ExecPosition((uint)Article.Pre_Id.Value, (uint)ArticleImage.ImaArt_Position, PsImageRepository, PsImage);
                    PsImage.Cover     = ExecCover((uint)Article.Pre_Id.Value, ArticleImage.ImaArt_Default, PsImageRepository, PsImage);
                    PsImageRepository.Add(PsImage, Global.CurrentShop.IDShop);

                    #region lang
                    isImageLang = false;
                    PsImageLang = new Model.Prestashop.PsImageLang();
                    if (PsImageLangRepository.ExistImageLang(PsImage.IDImage, Core.Global.Lang))
                    {
                        PsImageLang = PsImageLangRepository.ReadImageLang(PsImage.IDImage, Core.Global.Lang);
                        isImageLang = true;
                    }
                    PsImageLang.Legend = ArticleImage.ImaArt_Name;
                    if (isImageLang == true)
                    {
                        PsImageLangRepository.Save();
                    }
                    else
                    {
                        PsImageLang.IDImage = PsImage.IDImage;
                        PsImageLang.IDLang  = Core.Global.Lang;
                        PsImageLangRepository.Add(PsImageLang);
                    }
                    // <JG> 26/12/2012 ajout insertion autres langues actives si non renseignées
                    try
                    {
                        Model.Prestashop.PsLangRepository PsLangRepository = new Model.Prestashop.PsLangRepository();
                        foreach (Model.Prestashop.PsLang PsLang in PsLangRepository.ListActive(1, Global.CurrentShop.IDShop))
                        {
                            if (!PsImageLangRepository.ExistImageLang(PsImage.IDImage, PsLang.IDLang))
                            {
                                PsImageLang = new Model.Prestashop.PsImageLang()
                                {
                                    IDImage = PsImage.IDImage,
                                    IDLang  = PsLang.IDLang,
                                    Legend  = ArticleImage.ImaArt_Name
                                };
                                PsImageLangRepository.Add(PsImageLang);
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Core.Error.SendMailError(ex.ToString());
                    }
                    #endregion

                    try
                    {
                        // <JG> 10/04/2013 gestion système d'images
                        string ftpPath = "/img/p/";
                        switch (Core.Global.GetConfig().ConfigImageStorageMode)
                        {
                        case Core.Parametres.ImageStorageMode.old_system:
                            #region old_system
                            // no action on path
                            break;
                            #endregion

                        case Core.Parametres.ImageStorageMode.new_system:
                        default:
                            #region new_system

                            //System.Net.FtpWebRequest ftp_folder = null;

                            foreach (char directory in PsImage.IDImage.ToString())
                            {
                                ftpPath += directory + "/";

                                #region MyRegion
                                try
                                {
                                    FtpWebRequest request = (FtpWebRequest)FtpWebRequest.Create(FTP + ftpPath);

                                    request.Credentials = new NetworkCredential(User, Password);
                                    request.UsePassive  = true;
                                    request.UseBinary   = true;
                                    request.KeepAlive   = false;
                                    request.EnableSsl   = Core.Global.GetConfig().ConfigFTPSSL;

                                    request.Method = WebRequestMethods.Ftp.MakeDirectory;

                                    FtpWebResponse makeDirectoryResponse = (FtpWebResponse)request.GetResponse();
                                }
                                catch     //Exception ex
                                {
                                    //System.Windows.MessageBox.Show(ex.ToString());
                                }
                                #endregion

                                //try
                                //{
                                //    ftp_folder = (System.Net.FtpWebRequest)System.Net.FtpWebRequest.Create(FTP + ftpPath);

                                //    ftp_folder.Credentials = new System.Net.NetworkCredential(User, Password);
                                //    ftp_folder.UseBinary = true;
                                //    ftp_folder.UsePassive = true;
                                //    ftp_folder.KeepAlive = false;
                                //    ftp_folder.Method = System.Net.WebRequestMethods.Ftp.MakeDirectory;

                                //    System.Net.FtpWebResponse response = (System.Net.FtpWebResponse)ftp_folder.GetResponse();
                                //    System.IO.Stream ftpStream = response.GetResponseStream();

                                //    ftpStream.Close();
                                //    response.Close();
                                //}
                                //catch(Exception ex)
                                //{
                                //    System.Windows.MessageBox.Show(ex.ToString());
                                //}
                            }
                            break;
                            #endregion
                        }

                        #region Upload des images
                        String extension = ArticleImage.GetExtension;
                        if (System.IO.File.Exists(ArticleImage.TempFileName))
                        {
                            string ftpfullpath = (Core.Global.GetConfig().ConfigImageStorageMode == Core.Parametres.ImageStorageMode.old_system)
                                ? FTP + ftpPath + PsImage.IDProduct + "-" + PsImage.IDImage + ".jpg"
                                : FTP + ftpPath + PsImage.IDImage + ".jpg";

                            System.Net.FtpWebRequest ftp = (System.Net.FtpWebRequest)System.Net.FtpWebRequest.Create(ftpfullpath);
                            ftp.Credentials = new System.Net.NetworkCredential(User, Password);
                            //userid and password for the ftp server to given

                            ftp.UseBinary  = true;
                            ftp.UsePassive = true;
                            ftp.EnableSsl  = Core.Global.GetConfig().ConfigFTPSSL;
                            ftp.Method     = System.Net.WebRequestMethods.Ftp.UploadFile;
                            System.IO.FileStream fs = System.IO.File.OpenRead(ArticleImage.TempFileName);
                            byte[] buffer           = new byte[fs.Length];
                            fs.Read(buffer, 0, buffer.Length);
                            fs.Close();
                            System.IO.Stream ftpstream = ftp.GetRequestStream();
                            ftpstream.Write(buffer, 0, buffer.Length);
                            ftpstream.Close();
                            ftp.Abort();
                        }

                        foreach (Model.Prestashop.PsImageType PsImageType in ListPsImageType)
                        {
                            String PathImg = ArticleImage.FileName(PsImageType.Name);
                            if (System.IO.File.Exists(PathImg))
                            {
                                string ftpfullpath = (Core.Global.GetConfig().ConfigImageStorageMode == Core.Parametres.ImageStorageMode.old_system)
                                    ? FTP + ftpPath + PsImage.IDProduct + "-" + PsImage.IDImage + "-" + PsImageType.Name + ".jpg"
                                    : FTP + ftpPath + PsImage.IDImage + "-" + PsImageType.Name + ".jpg";

                                System.Net.FtpWebRequest ftp = (System.Net.FtpWebRequest)System.Net.FtpWebRequest.Create(ftpfullpath);
                                ftp.Credentials = new System.Net.NetworkCredential(User, Password);
                                //userid and password for the ftp server to given

                                ftp.UseBinary  = true;
                                ftp.UsePassive = true;
                                ftp.EnableSsl  = Core.Global.GetConfig().ConfigFTPSSL;
                                ftp.Method     = System.Net.WebRequestMethods.Ftp.UploadFile;
                                System.IO.FileStream fs = System.IO.File.OpenRead(PathImg);
                                byte[] buffer           = new byte[fs.Length];
                                fs.Read(buffer, 0, buffer.Length);
                                fs.Close();
                                System.IO.Stream ftpstream = ftp.GetRequestStream();
                                ftpstream.Write(buffer, 0, buffer.Length);
                                ftpstream.Close();
                                ftp.Abort();
                            }
                        }
                        #endregion

                        ArticleImage.Pre_Id = Convert.ToInt32(PsImage.IDImage);
                        ArticleImageRepository.Save();
                    }
                    catch (Exception ex)
                    {
                        Core.Error.SendMailError("[UPLOAD FTP IMAGE ARTICLE]<br />" + ex.ToString());
                        PsImageLangRepository.DeleteAll(PsImageLangRepository.ListImage(PsImage.IDImage));
                        PsImageRepository.Delete(PsImage);
                    }
                }
                // option car si PAS GADA écrase infos PS
                else if (Core.Global.GetConfig().ConfigImageSynchroPositionLegende)
                {
                    PsImage = new Model.Prestashop.PsImage();
                    if (PsImageRepository.ExistImage((uint)ArticleImage.Pre_Id))
                    {
                        PsImage = PsImageRepository.ReadImage((uint)ArticleImage.Pre_Id);
                        if (PsImage.Position != (UInt16)ArticleImage.ImaArt_Position ||
                            PsImage.Cover !=
                                                                #if (PRESTASHOP_VERSION_172 || PRESTASHOP_VERSION_161)
                            ((ArticleImage.ImaArt_Default) ? Convert.ToByte(ArticleImage.ImaArt_Default) : (byte?)null))
                                                                #else
                            Convert.ToByte(ArticleImage.ImaArt_Default))
                                                                #endif
                        {
                            PsImage.Position = (ushort)ExecPosition((uint)Article.Pre_Id, (uint)ArticleImage.ImaArt_Position, PsImageRepository, PsImage);
                            PsImage.Cover    = ExecCover((uint)Article.Pre_Id, ArticleImage.ImaArt_Default, PsImageRepository, PsImage);
                            PsImageRepository.Save();

                            Model.Prestashop.PsImageShopRepository PsImageShopRepository = new Model.Prestashop.PsImageShopRepository();
                            Model.Prestashop.PsImageShop           PsImageShop           = PsImageShopRepository.ReadImage(PsImage.IDImage);
                            if (PsImageShop != null && PsImageShop.Cover !=
                                                                #if (PRESTASHOP_VERSION_160)
                                (sbyte)PsImage.Cover
                                                                #else
                                PsImage.Cover
                                                                #endif
                                )
                            {
                                                                #if (PRESTASHOP_VERSION_160)
                                PsImageShop.Cover = (sbyte)PsImage.Cover;
                                                                #else
                                PsImageShop.Cover = PsImage.Cover;
                                                                #endif
                                PsImageShopRepository.Save();
                            }
                        }

                        #region lang
                        PsImageLang = new Model.Prestashop.PsImageLang();
                        isImageLang = false;
                        if (PsImageLangRepository.ExistImageLang(PsImage.IDImage, Core.Global.Lang))
                        {
                            PsImageLang = PsImageLangRepository.ReadImageLang(PsImage.IDImage, Core.Global.Lang);
                            isImageLang = true;
                        }
                        PsImageLang.Legend = ArticleImage.ImaArt_Name;
                        if (isImageLang == true)
                        {
                            PsImageLangRepository.Save();
                        }
                        else
                        {
                            PsImageLang.IDImage = PsImage.IDImage;
                            PsImageLang.IDLang  = Core.Global.Lang;
                            PsImageLangRepository.Add(PsImageLang);
                        }
                        // <JG> 26/12/2012 ajout insertion autres langues actives si non renseignées
                        try
                        {
                            Model.Prestashop.PsLangRepository PsLangRepository = new Model.Prestashop.PsLangRepository();
                            foreach (Model.Prestashop.PsLang PsLang in PsLangRepository.ListActive(1, Global.CurrentShop.IDShop))
                            {
                                if (!PsImageLangRepository.ExistImageLang(PsImage.IDImage, PsLang.IDLang))
                                {
                                    PsImageLang = new Model.Prestashop.PsImageLang()
                                    {
                                        IDImage = PsImage.IDImage,
                                        IDLang  = PsLang.IDLang,
                                        Legend  = ArticleImage.ImaArt_Name
                                    };
                                    PsImageLangRepository.Add(PsImageLang);
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            Core.Error.SendMailError(ex.ToString());
                        }
                        #endregion
                    }
                }
            }
            catch (Exception ex)
            {
                Core.Error.SendMailError("[SYNCHRO IMAGE ARTICLE]<br />" + ex.ToString());

                if (PsImage != null)
                {
                    PsImageLangRepository.DeleteAll(PsImageLangRepository.ListImage(PsImage.IDImage));
                    PsImageRepository.Delete(PsImage);
                }
            }
        }
コード例 #4
0
        public void Exec(Model.Local.ArticleImage ArticleImage, Model.Local.Article Article, out List <string> log_out)
        {
            log_out = new List <string>();
            try
            {
                // Suppression de l'affectation de l'image à la gamme en local
                Model.Local.AttributeArticleImageRepository AttributeArticleImageRepository = new Model.Local.AttributeArticleImageRepository();
                AttributeArticleImageRepository.DeleteAll(AttributeArticleImageRepository.ListImageArticle(ArticleImage.ImaArt_Id));

                // 07/04/2016 ajout suppression liens compositions
                Model.Local.CompositionArticleImageRepository CompositionArticleImageRepository = new Model.Local.CompositionArticleImageRepository();
                CompositionArticleImageRepository.DeleteAll(CompositionArticleImageRepository.ListImageArticle(ArticleImage.ImaArt_Id));

                // Suppression des fichiers images en local
                if (File.Exists(ArticleImage.SmallFileName))
                {
                    try { File.Delete(ArticleImage.SmallFileName); }
                    catch (Exception ex) { Core.Error.SendMailError(ex.ToString()); }
                }
                if (File.Exists(ArticleImage.TempFileName))
                {
                    try { File.Delete(ArticleImage.TempFileName); }
                    catch (Exception ex) { Core.Error.SendMailError(ex.ToString()); }
                }

                string folder = (Core.Global.GetConfig().ConfigLocalStorageMode == Core.Parametres.LocalStorageMode.advanced_system)
                    ? ArticleImage.advanced_folder
                    : Core.Global.GetConfig().Folders.RootArticle;

                foreach (var fileName in Directory.GetFiles(folder, String.Format("{0}-*" + ArticleImage.GetExtension, ArticleImage.ImaArt_Id)))
                {
                    try { File.Delete(fileName); }
                    catch (Exception ex) { Core.Error.SendMailError(ex.ToString()); }
                }

                if (ArticleImage.Pre_Id != null && ArticleImage.Pre_Id > 0)
                {
                    Model.Prestashop.PsProductAttributeImageRepository PsProductAttributeImageRepository = new Model.Prestashop.PsProductAttributeImageRepository();
                    PsProductAttributeImageRepository.DeleteAll(PsProductAttributeImageRepository.ListImage((uint)ArticleImage.Pre_Id));

                    Model.Prestashop.PsImageLangRepository PsImageLangRepository = new Model.Prestashop.PsImageLangRepository();
                    PsImageLangRepository.DeleteAll(PsImageLangRepository.ListImage((uint)ArticleImage.Pre_Id));

                    // Suppression de l'occurence de l'image sur prestashop
                    Model.Prestashop.PsImageRepository PsImageRepository = new Model.Prestashop.PsImageRepository();
                    Model.Prestashop.PsImage           PsImage           = PsImageRepository.ReadImage((uint)ArticleImage.Pre_Id);

                    if (PsImage != null)
                    {
                        PsImageRepository.Delete(PsImage);

                        try
                        {
                            if (PsImage.Cover == 1 &&
                                !PsImageRepository.ExistProductCover(PsImage.IDProduct, 1) &&
                                PsImageRepository.ExistProduct(PsImage.IDProduct))
                            {
                                List <Model.Prestashop.PsImage> Others   = PsImageRepository.ListProduct(PsImage.IDProduct);
                                Model.Prestashop.PsImage        NewCover = Others.OrderBy(i => i.Position).FirstOrDefault();
                                if (NewCover != null)
                                {
                                    NewCover.Cover = 1;
                                    PsImageRepository.Save();

                                    Core.Transfert.TransfertArticleImage syncimage = new Core.Transfert.TransfertArticleImage();
                                    syncimage.ExecCover(PsImage.IDProduct, true, PsImageRepository, NewCover);

                                    Model.Prestashop.PsImageShopRepository PsImageShopRepository = new Model.Prestashop.PsImageShopRepository();
                                    foreach (Model.Prestashop.PsImageShop PsImageShop in PsImageShopRepository.List(NewCover.IDImage))
                                    {
                                        PsImageShop.Cover = 1;
                                    }
                                    PsImageShopRepository.Save();
                                }
                            }
                        }
                        catch
                        {
                            log_out.Add("II47- Erreur durant la réaffectation de l'image de couverture dans PrestaShop pour l'article " + Article.Art_Ref);
                        }
                        try
                        {
                            foreach (Model.Prestashop.PsImage Image in PsImageRepository.ListProduct(PsImage.IDProduct).Where(i => i.Position > PsImage.Position))
                            {
                                Image.Position--;
                            }
                            PsImageRepository.Save();
                        }
                        catch
                        {
                            log_out.Add("II48- Erreur durant le recalcul des positions dans PrestaShop pour les images de l'article " + Article.Art_Ref);
                        }

                        // Suppression des fichiers images sur prestashop
                        if (Core.Global.GetConfig().ConfigFTPActive)
                        {
                            String FTP      = Core.Global.GetConfig().ConfigFTPIP;
                            String User     = Core.Global.GetConfig().ConfigFTPUser;
                            String Password = Core.Global.GetConfig().ConfigFTPPassword;

                            // <JG> 10/04/2013 gestion système d'images
                            string ftpPath = "/img/p/";
                            switch (Core.Global.GetConfig().ConfigImageStorageMode)
                            {
                            case Core.Parametres.ImageStorageMode.old_system:
                                #region old_system
                                // no action on path
                                break;
                                #endregion

                            case Core.Parametres.ImageStorageMode.new_system:
                            default:
                                #region new_system

                                foreach (char directory in ArticleImage.Pre_Id.ToString())
                                {
                                    ftpPath += directory + "/";
                                }
                                break;
                                #endregion
                            }

                            // <JG> 21/05/2013 correct for 1.5 storage mode
                            string ftpfullpath = (Core.Global.GetConfig().ConfigImageStorageMode == Core.Parametres.ImageStorageMode.old_system)
                                ? FTP + ftpPath + Article.Pre_Id + "-" + ArticleImage.Pre_Id + ".jpg"
                                : FTP + ftpPath + ArticleImage.Pre_Id + ".jpg";

                            FtpWebRequest request = (FtpWebRequest)FtpWebRequest.Create(ftpfullpath);
                            request.Credentials = new System.Net.NetworkCredential(User, Password);
                            request.Method      = WebRequestMethods.Ftp.DeleteFile;
                            request.UseBinary   = true;
                            request.UsePassive  = true;
                            request.KeepAlive   = false;

                            FtpWebResponse response = (FtpWebResponse)request.GetResponse();
                            response.Close();

                            Model.Prestashop.PsImageTypeRepository PsImageTypeRepository = new Model.Prestashop.PsImageTypeRepository();
                            List <Model.Prestashop.PsImageType>    ListPsImageType       = PsImageTypeRepository.ListProduct(1);

                            foreach (Model.Prestashop.PsImageType PsImageType in ListPsImageType)
                            {
                                try
                                {
                                    // <JG> 21/05/2013 correct for 1.5 storage mode
                                    ftpfullpath = (Core.Global.GetConfig().ConfigImageStorageMode == Core.Parametres.ImageStorageMode.old_system)
                                        ? FTP + ftpPath + Article.Pre_Id + "-" + ArticleImage.Pre_Id + "-" + PsImageType.Name + ".jpg"
                                        : FTP + ftpPath + ArticleImage.Pre_Id + "-" + PsImageType.Name + ".jpg";

                                    request             = (System.Net.FtpWebRequest)System.Net.FtpWebRequest.Create(ftpfullpath);
                                    request.Credentials = new System.Net.NetworkCredential(User, Password);
                                    request.Method      = WebRequestMethods.Ftp.DeleteFile;
                                    request.UseBinary   = true;
                                    request.UsePassive  = true;
                                    request.KeepAlive   = false;

                                    response = (FtpWebResponse)request.GetResponse();
                                    response.Close();
                                }
                                catch {}
                            }
                        }
                    }
                }

                // Suppression de l'occurence de l'image en local
                Model.Local.ArticleImageRepository ArticleImageRepository = new Model.Local.ArticleImageRepository();
                Model.Local.ArticleImage           articleImage           = ArticleImageRepository.ReadArticleImage(ArticleImage.ImaArt_Id);

                if (articleImage != null)
                {
                    ArticleImageRepository.Delete(articleImage);

                    try
                    {
                        if (articleImage.ImaArt_Default &&
                            !ArticleImageRepository.ExistArticleDefault(Article.Art_Id, true) &&
                            ArticleImageRepository.ExistArticle(Article.Art_Id))
                        {
                            Model.Local.ArticleImage NewCover = ArticleImageRepository.ListArticle(Article.Art_Id).OrderBy(i => i.ImaArt_Position).FirstOrDefault();
                            if (NewCover != null)
                            {
                                NewCover.ImaArt_Default = true;
                                ArticleImageRepository.Save();
                            }
                        }
                    }
                    catch
                    {
                        log_out.Add("II43- Erreur durant la réaffectation de l'image de couverture dans PrestaConnect pour l'article " + Article.Art_Ref);
                    }
                    try
                    {
                        foreach (Model.Local.ArticleImage Image in ArticleImageRepository.ListArticle(Article.Art_Id).Where(i => i.ImaArt_Position > articleImage.ImaArt_Position))
                        {
                            Image.ImaArt_Position--;
                        }
                        ArticleImageRepository.Save();
                    }
                    catch
                    {
                        log_out.Add("II44- Erreur durant le recalcul des positions dans PrestaConnect pour les images de l'article " + Article.Art_Ref);
                    }
                }

                log_out.Add("II40- Suppression de l'image " + ArticleImage.ImaArt_SourceFile + " en position " + ArticleImage.ImaArt_Position + " pour l'article " + Article.Art_Ref);
            }
            catch (Exception ex)
            {
                Core.Error.SendMailError(ex.ToString());
            }
        }