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