String search function XML file with ASP.NET MVC

Question

My application can search for one type of tag in the XML which is: 'title', but nothing else. I want the user to be able to search for anything in the file with multiple fields and with part strings... What have I done wrong here?

Model:

using System;

namespace Andre_Kordasti___Programmeringsuppgift.Models
{
    public class BookModel
    {
        public string Author { get; set; }
        public string Title { get; set; }
        public string Genre { get; set; }
        public decimal Price { get; set; }
        public DateTime PublishDate { get; set; }
        public string Description { get; set; }
    }
}

View:

   @model IEnumerable<Andre_Kordasti___Programmeringsuppgift.Models.BookModel>

@{
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>Sök</h2>


@using (Html.BeginForm("Index", "Home", FormMethod.Get))
{
    <p>
        Författare: @Html.TextBox("author") <br /><br />
        Titel: @Html.TextBox("title") <br /><br />
        Genre: @Html.TextBox("genre") <br /><br />
        Pris: @Html.TextBox("price") <br /><br />
        Publicerad: @Html.TextBox("publishDate") <br /><br />
        Beskrivning: @Html.TextBox("description") <br /><br />

        <input class="btn btn-primary" type="submit" value="Sök" />
    </p>
}

<div id="bok">
    @foreach (var book in Model)
    {
        <p>Author: @Html.DisplayFor(m => book.Author)</p>
        <p>Title: @Html.DisplayFor(m => book.Title)</p>
        <p>Genre: @Html.DisplayFor(m => book.Genre)</p>
        <p>Price: @Html.DisplayFor(m => book.Price)</p>
        <p>Publish Date: @Html.DisplayFor(m => book.PublishDate)</p>
        <p>Description: @Html.DisplayFor(m => book.Description)</p>
        <hr />
    }
</div>

Controller:

using System;
using System.Linq;
using System.Web.Mvc;
using System.Xml.Linq;
using Andre_Kordasti___Programmeringsuppgift.Models;

namespace Andre_Kordasti___Programmeringsuppgift.Controllers
{
    public class HomeController : Controller
    {
        public ActionResult Index(string author, string title, string genre, decimal? price, string description)
        {
            const string FILENAME = @"c:\users\andre\documents\visual studio 2015\Projects\Andre Kordasti - Programmeringsuppgift\Andre Kordasti - Programmeringsuppgift\DataSource\books.xml";

            XDocument doc = XDocument.Load(FILENAME);

            var books = doc.Descendants("book").Select(x => new BookModel()
            {
                Author = (string)x.Element("author"),
                Title = (string)x.Element("title"),
                Genre = (string)x.Element("genre"),
                Price = (decimal)x.Element("price"),
                PublishDate = (DateTime)x.Element("publish_date"),
                Description = (string)x.Element("description")
            });

            //if (!String.IsNullOrEmpty(searchString))
            //{
            //    books = books.Where(s => s.Author.Contains(searchString) || (s.Title.Contains(searchString)) || (s.Genre.Contains(searchString)) || (s.Description.Contains(searchString)));
            //}

            if (author != null)
            {
                books = books.Where(b => b.Author.Contains(author));
            }

            if (title != null)
            {
                books = books.Where(b => b.Title.Contains(title));
            }

            if (genre != null)
            {
                books = books.Where(b => b.Genre.Contains(genre));
            }

            if (price.HasValue)
            {
                books = books.Where(b => b.Price <= price.Value);
            }

            if (description != null)
            {
                books = books.Where(b => b.Description.Contains(description));
            }

            return View(books);
        }

        public ActionResult Fibonacci()
        {
            return View();
        }
    }
}

XML File:

<?xml version="1.0"?>
<catalog>
  <book id="bk101">
    <author>Gambardella, Matthew</author>
    <title>XML Developer's Guide</title>
    <genre>Computer</genre>
    <price>44.95</price>
    <publish_date>2000-10-01</publish_date>
    <description>
      An in-depth look at creating applications
      with XML.
    </description>
  </book>
  <book id="bk102">
    <author>Ralls, Kim</author>
    <title>Midnight Rain</title>
    <genre>Fantasy</genre>
    <price>5.95</price>
    <publish_date>2000-12-16</publish_date>
    <description>
      A former architect battles corporate zombies,
      an evil sorceress, and her own childhood to become queen
      of the world.
    </description>
  </book>
  <book id="bk103">
    <author>Corets, Eva</author>
    <title>Maeve Ascendant</title>
    <genre>Fantasy</genre>
    <price>5.95</price>
    <publish_date>2000-11-17</publish_date>
    <description>
      After the collapse of a nanotechnology
      society in England, the young survivors lay the
      foundation for a new society.
    </description>
  </book>
  <book id="bk104">
    <author>Corets, Eva</author>
    <title>Oberon's Legacy</title>
    <genre>Fantasy</genre>
    <price>5.95</price>
    <publish_date>2001-03-10</publish_date>
    <description>
      In post-apocalypse England, the mysterious
      agent known only as Oberon helps to create a new life
      for the inhabitants of London. Sequel to Maeve
      Ascendant.
    </description>
  </book>
  <book id="bk105">
    <author>Corets, Eva</author>
    <title>The Sundered Grail</title>
    <genre>Fantasy</genre>
    <price>5.95</price>
    <publish_date>2001-09-10</publish_date>
    <description>
      The two daughters of Maeve, half-sisters,
      battle one another for control of England. Sequel to
      Oberon's Legacy.
    </description>
  </book>
  <book id="bk106">
    <author>Randall, Cynthia</author>
    <title>Lover Birds</title>
    <genre>Romance</genre>
    <price>4.95</price>
    <publish_date>2000-09-02</publish_date>
    <description>
      When Carla meets Paul at an ornithology
      conference, tempers fly as feathers get ruffled.
    </description>
  </book>
  <book id="bk107">
    <author>Thurman, Paula</author>
    <title>Splish Splash</title>
    <genre>Romance</genre>
    <price>4.95</price>
    <publish_date>2000-11-02</publish_date>
    <description>
      A deep sea diver finds true love twenty
      thousand leagues beneath the sea.
    </description>
  </book>
  <book id="bk108">
    <author>Knorr, Stefan</author>
    <title>Creepy Crawlies</title>
    <genre>Horror</genre>
    <price>4.95</price>
    <publish_date>2000-12-06</publish_date>
    <description>
      An anthology of horror stories about roaches,
      centipedes, scorpions  and other insects.
    </description>
  </book>
  <book id="bk109">
    <author>Kress, Peter</author>
    <title>Paradox Lost</title>
    <genre>Science Fiction</genre>
    <price>6.95</price>
    <publish_date>2000-11-02</publish_date>
    <description>
      After an inadvertant trip through a Heisenberg
      Uncertainty Device, James Salway discovers the problems
      of being quantum.
    </description>
  </book>
  <book id="bk110">
    <author>O'Brien, Tim</author>
    <title>Microsoft .NET: The Programming Bible</title>
    <genre>Computer</genre>
    <price>36.95</price>
    <publish_date>2000-12-09</publish_date>
    <description>
      Microsoft's .NET initiative is explored in
      detail in this deep programmer's reference.
    </description>
  </book>
  <book id="bk111">
    <author>O'Brien, Tim</author>
    <title>MSXML3: A Comprehensive Guide</title>
    <genre>Computer</genre>
    <price>36.95</price>
    <publish_date>2000-12-01</publish_date>
    <description>
      The Microsoft MSXML3 parser is covered in
      detail, with attention to XML DOM interfaces, XSLT processing,
      SAX and more.
    </description>
  </book>
  <book id="bk112">
    <author>Galos, Mike</author>
    <title>Visual Studio 7: A Comprehensive Guide</title>
    <genre>Computer</genre>
    <price>49.95</price>
    <publish_date>2001-04-16</publish_date>
    <description>
      Microsoft Visual Studio 7 is explored in depth,
      looking at how Visual Basic, Visual C++, C#, and ASP+ are
      integrated into a comprehensive development
      environment.
    </description>
  </book>
</catalog>

Is there anything I have to adjust in my LINQ statement?

Answer 1

You have to add Where clause before Select and call function for filter:

var results = doc.Descendants("book").Where(d => IsMatched(d, searchCriteria).Select(x => new BookModel()
        {
            Author = (string)x.Element("author"),
            Title = (string)x.Element("title"),
            Genre = (string)x.Element("genre"),
            Price = (decimal)x.Element("price"),
            PublishDate = (DateTime)x.Element("publish_date"),
            Description = (string)x.Element("description")
        }).ToList();

public bool IsMatched(XElement node, Dictionary<string, string> searchCriteria)
    {
        foreach (var key in criteras)
        {
            if (!node.Element(key.Key).Value.Contains(key.Value))
            {
                return false;
            }
        }
        return true;
    }

You can pass searchCriteria from with jquery ajax: JS:

var dict = {};
dict['author'] = 'authorName';

$.post('/Home/Index/', { searchCriteria: dict });

Controller:

public ActionResult Index(Dictionary<string, string> searchCriteria)

Then, you pass it as a BookModel list to View.