public List <UserRole> GetUserRoles() { _executerUserRoleCmd executer = new _executerUserRoleCmd(ExecuteUserRoleSqlCmd); List <UserRole> userRoles = new List <UserRole>(); using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { using (SqlCommand cmd = new SqlCommand("GetUserRoles", sqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; userRoles = executer(sqlConnection, cmd); } return(userRoles); } }
public List <UserRole> GetUserRolesByUserId(int userId) { List <UserRole> userRoles = new List <UserRole>(); if (userId > 0) { _executerUserRoleCmd executer = new _executerUserRoleCmd(ExecuteUserRoleSqlCmd); using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { using (SqlCommand cmd = new SqlCommand("GetUserRolesByUserId", sqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", userId); userRoles = executer(sqlConnection, cmd); } } } return(userRoles); }