public static List<LogEntry> ReadAll(SupportedPeriod period)
{
using (BadgeDataContext db = new BadgeDataContext(BadgeDataContext.ConnectionString)) {
return (from entry in db.Entries
where entry.Time.Date >= period.From.Date && entry.Time.Date <= period.To.Date
orderby entry.Time
select entry).ToList();
}
}
public static List<ReportLog> ReadAll(SupportedPeriod period)
{
var list = new List<ReportLog>();
using (BadgeDataContext db = new BadgeDataContext(BadgeDataContext.ConnectionString)) {
var entrylistIn = (from entry in db.Entries
where entry.EntryTypeEnum == Model.EntryType.In && entry.Time >= period.From && entry.Time <= period.To
orderby entry.Time
select entry);
var entrylistOut = (from entry in db.Entries
where entry.EntryTypeEnum == Model.EntryType.Out && entry.Time >= period.From && entry.Time <= period.To
orderby entry.Time
select entry);
foreach (var item in entrylistIn) {
list.Add(new ReportLog(item,
entrylistOut.FirstOrDefault(log => log.Time > item.Time)));
}
}
return list;
}