ok-sp

CREATE PROCEDURE sp_InsertCustomer
	@CustomerId uniqueidentifier,
	@CustomerName nvarchar(150),
	@CardNo nvarchar(50),
	@PhoneNo nvarchar(50),
	@Province nvarchar(100),
	@City nvarchar(100),
	@Address nvarchar(200),
	@Mobile nvarchar(30),
	@Flag tinyint,
	@LSN binary,
	@LastUpdate datetime
AS
BEGIN
	BEGIN TRANSACTION
		IF EXISTS (SELECT CustomerId FROM CustomerClub WHERE CustomerId = @CustomerId)
		BEGIN
			UPDATE CustomerClub SET
				CustomerName=@CustomerName,
				CardNo=@CardNo,
				PhoneNo=@PhoneNo,
				Province=@Province,
				City=@City,
				Address=@Address,
				Mobile=@Mobile,
				Flag=@Flag,
				LSN=@LSN,
				LastUpdate = @LastUpdate WHERE CustomerId = @CustomerId
		END
		
		ELSE
			BEGIN
				INSERT INTO dbo.CustomerClub (CustomerId,CustomerName,CardNo,PhoneNo,Province,City,Address,Mobile,Flag,LSN,LastUpdate)
				VALUES (@CustomerId,@CustomerName,@CardNo,@PhoneNo,@Province,@City,@Address,@Mobile,@Flag,@LSN,@LastUpdate)
			END
	COMMIT TRANSACTION;
END

---------------------------------------------------

CREATE PROCEDURE sp_InsertCustomerCard
	@CustomerCardID uniqueidentifier,
	@CustomerId uniqueidentifier,
	@CardNo nvarchar(20),
	@AccontNo nvarchar(50),
	@BankId decimal,
	@IsDebit bit,
	@Status int,
	@CeilAmount money,
	@LastUpdate datetime
AS
BEGIN
	BEGIN TRANSACTION
		IF EXISTS (SELECT CustomerCardID FROM CustomerCardClub WHERE CustomerCardID = @CustomerCardID)
		BEGIN
			UPDATE CustomerCardClub SET
				CustomerCardID=@CustomerCardID,
				CustomerId=@CustomerId,
				CardNo=@CardNo,
				AccontNo=@AccontNo,
				BankId=@BankId,
				IsDebit=@IsDebit,
				Status=@Status,
				CeilAmount=@CeilAmount,
				LastUpdate = @LastUpdate WHERE CustomerCardID = @CustomerCardID
		END
		
		ELSE
		BEGIN
			INSERT INTO CustomerCardClub (CustomerCardID,CustomerId,CardNo,AccontNo,BankId,IsDebit,Status,CeilAmount,LastUpdate)
			VALUES (@CustomerCardID,@CustomerId,@CardNo,@AccontNo,@BankId,@IsDebit,@Status,@CeilAmount,@LastUpdate)
		END
	COMMIT TRANSACTION;
END