Facing difficulty to create search using MVC

Hi there..

I almost giveup creating search engine using MVC4. I'm beginner for MVC. I want user search Unit NO or Acc No and will display the list based on UnitNO or Acc No.

Below is the code : setup.cs controller :

public ActionResult UnitSearch(string s)
    {
        Query query = new Query();
        query.SearchQuery = s;
        using (var uow = db.CreateUnitOfWork())
        {
            var results = uow.Search(query, typeof(AccountProperty)).OrderByDescending(p => p.Score).Take(50); //model of AccountProperty
            //var propertyId = -1;
            //var u = Session["user"] as AccountDTO;
            //if (u != null)
            //    propertyId = u.ActiveProperty.Id;
            var sresult = new List<UnitDTO>();

            foreach (var result in results)
            {
                if (result.Entity is AccountProperty)
                {
                    var ap = result.Entity as AccountProperty;
                    sresult.Add(new UnitDTO() { AccNo = ap.AccNo });
                    sresult.Add(new UnitDTO() { UnitNo = ap.UnitNo });
                }
            }
            ViewBag.Search = s;
            return View("Units", sresult);
        }

    }

and in view Units.cshtml

<form action="@Url.Action("UnitSearch", "Setup")">
Search <input id="search" name="s" type="text" value="@ViewBag.Search" />
<input type="submit" value="Search" />

@foreach (var item in Model) { @* *@ }

Name	Contact No	Block	UnitNo	AccNo	Balance
@Html.DisplayFor(modelItem => item.Name)	@Html.DisplayFor(modelItem => item.ContactNo)	@Html.DisplayFor(modelItem => item.Block)	@Html.DisplayFor(modelItem => item.UnitNo)	@Html.DisplayFor(modelItem => item.AccNo)	@Html.DisplayFor(modelItem => item.Balance)	@Html.ActionLink("Edit", "Edit", new {id =item.Id}) | @Html.ActionLink("Details", "Details", new { id=item.Id }) | @Html.ActionLink("Delete", "Delete", new { id=item.Id})

I cannot find out where the mistaken. I hope i will get solution from here..

Thanks you in advance..

Is the issue that you are having no results returned for your queries?

If so, can you post details about how have set up your entities for indexing? Are you using the Indexed attribute or implementing GetSearchData()?

Here are our docs on Full Text Search in case that helps: http://www.mindscapehq.com/documentation/lightspeed/Advanced-Querying-Techniques/Full-Text-Search

Jeremy

Hi Jeremy

even i follow tull-text-search, still no results .. I got change some code, setup.controller

 public ActionResult UnitSearch(string s)
    {
        using (var uow = db.CreateUnitOfWork())
        {
            var results = uow.Search(s, typeof(AccountProperty)).OrderByDescending(p => p.Score);//.Take(50); //model of AccountProperty
            //var propertyId = -1;
            //var u = Session["user"] as AccountDTO;
            //if (u != null)
            //    propertyId = u.ActiveProperty.Id;
            var sresult = new List<UnitDTO>();

            foreach (var result in results)
            {
                if (result.Entity is AccountProperty)
                {
                    var ap = result.Entity as AccountProperty;
                    sresult.Add(new UnitDTO() { AccNo = ap.AccNo });
                    sresult.Add(new UnitDTO() { UnitNo = ap.UnitNo });
                }
            }
            return View("Units", sresult);
        }

    }

this is my view

@foreach (var item in Model) {

GetsearchData()

protected override string GetSearchData()
    {
        return UnitNo != null ? UnitNo.Trim() : "";
    }

I am appreciate if you can solve this problem.. i was suffering for 1 weeks.

Thanks in advance.

Name	Contact No	Block	UnitNo	AccNo	Balance
@Html.DisplayFor(modelItem => item.Name)	@Html.DisplayFor(modelItem => item.ContactNo)	@Html.DisplayFor(modelItem => item.Block)

public ActionResult UnitSearch(string s)
    {
        using (var uow = db.CreateUnitOfWork())
        {
            var results = uow.Search(s, typeof(Account), typeof(AccountProperty)).OrderByDescending(p => p.Score).Take(50); //model of AccountProperty
            //var propertyId = -1;
            //var u = Session["user"] as AccountDTO;
            //if (u != null)
            //propertyId = u.ActiveProperty.Id;
            var sresult = new List<UnitDTO>();
            foreach (var result in results)
            {
                if (result.Entity is Account)
                {
                    var ac = result.Entity as Account;
                    sresult.Add(new UnitDTO() { Name = ac.Name, AccNo = ac.AccNo, ContactNo = ac.ContactNo, Id = ac.Id });
                  }
                else if (result.Entity is AccountProperty)
                {
                    var ap = result.Entity as AccountProperty;
                    var a = uow.Accounts.FirstOrDefault(acc => acc.AccNo == ap.AccNo);
                    sresult.Add(new UnitDTO() {UnitNo = ap.UnitNo, Balance = (float)ap.Balance, Block= ap.Block});
                }
             }
             return View("Units", sresult);
        }

    }