public List <FileDataEntity> GetFDEList()
{
string sqlCmd = "SELECT Action, PathName, OldPathName, TimeAffected FROM Data ORDER BY TimeAffected DESC;";
List <FileDataEntity> fdeList = new List <FileDataEntity>();
try
{
cmd.CommandText = sqlCmd;
conn.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
FileDataEntity fde = new FileDataEntity();
fde.Action = rdr["Action"].ToString();
fde.PathName = rdr["PathName"].ToString();
fde.OldPathName = rdr["OldPathName"].ToString();
fde.TimeAffected = (DateTime)rdr["TimeAffected"];
fdeList.Add(fde);
}
}
catch (Exception ex)
{
Logger.Log("Exception: " + ex.Message);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(fdeList);
}
public void AddFileData(FileDataEntity fde)
{
string sqlCmd = "INSERT INTO Data (Action, PathName, OldPathName, TimeAffected) "
+ "VALUES ('"
+ fde.Action + "', '"
+ fde.PathName + "', '"
+ fde.OldPathName + "', '"
+ fde.TimeAffected.ToString() + "');";
try
{
cmd.CommandText = sqlCmd;
conn.Open();
int result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Logger.Log("Exception: " + ex.Message);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
void fsw_Created(object sender, FileSystemEventArgs e)
{
FileDataEntity fde = new FileDataEntity();
fde.Action = "Create";
fde.PathName = e.FullPath;
fde.OldPathName = "";
fde.TimeAffected = DateTime.UtcNow;
dal.AddFileData(fde);
}
void fsw_Renamed(object sender, RenamedEventArgs e)
{
FileDataEntity fde = new FileDataEntity();
fde.Action = "Rename";
fde.PathName = e.FullPath;
fde.OldPathName = e.OldFullPath;
fde.TimeAffected = DateTime.UtcNow;
dal.AddFileData(fde);
}
