Complex Stored procedur and asp.net code also

Question

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