How to display the first login time for the user?

Question

2.50/5 (2 votes)

See more:

, +

Hi to all,

I m working in SQL server 2008 and asp.net platform. My project has a button which on being clicked, shows the login time of the user.
I need a code as such that when the user logs in for the second time on the same day we have to display a label showing "You have logged in at" and a textbox displaying the first login time for that day. Also the button should be disabled on the page.

Any help regarding this would be very useful.

Thank you.

Posted 28-Aug-12 2:04am

prabhadevi chennai

Add a Solution

Comments

[no name] 28-Aug-12 8:18am

Respond me, if u need query for that....

prabhadevi chennai 28-Aug-12 8:47am

Thank you for your response,

I need to calculate the time difference between login and logout too. I want to display the first login of the current date after which the button should be disabled for all the successive logins on that particular date by the user.

Can you suggest me how to perform the above operations with the query?

3 solutions

Solution 1

step 1:
update ur table, logtime column on every login

step 2:
compare that date with the current date,
if it matches retrive date and time and show it in textbox
also disable the button
otherwise,
retrieve nothing

Posted 28-Aug-12 2:15am

Karthik J, Coimbatore

Solution 3

You can store the first login time in a database.
Here are some examples -
Tracking users login/logout times on your site[^]
http://www.4guysfromrolla.com/articles/081507-1.aspx[^]

Posted 28-Aug-12 2:38am

Abhinav S

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Santhosh Kumar Jayaraman · Accepted Answer · 2012-08-28T02:34:00

Solution 2

You should have Logindetails table.

You can do this in 2 way
First way

Insert new record everytime the user logins and get the min(time ) for that particular day.
This is kind of history so you can keep track of every login

Second way:

Insert new record when user logins first time for the day. If user tries to login second time, go and check whether a record already exists for that particular day and for particular user . If it exists dont insert.
So now you will have only one login time per day per user. No history tracking.

SQL

if not exists(select 1 from  logintable
where CONVERT(varchar(8), logindate, 112) =CONVERT(varchar(8), GETDATE(), 112) and Id=1)
insert into logintable(col1,col2,col3,logindate) values (val1,val2,val3,getdate())

updated solution, based on the comments.

C#

protected void Button2_Click(object sender, EventArgs e)
    {
        string intime = DateTime.Now.ToString();

        string ID = Session["Name"].ToString();
        string indate = DateTime.Now.ToShortDateString();
        SqlConnection cn = new SqlConnection("Data Source=Sony-VAIO\\MSSQLSERVER2008;InitialCatalog=db;Integrated Security=True");
        cn.Open();
        SqlCommand cmd = new SqlCommand(@"if not exists (select 1 from intime where convert(varchar(30),indate,112)=convert(varchar(30),getdate(),112) and Id=@Id) insert into intime
values ('" + ID + "','" + intime + "','" + indate + "')", cn);
        cmd.Parameters.AddWithValue("@Id", ID);

        cmd.ExecuteNonQuery();
        cn.Close();


    }

Posted 28-Aug-12 2:34am

Santhosh Kumar Jayaraman

Updated 29-Aug-12 2:28am

v4

Comments

Kuthuparakkal 28-Aug-12 8:43am

i agree... nice reply.. my 5+

prabhadevi chennai 28-Aug-12 8:50am

Thank you for your response,
Can you suggest a query for your second option?

Santhosh Kumar Jayaraman 28-Aug-12 9:01am

Check my updated solution., here am checking whether any record exists for currentdate if no, then am inserting into logintable.

Logintable=tablename
logindate=column..So you have to replace normal insert things which you already have to this in stored proc.
So at a time there will be only one record for user/day

prabhadevi chennai 28-Aug-12 9:43am

Sir, When i give the above query every time it is getting inserted as it is not checking with the current date. Also it displays the current date and time too.

Santhosh Kumar Jayaraman 28-Aug-12 10:57am

CONVERT(varchar(8), logindate, 112) =CONVERT(varchar(8), GETDATE(), 112) ) it will get only date and am comparing date only not time.

prabhadevi chennai 28-Aug-12 9:49am

sir, what does that l mean in (select l from login table), it shows an error saying 'invalid column name'

Santhosh Kumar Jayaraman 28-Aug-12 10:55am

its 1 not i..

prabhadevi chennai 29-Aug-12 3:03am

sir, I have tried in many ways, but i could not get my solution,
mainly i need to disable the button which will mark the attendance after the first login on that particular day. Where should i give your code, in my sql database or in visual studio command object?

Santhosh Kumar Jayaraman 29-Aug-12 3:06am

post your query

prabhadevi chennai 29-Aug-12 4:55am

this code is in attendance button
string intime = DateTime.Now.ToString();
TextBox1.Text = intime;
string ID = Session["Name"].ToString();
string indate = DateTime.Now.ToShortDateString();
SqlConnection cn = new SqlConnection("cn string");
cn.Open();
SqlCommand cmd = new SqlCommand("if not exists (select 1 from intime where convert(varchar(30),indate,112)=convert(varchar(30),getdate(),112)) insert into intime values ('" + ID +"','" + intime + "','" + indate + "')", cn);

cmd.ExecuteNonQuery();
cn.Close();
Button2.Visible = false;

Santhosh Kumar Jayaraman 29-Aug-12 5:05am

ok got it . The issue was in where clause we didnt pass Id, You have to add Id also for particular Id
if not exists(select 1 from logintable
where CONVERT(varchar(8), logindate, 112) =CONVERT(varchar(8), GETDATE(), 112) and Id=someting)
insert into logintable(col1,col2,col3,logindate) values (val1,val2,val3,getdate())

prabhadevi chennai 29-Aug-12 4:57am

this code is for logout button
protected void Button1_Click(object sender, EventArgs e)
{
string outtime= DateTime.Now.ToString();
//string intime = TextBox1.Text;
string ID = Session["Name"].ToString();
//TextBox2.Text = outtime;
//Response.Redirect("Home.aspx");
DialogResult dr = MessageBox.Show("Do You Want To End Today's Session?", "End Session", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{

SqlConnection cn = new SqlConnection("cn string");
cn.Open();
SqlCommand cmd = new SqlCommand("insert into attendance values ('" + ID +"','" + outtime + "')", cn);
cmd.ExecuteNonQuery();
cn.Close();
MessageBox.Show("Your Attendance has been marked");
Response.Redirect("Home.aspx");

}
else
{
DialogResult dr1 = MessageBox.Show("You have chosen to continue", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}

prabhadevi chennai 29-Aug-12 5:35am

if not exists(select 1 from intime where CONVERT(varchar(8),
indate, 112) =CONVERT(varchar(8), GETDATE(), 112) )
insert into intime(ID,intime,indate) values ('col1','col2','col3')

I don't know what give for column values in sql as this does not have a single user.
Here intime denotes table name
intime,id,indate denotes columns

Santhosh Kumar Jayaraman 29-Aug-12 5:41am

id is the column for each user right? If user 1 login , he will have some Id right? pass that id .