How to avoid the duplicate Entry ?

Karthik K

HI To ALL,

I had a problem with duplication entry while trying to Place booking in Booking application.I have dealing with the Calltaxi Booking dispatch application.Here the more than 200 endusers are working this application.when the people trying to press submit in the same time.That BookingNO Get
Duplicate.

Can anyone help me out if possible ...

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

if (obj.BookingNo == "1")

{

objA.BookingNo_Insert(obj.BookingNo, obj.BookingDate);

}

else

{

BookingNo_Update(obj.BookingNo, obj.BookingDate);

}

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

This Is The Function which I have used :

public string BookingNo(DateTime rDate)

{

System.Globalization.DateTimeFormatInfo dateInfo = new System.Globalization.DateTimeFormatInfo();

dateInfo.ShortDatePattern = "dd/MMM/yyyy";

string dateformat = "dd/MMM/yyyy";

string RequestDate = rDate.ToString(dateformat);

//SqlConnection con = new SqlConnection(connString);

//SqlCommand cmd = new SqlCommand();

OleDbConnection con = new OleDbConnection(connGrid);

OleDbCommand cmd = new OleDbCommand();

con.Open();

string Query = "select BOOKING_NO from TEST_bookingno where REQUEST_DT=to_date('" + RequestDate + "','dd/MON/yy')";

//cmd = new SqlCommand(Query, con);

//SqlDataReader Dr = cmd.ExecuteReader();

cmd = new OleDbCommand(Query, con);

OleDbDataReader Dr = cmd.ExecuteReader();

int r;

try

{

if (Dr.Read())

{

string d = Dr["BOOKING_NO"].ToString();

r = Convert.ToInt32(d);

r = r + 1;

txtBookingNo.Text = r.ToString();

//}

}

else

{

txtBookingNo.Text = Convert.ToString(1);//set the value in textbox which name is id

}

catch (Exception ex)

{

BL_ErrorLog objLog = new BL_ErrorLog();

objLog.Write(ex);

}

finally

{

con.Close();

}

return txtBookingNo.Text;

}

**********************************************************************************************

Thanks in advance..

Regard ,

Ernesto Karthik

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Shekhar13y ago
Accepted answer
Hi,

Try this one using StoredProcedure.

see Sample stored procedure below . . .

Create proc abc
@BookingId varchar(50)
As begin
if exists(select BookingId from mBrand where BookingId=@BookingId)
begin
Update Query
end

else

begin
INSERT query
end
end
0
Ravi Shekhar13y ago
Your Most Welcome karthik...
0
Karthik K13y ago

Dear Ravi ,

My problem has been solved. its working Fine..i Got solution for my Long days issue

THANKS YOU SO MUCH ...

Regards ,

- Karthik
0
Ravi Shekhar13y ago
Hey you can easily do like....

First you run a query...

select BookingId from mBrand where BookingId=@BookingId

and bind result with datatable.

now check your dt if dt.rows.count>0

then update query.........

else

Insert Query
0
Karthik K13y ago
Dear Ravi shekhar ,

First i am glad to your Reply regarding my Post ..But That Particular Procedure which was working sql properly , it is not working in Oracle...

I just attatched that Procedure find it..

Guide me any procedure for Oracle ..

Thanks in advance

0
Riyaz Akhtar13y ago
if i understood correctly then this issue is happening when button is click more than one times.

if yes , use OnClientClick event in ur button and write a javascript function to check if button is pressed second time. if button is pressed second time then dont let button submit.

try below sample code:

button:

OnClientClick="return ChechDuplicateClick();" Text="Button" />

add on hidden field in ur aspx,

javascript:

function ChechDuplicateClick() {
var hdn = document.getElementById("hdnCheckSubmit");

if (hdn.value=="") {
hdn.value = "wait";
return true;
}
alert("Request is processing, please wait.");
return false;
}
0
Iftikar Hussain13y ago
Hi,
Try to declare booking no as identity column.

Regards,
Iftikar
0
Pankaj Pandey13y ago
replace your query with this..

select BOOKING_NO from TEST_bookingno where REQUEST_DT=to_date('" + RequestDate + "','dd/MON/yy') with no lock.

0