public void CleanIQCareTestPatients(int testIqPatientId)
{
string sql =
$@"
delete from iqcare.[dbo].dtl_fb_DisabilityHTC where Ptn_pk= {testIqPatientId};
delete from iqcare.[dbo].dtl_fb_HTCReferredTO where Ptn_pk= {testIqPatientId};
delete from iqcare.[dbo].dtl_fb_InformationSourceHTC where Ptn_pk= {testIqPatientId};
delete from iqcare.[dbo].dtl_fb_MARPsHTC where Ptn_pk= {testIqPatientId};
delete from iqcare.[dbo].dtl_fb_ServicesGivenHTC where Ptn_pk= {testIqPatientId};
delete from iqcare.[dbo].dtl_fb_VisitReasonHTC where Ptn_pk= {testIqPatientId};
delete from iqcare.[dbo].[DTL_FBCUSTOMFIELD_KNH_HTC_Form] where Ptn_pk= {testIqPatientId};
delete from dtl_PatientContacts where Ptn_Pk= {testIqPatientId};
delete from [DTL_PATIENTHOUSEHOLDINFO] where Ptn_Pk= {testIqPatientId};
delete from [DTL_RURALRESIDENCE] where Ptn_Pk= {testIqPatientId};
delete from [DTL_URBANRESIDENCE] where Ptn_Pk= {testIqPatientId};
delete from [DTL_PATIENTHIVPREVCAREENROLLMENT] where Ptn_Pk= {testIqPatientId};
delete from [DTL_PATIENTGUARANTOR] where Ptn_Pk= {testIqPatientId};
delete from [DTL_PATIENTDEPOSITS] where Ptn_Pk= {testIqPatientId};
delete from [DTL_PATIENTINTERVIEWER] where Ptn_Pk= {testIqPatientId};
delete from [DTL_FBCUSTOMFIELD_Patient_Registration] where Ptn_Pk= {testIqPatientId};
delete from ord_Visit where Ptn_Pk= {testIqPatientId};
delete from mst_Patient where Ptn_Pk= {testIqPatientId};
";
if (testIqPatientId > -1)
{
_emrRepository.ExecuteCommand(sql);
}
}
