restrict specific data to delete or edit by user

Question

i have table name of Role

i have two columns name RoleID and RoleName,

 

and it contains data like below,

1. Admin 

2. User

3. Employee

4. Etc. 

 

now in MVC view i have bind all the data into table view and allow EDIT and DELETE functionality,

 

but i dont want to allow user to delete or edit first two data(1. Admin, 2. User) from the database.

 

do anyone have any idea about this..

thanks in advance. 

Answer 1

Hi Dheeraj,

 

Just Run a query of checking user's permission before delete like this...

I assuming that you have a mapping table of UserPermissions

IF EXISTS(select count(*) from UserRoleMapping where UserID = 1 and RoleID = 1 and PermissionID = 1)
BEGIN
    --delete the data
END
ELSE
BEGIN
    --you have no rights to delete the data
END

 Thats it...