public void SeedTestDatabase(PacketsTestEntities context)
{
var captureBatch = new CaptureBatch
{
FileName = "CaptureFileTest1d.pcap",
Marked = true,
Mean = 0M,
TrimmedMean = 0M,
Parsed = false,
SingleStatistics = false,
CumulativeStatistics = false
};
context.CaptureBatches.Add(captureBatch);
int msec = 067;
for (int i = 0; i < 10; i++)
{
var capturePacket = new CapturePacket
{
PacketNumber = i,
CaptureBatchId = 1,
TimeStamp = Convert.ToDateTime(string.Format("2016-01-31 12:13:58." + msec++)),
Marked = true
};
context.CapturePackets.Add(capturePacket);
}
context.SaveChanges();
/* Test Data
CapturePacketId CaptureBatchId PacketNumber TimeStamp Marked
1 1 0 2016-01-31 12:13:58.067 1
2 1 1 2016-01-31 12:13:58.067 1
3 1 2 2016-01-31 12:13:58.067 1
4 1 3 2016-01-31 12:13:58.070 1
5 1 4 2016-01-31 12:13:58.070 1
6 1 5 2016-01-31 12:13:58.070 1
7 1 6 2016-01-31 12:13:58.073 1
8 1 7 2016-01-31 12:13:58.073 1
CaptureBatchId FileName Marked Mean TrimmedMean Parsed SingleStatistics CumulativeStatistics
1 CaptureFile635898392258793796d.pcap 1 105.5416666667 115.0454545455 1 1 1
2 CaptureFile635898392480034634u.pcap 0 9.8230616302 125.6944444444 1 1 1
3 CaptureFile635898392680134473d.pcap 1 7.7898989899 132.3846153846 1 1 1
4 CaptureFile635898392880258123u.pcap 0 9.6271844660 106.0930232558 1 1 1
5 CaptureFile635898393080301245d.pcap 1 9.7991967871 110.2682926829 1 1 1
6 CaptureFile635898393280407635u.pcap 0 9.5570866142 120.8648648649 1 1 1
7 CaptureFile635898393480605337d.pcap 1 9.1496062992 109.3076923077 1 1 1
8 CaptureFile635898393680732945u.pcap 0 10.3278008299 131.9714285714 1 1 1
*/
}
public BindingList<CapturePacket> GetCapturePackets(string fileName)
{
BindingList<CapturePacket> packets = new BindingList<CapturePacket>();
try
{
//using (var context = new PacketCaptureContext())
using (var context = new PacketAnalysisEntity())
{
//var captureBatchId = (from c in context.CaptureBatches
// where c.FileName == fileName
// select c).FirstOrDefault();
//var capturePackets = context.CapturePackets.ToList();
//var batch = context.BatchIntervals.ToList();
//var capturePackets = (from c in context.CapturePackets
// where c.FileName == fileName
// select c).ToList();
//var capturePackets = (from c in context.CapturePackets
// where c.CaptureBatchId == captureBatchId
// select c).ToList();
var captureBatchId = (from b in context.CaptureBatches
where b.FileName == fileName
select b.CaptureBatchId).FirstOrDefault();
var capturePackets = (from c in context.CapturePackets
where c.CaptureBatchId == captureBatchId
select c).ToList();
foreach (var pkt in capturePackets)
{
CapturePacket packet = new CapturePacket();
packet.CapturePacketId = pkt.CapturePacketId;
packet.CaptureBatchId = pkt.CaptureBatchId;
packet.PacketNumber = pkt.PacketNumber;
packet.TimeStamp = pkt.TimeStamp;
packet.Marked = pkt.Marked;
packets.Add(packet);
}
}
return packets;
}
catch (Exception ex)
{
throw new Exception("Error retrieving capture packet data for file [" + fileName + "]: " + ex.Message);
}
}
