Hope you all will be keeping well i will really appreciate if you help me out in this issue
Subject: Scenario is that i want a complex stored procedure in which
Session[Basket]
contains all the selected products ( Product id,Product name,unit
price,total ) which i wanted to insert into CustomerOrderDetail Table(for further use of customer if he want to see his history)
and Creadit Card information will be added to the CreditCardDetail
Table
"but" before insertion check
if already CreditCardNumber exist or not if not then first
insert into CreditCardDetail tabel retuned id will be
then
sent to the customerOrder table here insert recent customer info in
table returned id will be sent to the CustomerOrderDetails table for
insertion of all the basket value into CustomerOrderDetail table(NOTE:
when user selects multiple rows into basket then how will i insert this
record into CustomerOrderDetail
)
please guide me how will i manage it and correct my concept
Regards
