Error executing template "Designs/Lb/eCom/Productlist/ProductLandingPage.cshtml"
System.DivideByZeroException: Attempted to divide by zero.
   at System.Decimal.FCallDivide(Decimal& d1, Decimal& d2)
   at System.Decimal.op_Division(Decimal d1, Decimal d2)
   at CompiledRazorTemplates.Dynamic.RazorEngine_67ec5a19200443ee9ff7a173d9f5a8c9.Execute() in C:\Solutions\Sojborg.Production\Files\Templates\Designs\Lb\eCom\Productlist\ProductLandingPage.cshtml:line 44
   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.b__0(TextWriter writer)
   at RazorEngine.Templating.RazorEngineServiceExtensions.WithWriter(Action`1 withWriter)
   at Dynamicweb.Rendering.Template.RenderRazorTemplate()


  1	@inherits RazorTemplateBase<RazorTemplateModel<Template>>
  2	@using Dynamicweb;
  3	@using Dynamicweb.Rendering;
  4	@using System.Web;
  5	
  6	@{
  7	
  8	    var product = GetLoop("Products").Where(x => x.GetString("Ecom:Product:Field.FamilyMaster.Value") == "True").FirstOrDefault();
  9	
 10	    if (product != null)
 11	    {
 12	
 13	        var image1 = Sojborg.Helpers.Helpers.GetListImagePath(product.GetString("Ecom:Product.Number"), "littlebugz", "_1", "jpg");
 14	
 15	
 16	
 17	        var commentsList = new List<Sojborg.Models.Comment>();
 18	
 19	        string sqlGetProductsInPattern = "SELECT * FROM EcomProducts WHERE ProductNumber LIKE '" + product.GetString("Ecom:Product:Field.FamilyPattern.Value") + "%' AND ProductRating > 0";
 20	
 21	        using (var myDr = Dynamicweb.Data.Database.CreateDataReader(sqlGetProductsInPattern))
 22	        {
 23	            while (myDr.Read())
 24	            {
 25	                string sqlGetRatings = "SELECT * FROM Comment WHERE CommentItemID = '" + myDr["ProductID"] + "'";
 26	                using (var myDr2 = Dynamicweb.Data.Database.CreateDataReader(sqlGetRatings))
 27	                {
 28	                    while (myDr2.Read())
 29	                    {
 30	                        Sojborg.Models.Comment c = new Sojborg.Models.Comment
 31	                        {
 32	                            CommentCreatedBy = myDr2["CommentName"].ToString(),
 33	                            CommentEmail = myDr2["CommentEmail"].ToString(),
 34	                            CommentText = myDr2["CommentText"].ToString(),
 35	                            CommentRating = decimal.Parse(myDr2["CommentRating"].ToString()),
 36	                            CommentCreatedDate = DateTime.Parse(myDr2["CommentCreatedDate"].ToString())
 37	                        };
 38	                        commentsList.Add(c);
 39	                    }
 40	                }
 41	            }
 42	        }
 43	
 44	        decimal RatingSum = (commentsList.Sum(x => x.CommentRating) / commentsList.Count);
 45	
 46	<div class="row center">
 47	    <div class="col-md-12">
 48	        <div class="rating-stars" data-rating="@RatingSum.ToString().Replace(",",".")" id="rateYo"></div>
 49	        <label class="rating-stars-panel" for="rateYo2">(@commentsList.Count @(commentsList.Count > 1 ? "Anmeldelser" : "Anmeldelse"))</label>
 50	    </div>
 51	</div>
 52	
 53	<script type="application/ld+json">
 54	    @{
 55	        <text>
 56	            {
 57	            "@@context": "http://schema.org/",
 58	            "@@type": "Product",
 59	            "name": "@product.GetString("Ecom:Product:Field.FamilyName.Value")",
 60	            "image": "http://@GetGlobalValue("Global:Request.Host")/admin/public/getimage.ashx?image=@image1&width=580",
 61	            "description": "@product.GetString("Ecom:Product.LongDescription")",
 62	            "mpn": "@product.GetString("Ecom:Product.Number")",
 63	            "sku": "@(!string.IsNullOrEmpty(product.GetString("Ecom:Product:Field.EAN.Value")) ? product.GetString("Ecom:Product:Field.EAN.Value") : product.GetString("Ecom:Product.Number") )",
 64	            "brand": {
 65	            "@@type": "Thing",
 66	            "name": "@(!string.IsNullOrEmpty(product.GetString("Ecom:Manufacturer.Name")) ? product.GetString("Ecom:Manufacturer.Name") : "Littlebugz")"
 67	            },
 68	            "review": [
 69	            @GetReviews(commentsList)
 70	            ],
 71	            "aggregateRating": {
 72	            "@@type": "AggregateRating",
 73	            "ratingValue": "5",
 74	            "reviewCount": "@commentsList.Count()"
 75	            },
 76	            "offers": {
 77	            "@@type": "Offer",
 78	            "url": "@HttpContext.Current.Request.Url.AbsoluteUri",
 79	            "priceCurrency": "DKK",
 80	            "price": "@product.GetString("Ecom:Product.Discount.Price.Price").Replace(",", ".")",
 81	            "priceValidUntil": "@(DateTime.Now.AddYears(1).ToString("yyyy-MM-dd"))",
 82	            "itemCondition": "http://schema.org/NewCondition",
 83	            "availability": "http://schema.org/InStock"
 84	            }
 85	            }
 86	        </text>
 87	
 88	    }
 89	
 90	</script>
 91	
 92	            }
 93	        }
 94	
 95	    @helper GetReviews(List<Sojborg.Models.Comment> commentsList)
 96	    {
 97	        int counter = 1;
 98	        foreach (Sojborg.Models.Comment comment in commentsList)
 99	        {
100	            <text>
101	                {
102	                "@@type": "Review",
103	                "author": "@comment.CommentCreatedBy",
104	                "datePublished": "@comment.CommentCreatedDate.ToString("dd-MM-yyyy")",
105	                "description": "@comment.CommentText",
106	                "reviewRating": {
107	                "@@type": "Rating",
108	                "bestRating": "5",
109	                "worstRating": "1",
110	                "ratingValue": "@comment.CommentRating"
111	                }
112	                }@(counter == commentsList.Count() ? string.Empty : ",")
113	            </text>
114	            counter++;
115	        }
116	    }
117	
118	
119