l3pord
❔ Implementation of Search page in ASP. NET MVC along with stored procedure
Refer to product table above and implement a Search page in ASP.MVC along with stored procedure in backend (db).
Please follow below points while developing solution for given requirement.
1. Search Criteria needs to be developed at both frontend & backend for following fields
a. ProductName
b. Size
c. Price
d. MfgDate
e. Category
2. UI should provide option to define search criteria using any combination of 1 or more fields specified in point 1.(i.e. Search criteria can be specified using 1 field, 2 field or all fields)
3. If two or more fields are used in search criteria then an option should be provided in UI to specify the conjunction between two conditions(i.e. AND , OR)
4. Also provide option to clear/reset the search criteria.
5. Show the Search results in grid/table in UI.
6. Develop the stored procedure that satisfies all the conditions provided by UI.
29 replies