AspDotNetStorefront Community | ASP.NET eCommerce Shoppingcart Software - AspDotNetStorefront ML

App_Code error on new site

chana — Mon, 06 Sep 2010 17:21:58 GMT

I am setting up a new V9 site, and encountering the following error:

Compiler Error Message: CS0234: The type or namespace name 'Web' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)

Source Error:

Line 11: using System.Security.Permissions;
Line 12: using System.Security.Principal;
Line 13: using Microsoft.Web.Services3.Security;
Line 14: using Microsoft.Web.Services3.Security.Tokens;
Line 15: using AspDotNetStorefrontCommon;

Source File: c:\inetpub\wwwroot\si-sv3781.com\wwwroot\App_Code\ASPDNSFUsernameTokenMa nager.cs Line: 13

Related Product Price

xxandyxexx — Mon, 06 Sep 2010 11:05:10 GMT

Hi,

I'm currently working on the related products within my site, but unlike the Upsell XML package, I can not pull in the price and msrp price into my related products section.

I am using AspDotNetStorefront ML 8.0.1.2 and I have looked through these forums applying the instructions given out by many on here, but still no luck.

Here is the code I'm using

Quote:

alter PROCEDURE [dbo].[aspdnsf_GetCustomersRelatedProducts]
@CustomerViewID nvarchar(50),
@ProductID int,
@CustomerLevelID int,
@InvFilter int,
@affiliateID int
--WITH ENCRYPTION
AS
SET NOCOUNT ON

DECLARE
@custlevelcount int,
@CustomerLevelFilteringIsAscending bit,
@FilterProductsByCustomerLevel tinyint,
@relatedprods varchar(8000),
@DynamicProductsEnabled varchar(10),
@DynamicProductsDisplayed int,
@FilterProductsByAffiliate tinyint,
@affiliatecount int,
@AffiliateExists int

SELECT @custlevelcount = si.rows from dbo.sysobjects so with (nolock) join dbo.sysindexes si with (nolock) on so.id = si.id where so.id = object_id('ProductCustomerLevel') and si.indid < 2 and type = 'u'
SELECT @FilterProductsByCustomerLevel = case ConfigValue when 'true' then 1 else 0 end FROM dbo.AppConfig with (nolock) WHERE [Name] = 'FilterProductsByCustomerLevel'
SELECT @FilterProductsByAffiliate = case ConfigValue when 'true' then 1 else 0 end FROM dbo.AppConfig with (nolock) WHERE [Name] = 'FilterProductsByAffiliate'
SELECT @affiliatecount = count(*), @AffiliateExists = sum(case when AffiliateID = @affiliateID then 1 else 0 end) from dbo.ProductAffiliate with (nolock) where ProductID = @ProductID

SET @CustomerLevelFilteringIsAscending = 0
SELECT @CustomerLevelFilteringIsAscending = case configvalue when 'true' then 1 else 0 end
FROM dbo.appConfig with (nolock)
WHERE name like 'FilterByCustomerLevelIsAscending'

SELECT @DynamicProductsDisplayed = CAST(ConfigValue AS INT) from AppConfig with (NOLOCK) where Name = 'DynamicRelatedProducts.NumberDisplayed'
SELECT @DynamicProductsEnabled = CASE ConfigValue WHEN 'true' then 1 else 0 end from AppConfig with (NOLOCK) where Name = 'DynamicRelatedProducts.Enabled'
select @relatedprods = replace(cast(relatedproducts as varchar(8000)), ' ', '') from dbo.product with (NOLOCK) where productid = @productid

