Error executing template "/Designs/PLC/nolayout/Paragraph/OrderSync.cshtml"
System.NullReferenceException: Object reference not set to an instance of an object.
   at CompiledRazorTemplates.Dynamic.RazorEngine_52c131e809b5443aac38cf1989aeb52e.Execute() in E:\www\uat.petloverscentre.co.th\Solution\Files\Templates\Designs\PLC\nolayout\Paragraph\OrderSync.cshtml:line 42
   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	@using System;
  2	@using System.Collections.Generic;
  3	@using System.Linq;
  4	@using System.Web;
  5	@using System.Xml;
  6	@using System.Net;
  7	@using System.Net.Http;
  8	@using System.Net.Http.Headers;
  9	@using System.IO;
 10	@using System.Text;
 11	@using System.Globalization;
 12	@using System.Xml.Linq;
 13	@using Dynamicweb.Controls;
 14	@using Dynamicweb.Controls.Extensibility;
 15	@using Dynamicweb.Ecommerce.Orders;
 16	@using Dynamicweb.Extensibility;
 17	@using Dynamicweb.Ecommerce.Products;
 18	@using Dynamicweb.Ecommerce.Orders.SalesDiscounts;
 19	@using Dynamicweb.Extensibility.AddIns;
 20	@using Dynamicweb.Security;
 21	@using Newtonsoft.Json;
 22	@{
 23		Order order = Order.GetOrderById(System.Web.HttpContext.Current.Request["OrderId"]);
 24		
 25		string message = string.Empty;
 26		string json = string.Empty;
 27		string GetAllJson = string.Empty;
 28		string homeDInvoice = string.Empty;
 29	
 30		string orderVIPCardNo = "";
 31		string orderOrderRemark = "";
 32		string orderDeliverySlotDateTime = "";
 33		string orderDeliverySlotDate = "";
 34		string orderDeliverySlotTime = "";
 35		string orderOrderComment = "";
 36		string orderHomeDAuthorizedUserRemark = "";
 37		string orderIsMobile = "false";
 38		string orderIPaymentRemarks = "";
 39		string orderHomeDAuthorizedUser = "";
 40		string orderHomeDStatus = "";
 41	
 42		foreach (OrderFieldValue ofv in order.OrderFieldValues)
 43		{
 44			switch (ofv.OrderField.SystemName.ToString().ToLower())
 45			{
 46				case "vipcardno":
 47					orderVIPCardNo = ofv.Value.ToString();
 48					break;
 49				case "orderremark":
 50					orderOrderRemark = ofv.Value.ToString();
 51					break;
 52				case "deliverytimeslot":
 53					orderDeliverySlotDateTime = ofv.Value.ToString();
 54					break;
 55				case "iremarks":
 56					orderHomeDAuthorizedUserRemark = ofv.Value.ToString();
 57					break;
 58				case "ipaymentremarks":
 59					orderIPaymentRemarks = ofv.Value.ToString();
 60					break;
 61				case "ismobileorder":
 62					orderIsMobile = ofv.Value.ToString();
 63					break;
 64				case "homedauthorizeduser":
 65					orderHomeDAuthorizedUser = ofv.Value.ToString();
 66					break;
 67				case "homedstatus":
 68					orderHomeDStatus = ofv.Value.ToString();
 69					break;
 70			}
 71		}
 72	
 73		json = "{" +
 74				"\"OrderId\":" + "\"" + order.Id + "\"," +
 75				"\"OrderShopId\":" + "\"" + order.ShopName + "\"," +
 76				"\"OrderDate\":" + "\"" + order.Date.ToString("yyyy/MM/dd h:mm:ss tt") + "\"," +
 77	//"\"OrderModified\":" + "\"" + order.CompletedDate?.ToString("yyyy/MM/dd h:mm:ss tt") + "\"," +
 78				"\"OrderComplete\":" + order.Complete.ToString().ToLower() + "," +
 79				"\"OrderDeleted\":" + order.Deleted.ToString().ToLower() + "," +
 80				"\"OrderStateId\":" + "\"" + order.StateId + "\"," +
 81				"\"OrderVAT\":" + order.Vat.ToString("0.##") + "," +
 82				"\"OrderIP\":" + "\"" + order.Ip + "\"," +
 83				"\"OrderReferrer\":" + "\"" + order.Referrer + "\"," +
 84				"\"OrderTransactionValue\":" + "\"" + order.TransactionValue + "\"," +
 85				"\"OrderTransactionType\":" + "\"" + order.TransactionType + "\"," +
 86				"\"OrderTransactionStatus\":" + "\"" + order.TransactionStatus + "\"," +
 87				"\"OrderTransactionAmount\":" + order.TransactionAmount + "," +
 88				"\"OrderTransactionPayGatewayCode\":" + "\"" + order.TransactionPayGatewayCode + "\"," +
 89				"\"OrderTrackTraceNumber\":" + "\"" + order.TrackTraceNumber + "\"," +
 90				"\"OrderShippingMethod\":" + "\"" + order.ShippingMethodId + "\"," +
 91				"\"OrderShippingMethodFee\":" + order.ShippingFee.Price + "," +
 92				"\"OrderPaymentMethod\":" + "\"" + order.PaymentMethod + "\"," +
 93				"\"OrderPaymentMethodFee\":" + order.PaymentFee.Price + "," +
 94				"\"OrderSalesDiscount\":" + order.SalesDiscount + "," +
 95				"\"OrderCurrencyName\":" + "\"" + order.CurrencyName + "\"," +
 96				"\"OrderCurrencyRate\":" + order.CurrencyRate + "," +
 97				"\"OrderCurrencyCode\":" + "\"" + order.CurrencyCode + "\"," +
 98				"\"OrderCart\":" + order.IsCart.ToString().ToLower() + "," +
 99				"\"OrderFieldsXML\":" + "\"" + order.FieldsXml + "\"," +
100				"\"OrderReSendEmail\":" + "\"" + order.ReSendEmail + "\"," +
101				"\"OrderCustomerNumber\":" + "\"" + order.CustomerNumber + "\"," +
102				"\"OrderCustomerCompany\":" + "\"" + order.CustomerCompany + "\"," +
103				"\"OrderCustomerName\":" + "\"" + order.CustomerName + "\"," +
104				"\"OrderCustomerAddress\":" + "\"" + order.CustomerAddress + "\"," +
105				"\"OrderCustomerAddress2\":" + "\"" + order.CustomerAddress2 + "\"," +
106				"\"OrderCustomerZip\":" + "\"" + order.CustomerZip + "\"," +
107				"\"OrderCustomerCity\":" + "\"" + order.CustomerCity + "\"," +
108				"\"OrderCustomerCountry\":" + "\"" + order.CustomerCountry + "\"," +
109				"\"OrderCustomerRegion\":" + "\"" + order.CustomerRegion + "\"," +
110				"\"OrderCustomerPhone\":" + "\"" + order.CustomerPhone + "\"," +
111				"\"OrderCustomerFax\":" + "\"" + order.CustomerFax + "\"," +
112				"\"OrderCustomerEmail\":" + "\"" + order.CustomerEmail + "\"," +
113				"\"OrderCustomerCell\":" + "\"" + order.CustomerCell + "\"," +
114				"\"OrderCustomerRefId\":" + "\"" + order.CustomerRefId + "\"," +
115				"\"OrderCustomerEAN\":" + "\"" + order.CustomerEan + "\"," +
116				"\"OrderCustomerVatRegNumber\":" + "\"" + order.CustomerVatRegNumber + "\"," +
117				"\"OrderDeliveryCompany\":" + "\"" + order.DeliveryCompany + "\"," +
118				"\"OrderDeliveryName\":" + "\"" + order.DeliveryName + "\"," +
119				"\"OrderDeliveryAddress\":" + "\"" + order.DeliveryAddress + "\"," +
120				"\"OrderDeliveryAddress2\":" + "\"" + order.DeliveryAddress2 + "\"," +
121				"\"OrderDeliveryZip\":" + "\"" + order.DeliveryZip + "\"," +
122				"\"OrderDeliveryCity\":" + "\"" + order.DeliveryCity + "\"," +
123				"\"OrderDeliveryCountry\":" + "\"" + order.DeliveryCountry + "\"," +
124				"\"OrderDeliveryRegion\":" + "\"" + order.DeliveryRegion + "\"," +
125				"\"OrderDeliveryPhone\":" + "\"" + order.DeliveryPhone + "\"," +
126				"\"OrderDeliveryFax\":" + "\"" + order.DeliveryFax + "\"," +
127				"\"OrderDeliveryEmail\":" + "\"" + order.DeliveryEmail + "\"," +
128				"\"OrderDeliveryCell\":" + "\"" + order.DeliveryCell + "\"," +
129				"\"OrderTotalPrice\":" + order.TotalPrice + "," +
130				"\"OrderComment\":" + "\"" + order.Comment + "\"," +
131				"\"OrderCustomerComment\":" + "\"" + order.CustomerComment.Replace("\"", "\\" + "\"") + "\"," +
132				"\"OrderWeight\":" + order.Weight + "," +
133				"\"OrderVolume\":" + order.Volume + "," +
134				"\"OrderPriceWithVAT\":" + order.Price.PriceWithVAT + "," +
135				"\"OrderPriceWithoutVAT\":" + order.Price.PriceWithoutVAT.ToString("0.00") + "," +
136				"\"OrderPriceVAT\":" + order.Price.VAT.ToString("0.00") + "," +
137				"\"OrderPriceVATPercent\":" + Convert.ToInt16(order.Price.VATPercent) + "," +
138				"\"OrderShippingFeeWithVAT\":" + order.ShippingFee.PriceWithVAT + "," +
139				"\"OrderShippingFeeWithoutVAT\":" + order.ShippingFee.PriceWithoutVAT.ToString("0.00") + "," +
140				"\"OrderShippingFeeVAT\":" + order.ShippingFee.VAT.ToString("0.00") + "," +
141				"\"OrderShippingFeeVATPercent\":" + Convert.ToInt16(order.ShippingFee.VATPercent) + "," +
142				"\"OrderPaymentFeeWithVAT\":" + order.PaymentFee.PriceWithVAT + "," +
143				"\"OrderPaymentFeeWithoutVAT\":" + order.PaymentFee.PriceWithoutVAT.ToString("0.00") + "," +
144				"\"OrderPaymentFeeVAT\":" + order.PaymentFee.VAT.ToString("0.00") + "," +
145				"\"OrderPaymentFeeVATPercent\":" + order.PaymentFee.VATPercent + "," +
146				"\"OrderPriceBeforeFeesWithVAT\":" + order.PriceBeforeFees.PriceWithVAT + "," +
147				"\"OrderPriceBeforeFeesWithoutVAT\":" + order.PriceBeforeFees.PriceWithoutVAT.ToString("0.00") + "," +
148				"\"OrderPriceBeforeFeesVAT\":" + order.PriceBeforeFees.VAT.ToString("0.00") + "," +
149				"\"OrderPriceBeforeFeesVATPercent\":" + Convert.ToInt16(order.PriceBeforeFees.VATPercent) + "," +
150				"\"OrderCustomerAccessUserId\":" + order.CustomerAccessUserId + "," +
151				"\"OrderCustomerAccessUserUserName\":" + "\"" + order.CustomerAccessUserUserName + "\"," +
152				"\"OrderShippingMethodId\":" + "\"" + order.ShippingMethodId + "\"," +
153				"\"OrderPaymentMethodId\":" + "\"" + order.PaymentMethodId + "\"," +
154				"\"OrderGatewayResult\":" + "\"" + order.GatewayResult + "\"," +
155				"\"OrderStepNum\":" + order.StepNum + "," +
156				"\"OrderTransactionNumber\":" + "\"" + order.TransactionNumber + "\"," +
157				"\"OrderCustomerCountryCode\":" + "\"" + order.CustomerCountryCode + "\"," +
158				"\"OrderDeliveryCountryCode\":" + "\"" + order.DeliveryCountryCode + "\"," +
159				"\"OrderStepHistory\":" + "\"" + order.StepHistory + "\"," +
160				"\"OrderLanguageId\":" + "\"" + order.LanguageId + "\"," +
161				"\"OrderTransactionMailSend\":" + order.TransactionMailSend.ToString().ToLower() + "," +
162				"\"OrderShippingMethodDescription\":" + "\"" + order.ShippingMethodDescription + "\"," +
163				"\"OrderPaymentMethodDescription\":" + "\"" + order.PaymentMethodDescription + "\"," +
164				"\"OrderCustomerNewsletterSubcribe\":" + order.NewsletterSubscribe.ToString().ToLower() + "," +
165				"\"OrderGatewayPaymentStatus\":" + "\"" + order.GatewayPaymentStatus + "\"," +
166				"\"OrderGatewayTransactionProblems\":" + "\"" + "" + "\"," +
167				"\"OrderGatewayUniqueId\":" + "\"" + order.GatewayUniqueId + "\"," +
168				"\"OrderCaptureInfo\":" + "\"" + "" + "\"," +
169				"\"OrderCartV2StepIndex\":" + order.CartV2StepIndex + "," +
170				"\"OrderSecret\":" + "\"" + order.Secret + "\"," +
171				"\"OrderShippingCountrySelection\":" + "\"" + order.ShippingCountrySelection + "\"," +
172				"\"OrderPaymentCountrySelection\":" + "\"" + order.PaymentCountrySelection + "\"," +
173				"\"OrderCustomerAccepted\":" + order.CustomerAccepted.ToString().ToLower() + "," +
174				"\"OrderDebuggingInfo\":" + "\"" + "" + "\"," +
175				"\"OrderHasSetUserDetails\":" + order.HasSetUserDetails.ToString().ToLower() + "," +
176				"\"OrderTrackAndTraceId\":" + order.TrackTraceId + "," +
177				"\"OrderTrackAndTraceParameters\":" + "\"" + order.TrackTraceParameters + "\"," +
178				"\"OrderIntegrationOrderId\":" + "\"" + order.IntegrationOrderId + "\"," +
179				"\"OrderRequisition\":" + "\"" + order.Requisition + "\"," +
180				"\"OrderAXOrderId\":" + "\"" + order.IntegrationOrderId + "\"," +
181				"\"OrderVisitorSessionId\":" + "\"" + order.VisitorSessionId + "\"," +
182				"\"OrderIsExported\":" + order.IsExported.ToString().ToLower() + "," +
183				"\"OrderVoucherCode\":" + "\"" + order.VoucherCode + "\"," +
184				"\"OrderCustomerSurname\":" + "\"" + order.CustomerSurname + "\"," +
185				"\"OrderCustomerInitials\":" + "\"" + order.CustomerInitials + "\"," +
186				"\"OrderCustomerPrefix\":" + "\"" + order.CustomerPrefix + "\"," +
187				"\"OrderDeliverySurname\":" + "\"" + order.DeliverySurname + "\"," +
188				"\"OrderDeliveryInitials\":" + "\"" + order.DeliveryInitials + "\"," +
189				"\"OrderDeliveryPrefix\":" + "\"" + order.DeliveryPrefix + "\"," +
190				"\"OrderShippingDocumentData\":" + "\"" + "" + "\"," +
191				"\"OrderShippingProviderData\":" + "\"" + "" + "\"," +
192	//"\"OrderCompletedDate\":" + "\"" + order.CompletedDate?.ToString("yyyy/MM/dd h:mm:ss tt") + "\"," +
193				"\"OrderSecondaryUserId\":" + order.SecondaryUserId + "," +
194				"\"OrderReceiptShowCount\":" + order.ReceiptShowCount + "," +
195				"\"OrderCaptureAmount\":" + order.CaptureAmount + "," +
196				"\"OrderTransactionCardType\":" + "\"" + order.TransactionCardType + "\"," +
197				"\"OrderExternalPaymentFee\":" + order.ExternalPaymentFee + "," +
198				"\"OrderAutoId\":" + order.AutoId + "," +
199	//"\"OrderPriceCalculationDate\":" + "\"" + order.PriceCalculationDate?.ToString("yyyy/MM/dd h:mm:ss tt") + "\"," +
200				"\"OrderTotalPoints\":" + order.TotalPoints + "," +
201				"\"OrderTotalRewardPoints\":" + order.RewardTotalPoints + "," +
202				"\"OrderTotalDiscountWithVAT\":" + order.TotalDiscount.PriceWithVAT + "," +
203				"\"OrderTotalDiscountWithoutVAT\":" + order.TotalDiscount.PriceWithoutVAT.ToString("0.00") + "," +
204				"\"OrderTotalDiscountVAT\":" + order.TotalDiscount.VAT.ToString("0.00") + "," +
205				"\"OrderTotalDiscountVATPercent\":" + Convert.ToInt16(order.TotalDiscount.VATPercent) + "," +
206				"\"OrderIsQuote\":" + order.IsQuote.ToString().ToLower() + "," +
207				"\"OrderTransactionCardNumber\":" + "\"" + order.TransactionCardNumber + "\"," +
208				"\"OrderCustomerTitle\":" + "\"" + order.CustomerTitle + "\"," +
209				"\"OrderCustomerFirstName\":" + "\"" + order.CustomerFirstName + "\"," +
210				"\"OrderCustomerMiddleName\":" + "\"" + order.CustomerMiddleName + "\"," +
211				"\"OrderCustomerHouseNumber\":" + "\"" + order.CustomerHouseNumber + "\"," +
212				"\"OrderDeliveryTitle\":" + "\"" + order.DeliveryTitle + "\"," +
213				"\"OrderDeliveryFirstName\":" + "\"" + order.DeliveryFirstName + "\"," +
214				"\"OrderDeliveryMiddleName\":" + "\"" + order.DeliveryMiddleName + "\"," +
215				"\"OrderDeliveryHouseNumber\":" + "\"" + order.DeliveryHouseNumber + "\"," +
216				"\"OrderCheckoutPageID\":" + order.CheckoutPageId + "," +
217				"\"OrderVisitorSessionDate\":" + "\"" + order.VisitorSessionDate.ToString("yyyy/MM/dd h:mm:ss tt") + "\"," +
218				"\"OrderPriceCalculatedByProvider\":" + order.IsPriceCalculatedByProvider.ToString().ToLower() + "," +
219				"\"OrderTaxTransactionNumber\":" + "\"" + order.TaxTransactionNumber + "\"," +
220				"\"OrderVoucherUseType\":\"" + 0 + "\"," +
221				"\"OrderContextID\":" + "\"" + order.OrderContextId + "\"," +
222				"\"OrderGiftcardTransactionFailed\":" + order.GiftCardTransactionFailed.ToString().ToLower() + "," +
223				"\"OrderShippingFeeRuleName\":" + "\"" + "" + "\"," +
224				"\"OrderRecurringOrderId\":" + order.RecurringOrderId + "," +
225				"\"OrderPaymentRecurringInfo\":" + "\"" + order.PaymentRecurringInfo + "\"," +
226				"\"OrderSavedCardID\":" + order.SavedCardId + "," +
227				"\"OrderIsRecurringOrderTemplate\":" + order.IsRecurringOrderTemplate.ToString().ToLower() + "," +
228				"\"OrderRemark\":" + "\"" + orderOrderRemark + "\"," +
229				"\"DeliveryTimeSlot\":" + "\"" + "" + "\"," +
230				"\"OrderTransactionToken\":" + "\"" + order.TransactionToken + "\"," +
231				"\"OrderTransactionTokenCheckSum\":" + "\"" + order.TransactionTokenCheckSum + "\"," +
232				"\"OrderIsLedgerEntry\":\"" + false + "\"," +
233				"\"OrderIsPayable\":\"" + false + "\"," +
234				"\"HomeDStatus\":" + "\"" + orderHomeDStatus + "\"," +
235				"\"OrderReturnOperations\":" + "\"" + "" + "\"," +
236				"\"IPaymentRemarks\":" + "\"" + orderIPaymentRemarks + "\"," +
237				"\"VIPCardNumber\":" + "\"" + orderVIPCardNo + "\"," +
238				"\"CustomerComment\":" + "\"" + order.CustomerComment.Replace("\"", "\\" + "\"") + "\"," +
239				"\"DeliverySlotDate\":" + "\"" + orderDeliverySlotDate + "\"," +
240				"\"DeliverySlotTime\":" + "\"" + orderDeliverySlotTime + "\"," +
241				"\"HomeDAuthorizedUserRemark\":" + "\"" + orderHomeDAuthorizedUserRemark + "\"," +
242				"\"HomeDUser\":" + "\"" + orderHomeDAuthorizedUser + "\"," +
243				"\"PaymentRemarks\":" + "\"" + orderIPaymentRemarks + "\"," +
244				"\"IsMobile\":" + "\"" + orderIsMobile + "\"," +
245	
246				"\"OrderLineModels\":" +
247				"[";
248	
249		string orderlinejson = string.Empty;
250		bool isfirst = true;
251	
252		foreach (var orderline in order.OrderLines)
253		{
254			string barcode = string.Empty;
255			string number = orderline.ProductNumber;
256			string brand = string.Empty;
257			string description = orderline.Product.ShortDescription;
258			double cost = 0.00;
259	
260			foreach (ProductFieldValue pfv in orderline.Product.ProductFieldValues)
261			{
262				if (pfv.ProductField.SystemName.Equals("ProductBarCode"))
263				{
264					barcode = (pfv.Value != null) ? (string)pfv.Value : string.Empty;
265				}
266				if (pfv.ProductField.SystemName.Equals("ProductSCost"))
267				{
268					cost = (pfv.Value != null) ? (double)pfv.Value : 0.00;
269				}
270			}
271			if (orderline.Type == "3")
272			{
273				//get orderlineParentLineId  and set discount value
274				//
275			}
276			if (orderline.Type == "1")
277			{
278				//check voucher or buy 1 get 1 dscount
279			}
280			if (orderline.Type != "3" && orderline.Type != "1")
281			{
282				var productID = "{[" + orderline.ProductId + "]}";
283				//PLCSVC.PS_Service service = new PLCSVC.PS_Service();
284				//var productStatus = service.GetMultiStatusAdv("dynamicweb", "{_0rfJ39sw", productID);
285				//productStatus = productStatus.Substring(productStatus.IndexOf(":") + 1);
286				//productStatus = (productStatus.Split(']'))[0];
287			}
288	
289			string orderLineStockStatus = "";
290			double orderLineSPrice = 0.00;
291			string orderLineSDiscount = "false";
292			double orderLineSDiscountAmount = 0.00;
293			double orderLineSCost = 0.00;
294			string orderLineBrand = "";
295			string orderLineCategory = "";
296			string productParentNumber = orderline.ParentLineId;
297			string productId = orderline.ProductId;
298			switch (orderline.Type.ToString())
299			{
300				case "0":
301					using (var myDr = Dynamicweb.Data.Database.CreateDataReader("SELECT StockStatus, sPrice, sDiscount, sdiscountamount, sCost, brand, category FROM EcomOrderLineExtensions WHERE OrderLineId ='" + orderline.Id + "'"))
302					{
303						while (myDr.Read())
304						{
305							orderLineStockStatus = myDr["StockStatus"].ToString();
306							orderLineSPrice = !string.IsNullOrEmpty(myDr["sPrice"].ToString()) ? Convert.ToDouble(myDr["sPrice"].ToString()) : 0;
307							orderLineSCost = !string.IsNullOrEmpty(myDr["sCost"].ToString()) ? Convert.ToDouble(myDr["sCost"].ToString()) : 0;
308							orderLineSDiscount = !string.IsNullOrEmpty(myDr["sDiscount"].ToString()) ? myDr["sDiscount"].ToString() : "false";
309							orderLineSDiscountAmount = !string.IsNullOrEmpty(myDr["sDiscountAmount"].ToString()) ? Convert.ToDouble(myDr["sDiscountAmount"].ToString()) : 0;
310							orderLineBrand = myDr["Brand"].ToString();
311							orderLineCategory = myDr["Category"].ToString();
312						}
313					}
314	
315					//orderLineSPrice = orderLineSPrice;
316					orderLineSDiscount = orderLineSDiscount == "1" ? "true" : "false";
317					//orderLineSDiscountAmount = orderLineSDiscountAmount;
318					//orderLineSCost = orderLineSCost;
319					foreach (OrderLineFieldValue olfv in orderline.OrderLineFieldValues)
320					{
321						switch (olfv.OrderLineFieldSystemName.ToString().ToLower())
322						{
323							case "parentproductnumber":
324								break;
325							case "parentproductid":
326								if (!string.IsNullOrEmpty(olfv.Value.ToString()))
327								{
328									productId = "";
329									productParentNumber = olfv.Value.ToString();
330								}
331								break;
332						}
333					}
334					break;
335	
336				case "1":
337					if(!string.IsNullOrEmpty(orderline.DiscountId))
338					{
339						orderLineBrand = Dynamicweb.Data.Database.ExecuteScalar("SELECT DiscountBrand FROM EcomDiscountExtensions WHERE DiscountID ='" + orderline.DiscountId + "'").ToString();
340						orderLineCategory = Dynamicweb.Data.Database.ExecuteScalar("SELECT DiscountCategory FROM EcomDiscountExtensions WHERE DiscountID ='" + orderline.DiscountId + "'").ToString();
341					}
342					break;
343			}
344	
345			orderlinejson = "{" +
346							"\"OrderLineId\":\"" + orderline.Id + "\"," +
347							"\"OrderLineOrderId\":\"" + orderline.OrderId + "\"," +
348							"\"OrderLineParentLineId\":\"" + orderline.ParentLineId + "\"," +
349							"\"OrderLineBOM\":" + orderline.Bom.ToString().ToLower() + "," +
350							"\"OrderLineDate\":\"" + orderline.Date.ToString("yyyy/MM/dd h:mm:ss tt") + "\"," +
351							"\"OrderLineModified\":\"" + orderline.Modified.Date.ToString("yyyy/MM/dd h:mm:ss tt") + "\"," +
352							"\"OrderLineProductNumber\":\"" + orderline.ProductNumber + "\"," +
353							"\"OrderLineProductId\":\"" + productId + "\"," +
354							"\"OrderLineProductVariantId\":\"" + orderline.ProductVariantId + "\"," +
355							"\"OrderLineProductName\":\"" + orderline.ProductName + "\"," +
356							"\"OrderLineProductVariantText\":\"" + orderline.ProductVariantText + "\"," +
357							"\"OrderLineUnitPrice\":" + orderline.UnitPrice.Price + "," +
358							"\"OrderLineVatPercent\":" + Convert.ToInt16(orderline.Price.VATPercent) + "," +
359							"\"OrderLineVatPrice\":" + orderline.Price.VAT + "," +
360							"\"OrderLineQuantity\":" + orderline.Quantity + "," +
361							"\"OrderLineType\":\"" + orderline.Type + "\"," +
362							"\"OrderLineReference\":\"" + orderline.Reference + "\"," +
363							"\"OrderLineBOMItemId\":\"" + orderline.BomItemId + "\"," +
364							"\"OrderLineUnitId\":\"" + orderline.UnitId + "\"," +
365							"\"OrderLineWeight\":" + orderline.Weight + "," +
366							"\"OrderLineVolume\":" + orderline.Volume + "," +
367							"\"OrderLinePriceWithVAT\":" + orderline.Price.PriceWithVAT + "," +
368							//"\"OrderLinePriceWithoutVAT\":" + orderline.Price.PriceWithoutVAT + "," +
369							"\"OrderLinePriceWithoutVAT\":" + orderline.Price.PriceWithoutVAT.ToString("0.00") + "," +
370							//"\"OrderLinePriceVAT\":" + orderline.Price.VAT + "," +
371							"\"OrderLinePriceVAT\":" + orderline.Price.VAT.ToString("0.00") + "," +
372							"\"OrderLinePriceVATPercent\":" + Convert.ToInt16(orderline.Price.VATPercent) + "," +
373							"\"OrderLineUnitPriceWithVAT\":" + orderline.UnitPrice.PriceWithVAT + "," +
374							"\"OrderLineUnitPriceWithoutVAT\":" + orderline.UnitPrice.PriceWithoutVAT.ToString("0.00") + "," +
375							//"\"OrderLineUnitPriceVAT\":" + orderline.UnitPrice.VAT + "," +
376							"\"OrderLineUnitPriceVAT\":" + orderline.UnitPrice.VAT.ToString("0.00") + "," +
377							"\"OrderLineUnitPriceVATPercent\":" + Convert.ToInt16(orderline.UnitPrice.VATPercent) + "," +
378							"\"OrderLinePageId\":" + orderline.PageId + "," +
379							"\"OrderLineDiscountId\":\"" + orderline.DiscountId + "\"," +
380							"\"OrderLineFieldValues\":\"" + productParentNumber + "\"," +
381							"\"OrderLineAttachment\":\"" + orderline.Attachment + "\"," +
382							"\"OrderLineAutoId\":" + 0 + "," +
383							"\"OrderLineWishListId\":" + orderline.ListId + "," +
384							"\"OrderLinePriceCalculationReference\":\"" + "" + "\"," +
385							"\"OrderLineUnitPriceCalculationReference\":\"" + "" + "\"," +
386							"\"OrderLineUnitPoints\":" + 0.00 + "," +
387							"\"OrderLineUnitRewardPoints\":" + 0.00 + "," +
388							"\"OrderLinePoints\":" + 0.00 + "," +
389							"\"OrderLineRewardPoints\":" + 0.00 + "," +
390							"\"OrderLineRewardId\":" + orderline.RewardId + "," +
391							"\"OrderLineReverseChargeForVat\":" + orderline.ReverseChargeForVat.ToString().ToLower() + "," +
392							"\"OrderLineTotalDiscountWithVAT\":" + orderline.TotalDiscount.PriceWithVAT + "," +
393							//"\"OrderLineTotalDiscountWithoutVAT\":" + orderline.TotalDiscount.PriceWithoutVAT + "," +
394							"\"OrderLineTotalDiscountWithoutVAT\":" + orderline.TotalDiscount.PriceWithoutVAT.ToString("0.00") + "," +
395							//"\"OrderLineTotalDiscountVAT\":" + orderline.TotalDiscount.VAT + "," +
396							"\"OrderLineTotalDiscountVAT\":" + orderline.TotalDiscount.VAT.ToString("0.00") + "," +
397							"\"OrderLineTotalDiscountVATPercent\":" + Convert.ToInt16(orderline.TotalDiscount.VATPercent) + "," +
398							"\"OrderLineGiftCardCode\":\"" + orderline.GiftCardCode + "\"," +
399	
400							"\"OrderLineStockStatus\":\"" + orderLineStockStatus + "\"," +
401							"\"sPrice\":\"" + orderLineSPrice + "\"," +
402							"\"sDiscount\":\"" + orderLineSDiscount + "\"," +
403							"\"sDiscountAmount\":\"" + orderLineSDiscountAmount + "\"," +
404							"\"sCost\":\"" + orderLineSCost + "\"," +
405							"\"Brand\":\"" + orderLineBrand + "\"," +
406							"\"Category\":\"" + orderLineCategory + "\"" +
407							"}";
408			if (isfirst) { isfirst = false; }
409			else { json += ","; }
410			json += orderlinejson;
411		}
412		json += "]}";
413	}
414	@json