--USE [MinovaES_Easy]
--GO
--/****** Object:  StoredProcedure [dbo].[Mobile_InsertAttendanceClockOut]    Script Date: 9/3/2025 2:16:11 PM ******/
--SET ANSI_NULLS ON
--GO
--SET QUOTED_IDENTIFIER ON
--GO




CREATE PROCEDURE [dbo].[Mobile_InsertAttendanceClockOut]
 
    @StartDate VARCHAR(8),
    @EndDate VARCHAR(8),
    @EmployeeID VARCHAR(8),
    @AttendanceType VARCHAR(4),
    @StartTime VARCHAR(4),
    @StartLocation VARCHAR(100),
    @EndTime VARCHAR(4),
    @EndLocation VARCHAR(100),
    @Notes VARCHAR(255),
    @CreateBy VARCHAR(50),
    @ChangeBy VARCHAR(50),
    @filename VARCHAR (MAX),
    @filebase64 VARCHAR (MAX)
AS

  --DECLARE  @StartDate VARCHAR(8)='20250709'
  --DECLARE  @EndDate VARCHAR(8)='20250709'
  --DECLARE  @EmployeeID VARCHAR(8)='00000001'
  --DECLARE  @AttendanceType VARCHAR(4)='1000'
  --DECLARE  @StartTime VARCHAR(4)=''
  --DECLARE  @StartLocation VARCHAR(100)=''
  --DECLARE  @EndTime VARCHAR(4)='1700'
  --DECLARE  @EndLocation VARCHAR(100)='PT Minova Infotech Solution'
  --DECLARE  @Notes VARCHAR(255)='From Maui With Image'
  --DECLARE  @CreateBy VARCHAR(50)='shofwan'
  --DECLARE  @ChangeBy VARCHAR(50)='shofwan'
  --DECLARE @filename VARCHAR (MAX)='00da52e6349840a78ae3e3ec59b3267a.jpg'
  --DECLARE @filebase64 VARCHAR (MAX)='/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAYEBQYFBAYGBQYHBwYIChAKCgkJChQODwwQFxQYGBcUFhYaHSUfGhsjHBYWICwgIyYnKSopGR8tMC0oMCUoKSj/2wBDAQcHBwoIChMKChMoGhYaKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCj/wAARCAJYAcIDASIAAhEBAxEB/8QAHAABAAIDAQEBAAAAAAAAAAAAAAYHAwQFAgEI/8QARxABAAADAgcLCAkDBAMBAAAAAAECAwQFERQWU1SSkwYHEhMVYnORobHRMzU2RXKDssIhMTRDUVJ0gcEyVXFBYYKzIiNEJP/EABoBAQADAQEBAAAAAAAAAAAAAAADBAUCAQb/xAAvEQEAAQIDBgQGAgMAAAAAAAAAAQIDE1FSBBESFDEzBRUygSFCYXGhwUGRIjSx/9oADAMBAAIRAxEAPwD9FgMBVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABDd8OeaTk/gTTS4eM+qOD8qHcdVzk+tFQvbdFquaOHoiqu8M7ty4xTnHVc5PrROOq5yfWii8yjT+XON9FxinOOq5yfWicdVzk+tE8yjT+TG+i4xTnHVc5PrROOq5yfWieZRp/JjfRcYpzjqucn1onHVc5PrRPMo0/kxvouMU5x1XOT60Tjqucn1onmUafyY30XGKc46rnJ9aJx1XOT60TzKNP5Mb6LjFOcdVzk+tE46rnJ9aJ5lGn8mN9FxinOOq5yfWicdVzk+tE8yjT+TG+i4xTnHVc5PrROOq5yfWieZRp/JjfRcYpzjqucn1onHVc5PrRPMo0/kxvouMU5x1XOT60Tjqucn1onmUafyY30XGKc46rnJ9aJx1XOT60TzKNP5Mb6LjFOcdVzk+tE46rnJ9aJ5lGn8mN9FxinOOq5yfWicdVzk+tFrbHTzNvE6JKa+KN64xTnHVc5PrROOq5yfWitcp9XW9cYpzjqucn1onHVc5PrROU+pvXGKc46rnJ9aIcp9TeuMBTegAAAAAAAAAAAAAAAAAAAIXvjer/AHnyoYme+N6v958qGMDbe/V7f8VLnqkAVXAAAAAAAAAAAAAAAAAAAAAAAAAPNSpJSlw1J5ZIfVhmjgY8bs2kUdeD63wf/Wj7ysW/SzDDjdm0ijrwMbs2kUdeDUdsww43ZtIo68DG7NpFHXgDMMON2bSKOvABdoDHdgAAAAAAAAAAAAAAAAAAAIXvjer/AHnyoYme+N6v958qGMDbe/V7f8VLnqkAVXAAAAAAAAAAAAAAAAAAAAAAAACMb4PmWj+ol+GZXywd8HzLR/US/DMr59b4P/rR95WLfpAGo7AAAAfs8BjuwAAAAAAAAAAAHPmvm7ZZoyzW2hCaEcEYRnh9D5y3dmnWfXgq+2/bbR0k3ewgtblu7NOs+vA5buzTrPrwVSJKKIqS27cVx8Vrct3Zp1n14HLd2adZ9eCqR3hQkwIzWty3dmnWfXgct3Zp1n14KpDCgwIzSvd3brLbMRxWvTq8Dh8LgRw4MPBwdyKYQUrvhtF2ua5mfijq2Smqd+8wmEEflFvVLnkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqczCYQPKLeqTkqc0Y3wfM1H9RL8Myvlg74Pmaj+ol+GZXzS2WiNmt4dPxSU7NTTG7eALOLL3l4zADFk5eMwAxZOXjN+zwGcrgAAAAAAAAAAAKetv220dJN3sLNbftlfpJu9hAHivVkoUalWrHBTpyxmmjgw4IQhhi5GU906THZzeCe10WbHSXaHFynunSY7ObwMp7p0mOzm8Eqd2hxcp7p0mOzm8DKe6dJjs5vAHaHFynunSY7ObwMp7p0mOzm8AdocXKe6dJjs5vAynunSY7ObwB2hxcp7p0mOzm8DKe6dJjs5vAHaHFynunSY7ObwMp7p0mOzm8AdocXKe6dJjs5vAynunSY7ObwB2hxcp7p0mOzm8DKe6dJjs5vAHaHFynunSY7ObwMp7p0mOzm8AdocXKe6dJjs5vAynunSY7ObwB2hxcp7p0mOzm8DKe6dJjs5vAHaHFynunSY7ObwMp7p0mOzm8AdocXKe6dJjs5vAynunSY7ObwB2hxcp7p0mOzm8DKe6dJjs5vAHaHFynunSY7ObwMp7p0mOzm8AdocXKe6dJjs5vAynunSY7ObwBpb4PmWj+ol+GZXyZbsL3sV43ZSo2OrGpUlrQnjDgxh9HBmh/rD/eCH8Cb8AeR64E34HAm/AHkeuBN+BwJvwB5HrgTfgA/ZoCmzwAAAAAAAAAAAFPW37baOkm72Fmtv2yv0k3ewg0758z27oKnwxVUtW+fM9u6Cp8MVVJ7XRZsdJAEqcAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB+yAFNngAAAAAAADxNUhLHBHC9ter5SKttV2q1RE0uap3MnGy/wC5xsv+7AM/nbrjilVNt+m2V+km72Fmtn2uv7c3ewuOfvIsWpp3z5nt3QVPhiqpat8+Z7d0FT4Yqqa3h1+u9TVNa/slU1RO8AaS2AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA/ZACmzwAAAAAAR/dLf89z16NOShLVhUljNhjNgwfS4+W1bQqevHwBOGvV8pFD8tq2hU9ePgxzbsqs02HE6evHwUfEJ3W4+6O5O6ExENyxq6HJrx8DLGrocmvHwY/FCLihG7Z9rr+3N3sL3Vn4yrPPGGDhTRmwf5eHCJp3z5nt3QVPhiqpat8+Z7d0FT4Yqqb3hHoq+7R2L0yANddAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAfsgBTZ4AAAAACC74f22ydHHvRJLd8P7bZOjj3okAAoeI9qPuivekAYqsAA0758z27oKnwxVUtW+fM9u6Cp8MVVN7wj0Vfdo7F6ZAGuugAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP0Jljef5bPqR8TLG8/y2fUj4o4PkuavamJx1ZpfdG6i32u8rPQqy0OBUmwRwSRhHvTHjZvwgrDc757sftrLdU7Vd1O6apmGTjZvwg9054zRwRwMDJQ/qj/AIT2L9yq5ETLuJnezgNhKgu+H9tsnRx70SS3fD+22To496JAAKHiPaj7or3pAGKrAANO+fpui3dBP8MVWcBal8eaLd0E/wAMVXLuy3a6Inhnc6puV0emXjgHAexb5m7qdcxc1PHAOA9hzN3Ucxc1Mc0MD49VP9HlbtXa5piZlSu7ZfiuYiqQBJiVZo+dv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65ADEqzOdv65XCA+YXXR3O+e7H7ay1abnfPdj9tZbulJR0GSh/VH/AAxslD+qP+FjZu7Skp6s4DeTILvh/bbJ0ce9Ekt3w/ttk6OPeiQACh4j2o+6K96QBiqwADUvjzRbugn+GKrls1qclalPSqQ4Uk8sZZofjCP1uZk7deiw15vFNauRRHxeTCuRY2Tt16LDXm8TJ269FhrzeKXHpNyuRY2Tt16LDXm8TJ269FhrzeJj0m5W1T/R5TS/7nsNm4jiaEJeFwsP/lGP4f7uRiNnzfbFp7PVxW4mGdf9cuEO7iNnzfbExGz5vtinROEO7iNnzfbExGz5vtiDhDu4jZ832xMRs+b7Yg4Q7uI2fN9sTEbPm+2IOEO7iNnzfbExGz5vtiDhDu4jZ832xMRs+b7Yg4Q7uI2fN9sTEbPm+2IOEO7iNnzfbExGz5vtiDhDu4jZ832xMRs+b7Yg4Q7uI2fN9sTEbPm+2IOEO7iNnzfbExGz5vtiDhDu4jZ832xMRs+b7Yg4Q7uI2fN9sTEbPm+2IOEO7iNnzfbExGz5vtiDhDu4jZ832xMRs+b7Yg4Q7uI2fN9sTEbPm+2IOEO7iNnzfbEBYgD5prujud892P21lq03O+e7H7ay3dKSjoMlD+qP+GNkof1R/wALGzd2lJT1ZwG8mQXfD+22To496JJbvh/bbJ0ce9EgAFDxHtR90V70gDFVgAAAAAAAHC3Uf/N/y/hwXe3Uf/N/y/hwW3sfZhnX+5IAtIQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGhynbtMtG0icp27TLRtItQS4VGmP6bm5I9yF5W2bdNd0s1rrxhGrDDCM8fwXRjVfPVNaKjdx3pPd3Sw7l2GFRpgZsar56prRfYWu0Q+qvUh/yiwCLaKKabczEE9Gxjtp0irrRMdtOkVdaLXGNiVZo+Kc1f76l4WyS8LDwLVWl/9U31Tx/FBuU7dplo2kUv31vOFg6KbvQV1FdWZxS2+U7dplo2kTlO3aZaNpFqPkVvZP8AOuYq+PwdUzv6tvlO3aZaNpE5Tt2mWjaRag0cKjTH9Otzb5Tt2mWjaROU7dplo2kWoGFRpj+jc2+U7dplo2kTlO3aZaNpFqBhUaY/o3NvlO3aZaNpE5Tt2mWjaRagYVGmP6Nzb5Tt2mWjaROU7dplo2kWoGFRpj+jc6dltVe08LGK1SrwcGDhzRjgZ2ldv3n7fy3UdURE7oZW09yQB4gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAcUBZbrs7jvSe7ulh3LsUnuO9J7u6WHcuwABBtPaqeVdABgola763nCwdFN3oKnW+t5wsHRTd6Cu46A+RfXyK7sPcn7OqeoA1UgAAAAAAADdu37z9v5brSu37z9v5bqCvqydp7sgDlAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA4o2uTbdoVp2U3gcm27QrTspvBNx05txv7jvSe7ulh3LsU3uSsFsp7pLvnqWW0SSQqwjGaanGEIfR/hchx05gAh2mumbVW6Xk9ABho1a763nCwdFN3oKnW+t5wsHRTd6Cu46A+RfXyK5sUxFc78nVPUAanHTm73gBx05m8AexMT0egD0AAbt2/eft/LdaV2/eft/LdQV9WTtPdkBhq2qz0Z+DVr0pJvwmnhCLlAzDWx+x6XZ9pDxMfsel2faQ8TdL3dLZGpG8rDCP022zbWXxOU7Bptl2svi94KsnWHXlLbGpynYNNsu1l8TlOwabZdrL4veCrIw68pbY1OU7Bptl2svi90rdZK1SFOjaqFSeP1Sy1IRjH9nnDVkTbqj+GwA8cA8z1JKcIRnnllhH8Y4HjGKOep60AZRixijnqetAxijnqetAiJn4Q9iJn4QyjFjFDPU9aBjFDPU9aDrDryl1h15SyjFjFDPU9aBjFDPU9aBh15SYdeUsoxYxQz1PWgyvJpmnrDyaZp6wAPHIAAMdevRs8kJ69WnSljHBCM80JYYf3YOU7Bptl2svi9imZ6Q6iiqfjENsanKdg02y7WXxOU7Bptl2svi94KsnuHXlLbGpynYNNsu1l8TlOwabZdrL4nBVkYdeUtsanKdg02y7WXxDgqyMOvKV7AMFqAAAAAAK131vOFg6KbvQVOt9bzhYOim70Fdx0AB6AAAAD4+vjS2H0y7pAF92AA3bt+8/b+W60rt+8/b+W6gr6snae7IrLd96Qz9HKs1WW770hn6OVJY9TrZfWjgC40HHr+Wqe1FjZK/lqntRY1yOjWp6QAD0STe79MLB7z/AK5kbSTe79MLB7z/AK5nF30VfaUO0dqr7SugBiPlXF3T+Qoe1HuR1It0/kKHtR7kdAAXvDu97L/hvf8AYAfQPoQABPEDTxkeK/J7/pj+LfJ7/oAZDHAAQvfY9HbP+ql+CdU62N9j0ds/6qX4J1TtXZO2+h8N7HuALK+AAAA/e4D4VjAAAAAAIHvjXRb7yttjnsNlqVpZKcYTRlwfRHCiOS99/wBurdniuoe7xSuS99/26t2eJkvff9urdniuoe8QpXJe+/7dW7PEyXvv+3VuzxXUHEPz7PJNJPNJPDBNLHBGH4ReWxePnC1dLN3xa70Hx9fGnsPpl3SAL7sABu3b95+38t1pXb95+38t1BX1ZO092RWW770hn6OVZqst33pDP0cqSx6nWy+tHAFxoOPX8tU9qLGyV/LVPaixrkdGtT0gAHokm936YWD3n/XMjaSb3fphYPef9czi76KvtKHaO1V9pXQAxHyri7p/IUPaj3I6kW6fyFD2o9yOgAL3h3e9l/w3v+wA+gfQgACeIGnjI8V+T3/TH8W+T3/QAyGOAAhe+x6O2f8AVS/BOqdbG+x6O2f9VL8E6p2rsnbfQ+G9j3AFlfAAAAfvcB8KxgAAAAAAAAAAAFB3j5wtXSzd8Wul1s3E3zVtdepJTo8GeeaaH/sh9UYsOQt9ZujtYO94i74lOQt95qjtYPmQt95qjtYL+x3aKIninc7plFxKMhb7zVHawMhb7zVHawXOYtanW+EXEoyFvvNUdrAyFvvNUdrA5i1qN8OJdv3n7fy3We1XFbbl4OPyyS8dh4HBm4X1fX3wYHM1RV8aejK2nuSKy3fekM/RyrNQrdXudvC8r3mtFlkpxpxkllwzT4I4YJbMxFXxe7PVFNe+UEEjyOvfN0dpAyOvfN0dpBaxKc13FozQSv5ap7UWNL6u4K+5qk00JKGCMYx8rB4yBvv8ln2q1F+3u9TSp2qzuj/KETEsyBvv8ln2pkDff5LPtTHt6nvN2dUImkm936YWD3n/AFzNjIG+/wAln2rs7kdyF63XuhslstctGFGnw+FGWphj9MkYQ+j/ADFxcvUTRMRP8Ir+02qrdURVHSVjgMl844u6fyFD2o9yOpFun8hQ9qPcjoAC94d3vZf8N7/sAPoH0IAAniBp4yPFfk9/0x/Fvk9/0AMhjgAIXvsejtn/AFUvwTqnXRu8ui1X1c9GzWGEkasteFSPDmwQwQlmh/MEDyBvv8ln2rR2W7RTb3TLc2C/bos7qqt0omJZkDff5LPtTIG+/wAln2qxj29S5zdnVCJiWZA33+Sz7UyBvv8AJZ9qY9vUc3Z1QiYlmQN9/ks+1DHt6jm7OqH7LAfFM4AAAAAAAAAAAAAAAAAAABCt8n1d7z5UJTbfJ9Xe8+VCWrs3bhnX+5IAnQgAAAAAAAAAOLun8hQ9qPcjqRbp/IUPaj3I6AAveHd72X/De/7AD6B9CAAJ4gaeMjxX5Pf9Mfxb5Pf9ADIY4AAAAAAAAAC6wGG1wAAAAAAAAAAAAAAAAAAAEK3yfV3vPlQlNt8n1d7z5UJauzduGdf7kgCdCAAAAAAAAAA4u6fyFD2o9yOpFun8hQ9qPcjoAC94d3vZf8N7/sAPoH0IAAniBp4yPFfk9/0x/Fvk9/0AMhjgAAAAAAAAALrAYbXAAAAAAAAAAAAAAAAAAAAQrfJ9Xe8+VCU23yfV3vPlQlr7NTM2oVLtiuuqaogAT8Eo+VuZABwScrcyADgk5W5kAHBJytzIAOCTlbmQAcEnK3MnF3T+Qoe1HuR1It0/kKHtR7kdOCTlbmQAt7HVFq7xV9FvYrVVq7xV9ABr87ZzbGPQAHO2czHoE8QNPGdt92m9w8H8b2b4hTN/h4P43gDO4JZ3K3MgA4JOVuZABwScrcyADgk5W5kAHBJytzIAOCTlbmS6wGCvgAAAAAAAAAAAAAAAAAAAIVvk+rvefKhKbb5Pq73nyoS3Nj7MJKegAsugAAAAAAAAAHF3T+Qoe1HuR1It0/kKHtR7kdAAAAAAATxA08AAAAAAAAAAAABdYD5pCAAAAAAAAAAAAAAAAAAAAgO+rWmo8l8DB9PG/X/wQHHKvN6k532/VXvfkV63Nj7MJKejZxyrzeoxyrzeprCy6bOOVeb1GOVeb1NYBs45V5vUY5V5vU1gGzjlXm9RjlXm9TWAbOOVeb1GOVeb1NYBs45V5vUY5V5vU1gC2/8A7JZZa31Sxww4P0NPk+jz+tuANPk+jz+s5Po8/rbgDT5Po8/rOT6PP624A0+T6PP6zk+jz+tuANPk+jz+t1ccq83qawDZxyrzeoxyrzeprANnHKvN6jHKvN6msA2ccq83qMcq83qawDZxyrzeoxyrzeprANnHKvN6jHKvN6msA2ccq83qGsA/QoD5pCAAAAAAAAAAAAAAAAAAAArzfb9Ve9+RXqwt9v1V735FetzY+zCSnoALLoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB+hQHzSEAAAAAAAAAAAAAAAAAAABXm+36q978ivVhb7fqr3vyK9bmx9mElPQAWXQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD9CgPmkIAAAAAAAAAAAAAAAAAAACvN9v1V735FerC32/VXvfkV63Nj7MJKegAsugAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH6FAfNIQAAAAAAAAAAAAAAAAAAAFeb7fqr3vyK9BubH2YSU9ABZdAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP/9k='



    SET NOCOUNT ON;

    -- Create a temporary table
    CREATE TABLE #TempTable (
        StartDate VARCHAR(8),
        EndDate VARCHAR(8),
        EmployeeID VARCHAR(8),
        Sequence INT,
        AttendanceType VARCHAR(4),
        StartTime VARCHAR(4),
        StartLocation VARCHAR(100),
        EndTime VARCHAR(4),
        EndLocation VARCHAR(100),
        Notes VARCHAR(255),
        CreateBy VARCHAR(50),
        CreateDate VARCHAR(14),
        ChangeBy VARCHAR(50),
        ChangeDate VARCHAR(14)
    );

	DECLARE @CreateDate VARCHAR (50)=FORMAT(GETDATE(), 'yyyyMMddHHmmss')
	DECLARE @ChangeDate VARCHAR (50)=FORMAT(GETDATE(), 'yyyyMMddHHmmss')

    -- Insert the input parameters into the temporary table
    INSERT INTO #TempTable (StartDate, EndDate, EmployeeID, Sequence, AttendanceType, StartTime, StartLocation, EndTime, EndLocation, Notes, CreateBy, CreateDate, ChangeBy, ChangeDate)
    VALUES (@StartDate, @EndDate, @EmployeeID, 1, @AttendanceType, @StartTime, @StartLocation, @EndTime, @EndLocation, @Notes, @CreateBy, @CreateDate, @ChangeBy, @ChangeDate);

    -- Get the maximum value of AuditorFlag and increment it
    DECLARE @MaxAuditorFlag INT;
    SELECT @MaxAuditorFlag = ISNULL(MAX(CAST(AuditorFlag AS INT)), 0) + 1
    FROM PHRPA0019 Where EmployeeID = @EmployeeID

    
	DECLARE @TransactionName VARCHAR(20) = 'InsertTransaction';

