CREATE PROCEDURE changeInfo
    @rContactId INT
AS
        DECLARE @TYPE INT = (SELECT TYPE FROM rContact WHERE rContactID = @rContactId)

        IF (@TYPE = 1) -- Fizicko lice
            BEGIN
                UPDATE rContact
                SET Name = 'Filip Loshkovski'
                WHERE rContactId = @rContactId

                UPDATE rPerson
                SET FirstName = 'Filip',LastName = 'Loshkovski',PersonalNumber = '070370674',BirthDate = '1996-06-20',
                IdentityCardAddress = 'Jani Lukrovski 8/21',gender = 1
                WHERE rContactId = @rContactId

                UPDATE rContactInfo
                SET Address = 'Jani Lukrovski 8/21',mobile = '070370674' , Email = 'filipLoshkovski@hotmail.com'
                WHERE rContactId = @rContactId
            END
        ELSE  --Pravno Lice
            BEGIN
                UPDATE rContact
                    SET Name = 'Loshko'
                    WHERE rContactId = @rContactId

                    UPDATE rPerson
                    SET FirstName = 'Loshko',LastName = 'Loshkovski',PersonalNumber = '010236584',BirthDate = '1996-06-21',
                    IdentityCardAddress = 'Jani Lukrovski 8/21',gender = 1
                    WHERE rContactId = @rContactId

                    UPDATE rContactInfo
                    SET Address = 'Jani Lukrovski 22',mobile = '010236584' , Email = 'filipLoshkovski@hotmail.com'
                    WHERE rContactId = @rContactId
            END
GO

/*kec fizicko lice , dvojka e pravno lice  */