USP_PARTIALINFORMATIONSEARCHRESULT_REALESTATEDETAIL_INSERT

This procedure is used to insert a Prospect Quick Search real estate detail result.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@PARTIALINFORMATIONSEARCHRESULT_REALESTATEID	uniqueidentifier	IN
@PROPERTYCOUNTY	nvarchar(255)	IN
@OWNERCAREOFNAME	nvarchar(40)	IN
@ASSESSEENAME	nvarchar(80)	IN
@ASSESSEENAME2	nvarchar(60)	IN
@ASSESSEECAREOFNAME	nvarchar(60)	IN
@ASSESSEEMAILINGADDRESSBLOCK	nvarchar(150)	IN
@ASSESSEEMAILINGADDRESSUNITNUMBER	nvarchar(25)	IN
@ASSESSEEMAILINGCITY	nvarchar(50)	IN
@ASSESSEEMAILINGSTATE	nvarchar(100)	IN
@ASSESSEEMAILINGPOSTCODE	nvarchar(10)	IN
@BUYERLASTNAME	nvarchar(100)	IN
@BUYERFIRSTNAME	nvarchar(50)	IN
@BUYER2LASTNAME	nvarchar(100)	IN
@BUYER2FIRSTNAME	nvarchar(50)	IN
@BUYERCAREOFNAME	nvarchar(40)	IN
@BUYERMAILINGADDRESSBLOCK	nvarchar(150)	IN
@BUYERMAILINGADDRESSUNITNUMBER	nvarchar(25)	IN
@BUYERMAILINGCITY	nvarchar(50)	IN
@BUYERMAILINGSTATE	nvarchar(100)	IN
@BUYERMAILINGPOSTCODE	nvarchar(10)	IN
@ESTIMATEDVALUE	money	IN
@ESTIMATEDVALUEDATE	datetime	IN
@CONFIDENCESCORE	int	IN
@ASSESSEDTOTALVALUE	money	IN
@ASSESSMENTYEAR	UDT_YEAR	IN
@TOTALMARKETVALUE	money	IN
@MARKETVALUEYEAR	UDT_YEAR	IN

Definition

Copy



            CREATE procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_REALESTATEDETAIL_INSERT (
                @ID uniqueidentifier output,
                @CHANGEAGENTID uniqueidentifier,
                @PARTIALINFORMATIONSEARCHRESULT_REALESTATEID uniqueidentifier,
                @PROPERTYCOUNTY nvarchar(255) = '',
                @OWNERCAREOFNAME nvarchar(40) = '',
                @ASSESSEENAME nvarchar(80) = '',
                @ASSESSEENAME2 nvarchar(60) = '',
                @ASSESSEECAREOFNAME nvarchar(60) = '',
                @ASSESSEEMAILINGADDRESSBLOCK nvarchar(150) = '',
                @ASSESSEEMAILINGADDRESSUNITNUMBER nvarchar(25) = '',
                @ASSESSEEMAILINGCITY nvarchar(50) = '',
                @ASSESSEEMAILINGSTATE nvarchar(100) = '',
                @ASSESSEEMAILINGPOSTCODE nvarchar(10) = '',
                @BUYERLASTNAME nvarchar(100) = '',
                @BUYERFIRSTNAME nvarchar(50) = '',
                @BUYER2LASTNAME nvarchar(100) = '',
                @BUYER2FIRSTNAME nvarchar(50) = '',
                @BUYERCAREOFNAME nvarchar(40) = '',
                @BUYERMAILINGADDRESSBLOCK nvarchar(150) = '',
                @BUYERMAILINGADDRESSUNITNUMBER nvarchar(25) = '',
                @BUYERMAILINGCITY nvarchar(50) = '',
                @BUYERMAILINGSTATE nvarchar(100) = '',
                @BUYERMAILINGPOSTCODE nvarchar(10) = '',
                @ESTIMATEDVALUE money = 0,
                @ESTIMATEDVALUEDATE datetime = null,
                @CONFIDENCESCORE int = 0,
                @ASSESSEDTOTALVALUE money = 0,
                @ASSESSMENTYEAR dbo.UDT_YEAR = 0,
                @TOTALMARKETVALUE money = 0,
                @MARKETVALUEYEAR dbo.UDT_YEAR = 0
            ) as
            begin
                set nocount on;

                declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                begin try
                    if @ID is null
                        set @ID = newid();
                        insert into dbo.[PARTIALINFORMATIONSEARCHRESULT_REALESTATEDETAIL] (
                            [ID],
                            [PARTIALINFORMATIONSEARCHRESULT_REALESTATEID],
                            [PROPERTYCOUNTY],
                            [OWNERCAREOFNAME],
                            [ASSESSEENAME],
                            [ASSESSEENAME2],
                            [ASSESSEECAREOFNAME],
                            [ASSESSEEMAILINGADDRESSBLOCK],
                            [ASSESSEEMAILINGADDRESSUNITNUMBER],
                            [ASSESSEEMAILINGCITY],
                            [ASSESSEEMAILINGSTATE],
                            [ASSESSEEMAILINGPOSTCODE],
                            [BUYERLASTNAME],
                            [BUYERFIRSTNAME],
                            [BUYER2LASTNAME],
                            [BUYER2FIRSTNAME],
                            [BUYERCAREOFNAME],
                            [BUYERMAILINGADDRESSBLOCK],
                            [BUYERMAILINGADDRESSUNITNUMBER],
                            [BUYERMAILINGCITY],
                            [BUYERMAILINGSTATE],
                            [BUYERMAILINGPOSTCODE],
                            [ESTIMATEDVALUE],
                            [ESTIMATEDVALUEDATE],
                            [CONFIDENCESCORE],
                            [CONFIDENCESCOREDATE],
                            [ASSESSEDTOTALVALUE],
                            [ASSESSMENTYEAR],
                            [TOTALMARKETVALUE],
                            [MARKETVALUEYEAR],
                            [ADDEDBYID],
                            [CHANGEDBYID],
                            [DATEADDED],
                            [DATECHANGED]
                        )
                        values (
                            @ID,
                            @PARTIALINFORMATIONSEARCHRESULT_REALESTATEID,
                            @PROPERTYCOUNTY,
                            @OWNERCAREOFNAME,
                            @ASSESSEENAME,
                            @ASSESSEENAME2,
                            @ASSESSEECAREOFNAME,
                            @ASSESSEEMAILINGADDRESSBLOCK,
                            @ASSESSEEMAILINGADDRESSUNITNUMBER,
                            @ASSESSEEMAILINGCITY,
                            @ASSESSEEMAILINGSTATE,
                            @ASSESSEEMAILINGPOSTCODE,
                            @BUYERLASTNAME,
                            @BUYERFIRSTNAME,
                            @BUYER2LASTNAME,
                            @BUYER2FIRSTNAME,
                            @BUYERCAREOFNAME,
                            @BUYERMAILINGADDRESSBLOCK,
                            @BUYERMAILINGADDRESSUNITNUMBER,
                            @BUYERMAILINGCITY,
                            @BUYERMAILINGSTATE,
                            @BUYERMAILINGPOSTCODE,
                            @ESTIMATEDVALUE,
                            @ESTIMATEDVALUEDATE,
                            @CONFIDENCESCORE,
                            @ESTIMATEDVALUEDATE,
                            @ASSESSEDTOTALVALUE,
                            @ASSESSMENTYEAR,
                            @TOTALMARKETVALUE,
                            @MARKETVALUEYEAR,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;
            end