Track application Usage - C# .Net 2.0

Question

I asked this question yesterday and got a great response/code example. The only problem is that I forgot to mention that I am forced to work with the .Net Framework 2.0 and can't use the List.Select ( I assume the linq namespace). Does anyone have a good work around for List.Select seen below:

class Program
{
    struct ProcessStartTimePair
    {
        public Process Process { get; set; }
        public DateTime StartTime { get; set; }
        public DateTime ExitTime
        {
            get
            {
                return DateTime.Now; // approximate value
            }
        }
        public ProcessStartTimePair(Process p) : this()
        {
            Process = p;
            try
            {
                StartTime = p.StartTime;
            }
            catch (System.ComponentModel.Win32Exception)
            {
                StartTime = DateTime.Now; // approximate value
            }
        }
    }
    static void Main(string[] args)
    {
        SqlConnection cnn = new SqlConnection(@"Data Source=XXXXXX;Initial Catalog=XXXXXX;User ID=XXXX;Password=XXXX");
        List<ProcessStartTimePair> knownProcesses = new List<ProcessStartTimePair>();
        while (true)
        {
            foreach (Process p in Process.GetProcesses())
            {
                if (!knownProcesses.Select(x => x.Process.Id).Contains(p.Id))
                {
                    knownProcesses.Add(new ProcessStartTimePair(p));
                    //Console.WriteLine("Detected new process: " + p.ProcessName);
                }
            }
            for (int i = 0; i < knownProcesses.Count; i++)
            {
                ProcessStartTimePair pair = knownProcesses[i];
                try
                {
                    if (pair.Process.HasExited)
                    {
                        Console.WriteLine(pair.Process.ProcessName + " has exited (alive from {0} to {1}).", pair.StartTime.ToString(), pair.ExitTime.ToString());
                        knownProcesses.Remove(pair);
                        i--; // List was modified, 1 item less
                        // TODO: Store in the info in the database
                        String sql = "insert into procs (machine,login,process,start_time,end_time) ";
                        sql += "values ('" + Environment.MachineName + "','" + System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString().Split('\\')[1] + "','" + pair.Process.ProcessName + "','" + pair.StartTime.ToString() + "','" + pair.ExitTime.ToString() + "');";
                        SqlCommand cmd = new SqlCommand(sql, cnn);
                        try
                        {
                            cnn.Open();
                            cmd.ExecuteNonQuery();
                        }
                        catch (Exception ex)
                        {
                            //Console.WriteLine(ex.Message);
                        }
                        finally
                        {
                            cnn.Close();
                        }
                    }
                }
                catch (System.ComponentModel.Win32Exception)
                {
                    // Would have to check whether the process still exists in Process.GetProcesses().
                    // The process probably is a system process.
                }
            }
            //Console.WriteLine();
            System.Threading.Thread.Sleep(5000);
        }
    }
}

Answer 1

I just edited my answer.

Answer 2

I'm not sure the datatype of Id. I'll assume an int, you get the idea:

List<int> idList = new List<int>();

foreach(ProcessStartTimePair proc in knownProcesses)
{
    idList.Add(proc.Process.Id);
}

if(idList.Contains(p.Id))
{
    // ...
}

You just have to do the work of getting the list of IDs yourself.

Also, it's generally a better idea to edit your original question, and leave comments on the answers of others.

Answer 3

Try this:

if(!knownProcesses.Exists(x => x.Process.Id == p.Id))

Or, if you are using Visual Studio 2005 (not 2008),

if(!knownProcesses.Exists(delegate(ProcessStartTimePair x) { return x.Process.Id == p.Id; }))