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_UpdateByPK]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
		DROP PROCEDURE [dbo].[PR_MST_Customer_UpdateByPK]
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_UpdateByPK] @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_UpdateByPK]

		@CustomerID       		uniqueidentifier,
		@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

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

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
--~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~