public static void DeleteRecordByOrganisationIdStandardCode(string organisationId, int standardCode) { var idToDelete = SqlStringService.ConvertStringToSqlValueString(organisationId); var sql = $@"DELETE from Organisations where [EndPointAssessorOrganisationId] = {idToDelete} and StandardCode = {standardCode}"; DatabaseService.Execute(sql); }
public static void DeleteRecord(Guid id) { var idToDelete = SqlStringService.ConvertStringToSqlValueString(id.ToString()); var sql = $@"DELETE from Organisations where id = {idToDelete}"; DatabaseService.Execute(sql); }
public static void DeleteRecord(Guid certificateId) { var idToDelete = SqlStringService.ConvertGuidToSqlValueString(certificateId); var sql = $@"DELETE from CertificateLogs where [CertificateId] = {idToDelete}"; DatabaseService.Execute(sql); }
public static void DeleteRecordByUserName(string username) { var usernameToDelete = SqlStringService.ConvertStringToSqlValueString(username); var sql = $@"DELETE from Contacts where [Username] = {usernameToDelete}"; DatabaseService.Execute(sql); }
public static void DeleteRecord(int orgStandardId, string standardUId) { var standardUIdToDelete = SqlStringService.ConvertStringToSqlValueString(standardUId); var sql = $@"DELETE from OrganisationStandardVersion where OrganisationStandardId = {orgStandardId} and StandardUId = {standardUIdToDelete}"; DatabaseService.Execute(sql); }