CREATE PROCEDURE AddJobService (@JobNumber INT = NULL, @ServiceCode VARCHAR (15) = NULL, @Notes VARCHAR (200) = NULL, Hours INT = NULL)
AS
DECLARE @TempNum INT
IF @JobNumber IS NULL OR @ServiceCode IS NULL OR @Notes IS NULL OR @Hours IS NULL
    BEGIN
    RaisError ('You must provide all information',16,1)
    END
IF EXISTS (SELECT JobNumber FROM Job WHERE JobNumber = @JobNumber)
    BEGIN
    INSERT INTO JobService (JobNumber, ServiceCode, Notes,hours, ActualCostPerHour, extcost)
    VALUES (@JobNumber,@ServiceCode,@Notes,@Hours,20,60)
    END
ELSE
    BEGIN
    RaisError ('That job does not exist', 16,1)
    END
RETURN
GO