private void ExecLocalToDistant(Model.Local.Article Article) { try { String FTP = Core.Global.GetConfig().ConfigFTPIP; String User = Core.Global.GetConfig().ConfigFTPUser; String Password = Core.Global.GetConfig().ConfigFTPPassword; Model.Local.ArticleImageRepository ArticleImageRepository = new Model.Local.ArticleImageRepository(); List <Model.Local.ArticleImage> ListArticleImage = ArticleImageRepository.ListArticle(Article.Art_Id); foreach (Model.Local.ArticleImage ArticleImage in ListArticleImage) { ExecImage(FTP, User, Password, Article, ArticleImage, ArticleImageRepository); } } catch (Exception ex) { Core.Error.SendMailError(ex.ToString()); } }
/// <summary> /// ExecArticle - Supprime toutes les images d'un article /// </summary> /// <param name="ArticleSend"></param> public void ExecArticle(Int32 ArticleSend, Boolean OnlyIfNotSourceExist, out List <string> log_out) { log_out = new List <string>(); try { Model.Local.ArticleRepository ArticleRepository = new Model.Local.ArticleRepository(); if (ArticleRepository.ExistArticle(ArticleSend)) { Model.Local.ArticleImageRepository ArticleImageRepository = new Model.Local.ArticleImageRepository(); List <Model.Local.ArticleImage> List = ArticleImageRepository.ListArticle(ArticleSend); if (List != null) { Model.Local.Article Article = ArticleRepository.ReadArticle(ArticleSend); foreach (Model.Local.ArticleImage ArticleImage in List) { List <string> log = null; if (OnlyIfNotSourceExist) { if (!System.IO.File.Exists(System.IO.Path.Combine(Core.Global.GetConfig().AutomaticImportFolderPicture, ArticleImage.ImaArt_SourceFile))) { Exec(ArticleImage, Article, out log); } } else { Exec(ArticleImage, Article, out log); } if (log != null && log.Count > 0) { log_out.AddRange(log); } } } } } catch (Exception ex) { Core.Error.SendMailError(ex.ToString()); } }
private void ExecAttributeImage(Model.Local.Article Article) { Model.Local.ArticleImageRepository ArticleImageRepository = new Model.Local.ArticleImageRepository(); List <Model.Local.ArticleImage> ListArticleImage = ArticleImageRepository.ListArticle(Article.Art_Id); Model.Local.AttributeArticleImageRepository AttributeArticleImageRepository = new Model.Local.AttributeArticleImageRepository(); Model.Local.CompositionArticleImageRepository CompositionArticleImageRepository = new Model.Local.CompositionArticleImageRepository(); Model.Prestashop.PsProductAttributeImageRepository PsProductAttributeImageRepository = new Model.Prestashop.PsProductAttributeImageRepository(); Model.Prestashop.PsImageRepository PsImageRepository = new Model.Prestashop.PsImageRepository(); Model.Local.AttributeArticle AttributeArticle = new Model.Local.AttributeArticle(); Model.Local.CompositionArticle CompositionArticle = new Model.Local.CompositionArticle(); foreach (Model.Local.ArticleImage ArticleImage in ListArticleImage) { if (ArticleImage.Pre_Id != null && PsImageRepository.ExistImage((uint)ArticleImage.Pre_Id.Value)) { List <Model.Local.AttributeArticleImage> ListAttributeArticleImage = AttributeArticleImageRepository.ListImageArticle(ArticleImage.ImaArt_Id); List <Model.Local.CompositionArticleImage> ListCompositionArticleImage = CompositionArticleImageRepository.ListImageArticle(ArticleImage.ImaArt_Id); #region suppression lien image déclinaison PrestaShop Model.Local.AttributeArticleRepository AttributeArticleRepository = new Model.Local.AttributeArticleRepository(); Model.Local.CompositionArticleRepository CompositionArticleRepository = new Model.Local.CompositionArticleRepository(); // liste des liens images déclinaisons Prestashop foreach (Model.Prestashop.PsProductAttributeImage PsProductAttributeImage in PsProductAttributeImageRepository.ListImage((uint)ArticleImage.Pre_Id)) { // si la déclinaison existe dans PrestaConnect if (AttributeArticleRepository.ExistPrestashop((int)PsProductAttributeImage.IDProductAttribute)) { AttributeArticle = AttributeArticleRepository.ReadPrestashop((int)PsProductAttributeImage.IDProductAttribute); // si dans prestaconnect la déclinaison n'est pas liée à l'image if (!AttributeArticleImageRepository.ExistAttributeArticleImage(AttributeArticle.AttArt_Id, ArticleImage.ImaArt_Id)) { // suppression du lien dans PrestaShop PsProductAttributeImageRepository.Delete(PsProductAttributeImage); } } else if (CompositionArticleRepository.ExistPrestaShop((int)PsProductAttributeImage.IDProductAttribute)) { CompositionArticle = CompositionArticleRepository.ReadPrestaShop((int)PsProductAttributeImage.IDProductAttribute); // si dans prestaconnect la déclinaison n'est pas liée à l'image if (!CompositionArticleImageRepository.ExistCompositionArticleImage(CompositionArticle.ComArt_Id, ArticleImage.ImaArt_Id)) { // suppression du lien dans PrestaShop PsProductAttributeImageRepository.Delete(PsProductAttributeImage); } } } #endregion // affectation image déclinaison foreach (Model.Local.AttributeArticleImage AttributeArticleImage in ListAttributeArticleImage) { if (AttributeArticleImage.AttributeArticle.Pre_Id != null && AttributeArticleImage.AttributeArticle.Pre_Id != 0) { if (PsProductAttributeImageRepository.ExistProductAttributeImage((UInt32)AttributeArticleImage.AttributeArticle.Pre_Id, (UInt32)AttributeArticleImage.ArticleImage.Pre_Id) == false) { PsProductAttributeImageRepository.Add(new Model.Prestashop.PsProductAttributeImage() { IDImage = (UInt32)AttributeArticleImage.ArticleImage.Pre_Id, IDProductAttribute = (UInt32)AttributeArticleImage.AttributeArticle.Pre_Id, }); } } } foreach (Model.Local.CompositionArticleImage CompositionArticleImage in ListCompositionArticleImage) { if (CompositionArticleImage.CompositionArticle.Pre_Id != null && CompositionArticleImage.CompositionArticle.Pre_Id != 0) { if (PsProductAttributeImageRepository.ExistProductAttributeImage((UInt32)CompositionArticleImage.CompositionArticle.Pre_Id, (UInt32)CompositionArticleImage.ArticleImage.Pre_Id) == false) { PsProductAttributeImageRepository.Add(new Model.Prestashop.PsProductAttributeImage() { IDImage = (UInt32)CompositionArticleImage.ArticleImage.Pre_Id, IDProductAttribute = (UInt32)CompositionArticleImage.CompositionArticle.Pre_Id, }); } } } } } }
public void Exec(Int32 ImageSend) { try { Model.Local.ArticleImageRepository ArticleImageRepository = new Model.Local.ArticleImageRepository(); if (ArticleImageRepository.ExistPre_Id(ImageSend) == false) { Model.Prestashop.PsImageRepository PsImageRepository = new Model.Prestashop.PsImageRepository(); Model.Prestashop.PsImage PsImage = PsImageRepository.ReadImage(Convert.ToUInt32(ImageSend)); Model.Local.ArticleRepository ArticleRepository = new Model.Local.ArticleRepository(); if (ArticleRepository.ExistPre_Id(Convert.ToInt32(PsImage.IDProduct))) { Model.Local.Article Article = ArticleRepository.ReadPre_Id(Convert.ToInt32(PsImage.IDProduct)); Model.Prestashop.PsImageLangRepository PsImageLangRepository = new Model.Prestashop.PsImageLangRepository(); if (PsImageLangRepository.ExistImageLang(Convert.ToUInt32(ImageSend), Core.Global.Lang)) { string extension = Core.Img.jpgExtension; String FTP = Core.Global.GetConfig().ConfigFTPIP; String User = Core.Global.GetConfig().ConfigFTPUser; String Password = Core.Global.GetConfig().ConfigFTPPassword; Model.Prestashop.PsImageLang PsImageLang = PsImageLangRepository.ReadImageLang(Convert.ToUInt32(ImageSend), Core.Global.Lang); Model.Local.ArticleImage ArticleImage = new Model.Local.ArticleImage() { ImaArt_Name = (!String.IsNullOrEmpty(PsImageLang.Legend)) ? PsImageLang.Legend : Article.Art_Ref, ImaArt_Position = PsImage.Position, ImaArt_Default = Convert.ToBoolean(PsImage.Cover), Pre_Id = Convert.ToInt32(PsImage.IDImage), Art_Id = Article.Art_Id, ImaArt_Image = string.Empty, ImaArt_SourceFile = SearchFreeNameFile(Article.Art_Id, Article.Art_Ref, extension), ImaArt_DateAdd = DateTime.Now }; ArticleImageRepository.Add(ArticleImage); Boolean import_img = false; 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 foreach (char directory in PsImage.IDImage.ToString()) { ftpPath += directory + "/"; } break; #endregion } // <JG> 21/05/2013 import image originale Boolean import_img_tmp = false; try { string ftpfullpath = (Core.Global.GetConfig().ConfigImageStorageMode == Core.Parametres.ImageStorageMode.old_system) ? FTP + ftpPath + PsImage.IDProduct + "-" + PsImage.IDImage + Core.Img.jpgExtension : FTP + ftpPath + PsImage.IDImage + Core.Img.jpgExtension; bool existfile = Core.Ftp.ExistFile(ftpfullpath, User, Password); if (existfile) { System.Net.FtpWebRequest ftp = (System.Net.FtpWebRequest)System.Net.FtpWebRequest.Create(ftpfullpath); ftp.Credentials = new System.Net.NetworkCredential(User, Password); ftp.UseBinary = true; ftp.UsePassive = true; ftp.KeepAlive = false; ftp.EnableSsl = Core.Global.GetConfig().ConfigFTPSSL; System.Net.FtpWebResponse response = (System.Net.FtpWebResponse)ftp.GetResponse(); Stream reader = response.GetResponseStream(); MemoryStream memStream = new MemoryStream(); byte[] buffer = new byte[1024]; byte[] downloadedData = new byte[0]; while (true) { int bytesRead = reader.Read(buffer, 0, buffer.Length); if (bytesRead != 0) { memStream.Write(buffer, 0, bytesRead); } else { break; } downloadedData = memStream.ToArray(); } string target_folder = (Core.Global.GetConfig().ConfigLocalStorageMode == Parametres.LocalStorageMode.simple_system) ? Global.GetConfig().Folders.TempArticle : ArticleImage.advanced_folder; if (downloadedData != null && downloadedData.Length != 0) { FileStream newFile = new FileStream( System.IO.Path.Combine(target_folder, String.Format("{0}" + extension, ArticleImage.ImaArt_Id)), FileMode.Create); newFile.Write(downloadedData, 0, downloadedData.Length); newFile.Close(); newFile.Dispose(); memStream.Dispose(); downloadedData = new byte[0]; } string local_file_tmp = System.IO.Path.Combine(target_folder, String.Format("{0}" + extension, ArticleImage.ImaArt_Id)); // <JG> 30/09/2013 détection encodage PNG lors de l'import Boolean rename_to_png = false; System.Drawing.Image img = System.Drawing.Image.FromFile(local_file_tmp); var imgguid = img.RawFormat.Guid; img.Dispose(); System.Drawing.Imaging.ImageCodecInfo search; foreach (System.Drawing.Imaging.ImageCodecInfo codec in System.Drawing.Imaging.ImageCodecInfo.GetImageDecoders()) { if (codec.FormatID == imgguid) { search = codec; if (search.FormatDescription == "PNG") { rename_to_png = true; } break; } } if (rename_to_png) { if (System.IO.File.Exists(local_file_tmp)) { extension = Core.Img.pngExtension; System.IO.File.Move(local_file_tmp, System.IO.Path.Combine(target_folder, String.Format("{0}" + extension, ArticleImage.ImaArt_Id))); } ArticleImage.ImaArt_SourceFile = SearchFreeNameFile(Article.Art_Id, Article.Art_Ref, extension); } ArticleImage.ImaArt_Image = String.Format("{0}" + extension, ArticleImage.ImaArt_Id); ArticleImageRepository.Save(); Core.Img.resizeImage(new System.Drawing.Bitmap(ArticleImage.TempFileName), Core.Global.GetConfig().ConfigImageMiniatureWidth, Core.Global.GetConfig().ConfigImageMiniatureHeight, ArticleImage.SmallFileName); import_img_tmp = true; } } catch (Exception) { // Not implemented } if (import_img_tmp) { Model.Prestashop.PsImageTypeRepository PsImageTypeRepository = new Model.Prestashop.PsImageTypeRepository(); List <Model.Prestashop.PsImageType> ListPsImageType = PsImageTypeRepository.ListProduct(1); foreach (Model.Prestashop.PsImageType PsImageType in ListPsImageType) { string ftpfullpath = (Core.Global.GetConfig().ConfigImageStorageMode == Core.Parametres.ImageStorageMode.old_system) ? FTP + ftpPath + PsImage.IDProduct + "-" + PsImage.IDImage + "-" + PsImageType.Name + Core.Img.jpgExtension : FTP + ftpPath + PsImage.IDImage + "-" + PsImageType.Name + Core.Img.jpgExtension; System.Net.FtpWebRequest ftp = (System.Net.FtpWebRequest)System.Net.FtpWebRequest.Create(ftpfullpath); ftp.Credentials = new System.Net.NetworkCredential(User, Password); ftp.UseBinary = true; ftp.UsePassive = true; ftp.KeepAlive = false; ftp.EnableSsl = Core.Global.GetConfig().ConfigFTPSSL; System.Net.FtpWebResponse response = (System.Net.FtpWebResponse)ftp.GetResponse(); Stream reader = response.GetResponseStream(); MemoryStream memStream = new MemoryStream(); byte[] buffer = new byte[1024]; byte[] downloadedData = new byte[0]; while (true) { int bytesRead = reader.Read(buffer, 0, buffer.Length); if (bytesRead != 0) { memStream.Write(buffer, 0, bytesRead); } else { break; } downloadedData = memStream.ToArray(); } if (downloadedData != null && downloadedData.Length != 0) { FileStream newFile = new FileStream(ArticleImage.FileName(PsImageType.Name), FileMode.Create); newFile.Write(downloadedData, 0, downloadedData.Length); newFile.Close(); } } import_img = true; // gestion image par défaut if (ArticleImage.ImaArt_Default) { List <Model.Local.ArticleImage> ListArticleImage = ArticleImageRepository.ListArticle(ArticleImage.Art_Id.Value); if (ListArticleImage.Count(i => i.ImaArt_Default == true && i.ImaArt_Id != ArticleImage.ImaArt_Id) > 0) { foreach (Model.Local.ArticleImage ArticleImageDefault in ListArticleImage.Where(i => i.ImaArt_Default == true && i.ImaArt_Id != ArticleImage.ImaArt_Id)) { ArticleImageDefault.ImaArt_Default = false; ArticleImageRepository.Save(); } } } // liens images déclinaisons ExecAttributeImage(PsImage, ArticleImage); } } catch (Exception ex) { Core.Error.SendMailError("[DOWNLOAD FTP IMAGE ARTICLE]<br />" + ex.ToString()); ArticleImageRepository.Delete(ArticleImage); } if (!import_img) { ArticleImageRepository.Delete(ArticleImage); } } } } else if (ArticleImageRepository.ExistPrestaShop(ImageSend)) { // import des affectations aux déclinaisons Model.Prestashop.PsImageRepository PsImageRepository = new Model.Prestashop.PsImageRepository(); Model.Prestashop.PsImage PsImage = PsImageRepository.ReadImage(Convert.ToUInt32(ImageSend)); Model.Local.ArticleImage ArticleImage = ArticleImageRepository.ReadPrestaShop(ImageSend); ExecAttributeImage(PsImage, ArticleImage); } } catch (Exception ex) { Core.Error.SendMailError(ex.ToString()); } }
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()); } }