private Guid GetSitefinitySiteId() { Guid siteId; using (var connection = SqlSessionFactory.Create(SitefinityConnectionString)) { siteId = connection.QueryFirstOrDefault <Guid>($"select id from sf_sites where nme = '{SitefinitySiteName}'"); } return(siteId); }
public IEnumerable <Product> Execute(IEnumerable <ProductViewModel> sitefinityProducts) { _session = SessionFactory.Create(ConnectionString); var connection = SqlSessionFactory.Create(ConfigurationManager.ConnectionStrings["SitefinityConnectionString"].ConnectionString); var catalog = _session.Query <ProductCatalog>().First(x => x.Name == SitefinitySiteName); _defaultPriceGroup = catalog.PriceGroup; var products = new List <Product>(); try { foreach (var sfProduct in sitefinityProducts) { var product = _session.Query <Product>() .SingleOrDefault(a => a.Sku == sfProduct.Item.Sku && (a.VariantSku == null || a.VariantSku == string.Empty)); if (product != null) { Log.Warn($"product {product.Name.ToShortName(25)} with sku {sfProduct.Item.Sku} already exists in Ucommerce"); continue; } product = new Product(); AddProduct(product, sfProduct); AddProductCategoryAssociations(product, sfProduct); products.Add(product); } } finally { connection.Close(); connection.Dispose(); _session.Close(); } return(products); }