USP_DATAFORMTEMPLATE_EDITSAVE_WPREALESTATE

The save procedure used by the edit dataform template "WealthPoint Real Estate Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SOURCE	nvarchar(100)	IN	Source
@CNOTES	nvarchar(1024)	IN	Notes
@DEEDTYPE	nvarchar(100)	IN	Deed type
@DOCUMENTNUMBER	nvarchar(200)	IN	Document number
@SALEPRICE	money	IN	Sale price
@RECORDEDDATE	nvarchar(200)	IN	Recorded date
@SALEDATE	datetime	IN	Sale date
@BUYERMAILINGADDRESS	nvarchar(200)	IN	Buyer mailing address
@SELLERMAILINGADDRESS	nvarchar(200)	IN	Seller mailing address
@SELLER	nvarchar(300)	IN	Seller
@BUYER	nvarchar(300)	IN	Buyer
@LEGALDESCRIPTION	nvarchar(2000)	IN	Legal description
@PROPERTYUSE	nvarchar(100)	IN	Property use
@LOTSIZE	nvarchar(50)	IN	Lot size
@ROOF	nvarchar(30)	IN	Roof
@FOUNDATION	nvarchar(30)	IN	Foundation
@EXTERIORWALLS	nvarchar(30)	IN	Exterior walls
@BASEMENT	nvarchar(30)	IN	Basement
@CONSTRUCTION	nvarchar(30)	IN	Construction
@HEATING	nvarchar(30)	IN	Heating
@AIRCONDITIONING	nvarchar(30)	IN	Air conditioning
@STYLE	nvarchar(30)	IN	Style
@ELEVATOR	nvarchar(5)	IN	Elevator
@NOOFBUILDINGS	nvarchar(5)	IN	No. of buildings
@BUILDINGAREA	nvarchar(10)	IN	Building area
@GARAGETYPE	nvarchar(30)	IN	Garage type
@FIREPLACE	nvarchar(5)	IN	Fireplace
@TOTALROOMS	nvarchar(5)	IN	Total rooms
@PARTIALBATHS	nvarchar(5)	IN	Partial baths
@BATHS	nvarchar(5)	IN	Baths
@BEDROOMS	nvarchar(5)	IN	Bedrooms
@UNITS	nvarchar(10)	IN	Units
@STORIES	nvarchar(50)	IN	Stories
@POOLSPA	nvarchar(30)	IN	Pool/Spa
@YEARBUILT	UDT_YEAR	IN	Year built
@OWNER	nvarchar(300)	IN	Owner
@BB_COUNTY	nvarchar(255)	IN	County
@MAILINGADDRESS	nvarchar(200)	IN	Mailing address
@TITLECOMPANY	nvarchar(50)	IN	Title company
@TERM	nvarchar(20)	IN	Term
@LOANAMOUNT	money	IN	Loan amount
@TYPEOFMORTGAGE	nvarchar(100)	IN	Mortgage type
@LENDER	nvarchar(100)	IN	Lender
@LENDERTYPE	nvarchar(50)	IN	Lender type
@LOANTYPE	nvarchar(50)	IN	Loan type
@DUEDATE	datetime	IN	Due date
@ASSESSORSPARCELNUMBER	nvarchar(100)	IN	Assessor's parcel number
@LANDUSE	nvarchar(100)	IN	Land use
@TAXRATECODE	nvarchar(50)	IN	Tax rate code
@MARKETIMPROVEMENTVALUE	money	IN	Market improvement value
@TOTALMARKETVALUE	money	IN	Total market value
@MARKETLANDVALUE	money	IN	Market land value
@MARKETVALUEYEAR	UDT_YEAR	IN	Market value year
@ASSESSEDMULTIPLIER	nvarchar(5)	IN	Assessed multiplier
@ASSESSMENTYEAR	UDT_YEAR	IN	Assessed value year
@ASSESSEDIMPROVEMENTVALUE	money	IN	Assessed improvement value
@ASSESSEDTOTALVALUE	money	IN	Assessed total value
@ASSESSEDLANDVALUE	money	IN	Assessed land value
@PROPADDRESS	nvarchar(150)	IN	Address
@PROPCITY	nvarchar(50)	IN	City
@PROPSTATE	nvarchar(100)	IN	State
@PROPZIP	nvarchar(10)	IN	ZIP
@PROPERTYRECORDFOR	nvarchar(50)	IN	Property record for
@PROPERTYTRANSFERRECORDFOR	nvarchar(50)	IN	Property transfer record for
@BORROWERS	nvarchar(200)	IN	Borrower(s)
@MORTGAGERECORDFOR	nvarchar(50)	IN	Mortgage record for

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_WPREALESTATE (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @SOURCE nvarchar(100),
                        @CNOTES nvarchar(1024),
                        @DEEDTYPE nvarchar(100),
                        @DOCUMENTNUMBER nvarchar(200),
                        @SALEPRICE money,
                        @RECORDEDDATE nvarchar(200),
                        @SALEDATE datetime,
                        @BUYERMAILINGADDRESS nvarchar(200),
                        @SELLERMAILINGADDRESS nvarchar(200),
                        @SELLER nvarchar(300),
                        @BUYER nvarchar(300),
                        @LEGALDESCRIPTION nvarchar(2000),
                        @PROPERTYUSE nvarchar(100),
                        @LOTSIZE nvarchar(50),
                        @ROOF nvarchar(30),
                        @FOUNDATION nvarchar(30),
                        @EXTERIORWALLS nvarchar(30),
                        @BASEMENT nvarchar(30),
                        @CONSTRUCTION nvarchar(30),
                        @HEATING nvarchar(30),
                        @AIRCONDITIONING nvarchar(30),
                        @STYLE nvarchar(30),
                        @ELEVATOR nvarchar(5),
                        @NOOFBUILDINGS nvarchar(5),
                        @BUILDINGAREA nvarchar(10),
                        @GARAGETYPE nvarchar(30),
                        @FIREPLACE nvarchar(5),
                        @TOTALROOMS nvarchar(5),
                        @PARTIALBATHS nvarchar(5),
                        @BATHS nvarchar(5),
                        @BEDROOMS nvarchar(5),
                        @UNITS nvarchar(10),
                        @STORIES nvarchar(50),
                        @POOLSPA nvarchar(30),
                        @YEARBUILT dbo.UDT_YEAR,
                        @OWNER nvarchar(300),
                        @BB_COUNTY nvarchar(255),
                        @MAILINGADDRESS nvarchar(200),
                        @TITLECOMPANY nvarchar(50),
                        @TERM nvarchar(20),
                        @LOANAMOUNT money,
                        @TYPEOFMORTGAGE nvarchar(100),
                        @LENDER nvarchar(100),
                        @LENDERTYPE nvarchar(50),
                        @LOANTYPE nvarchar(50),
                        @DUEDATE datetime,
                        @ASSESSORSPARCELNUMBER nvarchar(100),
                        @LANDUSE nvarchar(100),
                        @TAXRATECODE nvarchar(50),
                        @MARKETIMPROVEMENTVALUE money,
                        @TOTALMARKETVALUE money,
                        @MARKETLANDVALUE money,
                        @MARKETVALUEYEAR dbo.UDT_YEAR,
                        @ASSESSEDMULTIPLIER nvarchar(5),
                        @ASSESSMENTYEAR dbo.UDT_YEAR,
                        @ASSESSEDIMPROVEMENTVALUE money,
                        @ASSESSEDTOTALVALUE money,
                        @ASSESSEDLANDVALUE money,
                        @PROPADDRESS nvarchar(150),
                        @PROPCITY nvarchar(50),
                        @PROPSTATE nvarchar(100),
                        @PROPZIP nvarchar(10),
                        @PROPERTYRECORDFOR nvarchar(50),
                        @PROPERTYTRANSFERRECORDFOR nvarchar(50),
                        @BORROWERS nvarchar(200),
                        @MORTGAGERECORDFOR nvarchar(50)
                    ) as begin

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

                        update dbo.WPREALESTATE set
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = getdate(),
                            SOURCE = @SOURCE,
                            CNOTES = @CNOTES,
                            DEEDTYPE = @DEEDTYPE,
                            DOCUMENTNUMBER = @DOCUMENTNUMBER,
                            SALEPRICE = @SALEPRICE,
                            RECORDEDDATE = @RECORDEDDATE,
                            SALEDATE = @SALEDATE,
                            BUYERMAILINGADDRESS = @BUYERMAILINGADDRESS,
                            SELLERMAILINGADDRESS = @SELLERMAILINGADDRESS,
                            SELLER = @SELLER,
                            BUYER = @BUYER,
                            LEGALDESCRIPTION = @LEGALDESCRIPTION,
                            PROPERTYUSE = @PROPERTYUSE,
                            LOTSIZE = @LOTSIZE,
                            ROOF = @ROOF,
                            FOUNDATION = @FOUNDATION,
                            EXTERIORWALLS = @EXTERIORWALLS,
                            BASEMENT = @BASEMENT,
                            CONSTRUCTION = @CONSTRUCTION,
                            HEATING = @HEATING,
                            AIRCONDITIONING = @AIRCONDITIONING,
                            STYLE = @STYLE,
                            ELEVATOR = @ELEVATOR,
                            NOOFBUILDINGS = @NOOFBUILDINGS,
                            BUILDINGAREA = @BUILDINGAREA,
                            GARAGETYPE = @GARAGETYPE,
                            FIREPLACE = @FIREPLACE,
                            TOTALROOMS = @TOTALROOMS,
                            PARTIALBATHS = @PARTIALBATHS,
                            BATHS = @BATHS,
                            BEDROOMS = @BEDROOMS,
                            UNITS = @UNITS,
                            STORIES = @STORIES,
                            POOLSPA = @POOLSPA,
                            YEARBUILT = @YEARBUILT,
                            OWNER = @OWNER,
                            BB_COUNTY = @BB_COUNTY,
                            MAILINGADDRESS = @MAILINGADDRESS,
                            TITLECOMPANY = @TITLECOMPANY,
                            TERM = @TERM,
                            LOANAMOUNT = @LOANAMOUNT,
                            TYPEOFMORTGAGE = @TYPEOFMORTGAGE,
                            LENDER = @LENDER,
                            LENDERTYPE = @LENDERTYPE,
                            LOANTYPE = @LOANTYPE,
                            DUEDATE = @DUEDATE,
                            ASSESSORSPARCELNUMBER = @ASSESSORSPARCELNUMBER,
                            LANDUSE = @LANDUSE,
                            TAXRATECODE = @TAXRATECODE,
                            MARKETIMPROVEMENTVALUE = @MARKETIMPROVEMENTVALUE,
                            TOTALMARKETVALUE = @TOTALMARKETVALUE,
                            MARKETLANDVALUE = @MARKETLANDVALUE,
                            MARKETVALUEYEAR = @MARKETVALUEYEAR,
                            ASSESSEDMULTIPLIER = @ASSESSEDMULTIPLIER,
                            ASSESSMENTYEAR = @ASSESSMENTYEAR,
                            ASSESSEDIMPROVEMENTVALUE = @ASSESSEDIMPROVEMENTVALUE,
                            ASSESSEDTOTALVALUE = @ASSESSEDTOTALVALUE,
                            ASSESSEDLANDVALUE = @ASSESSEDLANDVALUE,
                            PROPADDRESS = @PROPADDRESS,
                            PROPCITY = @PROPCITY,
                            PROPSTATE = @PROPSTATE,
                            PROPZIP = @PROPZIP,
                            PROPERTYRECORDFOR = @PROPERTYRECORDFOR,
                            PROPERTYTRANSFERRECORDFOR = @PROPERTYTRANSFERRECORDFOR,
                            BORROWERS = @BORROWERS,
                            MORTGAGERECORDFOR = @MORTGAGERECORDFOR
                        where
                            ID=@ID;

                        if    (select
                                count(WEALTHSOURCE.SOURCE)
                            from
                                dbo.WEALTHSOURCE
                            where
                                WEALTHSOURCE.SOURCE = @SOURCE
                            ) = 0
                            begin
                                insert into dbo.WEALTHSOURCE (
                                    [SOURCE],
                                    [ISBUILTIN],
                                    [ADDEDBYID],
                                    [CHANGEDBYID]
                                )values(
                                    @SOURCE,
                                    0,
                                    @CHANGEAGENTID,
                                    @CHANGEAGENTID
                                );
                            end    

                        declare @WEALTHID uniqueidentifier;
                        select @WEALTHID=WEALTHID from dbo.WPREALESTATE where ID=@ID;

                        exec dbo.USP_WEALTHPOINT_UPDATEWEALTHSUMMARY_REALESTATE @WEALTHID, @CHANGEAGENTID;
                        exec dbo.USP_WEALTHCAPACITY_UPDATE @WEALTHID, @CHANGEAGENTID;

                        return 0;
                    end