public static RBCTimeData[] GetRBCTimeEntries(DateTime fromDate, DateTime toDate, SortOrder sortOrder)
{
//throw new NotImplementedException();
using (var db = new RBCTimeDataContext()) {
try {
var rtd = from x in db.RBCTimeDataItems
where x.Date >= fromDate && x.Date <= toDate
orderby x.Date
select x;
return(!rtd.Any() ? null : rtd.Select(i => RBCTimeData.Copy(i)).ToArray());
} catch { return(null); }
}
}
/// <summary>
/// Gets the RBC Time Data for a given itemID.
/// </summary>
/// <param name="itemID">The item ID to look up.</param>
/// <returns>The time data for the given item id.</returns>
public static RBCTimeData GetRBCTimeData(int itemID)
{
//
if (itemID < 0)
{
return(null);
}
using (var db = new RBCTimeDataContext()) {
try {
var rtd = db.RBCTimeDataItems.Single(s => s.ItemId == itemID);
if (rtd == null)
{
return(null);
}
return(RBCTimeData.Copy(rtd));
} catch {
return(null);
}
}
}