public void DeleteAllRecords(String RegistrationKey) { try { Logger.Information("In DeleteAllRecords"); customerNum = util.GetDentalOfficeID(RegistrationKey); if (customerNum == 0) { return; } //mobile web Patientms.DeleteAll(customerNum); Appointmentms.DeleteAll(customerNum); RxPatms.DeleteAll(customerNum); Providerms.DeleteAll(customerNum); Pharmacyms.DeleteAll(customerNum); Recallms.DeleteAll(customerNum); //pat portal LabPanelms.DeleteAll(customerNum); LabResultms.DeleteAll(customerNum); Medicationms.DeleteAll(customerNum); MedicationPatms.DeleteAll(customerNum); AllergyDefms.DeleteAll(customerNum); Allergyms.DeleteAll(customerNum); DiseaseDefms.DeleteAll(customerNum); Diseasems.DeleteAll(customerNum); ICD9ms.DeleteAll(customerNum); Statementms.DeleteAll(customerNum); Documentms.DeleteAll(customerNum); } catch (Exception ex) { Logger.LogError("IpAddress=" + HttpContext.Current.Request.UserHostAddress + " DentalOfficeID=" + customerNum, ex); throw new Exception("Exception in DeleteAllRecords"); } }