How to call a class from a cs file to update or save the session expired in database?

Question

3.00/5 (3 votes)

See more:

Hi, I have a class function as following & I would like to use this class to be called into my master page. Then, doing login & logout time saved of the page into my database.

C#

namespace LogInLogOut
    {
        public partial class LogInLogOut : System.Web.UI.Page
       {        
           public static void updateLogoutTime(string username, string pcname, string module)
            {
              String connectionString = ConfigurationManager.ConnectionStrings["VSConfigConnectionString"].ConnectionString;
                SqlConnection connection = new SqlConnection(connectionString);
                SqlCommand cmd = new SqlCommand("UPDATE [Access]  set LogOutDate =  '" + DateTime.Today.ToString("dd/MM/yyyy") + "', LogOutTime =  '" + DateTime.Now.ToString("HH:mm:ss") + "' WHERE LoginID ='" + username + "' AND ModuleID = '" + module + "' AND comptname ='" + pcname + "' AND LogOutDate= ' '", connection);
                cmd.Connection.Open();
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();
                cmd.Connection.Dispose();
            }
         }
    }

Here is the code in master page for doing popup message, but I have no idea to write the call function for calling the upper class into my master page. Hope anyone can assist me for this problem. Thank you.

C#

protected void Page_Load(object sender, EventArgs e)
     {
         string csname = "timeoutWarning";
         Type cstype = this.GetType();
         if (!Page.ClientScript.IsStartupScriptRegistered(cstype, csname))
         {
             string strconfirm = "<script>" +
                 "window.setTimeout('SessionTimeOutHandler()', 10000);" +
                 "function SessionTimeOutHandler() { " +
                 "alert('Your login session is expired');" +
                 "function(){ update(document.LogInLogOut('lblUserName.Text', 'lblComputerName.Text', 'UR')); } " +
                "window.location='../login.aspx';" +
                 " } </script>";
             Page.ClientScript.RegisterStartupScript(cstype, csname, strconfirm, false);
         }
 }

Posted 6-Aug-12 17:59pm

Nguang Sing Ping

Add a Solution

Comments

Sergey Alexandrovich Kryukov 7-Aug-12 0:14am

What does it mean: "call a class"? ..."call from file"? :-)
--SA

Nguang Sing Ping 8-Aug-12 0:34am

is calling class function from a cs file.

1 solution

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)

Prabhakaran Soundarapandian · Answer 1 · 2012-08-06T18:18:00

Solution 1

If your objective is to save the user session logout date&time means you could do that in Global.asax file where you have to write like the following

C#

void Session_End(Object sender, EventArgs E) {
   //Your method logic goes here.
}

and set your session timeout(default is 20 Minutes) in the web.config file as

C#

<sessionstate timeout="10000"></sessionstate>

Posted 6-Aug-12 18:18pm

Prabhakaran Soundarapandian

Comments

Nguang Sing Ping 7-Aug-12 0:49am

sorry that if without using the Global.asax is there any other way to do it?
Actually at the begining I used
LogInLogOut.LogInLogOut.updateLogoutTime(lblUserName.Text, lblComputerName.Text, "UR");
but it didn't saved the correct logout time. So I'm thought I could write it in javascript as I shown in my question:
function(){ update(document.LogInLogOut('lblUserName.Text', 'lblComputerName.Text', 'UR')); }
But fail to work as well. So how am I going to solve it?

Prabhakaran Soundarapandian 7-Aug-12 0:56am

Then you have to try with Jquery + ajax.