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