private static int CleanSQLEntries(List <AttachScanInfo> missingSQLDirs)
{
if (missingSQLDirs.Count > 0)
{
DeviceAttachmentsCols DeviceTable = new DeviceAttachmentsCols();
SibiAttachmentsCols SibiTable = new SibiAttachmentsCols();
int deletions = 0;
foreach (var sqlItem in missingSQLDirs)
{
if (!CheckForPrimaryItem(sqlItem.FKey))
{
var DeviceRows = DBFactory.GetDatabase().ExecuteNonQuery("DELETE FROM " + DeviceTable.TableName + " WHERE " + DeviceTable.FKey + "='" + sqlItem.FKey + "'");
if (DeviceRows > 0)
{
deletions += DeviceRows;
Logging.Logger("Deleted " + DeviceRows.ToString() + " Device SQL Entries For: " + sqlItem.FKey);
}
var SibiRows = DBFactory.GetDatabase().ExecuteNonQuery("DELETE FROM " + SibiTable.TableName + " WHERE " + SibiTable.FKey + "='" + sqlItem.FKey + "'");
if (SibiRows > 0)
{
deletions += SibiRows;
Logging.Logger("Deleted " + SibiRows.ToString() + " Sibi SQL Entries For: " + sqlItem.FKey);
}
}
}
return(deletions);
}
return(0);
}
private static int CleanSQLFiles(List <AttachScanInfo> missingSQLFiles)
{
if (missingSQLFiles.Count > 0)
{
DeviceAttachmentsCols DeviceTable = new DeviceAttachmentsCols();
SibiAttachmentsCols SibiTable = new SibiAttachmentsCols();
int deletions = 0;
foreach (var sqlItem in missingSQLFiles)
{
var DeviceRows = DBFactory.GetDatabase().ExecuteNonQuery("DELETE FROM " + DeviceTable.TableName + " WHERE " + DeviceTable.FileGuid + "='" + sqlItem.FileGuid + "'");
if (DeviceRows > 0)
{
deletions += DeviceRows;
Logging.Logger("Deleted Device SQL File: " + sqlItem.FKey + "/" + sqlItem.FileGuid);
}
var SibiRows = DBFactory.GetDatabase().ExecuteNonQuery("DELETE FROM " + SibiTable.TableName + " WHERE " + SibiTable.FileGuid + "='" + sqlItem.FileGuid + "'");
if (SibiRows > 0)
{
deletions += SibiRows;
Logging.Logger("Deleted Sibi SQL File: " + sqlItem.FKey + "/" + sqlItem.FileGuid);
}
}
return(deletions);
}
return(0);
}
private static List <AttachScanInfo> ListSQLFiles()
{
DeviceAttachmentsCols DeviceTable = new DeviceAttachmentsCols();
SibiAttachmentsCols SibiTable = new SibiAttachmentsCols();
List <AttachScanInfo> SQLFileList = new List <AttachScanInfo>();
var devFiles = DBFactory.GetDatabase().DataTableFromQueryString("SELECT * FROM " + DeviceTable.TableName);
foreach (DataRow file in devFiles.Rows)
{
SQLFileList.Add(new AttachScanInfo(file[DeviceTable.FKey].ToString(), file[DeviceTable.FileGuid].ToString()));
}
var sibiFiles = DBFactory.GetDatabase().DataTableFromQueryString("SELECT * FROM " + SibiTable.TableName);
foreach (DataRow file in sibiFiles.Rows)
{
SQLFileList.Add(new AttachScanInfo(file[SibiTable.FKey].ToString(), file[SibiTable.FileGuid].ToString()));
}
return(SQLFileList);
}