--IF(@DynamicProductsEnabled = 1 and @DynamicProductsDisplayed > 0)
BEGIN
SELECT TOP (@DynamicProductsDisplayed) tp.ProductID, tp.ProductGUID, tp.ImageFilenameOverride, tp.SKU, tp.SEAltText, tp.Name, tp.Description,
pv.VariantID,
pv.name VariantName,
pv.Price,
pv.Description VariantDescription,
isnull(pv.SalePrice, 0) SalePrice, isnull(pv.SkuSuffix, '') SkuSuffix,
pv.Dimensions, pv.Weight, isnull(pv.Points, 0) Points, pv.Inventory,
pv.ImageFilenameOverride VariantImageFilenameOverride, pv.isdefault,
sp.name SalesPromptName,
case when pcl.productid is null then 0 else isnull(e.Price, 0) end ExtendedPrice
FROM Product tp with (NOLOCK)
join dbo.productvariant pv with (NOLOCK) on tp.ProductID = pv.ProductID
join dbo.SalesPrompt sp with (NOLOCK) on tp.SalesPromptID = sp.SalesPromptID
left join dbo.ExtendedPrice e with (NOLOCK) on pv.VariantID=e.VariantID and e.CustomerLevelID = @CustomerLevelID
left join dbo.productcustomerlevel pcl with (nolock) on tp.productid = pcl.productid and @FilterProductsByCustomerLevel = 1
JOIN
(
SELECT p.ProductID, p.ProductGUID, p.ImageFilenameOverride, p.SKU, p.SEAltText, p.Name, p.Description,
pv.VariantID,
pv.name VariantName,
pv.Price,
pv.Description VariantDescription,
isnull(pv.SalePrice, 0) SalePrice, isnull(pv.SkuSuffix, '') SkuSuffix,
pv.Dimensions, pv.Weight, isnull(pv.Points, 0) Points, pv.Inventory,
pv.ImageFilenameOverride VariantImageFilenameOverride, pv.isdefault,
sp.name SalesPromptName,
case when pcl.productid is null then 0 else isnull(e.Price, 0) end ExtendedPrice

from dbo.product p with (nolock)
join dbo.productvariant pv with (NOLOCK) on p.ProductID = pv.ProductID
join dbo.SalesPrompt sp with (NOLOCK) on p.SalesPromptID = sp.SalesPromptID
left join dbo.ExtendedPrice e with (NOLOCK) on pv.VariantID=e.VariantID and e.CustomerLevelID = @CustomerLevelID
join dbo.split(@relatedprods, ',') rp on p.productid = cast(rp.items as int)
left join dbo.productcustomerlevel pcl with (nolock) on p.productid = pcl.productid and @FilterProductsByCustomerLevel = 1
join (select p.ProductID
from dbo.product p with (nolock)
join dbo.split(@relatedprods, ',') rp on p.productid = cast(rp.items as int)
join (select ProductID, sum(Inventory) Inventory from dbo.productvariant with (nolock) group by ProductID) pv on p.ProductID = pv.ProductID
left join (select ProductID, sum(quan) inventory from dbo.inventory i1 with (nolock) join dbo.productvariant pv1 with (nolock) on pv1.variantid = i1.variantid join dbo.split(@relatedprods, ',') rp1 on pv1.productid = cast(rp1.items as int) group by pv1.productid) i on i.productid = p.productid
where case p.TrackInventoryBySizeAndColor when 1 then isnull(i.inventory, 0) else pv.inventory end >= @InvFilter
) tp on p.productid = tp.productid
where p.published = 1 and p.deleted = 0 and p.productid != @productid
and PV.published = 1 and PV.deleted = 0
and GETDATE() BETWEEN ISNULL(AvailableStartDate, '1/1/1900') AND ISNULL(AvailableStopDate, '1/1/2999')
and case
when @FilterProductsByCustomerLevel = 0 then 1
when @CustomerLevelFilteringIsAscending = 1 and pcl.CustomerLevelID <= @CustomerLevelID or pcl.CustomerLevelID is null then 1
when @CustomerLevelID=0 and pcl.CustomerLevelID is null then 1
when @CustomerLevelID is null or @custlevelcount = 0 then 1
when pcl.CustomerLevelID = @CustomerLevelID or pcl.CustomerLevelID is null then 1
else 0
end = 1
UNION ALL
SELECT pr.ProductID, pr.ProductGUID, pr.ImageFilenameOverride, pr.SKU, pr.SEAltText, pr.Name, pr.Description,
pv.VariantID,
pv.name VariantName,
pv.Price,
pv.Description VariantDescription,
isnull(pv.SalePrice, 0) SalePrice, isnull(SkuSuffix, '') SkuSuffix,
pv.Dimensions, pv.Weight, isnull(pv.Points, 0) Points, pv.Inventory,
pv.ImageFilenameOverride VariantImageFilenameOverride, pv.isdefault,
sp.name SalesPromptName,
case when pcl.productid is null then 0 else isnull(e.Price, 0) end ExtendedPrice

FROM Product pr WITH (NOLOCK)
join dbo.productvariant pv with (NOLOCK) on pr.ProductID = pv.ProductID
join dbo.SalesPrompt sp with (NOLOCK) on pr.SalesPromptID = sp.SalesPromptID
left join dbo.ExtendedPrice e with (NOLOCK) on pv.VariantID=e.VariantID and e.CustomerLevelID = @CustomerLevelID
left join dbo.productcustomerlevel pcl with (nolock) on pr.productid = pcl.productid and @FilterProductsByCustomerLevel = 1
WHERE pr.ProductID in (
SELECT TOP 100 PERCENT p.ProductID FROM Product p with (NOLOCK)
JOIN
(
SELECT ProductID FROM ProductView with (NOLOCK) WHERE CustomerViewID
IN
(
SELECT CustomerViewID FROM ProductView with (NOLOCK)
WHERE ProductID = @ProductID AND CustomerViewID <> @CustomerViewID
)
AND ProductID <> @ProductID
AND ProductID NOT
IN
(
select ProductID
from product with (NOLOCK)
join split(@relatedprods, ',') rp on productid = cast(rp.items as int)
group by ProductID
)
) a on p.ProductID = a.ProductID
LEFT JOIN dbo.productcustomerlevel pcl with (NOLOCK) on p.productid = pcl.productid and @FilterProductsByCustomerLevel = 1
left join dbo.ProductAffiliate pa with (nolock) on p.ProductID = pa.ProductID
WHERE
pr.Published = 1 AND pr.Deleted = 0 and PV.published = 1 and PV.deleted = 0
and GETDATE() BETWEEN ISNULL(AvailableStartDate, '1/1/1900') AND ISNULL(AvailableStopDate, '1/1/2999')
and case
when @FilterProductsByCustomerLevel = 0 then 1
when @CustomerLevelFilteringIsAscending = 1 and pcl.CustomerLevelID <= @CustomerLevelID or pcl.CustomerLevelID is null then 1
when @CustomerLevelID=0 and pcl.CustomerLevelID is null then 1
when @CustomerLevelID is null or @custlevelcount = 0 then 1
when pcl.CustomerLevelID = @CustomerLevelID or pcl.CustomerLevelID is null then 1
else 0
end = 1
and (pa.AffiliateID = @affiliateID or pa.AffiliateID is null or @affiliatecount = 0 or @FilterProductsByAffiliate = 0)
group by p.ProductID
order by COUNT(*) desc
)
)prd on tp.ProductID = prd.ProductID

