spNetAccount_Administration
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ViewType | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spNetAccount_Administration
(@ViewType int)
AS
BEGIN
-- Total
-- Active
-- Confirmed
-- Deleted
-- Locked
-- Abuse
DECLARE @IDTABLE Table (ID int)
If @ViewType = 0
begin
INSERT INTO @IDTABLE (ID) (SELECT ID FROM NetAccount WHERE Deleted = 0)
end
If @ViewType = 1
begin
INSERT INTO @IDTABLE (ID) (SELECT ID FROM NetAccount WHERE Datediff(day, dateadd(day,-30,getutcdate()), UpdateDate) >= 0 AND Deleted = 0)
end
If @ViewType = 2
begin
INSERT INTO @IDTABLE (ID) (SELECT ID FROM NetAccount WHERE ClientUsersID IS NOT NULL AND Deleted = 0)
end
If @ViewType = 3
begin
INSERT INTO @IDTABLE (ID) (SELECT ID FROM NetAccount WHERE Deleted = 1)
end
If @ViewType = 4
begin
INSERT INTO @IDTABLE (ID) (SELECT ID FROM NetAccount WHERE LockedOut = 1 AND Deleted = 0)
end
If @ViewType = 5
begin
INSERT INTO @IDTABLE (ID) (SELECT ID FROM NetAccount WHERE LockedOut = 1 AND Deleted = 0 AND ID = 200000)
end
SELECT * FROM @IDTABLE
END