private static void FillCommand(DbCommand cmd, SaveModes saveMode, Level1Types level1Type, string descriptionValue, string objectSchema, string level1Name, Level2Types level2Type, string level2Name)
{
cmd.Connection.Open();
if (saveMode != SaveModes.Delete)
{
cmd.Parameters.Add(CommandFactory.CreateParameter("@value", descriptionValue));
}
cmd.Parameters.Add(CommandFactory.CreateParameter("@name", ApplicationSettings.Default.ExtendedPropKey));
cmd.Parameters.Add(CommandFactory.CreateParameter("@level0type", "SCHEMA"));
cmd.Parameters.Add(CommandFactory.CreateParameter("@level0name", objectSchema));
cmd.Parameters.Add(CommandFactory.CreateParameter("@level1type", level1Type.ToString()));
cmd.Parameters.Add(CommandFactory.CreateParameter("@level1name", level1Name));
if (level2Type != Level2Types.NULL)
{
cmd.Parameters.Add(CommandFactory.CreateParameter("@level2type", level2Type.ToString()));
cmd.Parameters.Add(CommandFactory.CreateParameter("@level2name", level2Name));
}
}
public string GenerateWikiMarkup(string connStr, EntityBase entity, Level1Types level1Type, Level2Types level2Type)
{
switch (level1Type)
{
case Level1Types.Table:
switch (level2Type)
{
case Level2Types.NULL:
return(GenerateWikiMarkupForTablesOrView(connStr, entity, level1Type));
case Level2Types.Index:
case Level2Types.Constraint:
return(CreateWikiMarkupForIndexesOnTable(connStr, entity));
default:
throw new ArgumentException();
}
case Level1Types.Procedure:
return(GenerateWikiMarkupForStoredProcedures(connStr, entity as StoredProcedureMetaData));
case Level1Types.View:
return(GenerateWikiMarkupForTablesOrView(connStr, entity, level1Type));
default:
throw new ArgumentException();
}
}
protected bool SaveDescription(SaveModes saveMode, string connStr, Level1Types level1Type, string descriptionValue, string objectSchema, string level1Name, Level2Types level2Type, string level2Name)
{
string sql = GetSQLTextForSaveMode(saveMode);
try
{
using (DbCommand cmd = CommandFactory.Create(sql, connStr, System.Data.CommandType.StoredProcedure))
{
FillCommand(cmd, saveMode, level1Type, descriptionValue, objectSchema, level1Name, level2Type, level2Name);
cmd.ExecuteNonQuery();
}
}
catch (Exception)
{
throw;
}
return(true);
}