END

IF(@DynamicProductsEnabled = 0 and @DynamicProductsDisplayed > 0)
BEGIN
select TOP (@DynamicProductsDisplayed) p.ProductID, p.ProductGUID, p.ImageFilenameOverride, p.SKU, p.SEAltText, p.Name, p.Description,
/* mb 11/09 */
pv.VariantID,
pv.name
VariantName,
pv.Price,
pv.Description VariantDescription,
isnull(pv.SalePrice, 0) SalePrice, isnull(SkuSuffix, '') SkuSuffix,
pv.Dimensions, pv.Weight, isnull(pv.Points, 0) Points, pv.Inventory,
pv.ImageFilenameOverride VariantImageFilenameOverride, pv.isdefault,
sp.name SalesPromptName,
case when pcl.productid is null then 0 else isnull(e.Price, 0) end ExtendedPrice
from dbo.product p with (nolock)
join dbo.productvariant pv with (NOLOCK) on p.ProductID = pv.ProductID
join dbo.SalesPrompt sp with (NOLOCK) on p.SalesPromptID = sp.SalesPromptID
left join dbo.ExtendedPrice e with (NOLOCK) on pv.VariantID=e.VariantID and e.CustomerLevelID = @CustomerLevelID
left join (select variantid, sum(quan) inventory from inventory group by variantid) i on pv.variantid = i.variantid
join dbo.split(@relatedprods, ',') rp on p.productid = cast(rp.items as int)
left join dbo.productcustomerlevel pcl with (nolock) on p.productid = pcl.productid and @FilterProductsByCustomerLevel = 1
join (select p.ProductID
from dbo.product p with (nolock)
join dbo.split(@relatedprods, ',') rp on p.productid = cast(rp.items as int)
join (select ProductID, sum(Inventory) Inventory from dbo.productvariant with (nolock) group by ProductID) pv on p.ProductID = pv.ProductID
left join (select ProductID, sum(quan) inventory from dbo.inventory i1 with (nolock) join dbo.productvariant pv1 with (nolock) on pv1.variantid = i1.variantid join dbo.split(@relatedprods, ',') rp1 on pv1.productid = cast(rp1.items as int) group by pv1.productid) i on i.productid = p.productid
where case p.TrackInventoryBySizeAndColor when 1 then isnull(i.inventory, 0) else pv.inventory end >= @InvFilter
) tp on p.productid = tp.productid
where p.published = 1 and p.deleted = 0 and p.productid != @productid
and pv.published = 1 and pv.deleted = 0
and GETDATE() BETWEEN ISNULL(AvailableStartDate, '1/1/1900') AND ISNULL(AvailableStopDate, '1/1/2999')
and case
when @FilterProductsByCustomerLevel = 0 then 1
when @CustomerLevelFilteringIsAscending = 1 and pcl.CustomerLevelID <= @CustomerLevelID or pcl.CustomerLevelID is null then 1
when @CustomerLevelID=0 and pcl.CustomerLevelID is null then 1
when @CustomerLevelID is null or @custlevelcount = 0 then 1
when pcl.CustomerLevelID = @CustomerLevelID or pcl.CustomerLevelID is null then 1
else 0
end = 1

