public static IEnumerable <ActivityExecutionPerformance> GetByActivityExecutionId(DataLogContext dlc, Guid?activityExecutionId)
{
IEnumerable <ActivityExecutionPerformance> aep = (from td in dlc.ActivityExecutionPerformances where td.ActivityExecutionId == activityExecutionId select td).ToList();
return(aep);
}
public static ActivityExecutionAssetUsage GetByActivityExecutionId(DataLogContext dlc, Guid activityExecutionId) => (from ae in dlc.ActivityExecutionAssetUsages where ae.ActivityExecutionId.Equals(activityExecutionId) select ae).FirstOrDefault();
public static List <string> GetProductsBySessionId(DataLogContext dlc, string sessionId) => (from sd in dlc.SessionDevices where sd.SessionId.Equals(sessionId) select sd.ProductName).Distinct().ToList();
/// <summary>
/// Gets the ActivityExecutionDetail List by the activity execution identifier.
/// </summary>
/// <param name="dlc">The DataLog Context.</param>
/// <param name="activityExecutionId">The activity execution identifier.</param>
/// <returns>ActivityExecutionDetail List</returns>
public static IEnumerable <ActivityExecutionDetail> GetByActivityExecutionId(DataLogContext dlc, Guid?activityExecutionId)
{
IEnumerable <ActivityExecutionDetail> aedList = (from aed in dlc.ActivityExecutionDetails where aed.ActivityExecutionId == activityExecutionId select aed).ToList();
return(aedList);
}
public static SessionDevice GetBySessionDeviceId(DataLogContext dlc, string sessionId, string deviceId) => (from sd in dlc.SessionDevices where sd.SessionId.Equals(sessionId) && sd.DeviceId.Equals(deviceId) select sd).FirstOrDefault();
public static TriageData GetTriageDataById(DataLogContext dl, Guid triageDataId) => (from td in dl.TriageDatas where td.TriageDataId.Equals(triageDataId) select td).FirstOrDefault();
public static int GetCountBySessionId(DataLogContext dlc, string sessionId) => (from td in dlc.TriageDatas where td.SessionId.Equals(sessionId) select td).Count();
public static IEnumerable <TriageData> GetTriageDataBySessionId(DataLogContext dlc, string sessionId) => (from td in dlc.TriageDatas where td.SessionId.Equals(sessionId) select td).Take(3000).ToList();
public static List <string> SessionIds(DataLogContext dlc, DateTime dtStart, DateTime dtEnd) => (from td in dlc.TriageDatas where td.TriageDateTime >= dtStart && td.TriageDateTime <= dtEnd select td.SessionId).Distinct().ToList();