Cacher is the code snippet organizer for pro developers

SYNC RoleMaster
SYNC AuditStatusMaster
New Table UserRoleXSection
New Table AuditSectionStatusMaster

SYNC AuditSectionStatusMaster

--Update AuditSection table Status = Audit(Accepted)/Audit(Declined)
--Update all audits which are in Accepted/Declined status as Acknowledged
--Delete AuditStatus 8 Section Feedback Sent Ack Pending,	9	Section Accepted,	10	Section Declined from AuditStatusMaster
------------------------------------------------------------------------------------------------------------------------

SELECT *
FROM dbo.AuditStatusMaster asm --WHERE asm.IsActive = 0

SELECT *
FROM dbo.AuditSectionStatusMaster assm

UPDATE dbo.AuditSectionDetail
SET dbo.AuditSectionDetail.AuditSectionStatusId = 1 --Section Auditing In Progress	SAINP
WHERE dbo.AuditSectionDetail.AuditId IN (
		SELECT a.Id
		FROM dbo.Audit a
		WHERE a.AuditStatusId = 2
		) --2	Auditing In Progress

UPDATE dbo.AuditSectionDetail
SET dbo.AuditSectionDetail.AuditSectionStatusId = 2 --Section Auditing Complete
WHERE dbo.AuditSectionDetail.AuditId IN (
		SELECT a.Id
		FROM dbo.Audit a
		WHERE a.AuditStatusId = 6
		) --6	Auditing Completed

UPDATE dbo.AuditSectionDetail
SET dbo.AuditSectionDetail.AuditSectionStatusId = 3 --Section Coaching Complete
WHERE dbo.AuditSectionDetail.AuditId IN (
		SELECT a.Id
		FROM dbo.Audit a
		WHERE a.AuditStatusId = 7
		) --7	Coaching Completed Feedback Pending

UPDATE dbo.AuditSectionDetail
SET dbo.AuditSectionDetail.AuditSectionStatusId = 3 --Section Coaching Complete
WHERE dbo.AuditSectionDetail.AuditId IN (
		SELECT a.Id
		FROM dbo.Audit a
		WHERE a.AuditStatusId = 8
		) --8	Feedback Sent Ack Pending


UPDATE dbo.AuditSectionDetail
SET dbo.AuditSectionDetail.AuditSectionStatusId = 5	--Section Accepted
WHERE dbo.AuditSectionDetail.AuditId IN (
		SELECT a.Id
		FROM dbo.Audit a
		WHERE a.AuditStatusId = 9
		) --9	Accepted


UPDATE dbo.AuditSectionDetail
SET dbo.AuditSectionDetail.AuditSectionStatusId = 6	--Section Declined
WHERE dbo.AuditSectionDetail.AuditId IN (
		SELECT a.Id
		FROM dbo.Audit a
		WHERE a.AuditStatusId = 10
		) --10	Declined


SELECT * FROM dbo.AuditSectionDetail asd WHERE asd.AuditSectionStatusId IS NULL

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


UPDATE dbo.Audit
SET
    dbo.Audit.AuditStatusId = 12	--Coaching In Progress
	WHERE dbo.Audit.AuditStatusId = 8	--Section Feedback Sent Ack Pending

UPDATE dbo.Audit
SET
    dbo.Audit.AuditStatusId = 11	--Acknowledged
	WHERE dbo.Audit.AuditStatusId = 9-- Accepted

UPDATE dbo.Audit
SET
    dbo.Audit.AuditStatusId = 11	--Acknowledged
	WHERE dbo.Audit.AuditStatusId = 10	--Declined
	
DELETE FROM dbo.AuditStatusMaster WHERE dbo.AuditStatusMaster.IsActive = 0
------------------------------------------------------------------------