private bool CheckDuplicatePK(string key)
{
try
{
return(MongoDB.CollectionContainsKey(TableName, key));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public override string ValidateQuery()
{
if (TableUtils.IsTableReferenced(DatabaseName, TableName))
{
var MongoDB = new MongoDBAcess(DatabaseName);
ForeignKeyFiles = TableUtils.GetForeignKeyFiles(DatabaseName, TableName);
foreach (var foreignKey in ForeignKeyFiles)
{
if (MongoDB.CollectionContainsKey(foreignKey, RemovedKey))
{
// PK of the record is used as a FK in another table => error
var tableName = foreignKey.Split('_');
return(Responses.DELETE_RECORD_USED_AS_FK + tableName[1]);
}
}
}
return(Responses.DELETE_RECORD_SUCCESS);
}
