/// <summary>
/// Loads the items.
/// </summary>
/// <param name="locationName">Name of the location.</param>
/// <param name="dateSince">The date since.</param>
/// <param name="dateTill">The date till.</param>
/// <returns></returns>
public IEnumerable <ExportData> LoadItems(string locationName = null, DateTime?dateSince = null, DateTime?dateTill = null)
{
using (ExportHistoryReportEntities context = new ExportHistoryReportEntities())
{
var query = from e in context.Exports
orderby e.ExecutionDateTime
select new ExportData
{
ID = e.ID,
Name = e.Name,
ExecutionDateTime = e.ExecutionDateTime,
UserName = e.UserName,
LocationName = e.LocationName
};
if (!string.IsNullOrEmpty(locationName))
{
query = query.Where(t => t.LocationName == locationName);
}
if (dateSince != null)
{
query = query.Where(t => t.ExecutionDateTime >= dateSince);
}
if (dateTill != null)
{
query = query.Where(t => t.ExecutionDateTime <= dateTill);
}
return(query.ToList());
}
}
/// <summary>
/// Gets the locations.
/// </summary>
/// <returns></returns>
public IEnumerable <string> GetLocations()
{
using (ExportHistoryReportEntities context = new ExportHistoryReportEntities())
{
return(context.Exports.Select(t => t.LocationName).Distinct().ToList());
}
}
