public bool AddRole(int userId, int roleId) { string q = $"INSERT INTO UserRole (AppUserId , RoleId) VALUES({userId} , {roleId} )"; using (CommanderBase commander = DBContext.CreateCommander()) { var ur = commander.NonQuery(q); return(ur); } }
public bool DeleteRole(int userId, int roleId) { string q = $"DELETE FROM UserRole WHERE AppUserId={userId} and RoleId={roleId}"; using (CommanderBase commander = DBContext.CreateCommander()) { var ur = commander.NonQuery(q); return(ur); } }