USE [Customer]
GO
/*
This is SP Begining Comment generated from Tools4SQL.net - T4S Stored Procedure Generator.
Website : http://www.tools4sql.net
Email : info@tools4sql.net
*/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sys.sysobjects WHERE id = object_id(N'[dbo].[PR_MST_Customer_Insert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
		DROP PROCEDURE [dbo].[PR_MST_Customer_Insert]
END
GO

/*
-- =============================================
-- Author 	  : Tools4SQL.net - T4S Stored Procedure Generator
-- Create date: 01-March-2011
-- Description:	This stored procedure is generated by T4S Stored Procedure Generator.
-- =============================================
*/

--   [dbo].[PR_MST_Customer_Insert] @CustomerID = '00000000-0000-0000-0000-000000000000', @CustomerName = 'CustomerName', @ParentCustomerID = '00000000-0000-0000-0000-000000000000', @AddressLine1 = 'AddressLine1', @AddressLine2 = 'AddressLine2', @AddressLine3 = 'AddressLine3', @CityID = 1, @PhoneNo = 'PhoneNo', @MobileNo = 'MobileNo', @FaxNo = 'FaxNo', @Email = 'Email', @Website = 'Website', @Remarks = 'Remarks', @IsActive = 1, @ModifiedDate = '1987-02-21', @CreatedDate = '1987-02-21'

CREATE PROCEDURE [dbo].[PR_MST_Customer_Insert]

		@CustomerID       		uniqueidentifier OUTPUT,
		@CustomerName     		varchar (100),
		@ParentCustomerID 		uniqueidentifier,
		@AddressLine1     		varchar (250),
		@AddressLine2     		varchar (250),
		@AddressLine3     		varchar (250),
		@CityID           		int,
		@PhoneNo          		varchar (50),
		@MobileNo         		varchar (50),
		@FaxNo            		varchar (50),
		@Email            		varchar (100),
		@Website          		varchar (100),
		@Remarks          		varchar (250),
		@IsActive         		bit = 1,
		@ModifiedDate     		datetime,
		@CreatedDate      		datetime

/*
This is SP Parameter Comment generated from Tools4SQL.net - T4S Stored Procedure Generator.
Website : http://www.tools4sql.net
Email : info@tools4sql.net
*/

AS

SET NOCOUNT ON;

/*
This is SP Body Comment generated from Tools4SQL.net - T4S Stored Procedure Generator.
Website : http://www.tools4sql.net
Email : info@tools4sql.net
*/

BEGIN TRY
BEGIN TRAN

SET @CustomerID = NEWID()


INSERT [dbo].[MST_Customer]
(
		[CustomerID],
		[CustomerName],
		[ParentCustomerID],
		[AddressLine1],
		[AddressLine2],
		[AddressLine3],
		[CityID],
		[PhoneNo],
		[MobileNo],
		[FaxNo],
		[Email],
		[Website],
		[Remarks],
		[IsActive],
		[ModifiedDate],
		[CreatedDate]
)
VALUES
(
		@CustomerID,
		@CustomerName,
		@ParentCustomerID,
		@AddressLine1,
		@AddressLine2,
		@AddressLine3,
		@CityID,
		@PhoneNo,
		@MobileNo,
		@FaxNo,
		@Email,
		@Website,
		@Remarks,
		@IsActive,
		ISNULL(@ModifiedDate,getdate()),
		ISNULL(@CreatedDate,getdate())
)

COMMIT TRAN
END TRY

BEGIN CATCH
ROLLBACK TRAN

DECLARE @ErrorNumber_INT INT;
DECLARE @ErrorSeverity_INT INT;
DECLARE @ErrorProcedure_VC VARCHAR(200);
DECLARE @ErrorLine_INT INT;
DECLARE @ErrorMessage_NVC NVARCHAR(4000);

SELECT
		@ErrorMessage_NVC = ERROR_MESSAGE(),
		@ErrorSeverity_INT = ERROR_SEVERITY(),
		@ErrorNumber_INT = ERROR_NUMBER(),
		@ErrorProcedure_VC = ERROR_PROCEDURE(),
		@ErrorLine_INT = ERROR_LINE()

RAISERROR(@ErrorMessage_NVC,@ErrorSeverity_INT,1);

END CATCH

GO
--~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~