USE [EmployeeDB] GO /****** Object: StoredProcedure [dbo].[spMember] Script Date: 6/23/2022 10:29:54 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[spMember] ( @WorkerID INT = NULL, @FirstName VARCHAR(50) = NULL, @Worker VARCHAR(50) = NULL, @Cnic VARCHAR(50) = NULL, @CardNumber VARCHAR(50) = NULL, @FlatNumber VARCHAR(50) = NULL, @Designation VARCHAR(50) = NULL, @Checkin datetime, @Checkout datetime, @ActionType VARCHAR(25) ) AS BEGIN IF @ActionType = 'SaveData' BEGIN IF NOT EXISTS (SELECT * FROM Member WHERE WorkerID=@WorkerID) BEGIN INSERT INTO Member (FirstName,Worker,Cnic,CardNumber,FlatNumber,Designation,Checkin,Checkout) VALUES (@FirstName,@Worker,@Cnic,@CardNumber,@FlatNumber,@Designation,@Checkin,@Checkout) END ELSE BEGIN UPDATE Member SET Checkout=@Checkout WHERE WorkerID=@WorkerID END END IF @ActionType = 'DeleteData' BEGIN DELETE Member WHERE WorkerID=@WorkerID END IF @ActionType = 'FetchData' BEGIN SELECT WorkerID AS Sn,FirstName,Worker,Cnic,CardNumber,FlatNumber,Designation,CAST (GETDATE() AS datetime) AS Checkin,CAST (GETDATE() AS datetime) AS Checkout FROM Member END IF @ActionType = 'FetchRecord' BEGIN SELECT WorkerID AS Sn,FirstName,Worker,Cnic,CardNumber,FlatNumber,Designation,CAST (GETDATE() AS datetime) AS Checkin,CAST (GETDATE() AS datetime) AS Checkout FROM Member WHERE WorkerID=@WorkerID END END