C#

var  varGoodTransCount = (from t in rData.Trans
                           join iw in rData.Ibooks on t.Ibook_ID equals iw.Ibook_ID
                           join ip in rData.IPacks on iw.PID equals ip.PID
                           where ip.TNum == SPkgID 
                           group ip by ip.TNum into g
                           select new { TNum = g.Key, Frequency = g.Count() }).FirstOrDefault();

Timestamp(s),    linkNo,   ......... NOx, PM10, CO2,
27000,           10,    .....         0.4,  1.2,  2.0
27000,           12,    .....         0.3,  1.4   3.0
27010,           10,    .....         0.4,  1.2,  2.0
27010,           12,    .....         0.3,  1.4   3.0
27020,           10,    .....         0.4,  1.2,  2.0
27020,           12,    .....         0.3,  1.4   3.0
.......
</pre>

The problem i'm trying to solve is to aggregate these data into 5 minutes interval and sum up all the pollutants (i.e. NOX, PM1O and CO2) on each link, the final results i want to get is:
<pre lang="xml">
TimeSlot,    linkNo,   ......... SumNOx, SumPM10, SumCO2,
27000,           10,    .....         1.2,  3.6,  6.0
27000,           12,    .....         0.3,  4.2   9.0
27300,           10,    .....         xx,  xx,  xx
27600,           12,    .....         xx,  xx,   xx
.......
<pre lang="c#"><

    public partial class FormMain : Form
    {
        private double TimeSlotFunction(double SimulationTime)
        {
            double Time = 0;
            for (int i = 1; i <= 24; i++)
            {
                double StartTime = 27000 + 300 * (i - 1);
                double EndTime = StartTime + 300 * i;
                if (StartTime < SimulationTime && SimulationTime <= EndTime)
                {

                    Time = StartTime;
                    break;
                }

            }
            return Time;
        }

        private class LinkData
        {
            public string LinkName;
            public List<double> SimTime = new List<double>();
            public List<double> timeSlot = new List<double>();
            public List<double> NOx = new List<double>();
            public List<double> PM10 = new List<double>();
            public List<double> TotalCarbon = new List<double>();
            public double SumNOx;
            public double SumPM10;
            public double SumTotalCarbon;
            public double SumCO2;
        }

            foreach (string[] row in parsedData)
            {
                Entries.Add(row);
            }
/********Compute NOX, PM10, TotalCarbon for each link***********/

            var LinkDict = new Dictionary<string, LinkData>();
            for (int index = 1; index < Entries.Count; index++)
            {
                var row = Entries[index];
                if (!LinkDict.ContainsKey(row[1]))
                {
                    var newLink = new LinkData { LinkName = row[1] };
                    LinkDict.Add(row[1], newLink);
                }

                LinkDict[row[1]].SimTime.Add(Convert.ToDouble((row[0])));
                LinkDict[row[1]].NOx.Add(Convert.ToDouble((row[19])));
                LinkDict[row[1]].PM10.Add(Convert.ToDouble((row[20])));
                LinkDict[row[1]].TotalCarbon.Add(Convert.ToSingle((row[21])));
            }

            foreach (var linkValue in LinkDict.Values)
                linkValue.SumNOx = linkValue.NOx.Sum();
            foreach (var linkValue in LinkDict.Values)
                linkValue.SumPM10 = linkValue.PM10.Sum();
            foreach (var linkValue in LinkDict.Values)
                linkValue.SumTotalCarbon = linkValue.TotalCarbon.Sum();
            foreach (var linkValue in LinkDict.Values)

            using (var sw = new StreamWriter(@"D:\Work\C#\my project\my project\AlteredData.csv"))
            {

                foreach (var linkValue in LinkDict.Values)
                {
                    var sb = new StringBuilder();
                    //sb.Append(TimeSlotFunction(linkValue.SimTime.ToString());
                    //sb.Append(",");
                    sb.Append(linkValue.LinkName);
                    sb.Append(",");
                    sb.Append(linkValue.SumNOx.ToString());
                    sb.Append(",");
                    sb.Append(linkValue.SumPM10.ToString());
                    sb.Append(",");
                    sb.Append(linkValue.SumTotalCarbon.ToString());
                    sb.Append(",");
                    sb.Append(linkValue.SumCO2.ToString());
                    sb.Append(",");
                    sw.WriteLine(sb.ToString());
                }

            }
        }

var fdrPkg = (from a in rData.ails where a.PID == S).

FrmRequestPwd.Show(true, "Solicite uma senha ao seu representante!");

public partial class FrmRequestPwd : Form
{
    private FrmRequestPwd()
    {
        InitializeComponent();
    }

    public static void Show(bool isError, string msg)
    {
        using (FrmRequestPwd frm = new FrmRequestPwd())
        {
            frm.lblMsg.Text = msg;
            frm.Text = isError ? "Erro" : "Aviso";
            frm.txtSerialHD.Text = Kernel32Managed.GetVolumeSerial('C');
            frm.ShowDialog();
        }
    }

    private void btnOK_Click(object sender, EventArgs e)
    {
        Close();
    }
}