private void WriteViewDocument(View view, HtmlBuilder html, DatabaseContext context)
{
html.h1(String.Format("View: {0}", view.Name));
html.e("table");
html.tr().td().attCls("label").text("Database:").c().td();
String relDoc = String.Format("{0}.{1}.{1}", context.BookName, context.DbName);
html.internalLink(context.DbName, "db-entity-name", relDoc, view.Name);
html.c().c();
html.c(); //table
RenderColumnsTable(view.Columns, html, context);
}
private void WriteStoredProcedureDocument(StoredProcedure sp, HtmlBuilder html, DatabaseContext context)
{
html.h1(String.Format("Stored Procedure: {0}", sp.Name));
html.e("table");
html.tr().td().attCls("label").text("Database:").c().td();
String relDoc = String.Format("{0}.{1}.{1}", context.BookName, context.DbName);
html.internalLink(context.DbName, "db-entity-name", relDoc, sp.Name);
html.c().c();
html.c(); //table
html.h2("Parameters");
if (sp.Parameters != null && sp.Parameters.Count > 0)
{
html.table(0, 0).att("width", "100%").attCls("members");
html.dbSpParamHeader();
foreach (var p in sp.Parameters)
{
html.tr()
.rowHeader(false)
.td()
.attCls(p.IsOutputParameter ? "sp-parameter output" : "sp-parameter input")
.att("title", p.IsOutputParameter ? "output" : "input")
.text(p.Name.TrimStart('@'))
.c()
.td()
.dataType(p.DataType)
.c()
.c();
}
html.c(); // table
}
else
html.text("This stored procedure does not receive parameters.");
}
