public DatabaseObjectItem(string name, string schemaName, string databaseName, DatabaseObjectTypeCode type)
{
Name = name;
SchemaName = schemaName;
DatabaseName = databaseName;
ItemType = type;
HasUnclaimedChanges = false;
HasPendingCheckin = false;
NeedsCodeReview = false;
}
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);
}
}
public List <DatabaseObjectBasicInformation> GetObjectBasicInformationFromDatabaseAndType(string databaseName, DatabaseObjectTypeCode typeCode)
{
//using (var ctx = new StoneEdgeRogueEntities())
//{
// string sql = string.Format(@"USE [{0}];
// SELECT DatabaseName = '{0}'
// ,ObjectName = ao.name
// ,ObjectSchema = s.name
// ,LastDdlChange = ao.modify_date
// FROM sys.all_objects ao JOIN sys.schemas s ON ao.schema_id = s.schema_id
// WHERE [type] = '{1}' AND ao.is_ms_shipped = 0
// ORDER BY s.name, ao.name ASC",
// databaseName,
// DatabaseTypeCodes[typeCode]);
// List<DatabaseObjectBasicInformation> results =
// ctx.Database.SqlQuery<DatabaseObjectBasicInformation>(sql).ToList();
// return results;
//}
throw new NotImplementedException();
}
public DatabaseCategoryItem(string name, string databaseName, DatabaseObjectTypeCode type)
{
Name = name;
DatabaseName = databaseName;
Type = type;
}
public List <DatabaseObjectBasicInformation> GetObjectBasicInformationFromDatabaseAndType(string databaseName, DatabaseObjectTypeCode typeCode)
{
using (var ctx = new StoneEdgeRogueEntities())
{
string sql = string.Format(@"USE [{0}];
SELECT DatabaseName = '{0}'
,ObjectName = ao.name
,ObjectSchema = s.name
,LastDdlChange = ao.modify_date
FROM sys.all_objects ao JOIN sys.schemas s ON ao.schema_id = s.schema_id
WHERE [type] = '{1}' AND ao.is_ms_shipped = 0
ORDER BY s.name, ao.name ASC",
databaseName,
DatabaseTypeCodes[typeCode]);
List <DatabaseObjectBasicInformation> results =
ctx.Database.SqlQuery <DatabaseObjectBasicInformation>(sql).ToList();
return(results);
}
}