USP_RECORDOPERATION_MEMBERSHIPREMOVEGIFTSTATUS

create procedure dbo.USP_RECORDOPERATION_MEMBERSHIPREMOVEGIFTSTATUS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

    declare @CURRENTDATE datetime = getDate();

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

    update dbo.MEMBERSHIP set
        ISGIFT = 0,
        GIVENBYID = null,
        SENDRENEWALCODE = 1,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = @ID;

    update dbo.MEMBERSHIPTRANSACTION set
        ISGIFT = 0,
        DONORID = null,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = dbo.UFN_MEMBERSHIP_GETLASTMEMBERSHIPTRANSACTIONID(@ID)
        and ISGIFT = 1
        and DONORID is not null;

    return 0;

end