Loading

how to write a query having multiple conditions ?

how to write a query having multiple conditions ?

Subin Thomas

Subin Thomas

7y1kSQL

i want to fetch project details of the user but i want to put a condition on the user

like if a user is a student then he /she can see only his projects

if a user ia a teacher then she can see her class student projects

if a user is a principal then he can see project of all the class students

i have role table which has roles of each person

1=student

2=teacher

3=principal etc

and i have another table from where i am getting project details

how to write such query

even a general syntax can help

5 Replies

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

Faisal Pathan7y ago
1. var roleID = "1";//Which you pass as parameter.
3. var roleObj = db.Roles.firstOrDefault(a=>a.ID == roleID);
4. if (roleObj.Name.Equals("Student"))
5. {
6. //Student logic
7. }
8. else if (roleObj.Name.Equals("Teacher"))
9. {
10. //Teacher logic
11. }
12. else if (roleObj.Name.Equals("Principal"))
13. {
14. //Principal logic
15. }
16. else
17. {
18. //default logic
19. }

Subin Thomas

Subin Thomas7y ago

i want to write a sql query which has multiple conditions

userid is passed to the query

and using that userid i want to show projects

if the user id is student then his project list should display

if the user id is teacher then a particular class project list will be shown

if the user id is principal then he should get all class students project list

to check if the user id is a student or not roles is checked each user id has a role

roles

1=student

2=teacher

3=principal

so for eg if the userid passedis role 1 that means it a student and only his project wil be seen in the list

Faisal Pathan

Faisal Pathan7y ago

can you please explain lil bit more and clear way? so I can help you.

Subin Thomas

Subin Thomas7y ago

i have to give a search box where if you search particular user ka name and projects appear

if the name selected is student then only his project should come

if the name selected is teacher then only her class student project should come

if the name selected is principal then all student project should come

this is the need as of now

Faisal Pathan

Faisal Pathan7y ago

while login you can check that what is the role of given Email? and base on that you can go further.