using System;

using System.Web.Mvc;

using System.Collections.Generic;

using System.Linq;

using System.Xml.Linq;

​

namespace HelloWorldMvcApp

{

    public class HomeController : Controller

    {

        [HttpGet]

        public ActionResult Index()

        {

         string myXML = @"<LowestOfferListings>

                <LowestOfferListing>

                    <Qualifiers>

                        <ItemCondition>Used</ItemCondition>

                        <ItemSubcondition>Acceptable</ItemSubcondition>

                        <FulfillmentChannel>Merchant</FulfillmentChannel>

                        <ShipsDomestically>True</ShipsDomestically>

                        <ShippingTime>

                            <Max>0-2 days</Max>

                        </ShippingTime>

                        <SellerPositiveFeedbackRating>95-97%</SellerPositiveFeedbackRating>

                    </Qualifiers>

                    <NumberOfOfferListingsConsidered>3</NumberOfOfferListingsConsidered>

                    <SellerFeedbackCount>8900</SellerFeedbackCount>

                    <Price>

                        <LandedPrice>

                            <CurrencyCode>USD</CurrencyCode>

                            <Amount>28.68</Amount>

                        </LandedPrice>

                        <ListingPrice>

                            <CurrencyCode>USD</CurrencyCode>

                            <Amount>24.69</Amount>

                        </ListingPrice>

                        <Shipping>

                            <CurrencyCode>USD</CurrencyCode>

                            <Amount>3.99</Amount>

                        </Shipping>

                    </Price>

                    <MultipleOffersAtLowestPrice>True</MultipleOffersAtLowestPrice>

                </LowestOfferListing>

                <LowestOfferListing>

                    <Qualifiers>

                        <ItemCondition>Used</ItemCondition>

                        <ItemSubcondition>Good</ItemSubcondition>

                        <FulfillmentChannel>Amazon</FulfillmentChannel>

                        <ShipsDomestically>True</ShipsDomestically>

                        <ShippingTime>

                            <Max>0-2 days</Max>

                        </ShippingTime>

                        <SellerPositiveFeedbackRating>90-94%</SellerPositiveFeedbackRating>

                    </Qualifiers>

                    <NumberOfOfferListingsConsidered>1</NumberOfOfferListingsConsidered>

                    <SellerFeedbackCount>1569694</SellerFeedbackCount>

                    <Price>

                        <LandedPrice>

                            <CurrencyCode>USD</CurrencyCode>

                            <Amount>30.50</Amount>

                        </LandedPrice>

                        <ListingPrice>

                            <CurrencyCode>USD</CurrencyCode>

                            <Amount>30.50</Amount>

                        </ListingPrice>

                        <Shipping>

                            <CurrencyCode>USD</CurrencyCode>

                            <Amount>0.00</Amount>

                        </Shipping>

                    </Price>

                    <MultipleOffersAtLowestPrice>False</MultipleOffersAtLowestPrice>

                </LowestOfferListing>

                <LowestOfferListing>

                    <Qualifiers>

                        <ItemCondition>Used</ItemCondition>

                        <ItemSubcondition>Good</ItemSubcondition>

                        <FulfillmentChannel>Merchant</FulfillmentChannel>

                        <ShipsDomestically>True</ShipsDomestically>

                        <ShippingTime>

                            <Max>0-2 days</Max>

                        </ShippingTime>

                        <SellerPositiveFeedbackRating>95-97%</SellerPositiveFeedbackRating>

                    </Qualifiers>

                    <NumberOfOfferListingsConsidered>3</NumberOfOfferListingsConsidered>

                    <SellerFeedbackCount>7732</SellerFeedbackCount>

                    <Price>

                        <LandedPrice>

                            <CurrencyCode>USD</CurrencyCode>

                            <Amount>30.99</Amount>

                        </LandedPrice>

                        <ListingPrice>

                            <CurrencyCode>USD</CurrencyCode>

                            <Amount>27.00</Amount>

                        </ListingPrice>

                        <Shipping>

                            <CurrencyCode>USD</CurrencyCode>

                            <Amount>3.99</Amount>

                        </Shipping>

                    </Price>

                    <MultipleOffersAtLowestPrice>False</MultipleOffersAtLowestPrice>

                </LowestOfferListing>

            </LowestOfferListings>";

​

         XDocument xdoc = new XDocument();

         xdoc = XDocument.Parse(myXML);

​

         var result = xdoc.Descendants().Elements()

                            .Where(d => d.Name.LocalName == "LowestOfferListing"); 

         string returnHTML = "";

         foreach (XElement item in result) {

             var LandedPrice_Node = item.DescendantsAndSelf().Elements()

                                .Where(d => d.Name.LocalName == "LandedPrice");

             string price = LandedPrice_Node.DescendantsAndSelf().Elements()

                                .Where(d => d.Name.LocalName == "Amount").FirstOrDefault().Value;

            string ItemCondition = item.DescendantsAndSelf().Elements()

                                .Where(d => d.Name.LocalName == "ItemCondition").FirstOrDefault().Value;

            string FulfillmentChannel = item.DescendantsAndSelf().Elements()

                                .Where(d => d.Name.LocalName == "FulfillmentChannel").FirstOrDefault().Value;

            string SellerPositiveFeedbackRating = item.DescendantsAndSelf().Elements()

                                .Where(d => d.Name.LocalName == "SellerPositiveFeedbackRating").FirstOrDefault().Value;

            string SellerFeedbackCount = item.DescendantsAndSelf().Elements()

                                .Where(d => d.Name.LocalName == "SellerFeedbackCount").FirstOrDefault().Value;

             //var ProductPriceInfos = item.DescendantsAndSelf().Elements()

                                    //.Select(x =>

                                    //   new { 

                                    //       Name = x.Element("LabelName").Value,

                                    //       Height = x.Element("LabelHeight").Value,

                                    //       Width = x.Element("LabelWidth").Value

                                    // });

​

            //Console.WriteLine("ProductPriceInfos - " + query.fname);

            //Console.WriteLine("ProductPriceInfos - " + ProductPriceInfos.ItemCondition);

​

                price = "<td>$" + price + "</td>";

                ItemCondition = "<td>(" + ItemCondition + ")</td>";

                FulfillmentChannel = "<td data-toggle='tooltip' title='Seller Feedback Rating and count: " + SellerPositiveFeedbackRating + " (" + SellerFeedbackCount + ")'>" + FulfillmentChannel + "</td>";

​

                returnHTML = returnHTML + "<tr>" + 

                    price + 

                    ItemCondition + 

                    FulfillmentChannel +

                    "</tr>";

         }

​

         //Console.WriteLine("\nPress any key to continue.");

         ViewBag.AllOffers = "<table>" + returnHTML + "<table>";

         ViewBag.BuyBox = "$39.99";

            return View(new SampleViewModel());

        }

​

​

        [HttpPost]

        public JsonResult GetAnswer(string question)

        {               

            int index = _rnd.Next(_db.Count);

            var answer = _db[index];

            return Json(answer);

        }

​

        private static Random _rnd = new Random();

        private static List<string> _db = new List<string> { "Yes", "No", "Definitely, yes", "I don't know", "Looks like, yes"} ;

    }

}