public int GetCountOfTeamUnclaimedObjects(DateTime minimumDateTime) { int countOfResults; using (var ctx = new smbimAuditEntities()) { countOfResults = ctx.GetUnclaimedDatabaseObjects(minimumDateTime, null).Count(); } return(countOfResults); }
public int GetCountOfUserUnclaimedObjects(string username, DateTime minimumDateTime) { int countOfResults; using (var ctx = new smbimAuditEntities()) { countOfResults = ctx.GetUnclaimedDatabaseObjects(minimumDateTime, username).Count(); } return(countOfResults); }
public List <DatabaseObject> GetUnclaimedDatabaseObjects(string developerUserName, DateTime minimumDateTime) { using (var ctx = new smbimAuditEntities()) { var results = ctx.GetUnclaimedDatabaseObjects(minimumDateTime.Date, developerUserName).ToList(); var returnResults = results.Select(r => new DatabaseObject { DatabaseName = r.DatabaseName, ObjectSchema = r.ObjectSchema, ObjectName = r.ObjectName, Category = r.Category }); return(returnResults.ToList()); } }
public List <DatabaseObjectStatus> GetObjectsWithUnclimainedChangesByDatabaseAndType(string databaseName, DatabaseObjectTypeCode type, DateTime startDate, string userName) { List <DatabaseObjectStatus> statusList = new List <DatabaseObjectStatus>(); using (var ctx = new smbimAuditEntities()) { var unclaimedChanges = ctx.GetUnclaimedDatabaseObjects(startDate, userName). Where(u => string.Compare(u.Category, UtilityRepository.DatabaseReadableTypeCodesLookup[type], StringComparison.OrdinalIgnoreCase) == 0).ToList(); statusList.AddRange(unclaimedChanges.Select(change => new DatabaseObjectStatus { ObjectInformation = new DatabaseObjectBasicInformation { DatabaseName = databaseName, ObjectName = change.ObjectName, ObjectSchema = change.ObjectSchema }, HasUnclaimedChanges = true })); return(statusList); } }