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);
}