And this is the error I am receiving:

Quote:

Exception=Incorrect syntax near the keyword 'PROCEDURE'. Must declare the scalar variable "@CustomerViewID". Incorrect syntax near ')'. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near '1'.

Any help would be greatly appreciated as this is driving me nuts at the moment!

Many Thanks.

Skin Required for website

dev.folks — Sun, 05 Sep 2010 18:11:36 GMT

Hi,

Im looking for similar skin (www.arenaflowers.com) for my website (version 9.0.1.3)

IF any one interested to do this job please post your quote and email id

Regards
Devaki

Critique my site

hunter0781 — Sat, 04 Sep 2010 16:56:26 GMT

www.soycandledepot.com

Opinions, recommendations, bashings�all are welcome. I�m looking for honest feedback on our site�s design, organization, graphics, layout, verbiage, etc.

Thanks for your time.

Visual studio and IIS

pwb — Sat, 04 Sep 2010 14:13:39 GMT

Hi, is there som documentation to setup IIS and VS2008 correctly to use with the sourcecode? I have tried it on Windows 7 (IIS 7) and XP (IIS 6) but i cant get the default.aspx or template.master to work/show correct in design mode. I have enabled parent path and that did help a litle, but the design mode still dont show correct. I can compile and everything, but in the documentation its says that its possible to see default.aspx layout in designmode, but all layout and images is "gone"

/PWB

I'm confused - formatting subcategory links

jhoskinson — Fri, 03 Sep 2010 21:25:37 GMT

The XML package we're using for categories w/ subcats displays them as such:

Code:

Crystal Beads

We've been told by our SEO company that it would be better if, at the very least, it looked like this: (so that there's only one tag)

Code:

Crystal Beads

How do we accomplish this? It looks like this in the XML Package:

