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);
}
