C#

//The service
private FileWatcher fw; 
public MyService()
{
InitializeComponent();
}

protected override void OnStart(string[] args)
{
fw = new FileWatcher();
fw.Start();
}

protected override void OnStop()
{
fw.Stop(); 
}

//The class that is beeing initialized

public FileWatcher()
{
_archiveFolder = "D:\\Archive\\";
_errorFolder = "D:\\Error\\";
_fileWatcherInputFolder = "C:\\Input\\";
_processFolder = "C:\\Process\\";

_archiveFolder = "C:\\PMI\\Archive";
_errorFolder = "C:\\PMI\\Error\\";
_fileWatcherInputFolder = "C:\\PMI\\Input";
_processFolder = "C:\\PMI\\Process";
_PMIRepository = new PMIRepository();
_ParserController = new ParserController(_archiveFolder, _errorFolder, _fileWatcherInputFolder, _processFolder);
}

public void Start()
{

try
{

// Log.Information("Starting FileWatcher " + DateTime.Now.ToString());
if (!Directory.Exists(_archiveFolder))
Directory.CreateDirectory(_archiveFolder);
if (!Directory.Exists(_errorFolder))
Directory.CreateDirectory(_errorFolder);
_fileCheckTimerBatch = new System.Timers.Timer { AutoReset = false, Interval = 1000 };
_fileCheckTimerBatch.Elapsed += FileCheckTimer_Batch_Elapsed;
_fileCheckTimerBatch.Start();

}
catch (Exception ex)
{
}

}
public void Stop()
{
_fileCheckTimerBatch.Stop(); 
}

try
{
SqlConnection myconn = new SqlConnection("User id = a; password = b; server=c;" database=e; connection timeout=30");
SqlCommand insp = new SqlCommand("INSERT INTO dbo.tbconn(Tstamp, SysID, PID, PName)VALUES (@Tstamp, @SysID, @PID, @PName)", myconn);

insp.Parameters.Add("@Tstamp", SqlDbType.DateTime);
insp.Parameters.Add("@SysID", SqlDbType.Int);
insp.Parameters.Add("@PID", SqlDbType.Int);
insp.Parameters.Add("@PName", SqlDbType.NVarChar, 50);

DateTime Tstamp = DateTime.Now;
Process[] processlist = Process.GetProcesses();
foreach (Process p in processlist)
    {
        insp.Parameters["@Tstamp"].Value = Tstamp;
        insp.Parameters["@SysID"].Value = 100;
        insp.Parameters["@PID"].Value = p.Id;
        insp.Parameters["@PName"].Value = p.ProcessName; 
        
        ProcMon.Open();
        insp.ExecuteNonQuery();
        ProcMon.Close();
}
}
catch (Exception procinfo)
{

try
{
SqlConnection myconn = new SqlConnection("User id = a; password = b; server=c;" database=e; connection timeout=30");
SqlCommand insp = new SqlCommand("INSERT INTO dbo.tbconn(Tstamp, SysID, PID, PName, PExe, PCPU, PMem)VALUES (@Tstamp, @SysID, @PID, @PName, @PExe, @PCPU, @PMem)", myconn);

insp.Parameters.Add("@Tstamp", SqlDbType.DateTime);
insp.Parameters.Add("@SysID", SqlDbType.Int);
insp.Parameters.Add("@PID", SqlDbType.Int);
insp.Parameters.Add("@PName", SqlDbType.NVarChar, 50);
insp.Parameters.Add("@PExe", SqlDbType.NVarChar, -1);
insp.Parameters.Add("@PCPU", SqlDbType.Int);
insp.Parameters.Add("@PMem", SqlDbType.Int)

DateTime Tstamp = DateTime.Now;
Process[] processlist = Process.GetProcesses();
foreach (Process p in processlist)
    {
        insp.Parameters["@Tstamp"].Value = Tstamp;
        insp.Parameters["@SysID"].Value = 100;
        insp.Parameters["@PID"].Value = p.Id;
        insp.Parameters["@PName"].Value = p.ProcessName;
        insp.Parameters["@PExe"].Value = p.MainModule.FileName; //Error 1
        insp.Parameters["@PCPU"].Value = p.TotalProcessorTime;  //Error 2
        insp.Parameters["@PMem"].Value = p.VirtualMemorySize64; //Error 3

        
        ProcMon.Open();
        insp.ExecuteNonQuery();
        ProcMon.Close();
}
}
catch (Exception procinfo)
{