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); }