USE [RADIOLOGY]
GO
/****** Object:  StoredProcedure [dbo].[Radio_UserPassword]    Script Date: 1/16/2024 1:19:53 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
--ALTER PROCEDURE [dbo].[Radio_UserPassword]
	@EmployeeID varchar(10),
	@Password varchar(25),
	@DepartmentID varchar(4)
AS

select tbpass.employeeid as EmployeeCode,tbpass.Right_Code1,tbpass.Right_Code2,tbpass.departmentid as DepartmentCode,
tbpass.Initial,tbpass.originaldepartment as ODept,tbpass.Position,tbpass.firstname + ' ' + tbpass.lastname as  EmployeeName
from password..tbpasswordmain tbpass
	--left outer join Radiology..tbRadioUserRights radpass on tbpass.EmployeeId = radpass.EmployeeId
where tbpass.employeeid = @EmployeeID and tbpass.password = @Password and 
(tbpass.departmentid = '00' or tbpass.departmentid = @DepartmentID)
--and isnull(laboratory.dbo.fn_LabCanAccess2(@EmployeeID,getdate(), @RightCode),0) = 1

exec Radio_UserPassword '1033','5BDE5ED34DD0','00'

select tbpass.DepartmentID,tbpass.employeeid as EmployeeCode,tbpass.Right_Code1,tbpass.Right_Code2,tbpass.departmentid as DepartmentCode,
tbpass.Initial,tbpass.originaldepartment as ODept,tbpass.Position,tbpass.firstname + ' ' + tbpass.lastname as  EmployeeName
from password..tbpasswordmain tbpass where EmployeeID = '1033'

------------------------

USE [RADIOLOGY]
GO
/****** Object:  StoredProcedure [dbo].[spRadio_SelectRadTech]    Script Date: 1/16/2024 11:23:27 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spRadio_SelectRadTech]--''

@SearchCriteria varchar(50)

as

select distinct A.EmployeeID, 
	A.LastName + ', ' + A.FirstName + ' ' + A.MiddleName [EmployeeName]
    From Password..tbPasswordMain A
	left outer join Radiology..tbRadioRadTech B on A.EmployeeID = B.EmployeeID
where (A.EmployeeID like @SearchCriteria + '%'  or A.LastName like @SearchCriteria + '%')
		and A.Position like '%RADTECH%' --and a.DepartmentID in ('11','13','23')
order by [EmployeeName]

--select distinct A.DoctorID [DoctorID], 
--	A.LastName + ', ' + A.FirstName + ' ' + A.MiddleName [DoctorName]
--    From Build_File..tbCoDoctor A 
--	WHERE Sonologist = 'Y' AND (A.EmployeeID like @SearchCriteria + '%'  or A.LastName like @SearchCriteria + '%')
--order by [DoctorName]



--select distinct EmployeeID, 
--	LastName + ', ' + FirstName + ' ' + MiddleName [EmployeeName]
--From RADIOLOGY..tbRadioRadTech
--where (EmployeeID like @SearchCriteria + '%'  or LastName like @SearchCriteria + '%')
--order by [EmployeeName]