public Form_SnapshotDatabaseProperties(
Sql.ServerVersion version,
Sql.ObjectTag tag
)
{
InitializeComponent();
Sql.Database db = Sql.Database.GetSnapshotDatabase(tag.SnapshotId, tag.DatabaseId);
if (db != null)
{
// Set the properties.
_lbl_Name.Text = db.Name;
_lbl_Owner.Text = db.Owner;
_lbl_GuestEnabled.Text = db.IsGuestEnabled ? "Yes" : "No";
_lbl_Trustworthy.Text = db.IsTrustworthy;
_lbl_Status.Text = db.Status;
// Set title based on type.
this.Text = tag.TypeName + " Properties - " + db.Name;
// If database is available, fill explicit permissions
// Else disable the grid.
if (db.IsAvailable)
{
_permissionsGrid.Initialize(version, tag);
}
else
{
_permissionsGrid.Enabled = false;
}
}
}
public ObjectTag( // Database objects - table, view, function, stored proc, etc.
int snapshotid,
Sql.ObjectType.TypeEnum objType,
Sql.Database database,
int classId,
int parentObjectId,
int objectId,
string objectName
)
{
Debug.Assert(snapshotid != 0);
Debug.Assert(objType == ObjectType.TypeEnum.Table ||
objType == ObjectType.TypeEnum.View ||
objType == ObjectType.TypeEnum.Synonym ||
objType == ObjectType.TypeEnum.StoredProcedure ||
objType == ObjectType.TypeEnum.Function ||
objType == ObjectType.TypeEnum.ExtendedStoredProcedure ||
objType == ObjectType.TypeEnum.Assembly ||
objType == ObjectType.TypeEnum.UserDefinedDataType ||
objType == ObjectType.TypeEnum.XMLSchemaCollection ||
objType == ObjectType.TypeEnum.FullTextCatalog ||
objType == ObjectType.TypeEnum.SequenceObjects ||
objType == ObjectType.TypeEnum.SequenceObject);
Debug.Assert(database != null);
Debug.Assert(!string.IsNullOrEmpty(objectName));
m_SnapshotId = snapshotid;
m_ObjType = objType;
m_Database = database;
m_ClassId = classId;
m_ParentObjectId = parentObjectId;
m_ObjectId = objectId;
m_ObjectName = objectName;
}
public ObjectTag( // Database user, role, schema, cert and key objects.
int snapshotid,
Sql.ObjectType.TypeEnum objType,
Sql.Database database,
int objectId,
string objectName
)
{
Debug.Assert(snapshotid != 0);
Debug.Assert(objType == ObjectType.TypeEnum.User ||
objType == ObjectType.TypeEnum.DatabaseRole ||
objType == ObjectType.TypeEnum.ApplicationRole ||
objType == ObjectType.TypeEnum.Key ||
objType == ObjectType.TypeEnum.Certificate);
Debug.Assert(database != null);
Debug.Assert(!string.IsNullOrEmpty(objectName));
m_SnapshotId = snapshotid;
m_ObjType = objType;
m_Database = database;
switch (m_ObjType)
{
case ObjectType.TypeEnum.User:
case ObjectType.TypeEnum.DatabaseRole:
case ObjectType.TypeEnum.ApplicationRole:
case ObjectType.TypeEnum.Key:
case ObjectType.TypeEnum.Certificate:
m_ClassId = 4;
break;
}
m_ObjectId = objectId;
m_ObjectName = objectName;
}
public ObjectTag( // database and database level tree view containers
int snapshotId,
Sql.ObjectType.TypeEnum objType,
Sql.Database database
)
{
Debug.Assert(snapshotId != 0);
Debug.Assert(objType == ObjectType.TypeEnum.DatabaseSecurity ||
objType == ObjectType.TypeEnum.Users ||
objType == ObjectType.TypeEnum.DatabaseRoles ||
objType == ObjectType.TypeEnum.Schemas ||
objType == ObjectType.TypeEnum.Keys ||
objType == ObjectType.TypeEnum.Certificates ||
objType == ObjectType.TypeEnum.Tables ||
objType == ObjectType.TypeEnum.Views ||
objType == ObjectType.TypeEnum.Synonyms ||
objType == ObjectType.TypeEnum.StoredProcedures ||
objType == ObjectType.TypeEnum.Functions ||
objType == ObjectType.TypeEnum.ExtendedStoredProcedures ||
objType == ObjectType.TypeEnum.Assemblies ||
objType == ObjectType.TypeEnum.UserDefinedDataTypes ||
objType == ObjectType.TypeEnum.XMLSchemaCollections ||
objType == ObjectType.TypeEnum.FullTextCatalogs ||
objType == ObjectType.TypeEnum.SequenceObjects);
Debug.Assert(database != null);
m_SnapshotId = snapshotId;
m_ObjType = objType;
m_Database = database;
}
public ObjectTag( // Database, and schema objects.
int snapshotid,
Sql.ObjectType.TypeEnum objType,
Sql.Database database,
int classId,
int objectId,
string objectName
)
{
Debug.Assert(snapshotid != 0);
Debug.Assert(objType == ObjectType.TypeEnum.Database ||
objType == ObjectType.TypeEnum.Schema);
Debug.Assert(database != null);
Debug.Assert(!string.IsNullOrEmpty(objectName));
m_SnapshotId = snapshotid;
m_ObjType = objType;
m_Database = database;
m_ClassId = classId;
m_ObjectId = objectId;
m_ObjectName = objectName;
}
