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();