MVC Searching with 2 possible view outcomes.

Question

0.00/5 (No votes)

See more:

Hi Guys,

I'm fairly new to MVC 3 and i've come accorss a situation where i need to do something and i'm not sure of the best path. we have a set of topics related in a database with a parent-child relationship.

in a nutshell : -

1) user enters a string into search box, which is on every page, and clicks submit.
2) Ajax post to search controller which checks the reults of the search with 2 possible outcomes

2.1)IF we have more than one (parent) macth. the top ten parent matches are shown to the user, which results in the user choosing one (clicking a link) and and exact match so move on to 2.2

2.2) We have one exact match - a search for topics relating to this parent are queued and cached by the DB, we load the view and the results are returned Asynchronously by ajax when they are ready.

Posted 19-Sep-11 23:00pm

SL_Nick

Add a Solution

Comments

Jephunneh Malazarte 21-Sep-11 12:24pm

were you using entity framework? just curious though.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Acino.Nyx · Answer 1 · 2011-10-06T04:09:00

I will not give you solution but just showing you the path.

1. By understanding your scenario I will suggest you to use entity framework so it is easy to make request to database by parent child relationship.

2. You can generate links on the view page dynamically and attach those links with javascript function into which appropriate ids(dynamically fetched from database [parentids]) is passed as a parameter.

3. Into javascript function based on the parent id you can asynchronously request for next search result and update your page using ajax(jquery).

4. Also suggest to use JQuery which made your ajax request and dynamically page updation process simple.