public AllUsersResponse GetAllUsers(AllUsersRequest request) { var response = new AllUsersResponse { ResponseStatus = ResponseStatus.Success }; var usersProvider = new UsersProvider(); try { if (request.ActionType == ActionType.Select) { response.Users = usersProvider.GetAllUsers(request); } else { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = "Not update action"; } } catch (Exception ex) { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = ex.Message; } return(response); }
public List<UserProfile> GetAllUsers(AllUsersRequest request) { var conn = GetConnection(ConnectionNames.CSPSqlDatabase); var commandWrapper = GetStoredProcCommand("dbo.Get_All_Users", conn); AddInParameter(commandWrapper, "@TeamId", DbType.Int16, request.TeamId); AddInParameter(commandWrapper, "@Role", DbType.Int16, request.Role); IDataReader reader = null; List<UserProfile> tmp = new List<UserProfile>(); try { conn.Open(); reader = commandWrapper.ExecuteReader(); FillUser(reader, tmp, 0, int.MaxValue); MakeDboLog(request.ToString(), reader.ToString(), "dbo.Get_All_Users"); return tmp; } finally { if (reader != null) reader.Close(); commandWrapper.Dispose(); conn.Close(); } }
public AllUsersRequest GetAllUsersRequest(int teamId, Role role) { var request = new AllUsersRequest { Role = role, TeamId = teamId, ActionType = DataBaseCommunication.Mappers.Requests.ActionType.Select }; return(request); }