private void ReadRedirection(Model.Local.Article Article)
{
try
{
Model.Local.ArticleRepository ArticleRepository = new Model.Local.ArticleRepository();
Article = ArticleRepository.ReadArticle(Article.Art_Id);
Model.Prestashop.DataClassesPrestashop DBPrestashop = new Model.Prestashop.DataClassesPrestashop(new MySqlConnection(Properties.Settings.Default.PRESTASHOPConnectionString));
List <Model.Prestashop.Product_Redirection> list = DBPrestashop.ExecuteQuery <Model.Prestashop.Product_Redirection>
("select redirect_type, " +
#if (PRESTASHOP_VERSION_172)
"id_type_redirected " +
#else
"id_product_redirected " +
#endif
" from ps_product_shop where id_product = " + Article.Pre_Id + " and id_shop = " + Core.Global.CurrentShop.IDShop + " ").ToList();
if (list != null && list.Count == 1)
{
Model.Prestashop.Product_Redirection values = list.FirstOrDefault();
Article.Art_RedirectType = values.redirect_type;
#if (PRESTASHOP_VERSION_172)
Article.Art_RedirectProduct = (ArticleRepository.ExistPre_Id((int)values.id_type_redirected)) ? ArticleRepository.ReadPre_Id((int)values.id_type_redirected).Art_Id : 0;
#else
Article.Art_RedirectProduct = (ArticleRepository.ExistPre_Id((int)values.id_product_redirected)) ? ArticleRepository.ReadPre_Id((int)values.id_product_redirected).Art_Id : 0;
#endif
ArticleRepository.Save();
}
}
catch (Exception ex)
{
Core.Error.SendMailError(ex.ToString());
}
}
public void Exec(Int32 ArticleSend)
{
try
{
Model.Local.ArticleRepository ArticleRepository = new Model.Local.ArticleRepository();
if (ArticleRepository.ExistArticle(ArticleSend))
{
Model.Local.Article Article = ArticleRepository.ReadArticle(ArticleSend);
Model.Sage.F_ARTICLERepository F_ARTICLERepository = new Model.Sage.F_ARTICLERepository();
string AR_Ref = Article.Art_Ref;
// ajout gestion lecture des informations pour une composition
if (!F_ARTICLERepository.ExistReference(Article.Art_Ref) &&
Article.TypeArticle == Model.Local.Article.enum_TypeArticle.ArticleComposition &&
Article.CompositionArticle != null && Article.CompositionArticle.Count > 0)
{
int sag_id = (from Table in Article.CompositionArticle
orderby Table.ComArt_Default descending
select Table.ComArt_F_ARTICLE_SagId).FirstOrDefault();
Model.Sage.F_ARTICLE_Light light = F_ARTICLERepository.ReadLight(sag_id);
if (light != null && !string.IsNullOrWhiteSpace(light.AR_Ref))
{
AR_Ref = light.AR_Ref;
}
}
if (F_ARTICLERepository.ExistReference(AR_Ref))
{
if (ImportValues(Article, AR_Ref))
{
if (Core.Temp.UpdateDateActive)
{
Article.Art_Date = DateTime.Now;
}
ArticleRepository.Save();
}
}
}
}
catch (Exception ex)
{
Core.Error.SendMailError(ex.ToString());
}
}
private void ExecDistantToLocal(Model.Prestashop.PsProduct Product, Model.Local.Article Article, Model.Local.ArticleRepository ArticleRepository)
{
try
{
#region Recovery Data From CategoryProduct
Model.Prestashop.PsCategoryProductRepository PsCategoryProductRepository = new Model.Prestashop.PsCategoryProductRepository();
Model.Local.CatalogRepository CatalogRepository = new Model.Local.CatalogRepository();
Model.Local.ArticleCatalogRepository ArticleCatalogRepository = new Model.Local.ArticleCatalogRepository();
Model.Prestashop.PsCategoryRepository PsCategoryRepository = new Model.Prestashop.PsCategoryRepository();
// filtrage des catalogues existants dans PC et PS
List <Model.Local.CatalogLight> ListLocalCatalog = CatalogRepository.ListLight();
List <uint> ListPrestashopCategory = PsCategoryRepository.ListIdOrderByLevelDepth(Core.Global.CurrentShop.IDShop, PsCategoryRepository.ReadId(Core.Global.CurrentShop.IDCategory).LevelDepth);
ListLocalCatalog = ListLocalCatalog.Where(lc => ListPrestashopCategory.Count(pc => pc == (uint)lc.Pre_Id) > 0).ToList();
// filtrage des associations PS par rapport aux catégories PS existantes en tant que catalogue PC
List <Model.Prestashop.PsCategoryProduct> ListPsCategoryProduct = PsCategoryProductRepository.ListProduct(Product.IDProduct);
ListPsCategoryProduct = ListPsCategoryProduct.Where(cp => ListLocalCatalog.Count(lc => lc.Pre_Id == cp.IDCategory) > 0).ToList();
// filtrage des associations PC par rapport aux catégories ayant un ID PS
List <Model.Local.ArticleCatalog> ListLocal = ArticleCatalogRepository.ListArticle(Article.Art_Id);
ListLocal = ListLocal.Where(ac => ac.Catalog.Pre_Id != null).ToList();
// tant que les associations en local contiennent des associations non présentes dans Prestashop
if (Core.Global.GetConfig().DeleteCatalogProductAssociation)
{
// suppression des occurences inexistantes dans PS
while (ListLocal.Count(ac => ListPsCategoryProduct.Count(cp => cp.IDCategory == ac.Catalog.Pre_Id) == 0) > 0)
{
Model.Local.ArticleCatalog target = ListLocal.FirstOrDefault(ac => ListPsCategoryProduct.Count(cp => cp.IDCategory == ac.Catalog.Pre_Id) == 0);
ArticleCatalogRepository.Delete(target);
ListLocal.Remove(target);
}
;
}
// récupération catégorie principale si catalogue existant dans Prestaconnect
if (Product.IDCategoryDefault != null && Product.IDCategoryDefault != 0 &&
ListLocalCatalog.Count(lc => lc.Pre_Id == (int)Product.IDCategoryDefault) > 0)
{
ArticleRepository = new Model.Local.ArticleRepository();
Article = ArticleRepository.ReadArticle(Article.Art_Id);
Article.Cat_Id = ListLocalCatalog.FirstOrDefault(lc => lc.Pre_Id == (int)Product.IDCategoryDefault).Cat_Id;
ArticleRepository.Save();
if (ListLocal.Count(ac => ac.Art_Id == Article.Art_Id && ac.Cat_Id == Article.Cat_Id) == 0)
{
ArticleCatalogRepository.Add(new Model.Local.ArticleCatalog()
{
Art_Id = Article.Art_Id,
Cat_Id = Article.Cat_Id
});
}
}
// filtre des associations Prestashop par rapport à celles déjà présentes dans Prestaconnect puis ajout
ListLocal = ArticleCatalogRepository.ListArticle(Article.Art_Id);
ListLocal = ListLocal.Where(ac => ac.Catalog.Pre_Id != null).ToList();
ListPsCategoryProduct = ListPsCategoryProduct.Where(cp => ListLocal.Count(ac => ac.Catalog.Pre_Id == (Int32)cp.IDCategory) == 0).ToList();
foreach (Model.Prestashop.PsCategoryProduct PsCategoryProduct in ListPsCategoryProduct)
{
ArticleCatalogRepository.Add(new Model.Local.ArticleCatalog()
{
Art_Id = Article.Art_Id,
Cat_Id = ListLocalCatalog.FirstOrDefault(lc => lc.Pre_Id == (Int32)PsCategoryProduct.IDCategory).Cat_Id
});
}
#endregion
}
catch (Exception ex)
{
Core.Error.SendMailError(ex.ToString());
}
}