C# asp.net logging clients' activities

Question

Database tables: Registration & Purchase (Using Unique ID ranged 1-10000 as primary key and foreign key connecting to two tables)

How can I put on unique ID to my Purchase tables when tourists with corresponding ID do the online purchase?

I am using visual studio to work out the asp.net. However, how can I store the clients Unique ID to identify their logging activities?

        string result = "0";
        OleDbConnection connection = new OleDbConnection();
        connection.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\sim\Desktop\Web.accdb";
        connection.Open();
        OleDbCommand command = new OleDbCommand();
        command.Connection = connection;
        command.CommandText = "select ID from Registration where Name ='" + TextBox1.Text + "' and Password ='" + TextBox2.Text + "'";

        string getValue = command.ExecuteScalar().ToString();
        if (getValue != null)
        {
            result = getValue.ToString();
        }
        Session.Add("UserID", result);

        command.CommandText = "select * from Registration where Name ='" + TextBox1.Text + "' and Password ='" + TextBox2.Text + "'";

        OleDbDataReader reader = command.ExecuteReader();
        int count = 0;

        while (reader.Read())
        {
            count = count + 1;
        }
        if (String.IsNullOrEmpty(TextBox1.Text))
        {
            MessageBox.Show("You have't input the Username.");
        }
        if (String.IsNullOrEmpty(TextBox2.Text))
        {
            MessageBox.Show("you havn't input the Password.");
        }
        if (count == 1)
        {   

            MessageBox.Show("Username and password is valid");
            connection.Close();
            connection.Dispose();
            Response.Redirect("Loginpage.aspx", true);
        }
        else
        {
            MessageBox.Show("Username or Password is not matched");
        }
    }

I want to save the client's corresponding unique ID so that i can put on the unique ID when the clients do the online shopping activities — chaintao wong, Apr 17 '15 at 10:11
Get the Session Id using `Process.GetCurrentProcess().SessionId` this will be unique per user per session. — Gopesh Sharma, Apr 17 '15 at 10:20
use it in the login page??? and then how can i mark the corresponding unique ID into the Purchase tables> — chaintao wong, Apr 17 '15 at 10:26
yes, and that will exist till the User ends its session. So if the User have a Unique ID and he is going to purchase any product you can bind that Id with the Purchase Table — Gopesh Sharma, Apr 17 '15 at 10:28
BUT , how can i use this code?? i am very new to C#...&asp.net. Do u have example? I just want to build a session based on clients' Unique ID — chaintao wong, Apr 17 '15 at 10:43

score 0 · Answer 1 · edited May 23 '17 at 12:14

0

You can try something like this to get your Registration (client) ID :

public static string GetClientId()
{
    string result = "0";
    OleDbConnection connection = new OleDbConnection();
    connection.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\sim\Desktop\Web.accdb";
    connection.Open();
    OleDbCommand command = new OleDbCommand();
    command.Connection = connection;
    command.CommandText = "select ID from Registration where Name ='" + TextBox1.Text + "' and Password ='" + TextBox2.Text + "'";

    string getValue = command.ExecuteScalar().ToString();
    if (getValue != null)
    {
        result = getValue.ToString();
    }
    conn.Close();
    return result;
}

You can save that ID in the Session using :

Page.Session["UserID"] = GetClientId();

Then once the purchase is made, you can save it by retrieving that value using :

string id = Page.Session["UserID"];

Finally, when a purchase is made, you will need to INSERT it in the database. To learn how to do this, you can look at this : C# Inserting Data from a form into an access Database

edited May 23 '17 at 12:14

Community

1
1

answered Apr 17 '15 at 10:54

JP Tétreault

600
5
15

Yes that's my ideas. However, i want to know how to Build a session for the logged users to mark down their ID into Purchase tables. I don't have the ideas... – chaintao wong Apr 17 '15 at 10:59
Ok I added more details in my answer – JP Tétreault Apr 17 '15 at 11:12
i am so new... can i ask what is the meaning of Getvalue exist? and Page.Session["UserID"] = GetClientId(); <-- the UserID is the fields name of Purchase? – chaintao wong Apr 17 '15 at 11:16
getValue is just a variable holding the result of your query. ExecuteScalar is the important keyword in this code because it allows to get a single value instead of a row/table. About Page.Session, I suggest reading : https://msdn.microsoft.com/en-us/library/ms178581%28v=vs.140%29.aspx – JP Tétreault Apr 17 '15 at 11:20
can u help me see the above code?? how can i use two command.commandtext ? – chaintao wong Apr 17 '15 at 12:13
Each time you define a CommandText, you should call ExecuteScalar or ExecuteNonQuery to execute that command. So to use 2 commands, you will need to define a command, execute it, define another, execute it. – JP Tétreault Apr 17 '15 at 22:24
Session["UserId"] = Purchase table "Unique no." fields . how can i make it? and also should i use the public static ? whether i can use the variable in the same project (visual studio) other page? – chaintao wong Apr 18 '15 at 04:11

C# asp.net logging clients' activities

1 Answers1