public virtual Project GetVersion(int projectId, int version) { Project projectVersion; using (var filterDisabler = new FilterDisabler(DbContext, "IsVersion")) { var data = GetQueryable().Where(p => p.ItemID == projectId); if (version == 0) { data = data.Where(p => p.VersionNumber == 0 || p.VersionNumber == null); } else { data = data.Where(p => p.VersionNumber == version); } projectVersion = data.SingleOrDefault(); } return(projectVersion); }
public IList <ProjectScheduleEntry> GetVersions(int projectScheduleEntryId, bool withChangeInfo) { List <ProjectScheduleEntry> projectScheduleEntryVersion; using (var filterDisabler = new FilterDisabler(DbContext, "IsVersion")) { projectScheduleEntryVersion = GetQueryable().Where(p => p.ItemID == projectScheduleEntryId || p.ID == projectScheduleEntryId) .OrderByDescending(p => p.VersionNumber).ToList(); } if (withChangeInfo) { for (int i = 0; i < projectScheduleEntryVersion.Count - 1; i++) { var changes = ChangedRecordsFiller.GetChangedData(projectScheduleEntryVersion[i], projectScheduleEntryVersion[i + 1]); projectScheduleEntryVersion[i].ChangedRecords = changes; } } return(projectScheduleEntryVersion); }
public VacationRecord GetVersion(int vacationRecordId, int version) { VacationRecord vacationRecordVersion; using (var filterDisabler = new FilterDisabler(DbContext, "IsVersion")) { var data = GetQueryable().Where(p => p.ItemID == vacationRecordId); if (version == 0) { data = data.Where(p => p.VersionNumber == 0 || p.VersionNumber == null); } else { data = data.Where(p => p.VersionNumber == version); } vacationRecordVersion = data.SingleOrDefault(); } return(vacationRecordVersion); }
public IList <TSAutoHoursRecord> GetVersions(int tsAutoHoursRecordId, bool withChangeInfo) { List <TSAutoHoursRecord> tsAutoHoursRecordVersion; using (var filterDisabler = new FilterDisabler(DbContext, "IsVersion")) { tsAutoHoursRecordVersion = GetQueryable().Where(p => p.ItemID == tsAutoHoursRecordId || p.ID == tsAutoHoursRecordId) .OrderByDescending(p => p.VersionNumber) .ToList(); } if (withChangeInfo) { for (int i = 0; i < tsAutoHoursRecordVersion.Count - 1; i++) { var changes = ChangedRecordsFiller.GetChangedData(tsAutoHoursRecordVersion[i], tsAutoHoursRecordVersion[i + 1]); tsAutoHoursRecordVersion[i].ChangedRecords = changes; } } return(tsAutoHoursRecordVersion); }
public virtual TSHoursRecord GetVersion(int tsHoursRecordId, int version) { TSHoursRecord tsHoursRecordVersion; using (var filterDisabler = new FilterDisabler(DbContext, "IsVersion")) { var data = GetQueryable().Where(p => p.ItemID == tsHoursRecordId); if (version == 0) { data = data.Where(p => p.VersionNumber == 0 || p.VersionNumber == null); } else { data = data.Where(p => p.VersionNumber == version); } tsHoursRecordVersion = data.SingleOrDefault(); } return(tsHoursRecordVersion); }