private bool DeleteGroupEntryFromXrefTable(int groupID, GroupDeleteTableType groupDeleteTableType)
{
bool isDeleted = false;
int count = -1;
int countDeleted = -1;
string tableName = GetTableNameForGroup(groupDeleteTableType);
string sql = "";
Logger.Log("Start deleting records from table '" + tableName + "' for group id " + groupID);
try {
DbInfo = new DatabaseWrapper(Lcf);
DbInfo.Connect();
Logger.Log("Getting records from table '" + tableName + "' for group id " + groupID);
count = GetRecordsForAGroupFromXref(groupID, tableName);
if (count > 0)
{
Logger.Log("Start deleting records from '" + tableName + "' for group id = " + groupID);
sql = GroupQB.GetDelteGroupSql(groupID, tableName, false);
bool success = false;
countDeleted = DbInfo.ExecuteSQL(sql, ref success);
if (count == countDeleted)
{
Logger.Log("Successfully deleted " + count + " records from " + tableName + " for group id = " + groupID);
isDeleted = true;
}
else
{
Logger.Log("Failed to delte " + count + " records from " + tableName + " for group id = " + groupID);
}
}
else if (count == 0)
{
Logger.Log("No records was found in table '" + tableName + "' for group id " + groupID);
return(true);
}
} catch (Exception ex) {
Logger.Log("Error deleting records from table '" + tableName + "' for group id " + groupID + " at: " + ex);
return(false);
} finally {
if (isDeleted)
{
SecureContentWrapper.SecurityHasBeenModifiedThisSession = true;
}
if (DbInfo != null)
{
DbInfo.Disconnect();
}
}
return(isDeleted);
}
private bool DeleteGroupFromMain(int groupID)
{
bool isDeleted = false;
string sql = "";
string tableName = "";
try {
Logger.Log("Trying to delete the group entry from main table '" + GroupQB.GROUP_TBLE_NAME + "'");
tableName = GetTableNameForGroup(GroupDeleteTableType.Main);
sql = GroupQB.GetDelteGroupSql(groupID, tableName, true);
DbInfo = new DatabaseWrapper(Lcf);
DbInfo.Connect();
bool success = false;
int numChanged = DbInfo.ExecuteSQL(sql, ref success);
if (numChanged == 0)
{
isDeleted = false;
}
else
{
isDeleted = true;
}
} catch (Exception ex) {
Logger.LogError(5, "Error deleting the group entry from main table '" + GroupQB.GROUP_TBLE_NAME + "' at: " + ex);
return(false);
} finally {
if (isDeleted)
{
SecureContentWrapper.SecurityHasBeenModifiedThisSession = true;
}
if (DbInfo != null)
{
DbInfo.Disconnect();
}
}
return(isDeleted);
}