Error executing template "Designs/Rapido/Json/eCom7/CartV2/Step/Cart.cshtml"
System.FormatException: Input string was not in a correct format.
at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Double.Parse(String s, IFormatProvider provider)
at CompiledRazorTemplates.Dynamic.RazorEngine_73406e08b35c43f4a7b580421d2efeb3.Execute() in D:\Dynamicweb.net\Solutions\Degree\eplast.cloud.dynamicweb-cms.com\Files\Templates\Designs\Rapido\Json\eCom7\CartV2\Step\Cart.cshtml:line 174
at RazorEngine.Templating.TemplateBase.RazorEngine.Templating.ITemplate.Run(ExecuteContext context, TextWriter reader)
at RazorEngine.Templating.RazorEngineService.RunCompile(ITemplateKey key, TextWriter writer, Type modelType, Object model, DynamicViewBag viewBag)
at RazorEngine.Templating.RazorEngineServiceExtensions.<>c__DisplayClass16_0.<RunCompile>b__0(TextWriter writer)
at RazorEngine.Templating.RazorEngineServiceExtensions.WithWriter(Action`1 withWriter)
at Dynamicweb.Rendering.RazorTemplateRenderingProvider.Render(Template template)
at Dynamicweb.Rendering.TemplateRenderingService.Render(Template template)
at Dynamicweb.Rendering.Template.RenderRazorTemplate()
1 @inherits Dynamicweb.Rendering.RazorTemplateBase<Dynamicweb.Rendering.RazorTemplateModel<Dynamicweb.Rendering.Template>>
2 @using System.Text.RegularExpressions
3 @using System.Linq
4 @using System.Web
5 @using Dynamicweb.Core
6 @using Dynamicweb.Ecommerce.Orders
7 @using System.Globalization
8 @inherits Dynamicweb.Rendering.RazorTemplateBase<Dynamicweb.Rendering.RazorTemplateModel<Dynamicweb.Rendering.Template>>
9
10
11 @*
12 This is a temporary fallback for the DefaultImage. The image pattern MUST be set up like this:
13
14 ImageSmall = /{ProductNumber}.jpg
15 ImageMedium = /{ProductNumber}{VariantOptionLevel1}.jpg
16 ImageLarge = /{ProductNumber}{VariantComboName}.jpg
17
18 In addition to the ImageDefault setting
19 *@
20
21 @functions {
22 public string GetProductImage(LoopItem productObject = null)
23 {
24 string theImage = "";
25
26 if (productObject == null) {
27 theImage = GetString("Ecom:Product.ImageDefault.Default.Clean");
28 theImage = String.IsNullOrEmpty(theImage) ? GetString("Ecom:Product.ImageLarge.Clean") : theImage;
29 theImage = String.IsNullOrEmpty(theImage) ? GetString("Ecom:Product.ImageMedium.Clean") : theImage;
30 theImage = String.IsNullOrEmpty(theImage) ? GetString("Ecom:Product.ImageSmall.Clean") : theImage;
31 theImage = String.IsNullOrEmpty(theImage) ? GetString("Ecom:Product.ImageLarge.Default.Clean") : theImage;
32 } else {
33 theImage = productObject.GetString("Ecom:Product.ImageDefault.Default.Clean");
34 theImage = String.IsNullOrEmpty(theImage) ? productObject.GetString("Ecom:Product.ImageLarge.Clean") : theImage;
35 theImage = String.IsNullOrEmpty(theImage) ? productObject.GetString("Ecom:Product.ImageMedium.Clean") : theImage;
36 theImage = String.IsNullOrEmpty(theImage) ? productObject.GetString("Ecom:Product.ImageSmall.Clean") : theImage;
37 theImage = String.IsNullOrEmpty(theImage) ? productObject.GetString("Ecom:Product.ImageLarge.Default.Clean") : theImage;
38 }
39
40 return theImage;
41 }
42 }
43 @{
44 int productCatalog = GetPageIdByNavigationTag("ProductsPage");
45 bool useGoogleTagManager = !string.IsNullOrEmpty(Pageview.AreaSettings.GetItem("Settings").GetString("GoogleTagManagerID"));
46 }
47
48 @functions {
49 public class ShippingMethod
50 {
51 public string id { get; set; }
52 public string name { get; set; }
53 public string selected { get; set; }
54 public string hasShippingProvider { get; set; }
55 public object shippingProviderContent { get; set; }
56 }
57
58 public class BomItem
59 {
60 public string id { get; set; }
61 public string productnumber { get; set; }
62 public string name { get; set; }
63 public string variantname { get; set; }
64 public string unitname { get; set; }
65 public string image { get; set; }
66 public string link { get; set; }
67 public string quantity { get; set; }
68 }
69
70 public class OrderLine
71 {
72 public string template { get; set; }
73 public string id { get; set; }
74 public string productnumber { get; set; }
75 public string name { get; set; }
76 public string variantname { get; set; }
77 public string variantId { get; set; }
78 public string quantity { get; set; }
79 public string totalprice { get; set; }
80 public string link { get; set; }
81 public double pointPrice { get; set; }
82 public string priceWithDiscount { get; set; }
83 public double pointsTotal { get; set; }
84 public bool canBePurchasedWithPoints { get; set; }
85 public string image { get; set; }
86 public bool isEmpty { get; set; }
87 public string orderLineId { get; set; }
88 public string unitname { get; set; }
89 public string unitprice { get; set; }
90 public string hideimage { get; set; }
91 public string hideBomItems { get; set; }
92 public string googleImpression { get; set; }
93 public List<BomItem> BomItems { get; set; }
94 public List<ShippingMethod> ShippingMethods { get; set; }
95 public string htmlSnippet { get; set; }
96 public string forceOpenDetails { get; set; }
97 public string isCustomProduct { get; set; }
98 public string cartNote { get; set; }
99 public int stockLevel { get; set; }
100
101 }
102
103 public class Root
104 {
105 public int numberofproducts { get; set; }
106 public string subtotalprice { get; set; }
107 public string subtotalpricewithouttaxes { get; set; }
108 public string paymentmethod { get; set; }
109 public string paymentfee { get; set; }
110 public bool hidePaymentfee { get; set; }
111 public string shippingmethod { get; set; }
112 public string shippingfee { get; set; }
113 public bool hideShippingfee { get; set; }
114 public bool hideSubTotal { get; set; }
115 public bool hideComment { get; set; }
116 public bool showCheckoutDisclaimer { get; set; }
117 public string checkoutDisclaimer { get; set; }
118 public string totalprice { get; set; }
119 public double earnings { get; set; }
120 public string totalvat { get; set; }
121 public string totaltaxes { get; set; }
122 public bool hasTaxSettings { get; set; }
123 public bool isEmpty { get; set; }
124 public string vouchercode { get; set; }
125 public string giftcardcode { get; set; }
126 public string comment { get; set; }
127 public double userPoints { get; set; }
128 public double pointsUsedInCart { get; set; }
129 public string termsAccepted { get; set; }
130 public string disabledNextStep { get; set; }
131 public string totalPriceWithVat { get; set; }
132 public string vatValue { get; set; }
133 public string totalPriceWithoutVat { get; set; }
134 public string vatPercent { get; set; }
135 public string cartNoteGlobal { get; set; }
136 public List<OrderLine> OrderLines { get; set; }
137 }
138
139 public class GoogleImpression
140 {
141 public string name { get; set; }
142 public string id { get; set; }
143 public double price { get; set; }
144 public string brand { get; set; }
145 public string category { get; set; }
146 public string variant { get; set; }
147 public int quantity { get; set; }
148 public string currency { get; set; }
149 }
150 }
151
152 @{
153 string jsonFeed = "";
154
155 List<Root> feedObject = new List<Root>();
156 Root feedRoot = new Root();
157
158 feedRoot.numberofproducts = GetInteger("Ecom:Order.OrderLines.TotalProductQuantity");
159 feedRoot.subtotalprice = GetString("Ecom:Order.PriceWithoutFees.PriceFormatted");
160 feedRoot.subtotalpricewithouttaxes = Dynamicweb.Ecommerce.Services.Currencies.Format(Dynamicweb.Ecommerce.Common.Context.Currency, (GetDouble("Ecom:Order.PriceWithoutFees.PriceWithVAT") - GetDouble("Ecom:Order.Taxes.Total.PriceWithVAT")), true);
161 feedRoot.paymentmethod = !string.IsNullOrEmpty(GetString("Ecom:Order.PaymentMethod")) ? GetString("Ecom:Order.PaymentMethod") : Translate("Payment");
162 feedRoot.paymentfee = GetInteger("Ecom:Order.PaymentFee.Price") != 0 ? GetString("Ecom:Order.PaymentFee.PriceFormatted") : Translate("Free");
163 feedRoot.hidePaymentfee = Pageview.AreaSettings.GetItem("Ecommerce").GetItem("Checkout").GetBoolean("HideFreeServices") && GetInteger("Ecom:Order.PaymentFee.Price") == 0;
164 feedRoot.shippingmethod = !string.IsNullOrEmpty(GetString("Ecom:Order.ShippingMethod")) ? GetString("Ecom:Order.ShippingMethod") : Translate("Shipping");
165 feedRoot.shippingfee = GetDouble("Ecom:Order.ShippingFee.Price") != 0 ? GetString("Ecom:Order.ShippingFee.PriceFormatted") : Translate("Free");
166 feedRoot.hideShippingfee = Pageview.AreaSettings.GetItem("Ecommerce").GetItem("Checkout").GetBoolean("HideFreeServices") && GetInteger("Ecom:Order.ShippingFee.Price") == 0;
167 feedRoot.totalprice = GetString("Ecom:Order.Price.PriceFormatted");
168 feedRoot.earnings = GetInteger("Ecom:Order.RewardTotalPoints");
169 feedRoot.totalvat = GetString("Ecom:Order.OrderLines.Total.PriceVAT");
170 feedRoot.totaltaxes = GetDouble("Ecom:Order.Taxes.Total.Price") != 0 ? GetString("Ecom:Order.Taxes.Total") : "-";
171 feedRoot.hasTaxSettings = Dynamicweb.Rapido.Services.Countries.HasTaxSettings(GetString("Ecom:Order.ID"));
172 feedRoot.vatPercent = GetString("Ecom:Order.PriceWithoutFees.VATPercentFormatted");
173 var priceString = GetString("Ecom:Order.Price.PriceFormatted").Split('k', 'r')[0];
174 double number = double.Parse(priceString, CultureInfo.GetCultureInfo("fr-FR"));
175 double percent = 25;
176 double result = number * percent / 100;
177 double resultTotal = result + number;
178 string price25PercentString = "";
179
180 feedRoot.vatValue = result.ToString("F2");
181 feedRoot.totalPriceWithVat = resultTotal.ToString("F2");
182 feedRoot.totalPriceWithoutVat = GetString("Ecom:Order.OrderLines.Total.PriceWithoutVAT");
183
184 feedRoot.isEmpty = GetBoolean("Ecom:Order.IsEmpty");
185 feedRoot.vouchercode = GetString("Ecom:Order.Customer.VoucherCode");
186 feedRoot.giftcardcode = GetString("Ecom:Order.GiftCardCode");
187 feedRoot.hideSubTotal = Pageview.AreaSettings.GetItem("Ecommerce").GetItem("Checkout").GetBoolean("HideSubtotal");
188 feedRoot.hideComment = Pageview.AreaSettings.GetItem("Ecommerce").GetItem("Checkout").GetBoolean("HideComment");
189 feedRoot.comment = GetString("Ecom:Order.Customer.Comment");
190 feedRoot.showCheckoutDisclaimer = Dynamicweb.Rapido.Services.Countries.HasTaxSettings(GetString("Ecom:Order.ID")) && Pageview.AreaSettings.GetItem("Ecommerce").GetItem("Checkout").GetBoolean("ShowCheckoutDisclaimer") && (GetDouble("Ecom:Order.Taxes.Total.Price") == 0 || string.IsNullOrEmpty(GetString("Ecom:Order.ShippingMethodID")));
191 feedRoot.checkoutDisclaimer = string.Format("{0}", GetDouble("Ecom:Order.Taxes.Total.Price") == 0 && string.IsNullOrEmpty(GetString("Ecom:Order.ShippingMethodID")) ? Translate("* Sales Tax and Shipping calculated at Checkout") : string.IsNullOrEmpty(GetString("Ecom:Order.ShippingMethodID")) ? Translate("* Shipping calculated at Checkout") : Translate("* Sales Tax Calculated at Checkout"));
192 feedRoot.termsAccepted = GetBoolean("Ecom:Order.Customer.Accepted") ? "checked" : "";
193 feedRoot.disabledNextStep = GetBoolean("Ecom:Order.Customer.Accepted") ? "" : "disabled";
194 feedRoot.cartNoteGlobal = GetLoop("OrderLines")[0].GetString("Ecom:OrderLine.CustomFields.cartnote");
195
196 var user = Dynamicweb.Security.UserManagement.User.GetCurrentUser(Dynamicweb.Security.UserManagement.PagePermissionLevels.Frontend);
197 feedRoot.userPoints = user != null ? Converter.ToInt32(user.PointBalance) : 0;
198
199 var cart = Dynamicweb.Ecommerce.Common.Context.Cart;
200 feedRoot.pointsUsedInCart = cart != null && cart.TotalPoints.HasValue ? cart.TotalPoints.Value : 0;
201
202 feedRoot.OrderLines = new List<OrderLine>();
203 foreach (LoopItem orderline in GetLoop("OrderLines").Where(o => o.GetInteger("Ecom:Order:OrderLine.Type") != (int)OrderLineType.Tax).OrderBy(o => o.GetString("Ecom:OrderLine.CustomFields.SortingIndex")).ToList())
204 {
205
206 OrderLine cartOrderLine = new OrderLine();
207 string productLink = "/" + Regex.Replace(orderline.GetString("Ecom:Product.LinkGroup.Clean"), @"\?ID=\d*\&", "?ID=" + productCatalog + "&");
208 productLink += !string.IsNullOrEmpty(orderline.GetString("Ecom:Order:OrderLine.ProductVariantID")) ? "&VariantID=" + orderline.GetString("Ecom:Order:OrderLine.ProductVariantID") : "";
209
210 cartOrderLine.template = Pageview.Device.ToString() != "Mobile" ? "CartOrderline" : "CartOrderlineMobile";
211 cartOrderLine.template = orderline.GetBoolean("Ecom:Order:OrderLine.IsProduct") ? cartOrderLine.template : "CartOrderlineDiscount";
212 cartOrderLine.id = orderline.GetString("Ecom:Product.ID");
213 cartOrderLine.productnumber = orderline.GetString("Ecom:Order:OrderLine.ProductNumber");
214 cartOrderLine.isCustomProduct = orderline.GetString("Ecom:Order:OrderLine.ProductNumber")[0].ToString() + orderline.GetString("Ecom:Order:OrderLine.ProductNumber")[1].ToString() == "EP" ? "true" : "";
215 cartOrderLine.name = orderline.GetString("Ecom:Order:OrderLine.ProductName");
216 cartOrderLine.variantname = orderline.GetString("Ecom:Order:OrderLine.ProductVariantText");
217 cartOrderLine.variantId = orderline.GetString("Ecom:Order:OrderLine.ProductVariantID");
218 cartOrderLine.quantity = orderline.GetString("Ecom:Order:OrderLine.Quantity");
219 cartOrderLine.totalprice = orderline.GetString("Ecom:Order:OrderLine.Price");
220 cartOrderLine.link = productLink;
221 cartOrderLine.image = GetProductImage(orderline) == "/Images/missing_image.jpg" ? "/Files/Images/Alvoen/ecom/products/"+ orderline.GetString("Ecom:Order:OrderLine.ProductNumber") +".png" : GetProductImage(orderline);
222 cartOrderLine.pointsTotal = orderline.GetInteger("Ecom:Order:OrderLine.Points");
223 cartOrderLine.pointPrice = orderline.GetInteger("Ecom:Product.PointPrice");
224 cartOrderLine.canBePurchasedWithPoints = cartOrderLine.pointsTotal == 0 && cartOrderLine.pointPrice > 0 && feedRoot.userPoints - feedRoot.pointsUsedInCart >= cartOrderLine.pointPrice;
225 cartOrderLine.isEmpty = GetBoolean("Ecom:Order.IsEmpty");
226 cartOrderLine.orderLineId = orderline.GetString("Ecom:Order:OrderLine.Id");
227 cartOrderLine.unitname = orderline.GetString("Ecom:Order:OrderLine.UnitName");
228 cartOrderLine.unitprice = orderline.GetString("Ecom:Order:OrderLine.UnitPrice");
229 cartOrderLine.hideimage = !orderline.GetBoolean("Ecom:Order:OrderLine.IsProduct") ? "u-hidden" : "";
230 cartOrderLine.hideBomItems = orderline.GetLoop("BOMItems").Count > 0 ? "" : "u-hidden";
231 cartOrderLine.htmlSnippet = orderline.GetString("Ecom:OrderLine.CustomFields.HtmlSnippet") != "" ? orderline.GetString("Ecom:OrderLine.CustomFields.HtmlSnippet") : orderline.GetString("Ecom:OrderLine.CustomFields.htmlsnippet");
232 cartOrderLine.cartNote = orderline.GetString("Ecom:OrderLine.CustomFields.CartNote") != "" ? orderline.GetString("Ecom:OrderLine.CustomFields.CartNote") : orderline.GetString("Ecom:OrderLine.CustomFields.cartnote");
233 cartOrderLine.stockLevel = orderline.GetInteger("Ecom:Product.Stock");
234 cartOrderLine.forceOpenDetails = orderline.GetString("Ecom:OrderLine.CustomFields.ForceOpenDetails") == "True" ? orderline.GetString("Ecom:OrderLine.CustomFields.ForceOpenDetails") : "" ;
235
236
237
238 if (useGoogleTagManager)
239 {
240 var groupObject = Dynamicweb.Ecommerce.Services.ProductGroups.GetGroup(orderline.GetString("Ecom:Product.PrimaryOrFirstGroupID"));
241 cartOrderLine.googleImpression = Newtonsoft.Json.JsonConvert.SerializeObject(new GoogleImpression()
242 {
243 name = cartOrderLine.name,
244 brand = orderline.GetString("Ecom:Product:Field.brand.Value"),
245 category = (groupObject != null ? groupObject.Name : ""),
246 id = cartOrderLine.id,
247 quantity = Converter.ToInt32(cartOrderLine.quantity),
248 price = orderline.GetDouble("Ecom:Order:OrderLine.UnitPrice.Price"),
249 variant = cartOrderLine.variantId,
250 currency = orderline.GetString("Ecom:Product.Price.Currency.Code")
251 });
252 }
253
254 cartOrderLine.BomItems = new List<BomItem>();
255
256 foreach (LoopItem bomitem in orderline.GetLoop("BOMItems"))
257 {
258 BomItem bomItem = new BomItem();
259 string bomItemLink = "/" + Regex.Replace(bomitem.GetString("Ecom:Product.LinkGroup.Clean"), @"\?ID=\d*\&", "?ID=" + productCatalog + "&");
260
261 bomItem.id = bomitem.GetString("Ecom:Order:OrderLine.Id");
262 bomItem.name = bomitem.GetString("Ecom:Order:OrderLine.ProductName");
263 bomItem.productnumber = bomitem.GetString("Ecom:Order:OrderLine.ProductNumber");
264 bomItem.variantname = bomitem.GetString("Ecom:Order:OrderLine.ProductVariantText");
265 bomItem.unitname = bomitem.GetString("Ecom:Order:OrderLine.UnitName");
266 bomItem.image = GetProductImage(bomitem);
267 bomItem.link = bomItemLink;
268 bomItem.quantity = bomitem.GetString("Ecom:Order:OrderLine.Quantity");
269 cartOrderLine.BomItems.Add(bomItem);
270 }
271
272 cartOrderLine.ShippingMethods = new List<ShippingMethod>();
273
274 List<LoopItem> shippingMethods = GetLoop("Shippingmethods");
275 if (Pageview.AreaSettings.GetItem("Ecommerce").GetItem("Checkout").GetBoolean("HideShippingWarningsAndErrors"))
276 {
277 shippingMethods = shippingMethods.Where(s => !(string.Concat(s.GetString("Ecom:Cart.Shippingmethod.Error"), s.GetString("Ecom:Cart.Shippingmethod.Warning")).IsNotNullOrEmpty() && s.GetDouble("Ecom:Cart.ShippingMethod.Price.Price").Equals(0))).ToList();
278 }
279 foreach (LoopItem shipping in shippingMethods)
280 {
281 ShippingMethod shippingMethod = new ShippingMethod();
282 shippingMethod.id = shipping.GetString("Ecom:Cart.Shippingmethod.ID");
283 shippingMethod.name = shipping.GetString("Ecom:Cart.Shippingmethod.Name");
284 shippingMethod.selected = shipping.GetString("Ecom:Cart.Shippingmethod.Name") == GetString("Ecom:Order.ShippingMethod") ? "checked" : "";
285 if (shipping.GetString("Ecom:Cart.Shippingmethod.Name") == GetString("Ecom:Order.ShippingMethod"))
286 {
287 shippingMethod.hasShippingProvider = string.IsNullOrWhiteSpace(shipping.GetString("Ecom:ShippingProvider.Content")) ? "u-hidden" : "";
288 shippingMethod.shippingProviderContent = Newtonsoft.Json.JsonConvert.DeserializeObject(shipping.GetString("Ecom:ShippingProvider.Content"));
289 }
290 else
291 {
292 shippingMethod.shippingProviderContent = null;
293 shippingMethod.hasShippingProvider = "u-hidden";
294 }
295 cartOrderLine.ShippingMethods.Add(shippingMethod);
296 }
297
298 feedRoot.OrderLines.Add(cartOrderLine);
299 }
300
301 feedObject.Add(feedRoot);
302 jsonFeed = Newtonsoft.Json.JsonConvert.SerializeObject(feedObject);
303
304 }
305
306 @jsonFeed