how to write a query having multiple conditions ?

Question

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

Faisal Pathan · Answer

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

Faisal Pathan · Answer

var roleID = "1" ; //Which you pass as parameter. var roleObj = db.Roles.firstOrDefault(a=>a.ID == roleID); if (roleObj.Name.Equals( "Student" )) { //Student logic } else if (roleObj.Name.Equals( "Teacher" )) { //Teacher logic } else if (roleObj.Name.Equals( "Principal" )) { //Principal logic } else { //default logic }

Subin Thomas · Answer

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 · Answer

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

Subin Thomas · Answer

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