how to execute query on button click in mvc5

jaydeep shah

11y966LINQ

i have some images

image name plazma 90 , plazma 120 , plazma 160 => directitemid

and i have to execute query catagory vise

catagory like = rowitem,casting,hardware

PLASMA 60

PLASMA 90

PLASMA 120

PLASMA 150

i write query ..

RowItemcontroller.cshtml

public ActionResult ifcondi()

{

var data1 = (from c in db.RowItems

join a in db.categories on c.CategoryItemId equals a.category_id

join d in db.DirectItems on c.DirectItemId equals d.Id

where d.ItemName == "PLASMA 60" // how can i pass parameter here ...

select new { c, a, d }).GroupBy(x => x.a.category_name).Select(y => new tempdata

{

CatagoryName = y.Key,

lists = y.Select(p => new a

{

name = p.c.ItemName

}).ToList()

}).ToList();

return View(data1.ToList());

}

and i get result but i want to get result from image click .. so what can i add ????

index2.cshtml

image code

@Html.DisplayFor(modelItem => item.ItemName)

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

jaydeep shah11y ago
thanks Bhushan Bhasme for repling me .

but plazma - 60 , 90 is image and is automatic create from database i put foreach for it

index2.cshtml

@foreach (var item in Model)
{

@Html.DisplayFor(modelItem => item.ItemName)

}

so i have pass perameter in controller ....
RowItemcontroller.cs

public ActionResult ifcondi()
{
// may be here i have write something for add parameter
var data1 = (from c in db.RowItems
join a in db.categories on c.CategoryItemId equals a.category_id
join d in db.DirectItems on c.DirectItemId equals d.Id
where d.ItemName == "PLASMA 60" //and here so image understand i am 60 , 90 , 120 or ..
select new { c, a, d }).GroupBy(x => x.a.category_name).Select(y => new tempdata
{
CatagoryName = y.Key,
lists = y.Select(p => new a
{
name = p.c.ItemName
}).ToList()
}).ToList();
return View(data1.ToList());
}

RowItemcontroller.cs

public class tempdata
{
public string CatagoryName { get; set; }
public List lists { get; set; }
}
public class a {
public string name { get; set; }
}
}
Bhushan Bhasme11y ago
You can have a href for all images and you can one enum.in enum you can write like

enum plazma{
plazma 60=1,
plazma 90,
plazma 120,
plazma 150,

}

You can take out the id for plazma60 using enum
and pass that value to controller
Or You can fetch the id from the database for each plazma in cshtml
@{//in this you can use database logic}
you can put like this and use image as button using
Plazma 60
Plazma 90
Plazma 120
Plazma 150

public actionresult Plazma(int id){
//here You will get id =1,2,3,4
//Do your Stuff Here

}
hope this will help You..if u get any issue further, u can ask me.
if it helps mark it as answer
thanks