Code:

Prices.Cs

chrismartz — Fri, 03 Sep 2010 20:17:56 GMT

I am trying to add to Prices.cs. I have created the following on ShoppingCart.cs:

Code:

public string ClayRateDisplayFormat

        {

            get

            {

                Decimal tCalcRate = ClayCalcRate();

                return Localization.CurrencyStringForDisplayWithExchangeRate(tCalcRate, ThisCustomer.CurrencySetting);

            }

        }

How can I pull this value into Prices.cs. I specifically want to add it to the taxSubTotal total. Any ideas? When I try to do cart.ClayRateDisplayFormat, it doesn't recognize it.

Help... Missing Order # but Processed in PayPal with order #

MSD — Fri, 03 Sep 2010 19:49:21 GMT

I am missing an order for a �confirmed� customer in PayPal message. We have been paid but the order is not listed in admin just skipped over. When we do a report by category we see the order number and products but no order can be pulled in admin. We offer credit cars and PayPal Express and almost missed the order but caught it in the our gateway CMS. Its only happened once but it�s a new store.

Anyone seen this.

MSD

Typos and Inconsistencies in Country Table

dayhawk — Fri, 03 Sep 2010 19:45:15 GMT

1) In the Country table in 9.0.1.3, "Bosnia and Herzegowina" is spelled half in English and half in German.

2) "Korea, Democratic People's Republic of" is in fact the English long form for North Korea. This should be changed to "Korea, South," the international short form or to "Korea, Republic of," the international long form.

3) For consistency, "Croatia (local Name: Hrvatska)" should either drop the contents in parentheses or others like the Czech Republic should also have Cesko.

Not a big deal, but wanted to point out the first two at least. The second especially makes ASPDotNetStorefront appear to prefer North Korea over South Korea. :rolleyes::D

Thanks!

AddIns

pwb — Fri, 03 Sep 2010 17:56:58 GMT

9.0.1.3
Hi, when trying to enter the Addins from the admin menu i got security error on the folders, i needed to add IIS_USR with modify on the addins folder and subfolder. Its on IIS 7, but network service wasnt any help, is there some security issues on this, or what should be the correct security setting on the folder?

/PWB

Google Analytics

cjbarth — Fri, 03 Sep 2010 17:04:50 GMT

I was trying to get Google Analytics set up on my site and I found the directions Google gives are very different from the one that the ASPDNSF manual gives http://manual.aspdotnetstorefront.co...-tracking.aspx.

Obviously Google is the authority on this, but why are the ASPDNSF directions so different? Is there something I'm unaware of behind the scenes that requires this other stuff from ASPDNSF?

Turning off the auto newsletter email

UNLGroup — Fri, 03 Sep 2010 15:25:39 GMT

How do I turn this off? I don't want this email to go out.

Real Time Shipping Problems

Amazing — Thu, 02 Sep 2010 21:49:28 GMT

Anyone have any trouble today 9/2/2010 with Real-Time shipping not working? We had about a 45 minute outage, which we could not explain. It worked fine on Fixed Pricing and other non-real time options.

New column added to Customer Table and orders Table

dev.folks — Thu, 02 Sep 2010 20:02:46 GMT

New column added to Customer Table and orders Table

I Added new Column "SpecialOrderNotes" to the customer table and showing in shopping cart page just above to order notes field.

im able to save data in "SpecialOrderNotes" in customer table in database if someone clicks on update / checkout button in shopping page.

Now the problem is after new order got generated entire data is from customer table is moved to orders table except one column which i have added i.e "SpecialOrderNotes"

So can one please let me know where is the query that moving data from customer table to orders table

Thanks in advance
Devender

Importing customer datails into 9.0.1.3

snowy — Thu, 02 Sep 2010 13:05:22 GMT

We are going to upgrade the to 9.0.1.3 from 8.0.1.2.

I would like to import only the customer details and loging passwords etc..

Is it possible? would the customer be able to login into their account with the password they already have?

We are looking to setup the product separatly for the start.

Thank you:)