CREATE PROCEDURE [dbo].[SP_InsertTestData]
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
INSERT INTO [User] ([UserName], [Password], [Email], [Role], [DisplayName], [Verified]) VALUES ('RAHUL','RAHUL','dummy@domain.ext','SystemIntegrator','RAHUL', 1)
INSERT INTO dbo.[CARDCONTROL]( [Name], [EmailForAlerts], SystemIntegratorId) VALUES ( 'My First CARDCONTROL', 'RAHUL_test@serverTT2.com', (Select Id from [dbo].[User] where UserName = 'RAHUL' ));
INSERT INTO dbo.GOLDCARDCONTROL( Name, Serial, [Type], CARDControlnumber, ChipId, MaximumCARDControlLimit, BranchID) VALUES ( 'TestUser 1', '1178189980', 'STANDARDCHARTEDGBP', '321082.50.107', 9600, 2.0, (Select Id from dbo.Logins where NAME='Securelogins'));
INSERT INTO dbo.GOLDCARDCONTROL( Name, Serial, [Type], CARDControlnumber, ChipId, MaximumCARDControlLimit, BranchID) VALUES ( 'TestUser 2', '1178189981', 'STANDARDCHARTEDGBP', '321082.50.107', 9600, 2.0, (Select Id from dbo.Logins where NAME='Securelogins2'));
INSERT INTO dbo.GOLDCARDCONTROL( Name, Serial, [Type], CARDControlnumber, ChipId, MaximumCARDControlLimit, BranchID) VALUES ( 'TestUser 3', '1178189982', 'STANDARDCHARTEDGBP', '321082.50.107', 9600, 2.0, (Select Id from dbo.Logins where NAME='Securelogins3'));
INSERT INTO dbo.GOLDCARDCONTROL( Name, Serial, [Type], CARDControlnumber, ChipId, MaximumCARDControlLimit, BranchID) VALUES ( 'TestUser 4', '1178189983', 'STANDARDCHARTEDGBP', '321082.50.107', 9600, 2.0, (Select Id from dbo.Logins where NAME='Securelogins4'));
INSERT INTO dbo.GOLDCARDCONTROL( Name, Serial, [Type], CARDControlnumber, ChipId, MaximumCARDControlLimit, BranchID) VALUES ( 'TestUser 5', '1178189984', 'STANDARDCHARTEDGBP', '321082.50.107', 9600, 2.0, (Select Id from dbo.Logins where NAME='Securelogins5'));
INSERT INTO dbo.GOLDCARDCONTROL( Name, Serial, [Type], CARDControlnumber, ChipId, MaximumCARDControlLimit, BranchID) VALUES ( 'TestUser 6', '1234560', 'STANDARDCHARTEDGBP', '321082.50.107', 9600, 2.0, (Select Id from dbo.Logins where NAME='Securelogins6'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (1, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (2, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (3, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (4, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (1, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (2, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (3, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (4, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (1, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (2, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (3, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (4, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (1, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (2, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (3, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (4, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (1, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (2, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (3, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (4, (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (1, (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (2, (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (3, (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
INSERT INTO dbo.SAVINGSACCOUNT([Sequence], GOLDCARDCONTROLId) VALUES (4, (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
END
