public static FileItem FindFileFromFileInfo(FileInfo item)
{
FileItem itemToReturn = new FileItem();
var SqlConnection = new SQLiteConnection("Data Source=" + DBLocation + "; Version=3");
SqlConnection.Open();
var sql = "Select * FROM FilesFound WHERE FileName = \"" + item.Name + "\" AND FileLocation = \"" + item.FullName + "\"";
var cmd = new SQLiteCommand(sql, SqlConnection);
cmd.ExecuteNonQuery();
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
itemToReturn = new FileItem { ID = Convert.ToInt32(reader["ID"].ToString()), FileLocation = reader["FileLocation"].ToString(), FileName = reader["FileName"].ToString(), DisplayName = reader["DisplayName"].ToString(), ExtensionID = Convert.ToInt32(reader["ExtensionID"].ToString()), Type = (FileType)Convert.ToInt32(reader["Type"].ToString()), LastUsed = Convert.ToDateTime(reader["LastUsed"].ToString()), TotalUsed = Convert.ToInt32(reader["TotalUsed"].ToString()) };
}
SqlConnection.Close();
return itemToReturn;
}
public static bool InsertIntoFilesTable(FileItem item)
{
try
{
var SqlConnection = new SQLiteConnection("Data Source=" + DBLocation + "; Version=3");
SqlConnection.Open();
var sql = "INSERT INTO FilesFound(FileName,ExtensionID,Type,DisplayName,LastUsed,TotalUsed,FileLocation) VALUES ('" + item.FileName + "','" + item.ExtensionID + "','" + (int)item.Type + "','" + item.DisplayName + "','" + item.LastUsed + "','" + item.TotalUsed + "','" + item.FileLocation + "')";
SQLiteCommand cmd = new SQLiteCommand(sql, SqlConnection);
cmd = new SQLiteCommand(sql, SqlConnection);
cmd.ExecuteNonQuery();
SqlConnection.Close();
return true;
}
catch (Exception e)
{
return false;
throw e;
}
}