1.In the web page display the following search button.

auburnhairSoftware and s/w Development

Dec 13, 2013 (3 years and 3 months ago)

65 views

1.

In the web page display the following search button.



2.

The users will enter
some search text. And the search result will be returned like this in the MVC
partial view just below the search text box.


Fig 1.0

3.

In the database there should be three
tables. Please create the scripts to create this database.

a.

Category

i.


CategoryID(PK)

ii.

CategoryTypeID (FK)

iii.


CategoryName [e.g. Carpenter]

b.

CategoryType

i.

CategoryTypeID(PK)

ii.

Description [e.g: Construction]

c.

CategoryTag

i.

CategoryID(PK
,FK
)

ii.

Tag

4.

Ent
er some dummy data i
n the tble based on the Fig 1.0

5.

Create a project called BusinessEntity

6.

Create project called DataAccess.

7.

Create a MVC2 solution

8.

Use entity framework to create edmx of the
DB
object
s

in BusinessEntity project

9.

Use the DataAccess project
with namespace DataAc
cess
to pull data from the database.

10.

Create a method in the CategoryDAO class called SearchServiceCategory

public

List
<
Category
>
SearchServiceCategory
(
string searchtext
)


{


////Fill in the logic to pull data from the DB


return

categories;


}

11.

Call the
SearchServiceCategory method from MVC controller called HomePageController to
return the search result

12.

Render the View like Fig 1.0

13.

Every time the user enters new text in the search box the only Partial View of Search Result

should be refreshed not the whole page.

14.

When the user is entering search text show them suggestions from the tag table just like it
happens in google search.