I have Signup and UserWallet Table ndash the Signup table is where signup data is stored for both Admin and user and the UserWallet is where money is When admin logs in Admin ID and wallet balance is displayed from the AdminWalletHere is how the structure of my ldquoSignuprdquo table to save new signup data looks like it has 7 columnsEmail pass conpass Name UserType CreatedBy CreateDateI have two sets of people with access to one account these two sets of people are Admin an

Hi George616You need to check the record and display as per the data present in the databaseRefer below query for exampleSQLCREATE TABLE Signupemail VARCHAR100 password VARCHAR100 conPasword VARCHAR100 Name VARCHAR100 UserType CHAR1 CreatedBy VARCHAR100 CreateDate DATETIMEINSERT INTO Signup VALUES39test1gmailcom393912339391233939test 13939U3939test2gmailcom39GETDATEINSERT INTO Signup VALUES39test2gmailcom393912339391233939test 23939A393939GETDATEINSERT INTO Signup VALUES39test3gmailcom393912339391233939test 33939A393939GETDATEINSERT INTO Signup VALUES39test4gmailcom393912339391233939test 43939U3939test3gmailcom39GETDATECREATE TABLE UserWalletemail VARCHAR100 amount INTINSERT INTO UserWallet VALUES39test2gmailcom3910INSERT INTO UserWallet VALUES

Display user data if exists else display from admin data in SQL Server

George61...

SOLVED CLOSED ACTIVE ANSWERED
User: George616
Posted: on Jun 22, 2020 12:09 AM
Forum: SQL Server
Answer: 1
Views: 1671

I have Signup and UserWallet Table – the Signup table is where signup data is stored (for both Admin and user) and the UserWallet is where money is.

When admin logs in, Admin ID and wallet balance is displayed from the AdminWallet.

Here is how the structure of my “Signup” table to save new signup data looks like; it has 7 columns:

Email, pass, con_pass, Name, UserType, CreatedBy, CreateDate

I have two sets of people with access to one account (these two sets of people are Admin and Users). There are two Database Tables (Sign Up and User wallet). When an admin signs up and/or login, Admin ID and wallet balance will be displayed on the web forms, this data that will be displayed is gotten from the wallet Table. The admin ID is the Email of the Admin.

Then Admin will proceed to the dashboard and create new users that he or she will grant access to use the same account as Admin’s. Then when new user is created, the user will be linked to the Admin ID (as seen in the Database Table); the column CreatedBy represents the Admin ID who created the user. From the image of the database table, you can see that UserType column differentiates between Admin – A and User – U. How can I make it in such a way that when the new user created logs in, the Admin ID and wallet balance that created the user will be displayed exactly like when the Admin logs in?

For example, if an Admin (check@gmail.com) registers as new Admin and logs in, the ID and wallet balance of Admin (check@gmail.com) will display. Then Admin (check@gmail.com) proceeds to dashboard and creates new user (tyler@yahoo.com). The user (tyler@yahoo.com) will be under the Admin (check@gmail.com).

So what I want achieve is when the user (tyler@yahoo.com) logs in, the ID and wallet balance of Admin (check@gmail.com) will be displayed and the user will not be able to do some of the things the Admin does, which are see deposit button to make deposit or see dashboard too. But user can be able to use funds in the Admin's wallet and Admin can know if funds have been used.

The issue here is that the ID and wallet balance is gotten from wallet Table which has two columns (email and amount), and the user created has no record in the wallet table except the Admin. How can user be linked to Admin Id in wallet so that when user logs in the Admin ID and wallet balance will be displayed?

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Jun 22, 2020 07:36 AM
Report

Hi George616,

You need to check the record and display as per the data present in the database.

Refer below query for example.

SQL

CREATE TABLE #Signup(email VARCHAR(100), password VARCHAR(100), con_Pasword VARCHAR(100), Name VARCHAR(100), UserType CHAR(1), CreatedBy VARCHAR(100), CreateDate DATETIME)
INSERT INTO #Signup VALUES('test1@gmail.com','123','123','test 1','U','test2@gmail.com',GETDATE())
INSERT INTO #Signup VALUES('test2@gmail.com','123','123','test 2','A','',GETDATE())
INSERT INTO #Signup VALUES('test3@gmail.com','123','123','test 3','A','',GETDATE())
INSERT INTO #Signup VALUES('test4@gmail.com','123','123','test 4','U','test3@gmail.com',GETDATE())

CREATE TABLE #UserWallet(email VARCHAR(100), amount INT)
INSERT INTO #UserWallet VALUES('test2@gmail.com',10)
INSERT INTO #UserWallet VALUES('test3@gmail.com',00)

SELECT * FROM #Signup
SELECT * FROM #UserWallet

DECLARE @Email VARCHAR(100)
SET @Email = 'test2@gmail.com'

IF EXISTS (SELECT email FROM #UserWallet WHERE email = @Email)
BEGIN
	SELECT su.email,su.UserType,su.CreatedBy,uw.amount 
	FROM #Signup su
	INNER JOIN #UserWallet uw ON su.email = uw.email
	WHERE su.email = @Email
END
ELSE
BEGIN
	DECLARE @CreatedBy VARCHAR(100)
	SELECT @CreatedBy = CreatedBy FROM #Signup WHERE email = @Email
	SELECT @Email email,'U' UserType,@CreatedBy CreatedBy,uw.amount 
	FROM #Signup su
	INNER JOIN #UserWallet uw ON su.email = uw.email
	WHERE su.email = @CreatedBy
END
 
DROP TABLE #Signup
DROP TABLE #UserWallet

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Display user data if exists else display from admin data in SQL Server

Company

Explore

Follow us

Contact Us