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);
}
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));
}
public void Exec(Int32 ImageSend)
{
try
{
Model.Prestashop.PsImageRepository PsImageRepository = new Model.Prestashop.PsImageRepository();
Model.Prestashop.PsImageShopRepository PsImageShopRepository = new Model.Prestashop.PsImageShopRepository();
if (PsImageRepository.ExistImage((UInt32)ImageSend))
{
Model.Prestashop.PsImage PsImage = PsImageRepository.ReadImage(Convert.ToUInt32(ImageSend));
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 PsImage.IDImage.ToString())
{
ftpPath += directory + "/";
}
break;
#endregion
}
string ftpfullpath = (Core.Global.GetConfig().ConfigImageStorageMode == Core.Parametres.ImageStorageMode.old_system)
? FTP + ftpPath + PsImage.IDProduct + "-" + PsImage.IDImage + ".jpg"
: FTP + ftpPath + PsImage.IDImage + ".jpg";
if (!Core.Ftp.ExistFile(ftpfullpath, User, Password))
{
PsImageShopRepository.DeleteAll(PsImageShopRepository.List(PsImage.IDImage));
PsImageRepository.Delete(PsImage);
}
}
}
catch (Exception ex)
{
Core.Error.SendMailError(ex.ToString());
}
}
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);
}
}
}
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());
}
}
