/// <summary>
///
/// </summary>
/// <param name="file"></param>
/// <returns></returns>
private bool Include(FileInfo file)
{
if (config.BackupType == BackupTypes.All)
{
return(IncludeFiletype(file));
}
if (!IncludeFiletype(file))
{
return(false);
}
CMD.ClearParameters();
CMD.CommandText = "SELECT ModifiedDate FROM BackupFiles WHERE Filename = @Filename";
CMD.AddWithValue("@Filename", file.FullName);
CMD.ExecuteReader();
if (CMD.Read())
{
DateTime md = CMD.GetDateTime(0);
if (file.LastWriteTime > md)
{
CMD.CommandText = "UPDATE BackupFiles SET ModifiedDate = @ModifiedDate WHERE Filename = @Filename";
CMD.AddWithValue("@ModifiedDate", file.LastWriteTime);
CMD.ExecuteNonQuery();
return(true);
}
return(false);
}
CMD.ClearParameters();
CMD.CommandText = "INSERT INTO BackupFiles( Filename, ModifiedDate ) VALUES( @Filename, @ModifiedDate )";
CMD.AddWithValue("@Filename", file.FullName);
CMD.AddWithValue("@ModifiedDate", file.LastWriteTime);
CMD.ExecuteNonQuery();
return(true);
}
public static List <string> GetFileInfo(IEnumerable <string> lFileHash, Bit9ReturnValues lBit9ReturnValues)
{
var lBit9Info = new List <string>();
var oBit9Return = new object[69];
var sAcekDecode = Object_Fido_Configs.GetAsString("fido.detectors.bit9.acek", null);
sAcekDecode = Aes_Crypto.DecryptStringAES(sAcekDecode, "1");
var sUserID = Aes_Crypto.DecryptStringAES(Object_Fido_Configs.GetAsString("fido.detectors.bit9.userid", null), sAcekDecode);
var sPwd = Aes_Crypto.DecryptStringAES(Object_Fido_Configs.GetAsString("fido.detectors.bit9.pwd", null), sAcekDecode);
var sBit9Server = Object_Fido_Configs.GetAsString("fido.detectors.bit9.server", null);
var sDb = Object_Fido_Configs.GetAsString("fido.detectors.bit9.db", null);
try
{
//todo: take connection string and encrypt to put in XML config
var vConnection = new SqlConnection("user id=" + sUserID + ";password="******";Server=" + sBit9Server + ",1433;Integrated Security=sspi;Database=" + sDb + ";connection timeout=60");
if (lFileHash != null)
{
//todo: SQL injection. Store query in database and fill variables when retrieving
foreach (var CMD in lFileHash.Select(sFileHash => "SELECT * FROM [das].[dbo].[Fido_FileInstanceInfo] WHERE MD5 = '" + sFileHash + "'").Select(sQuery => new SqlCommand(sQuery, vConnection)))
{
CMD.CommandType = CommandType.Text;
vConnection.Open();
using (var objReader = CMD.ExecuteReader())
{
if (objReader.HasRows)
{
while (objReader.Read())
{
var quant = objReader.GetSqlValues(oBit9Return);
if (!oBit9Return.Any())
{
continue;
}
lBit9Info.AddRange(oBit9Return.Select(item => item.ToString()));
}
}
}
vConnection.Close();
}
}
else if (lBit9ReturnValues != null)
{
//todo: SQL injection. Store query in database and fill values when retrieving
var sQuery = "SELECT * FROM [das].[dbo].[Fido_FileInstanceInfo] WHERE FILE_NAME = '" + lBit9ReturnValues.FileName.ToLower() + "' AND Path_Name = '" + lBit9ReturnValues.FilePath.ToLower() + "' AND Computer_Name = '" + lBit9ReturnValues.HostName + "'";
var CMD = new SqlCommand(sQuery, vConnection)
{
CommandType = CommandType.Text
};
vConnection.Open();
using (var objReader = CMD.ExecuteReader())
{
if (objReader.HasRows)
{
while (objReader.Read())
{
var quant = objReader.GetSqlValues(oBit9Return);
if (!oBit9Return.Any())
{
continue;
}
lBit9Info.AddRange(oBit9Return.Select(item => item.ToString()));
}
}
}
vConnection.Close();
}
//if no count then no hash information exists
if (lBit9Info.Count != 0)
{
}
}
catch (Exception e)
{
Fido_EventHandler.SendEmail("Fido Error", "Fido Failed: {0} Exception caught retrieving file information from Bit9:" + e);
}
return(lBit9Info);
}