how to achieve counts dashboard using asp.net mvc5 using entity framework code first approace

Question

User-471420332 posted

I have below table with data

select * from Table_Card

Sno    name      status

1          raj           Card completed
2          ravi         Cards overdue
3          rohan     Card due
4          mazhar   Cards in progress

Below is select queries
select count(*) from Table_Card where Status="Card completed"
select count(*) from Table_Card where Status="Cards overdue"
select count(*) from Table_Card where Status="Card due"
select count(*) from Table_Card where Status="Cards in progress"

Now I got counts like this: 

 Card completed: 1

Cards overdue: 1

Card due: 1

Cards in progress: 1

This is my actually dashboard to show after admin login using any sample code or your own code to achieve