BEGIN TRANSACTION @TransactionName;

BEGIN TRY
    -- Update data into PHRPA0019
    UPDATE PHRPA0019 SET EndTime = (SELECT EndTime from #TempTable) where StartDate=@StartDate and EndDate=@EndDate and EmployeeID=@EmployeeID and AttendanceType=@AttendanceType;
    UPDATE PHRPA0019 SET EndLocation = (SELECT EndLocation from #TempTable) where StartDate=@StartDate and EndDate=@EndDate and EmployeeID=@EmployeeID and AttendanceType=@AttendanceType;

    -- Get the ID for PHRPA0019 insert
    DECLARE @InsertedID VARCHAR(10);
    SELECT @InsertedID = SCOPE_IDENTITY();

    -- Insert data into PHRPA0068
    UPDATE PHRPA0068 SET FileDataClockOut = @filebase64 WHERE id = (select top(1)AuditorFlag from PHRPA0019 where StartDate=@StartDate and EndDate=@EndDate and EmployeeID=@EmployeeID and AttendanceType=@AttendanceType)

    COMMIT TRANSACTION @TransactionName;
END TRY
BEGIN CATCH
    -- Error occurred, rollback transaction
    ROLLBACK TRANSACTION @TransactionName;

	-- Drop the temporary table
    IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL
        DROP TABLE #TempTable;

    -- Optionally, raise the error or handle it as per your application logic
    THROW;
END CATCH;

-- Drop the temporary table if transaction succeeded (normally)
IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL
    DROP TABLE #TempTable;


	
  --select * from PHRPA0019 
  --where 
  --StartDate=@StartDate 
  --and EndDate=@EndDate 
  --and EmployeeID=@EmployeeID 
  --and AttendanceType=@AttendanceType