private void SaveXmlValue(string name, string parentNodeName, NodeType nodeType, string description, string databaseFieldName)
{
string level1Name = name;
string level2Name = null;
if (parentNodeName != null)
{
level1Name = parentNodeName;
level2Name = name;
}
string level1Type = ExtendedPropertiesHelper.GetLevel1Type(nodeType);
string level2Type = ExtendedPropertiesHelper.GetLevel2Type(nodeType);
if (level2Type == "")
{
level2Name = "";
}
if (_objectsSelectorForm.allCheckBox.Checked || (!_objectsSelectorForm.allCheckBox.Checked && _selectedDatabaseFieldNames.Contains(databaseFieldName)))
{
if (_objectsSelectorForm.IncludeObjectType(level1Type, level2Type))
{
if (_objectsSelectorForm.IncludeIndividualObject(level1Type, level1Name))
{
_databaseOperation.SaveDescription(level1Type, level1Name, level2Type, level2Name, description, databaseFieldName);
}
}
}
}
public static string GetCheckWrapper(CustomNode node, string sqlToWrap)
{
string level1Type = ExtendedPropertiesHelper.GetLevel1Type(node.Type);
string level1Name = ExtendedPropertiesHelper.GetLevel1Name(node);
string level2Type = ExtendedPropertiesHelper.GetLevel2Type(node.Type);
string level2Name = ExtendedPropertiesHelper.GetLevel2Name(node);
return(GetCheckWrapper(level1Type, level1Name, level2Type, level2Name, sqlToWrap));
}
public string GetDescription(CustomNode node, string databaseFieldName)
{
DataTable dt = ExecuteDataTable(ExtendedPropertiesHelper.GetCheckSql(node, databaseFieldName));
if (dt.Rows.Count == 1)
{
return(dt.Rows[0]["value"].ToString());
}
else
{
return("");
}
}
private void DoExportNodeExcel(CustomNode node, List <string> dataRows)
{
SortDescriptions(node);
AddEmptyDescriptions(node);
foreach (DescriptionItem item in node.Descriptions)
{
if (_objectsSelectorForm.allCheckBox.Checked || (!_objectsSelectorForm.allCheckBox.Checked && _selectedDatabaseFieldNames.Contains(item.Type.DatabaseFieldName)))
{
if (!additionalOptionsCheckBox.Checked || (additionalOptionsCheckBox.Checked && !string.IsNullOrEmpty(item.Description)))
{
dataRows.Add(ExtendedPropertiesHelper.GetExcelData(node, item.Description, item.Type.DatabaseFieldName));
}
}
}
}
public static int CustomNodeToIndex(DatabaseOperation databaseOperation, CustomNode node)
{
string level1Type = GetLevel1NodeTypeString(node.Type);
string level1Name;
string level2Type = GetLevel2NodeTypeString(node.Type);
string level2Name = "";
if (node.Type == NodeType.Database || node.Type == NodeType.Tables || node.Type == NodeType.Views || node.Type == NodeType.Programmability || node.Type == NodeType.StoredProcedures || node.Type == NodeType.Functions || node.Type == NodeType.TableValuedFunctions || node.Type == NodeType.ScalarValuedFunctions)
{
if (node.Type == NodeType.Database || node.Type == NodeType.Programmability || node.Type == NodeType.Functions)
{
level1Name = GetFirstLevel1NodeName(databaseOperation, (CustomNode)node.Nodes[0]);
}
else
{
level1Name = GetFirstLevel1NodeName(databaseOperation, node);
}
}
else
{
if (node.Type == NodeType.TableColumns || node.Type == NodeType.TableKeys || node.Type == NodeType.TableConstraints || node.Type == NodeType.TableTriggers || node.Type == NodeType.TableIndexes || node.Type == NodeType.ViewColumns || node.Type == NodeType.ViewTriggers || node.Type == NodeType.ViewIndexes || node.Type == NodeType.StoredProcedureParameters || node.Type == NodeType.TableValuedFunctionParameters || node.Type == NodeType.ScalarValuedFunctionParameters)
{
level1Name = ExtendedPropertiesHelper.GetLevel1Name(node.ParentNode);
level2Name = GetFirstLevel2NodeName(databaseOperation, node);
}
else
{
level1Name = ExtendedPropertiesHelper.GetLevel1Name(node);
if (ExtendedPropertiesHelper.AddLevel2(node.Type))
{
level2Name = ExtendedPropertiesHelper.GetLevel2Name(node);
}
}
}
int treeId = databaseOperation.GetIdFromName(level1Type, level1Name, level2Type, level2Name);
return(treeId - 1);
}
public void SaveDescription(CustomNode node, string description, string databaseFieldName)
{
DataTable dt = ExecuteDataTable(ExtendedPropertiesHelper.GetCheckSql(node, databaseFieldName));
string sql;
if (dt.Rows.Count == 0)
{
sql = ExtendedPropertiesHelper.GetAddSql(node, description, databaseFieldName);
}
else
{
if (description == "")
{
sql = ExtendedPropertiesHelper.GetDropSql(node, databaseFieldName);
}
else
{
sql = ExtendedPropertiesHelper.GetUpdateSql(node, description, databaseFieldName);
}
}
Execute(sql);
}
public void SaveDescription(string level1Type, string level1Name, string level2Type, string level2Name, string description, string databaseFieldName)
{
DataTable dt = ExecuteDataTable(ExtendedPropertiesHelper.GetCheckSql(level1Type, level1Name, level2Type, level2Name, databaseFieldName));
string sql;
if (dt.Rows.Count == 0)
{
sql = ExtendedPropertiesHelper.GetAddSql(level1Type, level1Name, level2Type, level2Name, description, databaseFieldName);
}
else
{
if (description == "")
{
sql = ExtendedPropertiesHelper.GetDropSql(level1Type, level1Name, level2Type, level2Name, databaseFieldName);
}
else
{
sql = ExtendedPropertiesHelper.GetUpdateSql(level1Type, level1Name, level2Type, level2Name, description, databaseFieldName);
}
}
sql = CheckWrapper.GetCheckWrapper(level1Type, level1Name, level2Type, level2Name, sql);
Execute(sql);
}
private void DoExportNodeSql(CustomNode node, StringBuilder stringBuilder)
{
SortDescriptions(node);
AddEmptyDescriptions(node);
foreach (DescriptionItem item in node.Descriptions)
{
string sql = "";
if (_objectsSelectorForm.allCheckBox.Checked || (!_objectsSelectorForm.allCheckBox.Checked && _selectedDatabaseFieldNames.Contains(item.Type.DatabaseFieldName)))
{
string databaseFieldName = item.Type.DatabaseFieldName;
if (string.IsNullOrEmpty(item.Description))
{
if (additionalOptionsCheckBox.Checked)
{
sql = string.Format("if exists ({0})\r\nbegin\r\n\t{1}\r\nend", ExtendedPropertiesHelper.GetCheckSql(node, databaseFieldName), ExtendedPropertiesHelper.GetDropSql(node, databaseFieldName));
}
}
else
{
sql = string.Format("if exists ({0})\r\nbegin\r\n\t{1}\r\nend\r\nelse\r\nbegin\r\n\t{2}\r\nend", ExtendedPropertiesHelper.GetCheckSql(node, databaseFieldName), ExtendedPropertiesHelper.GetUpdateSql(node, item.Description, databaseFieldName), ExtendedPropertiesHelper.GetAddSql(node, item.Description, databaseFieldName));
}
}
if (sql != "")
{
sql = CheckWrapper.GetCheckWrapper(node, sql);
if (generateGoStatementsCheckBox.Checked)
{
sql = string.Format("{0}\r\ngo", sql);
}
stringBuilder.Append(string.Format("{0}\r\n\r\n", sql));
}
}
}
private void DoDelete(string level1Type, string level1Name, string level2Type, string level2Name, string databaseFieldName)
{
string sql = ExtendedPropertiesHelper.GetDropSql(level1Type, level1Name, level2Type, level2Name, databaseFieldName);
_databaseOperation.Execute(sql);
}
