Save logout time in database using session

Question

4.00/5 (1 vote)

See more:

How to save logout time in database when user click on logout button using session in C#?

C#

string username = Session["uname"].ToString();
           string password = Session["pwd"].ToString();
           lbl_1.Text = username;
               cn.Open();
               SqlCommand cmd = new SqlCommand();
               cmd.Connection = cn;
               cmd.CommandType = CommandType.StoredProcedure;
               cmd.CommandText = "SP_TRACK_USE";
               cmd.Parameters.AddWithValue("@Username", username);
               cmd.Parameters.AddWithValue("@Password", password);
               cmd.Parameters.AddWithValue("@COMMAND", 1);
               cmd.ExecuteScalar();
               cn.Close();
               Response.Redirect("Default.aspx");

Coding runs properly, but logout time is not saved in database.

Posted 17-Dec-12 22:07pm

Member 8110943

Updated 17-Dec-12 22:10pm

André Kraak

v2

Add a Solution

Comments

faisal23 18-Dec-12 4:12am

In stored procedure pick the machine time by getDate() and on logout button call this procedure and at the same time insert into proper table.

Member 8110943 18-Dec-12 4:30am

i already try same coding as u said,but its not working.

AshishChaudha 18-Dec-12 5:29am

have you tried debugging??? Please share your stored procedure.

Member 8110943 18-Dec-12 5:48am

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[SP_TRACK_USE]

@Username varchar(50),
@Password varchar(50),
@COMMAND INT = 0
AS
BEGIN
SET NOCOUNT ON;
IF(@COMMAND = 0)
BEGIN
INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL)
END
ELSE IF (@COMMAND = 1)
BEGIN
UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password
END
END

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[SP_TRACK_USE]

@Username varchar(50),
@Password varchar(50),
@COMMAND INT = 0
AS
BEGIN
SET NOCOUNT ON;
IF(@COMMAND = 0)
BEGIN
INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL)
END
ELSE IF (@COMMAND = 1)
BEGIN
UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password
END
END

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[SP_TRACK_USE]

@Username varchar(50),
@Password varchar(50),
@COMMAND INT = 0
AS
BEGIN
SET NOCOUNT ON;
IF(@COMMAND = 0)
BEGIN
INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL)
END
ELSE IF (@COMMAND = 1)
BEGIN
UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password
END
END

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[SP_TRACK_USE]

@Username varchar(50),
@Password varchar(50),
@COMMAND INT = 0
AS
BEGIN
SET NOCOUNT ON;
IF(@COMMAND = 0)
BEGIN
INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL)
END
ELSE IF (@COMMAND = 1)
BEGIN
UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password
END
END

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[SP_TRACK_USE]

@Username varchar(50),
@Password varchar(50),
@COMMAND INT = 0
AS
BEGIN
SET NOCOUNT ON;
IF(@COMMAND = 0)
BEGIN
INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL)
END
ELSE IF (@COMMAND = 1)
BEGIN
UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password
END
END

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[SP_TRACK_USE]

@Username varchar(50),
@Password varchar(50),
@COMMAND INT = 0
AS
BEGIN
SET NOCOUNT ON;
IF(@COMMAND = 0)
BEGIN
INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL)
END
ELSE IF (@COMMAND = 1)
BEGIN
UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password
END
END

ALTER PROCEDURE [dbo].[SP_TRACK_USE]

@Username varchar(50),
@Password varchar(50),
@COMMAND INT = 0
AS
BEGIN
SET NOCOUNT ON;
IF(@COMMAND = 0)
BEGIN
INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL)
END
ELSE IF (@COMMAND = 1)
BEGIN
UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password
END
END

please give me solution for this pbm.

4 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*Abhishek Pant* · Answer 1 · 2012-12-17T22:21:00

Solution 2

use SQL Server Session mode to store and pick the date from the system.

Exploring Session in ASP.NET[^]
hope it helped!

Posted 17-Dec-12 22:21pm

Abhishek Pant

Comments

Member 8110943 18-Dec-12 4:54am

Give me code for this..I tried but it doesn't work.

Thomas Daniels 18-Dec-12 5:20am

My Edit: Shouting removed.

ashokmmrk · Answer 2 · 2012-12-17T23:19:00

Hi,

why not you alter the StoredProcedure with additional parameter 'logout_time' and pass the value

C#

string username = Session["uname"].ToString();
            string password = Session["pwd"].ToString();
            lbl_1.Text = username;
                cn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = cn;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "SP_TRACK_USE";
                cmd.Parameters.AddWithValue("@Username", username);
                cmd.Parameters.AddWithValue("@Password", password);
                cmd.Parameters.AddWithValue("@logout_time", DateTime.Now());
                cmd.Parameters.AddWithValue("@COMMAND", 1);
                cmd.ExecuteScalar();
                cn.Close();
                Response.Redirect("Default.aspx");

AshishChaudha · Answer 3 · 2012-12-17T23:29:00

Solution 5

You can do this in global.asax file.

Posted 17-Dec-12 23:29pm

AshishChaudha

Christian Graus · Answer 4 · 2012-12-17T22:12:00

Solution 1

Why do you need to store the password ? Where are you storing the logout time ? If you add a column to store it and make the default getdate(), then that will work, but right now, you've either done that ( and it would work ), or you've not tried at all.

Posted 17-Dec-12 22:12pm

Christian Graus

Comments

Member 8110943 18-Dec-12 4:27am

UPDATE USERLOG SET LOGOUT = GETDATE() where Username=@Username and Password=@Password
i m trying this code for saving logout time.Any mistake then please guide me

Member 8110943 18-Dec-12 4:29am

UPDATE USERLOG SET LOGOUT = GETDATE()
i also try this code but it also not save the logout time in database..

Christian Graus 18-Dec-12 14:20pm

Well, gee, you're trying things at random, do you have any clue what you're doing ? Perhaps if you told us what DOES happen, if you get an error, etc, that would help. Is logout a datetime ?

Save logout time in database using session

4 solutions

Solution 2

Solution 3

Solution 5

Solution 1

Add your solution here

Preview 0

Save logout time in database using session

4 solutions

Solution 2

Solution 3

Solution 5

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us