Populate data based on search criteria in asp.net mvc c#

Question

I have a product listing page. All the products are display based on 3 criteria :

When user click on the left menu
When user input in search text box and search
When user choose in the brand combo box

This is the exam url due to the user click the below list :

http://mysite.com/Products?dep=1&cat=2&tab=2 : display the product that have depId = 1 , and categoryID = 2.
http://mysite.com/Products?brand=ABC_2&tab=2 : display the product that have the brand name = "ABC" and brand id=2
http://mysite.com/Products?tab=2&search=ABCD : display the product that the product name = "ABCD"

Problem : When the user click on each link below, the page will refresh, so I cannot mix the parameter string together. I want to combine these 3 criteria together, mean when the user click on (1) then continue to (2) and (3), the url will :

http://mysite.com/Products?dep=1&cat=2&brand=ABC_2&search=ABCD&tab=2

So the page will display the product that have depID = 1, categoryID = 2, brand id = 2, brand name = ABC and product name = "ABCD".

This is what I have tried to get the (3) in my site.master :

function SearchClick() {
   window.location = "/Products?tab=2" + ($("#txtsearch").val() != "" || $("#txtsearch").val() 
   == "undefined" ? "&search=" + $("#txtsearch").val() : "");
}

Thanks in advanced.

rofans91 · Accepted Answer · 2012-02-02 07:55:33Z

1

I notice you are using jQuery, I will suggest:

//using Request.Params
string Dept = Request.Params["dep"];
string Cat = Request.Params["cat"];
string Brand = Request.Params["brand"];
//capture the char after '?' or '&' and pass into Params["char"]
//do your search function.

This link will help you.

If you want to keep it after page refresh you can store it in Session.

string theDept = Request.Params["dep"];
Session["dep"] = aa;    

string dep = (string)Session["dep"];

edited Feb 2, 2012 at 7:55

answered Feb 2, 2012 at 6:48

rofans91

3,00611 gold badges48 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

titi Over a year ago

Error : Object reference not set to an instance of an object, with declaration Session["dep"] = Request.Params["dep"].ToString();

titi Over a year ago

Session["dep"] = theDept; or Session["dep"] = aa;

titi Over a year ago

But while I tried to use the session, after my page refreshed, it lose the session value.

rofans91 Over a year ago

Where did you put the session?

titi Over a year ago

let us continue this discussion in chat

rkw · Accepted Answer · 2012-02-02 06:55:48Z

1

This should get you started

Back end:

create a SearchModel with 3 properties: search, brand, dep
have an action Product that takes in the search model

Front end:

create a form that posts to the Product action above, make sure it has a submit button
create a textbox inside that form with id/name = 'search'
create a ddl inside that form with id/name = 'dep'
create a hidden field inside that form with id/name = 'brand'
use jquery, to update the hidden field when the user clicks on the left column
use jquery to submit the form anytime the user: hits the submit button, changes the ddl, or clicks on the left column

answered Feb 2, 2012 at 6:55

rkw

7,2974 gold badges28 silver badges39 bronze badges

Comments

Muthu · Accepted Answer · 2012-02-02 06:57:14Z

1

You can also try this if you are using ajax to load your pages.

    $.ajax({
        url: '/Products',
        type: 'GET',
        dataType: 'json',
        cache: false,
        async: false,
        data: { dep: 1, brand: abc_2, search:abcd, tab:2 },
        success: function (data) {
        //Do your work here
              },
        error: function (ex) {
            alert('Error.');
        }

    });

You'll typically put the 3 criteria in the same page like search textbox, brand/department dropdown and then on a button click will fire this query.

answered Feb 2, 2012 at 6:57

Muthu

2,7054 gold badges29 silver badges35 bronze badges

Collectives™ on Stack Overflow

Populate data based on search criteria in asp.net mvc c#

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related