How can I get a unique Order Id on every transaction?

Question

5.00/5 (1 vote)

See more:

I have mentioned this Code in .CS file to get an Order id but every time when someone choose different packages from my Services Page so its get me the same Order Id which is 10 . now i want to get a unique Order Id on every time when any user choose any of the Services .

C#

protected void Page_Load(object sender, EventArgs e)
   {
       if (!IsPostBack)
       {
           AmountBox.Text = Request.QueryString[0].ToString();
           lblCustNotes.Text = Request.QueryString[1].ToString();
           lblOrderId.Text = OrderID().ToString();
       }
   }
   protected int OrderID()
   {
       string query = "SELECT MAX(OrderID) FROM Orders";
       int id = Query.Scaller(query, 0);
       return id + 000;
   }
   protected void btnSubmit_Click(object sender, EventArgs e)
   {
       Response.Redirect("~/SubmitData.aspx?x=" + AmountBox.Text + "&y=" + lblCustNotes.Text+"&z="+lblOrderId.Text);
   }

Do let me know the Solution so i can complete this Project .

Posted 27-Jan-14 19:57pm

Navneet k soni

Updated 27-Jan-14 20:30pm

André Kraak

v2

Add a Solution

Comments

Sampath Lokuge 28-Jan-14 3:31am

You have to modify it according to your situation (i.e. Solution 1).

3 solutions

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)

Sampath Lokuge · Answer 1 · 2014-01-27T20:10:00

You can use GUID for that.Please check below mentioned article for more info.

// This code example demonstrates the Guid.NewGuid() method. 

using System;

class Sample 
{
    public static void Main() 
    {
    Guid g;
// Create and display the value of two GUIDs.
    g = Guid.NewGuid();
    Console.WriteLine(g);
    Console.WriteLine(Guid.NewGuid());
    }
}

/*
This code example produces the following results:

0f8fad5b-d9cb-469f-a165-70867728950e
7c9e6679-7425-40de-944b-e07fc1f90ae7

*/

Guid

V5709 · Answer 2 · 2014-01-27T20:28:00

Solution 3

Just make little bit change in your query.

C#

string query = @"DECLARE @MAX_Id int=null;
                 SELECT MAX_Id= MAX(OrderID) FROM Orders ;
                 SET   MAX_Id=MAX_Id +1;
                 SELECT MAX_Id;";

Posted 27-Jan-14 20:28pm

V5709

Updated 27-Jan-14 20:33pm

v4

Navneet k soni · Answer 3 · 2014-01-27T20:13:00

Solution 2

Well do i have to put this code in my .CS file or i have to Modify it ?

Posted 27-Jan-14 20:13pm

Navneet k soni