alter proc AddTasks @ID int, @Title nvarchar(200),@Name nvarchar(200),@Dom_ID_Status int,@Dom_ID_Type int,  @Description nvarchar(1000)  
as    
begin    
	if not exists(select ID from task where ID = @ID)    
	begin
		insert into task (ID,Title,Name,Dom_ID_Status,Dom_ID_Type,Description) values (@ID,@Title,@Name,@Dom_ID_Status,@Dom_ID_Type,@Description)    
	end
end
;
alter proc UpdateTasks @ID int, @Title nvarchar(200),@Name nvarchar(200),@Dom_ID_Status int,@Dom_ID_Type int,  @Description nvarchar(1000)  
as    
begin    
	update task set Title=@Title, Name=@Name ,Dom_ID_Status=@Dom_ID_Status,Dom_ID_Type=@Dom_ID_Type , Description =@Description where ID = @ID  
end