public string GerarBody()
{
var header = new StringBuilder();
header.Append($"create or replace package BODY {NomeTabela.TratarNomePackage()} is" + Environment.NewLine +
Environment.NewLine);
header.Append(BodyInsert());
header.Append(BodyUpdate());
header.Append(BodyDelete());
header.Append(BodySelect(true));
header.Append(BodySelect());
header.Append($"end {NomeTabela.TratarNomePackage()};" + Environment.NewLine);
return(header.ToString());
}
public StringBuilder GerarPackageHeader()
{
var header = new StringBuilder();
header.Append($"create or replace package {NomeTabela.TratarNomePackage()} is" + Environment.NewLine +
Environment.NewLine);
header.Append(" TYPE TP_CURSOR IS REF CURSOR;" + Environment.NewLine + Environment.NewLine);
header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "I_" + NomeTabela.TratarNomeTabela(),
true, false, false, false, true));
header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "U_" + NomeTabela.TratarNomeTabela(),
true));
header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "D_" + NomeTabela.TratarNomeTabela(),
true, false, true));
header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela(),
true, true, true, true));
header.Append(AdicionaCabecalho(
ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela() + "_ID", true, true, true));
header.Append(Environment.NewLine + Environment.NewLine + $"end {NomeTabela.TratarNomePackage()};" +
Environment.NewLine);
return(header);
}
public StringBuilder GerarClasse()
{
var nomeProcBase = NomeTabela.TratarNomeTabela();
var classe = new StringBuilder();
classe.Append("using System.Net;" + N);
classe.Append("using System;" + N + N);
classe.Append("namespace MeuProjeto" + N);
classe.Append("{" + N);
classe.Append($" public class {nomeProcBase.ToLowerInvariant()}RequestRepository : ADORepository" + N);
classe.Append(" {" + N + N);
classe.Append($" private const string PackageName = \"{NomeTabela.TratarNomePackage()}\";" + N + N);
classe.Append(Procedures(nomeProcBase));
classe.Append(GetById(nomeProcBase));
classe.Append(Add(nomeProcBase));
classe.Append(Update(nomeProcBase));
classe.Append(" }" + N);
classe.Append("}" + N);
return(classe);
}
private StringBuilder Update()
{
var get = new StringBuilder();
get.Append($" update: function (body, callback) {{ {N}");
get.Append(
$" oracleDb.executeProcedure({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "U_" + NomeTabela.TratarNomeTabela()}\",{N}");
get.Append($" {{{N}");
get.Append(
$" P_RESULT: {{ dir: oracleDb.type(\"BIND_OUT\"), type: oracleDb.type(\"STRING\") }}, {N}");
for (var i = 0; i < ListaAtributosTabela.Count; i++)
{
get.Append(
$" P_{ListaAtributosTabela[i].COLUMN_NAME}: body.{ListaAtributosTabela[i].COLUMN_NAME},{N}");
}
get.Append($" }}, \"P_RESULT\",{N}");
get.Append($" function (err, result) {{ {N}");
get.Append($" callback(err, result);{N}");
get.Append($" }});{N}");
get.Append($" }},{N}");
return(get);
}
private StringBuilder GetAll()
{
var get = new StringBuilder();
get.Append($" getAll: function (callback) {{{N}");
get.Append(
$" oracleDb.beginProcedure({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela()}\",{N}");
get.Append($" {{{N}");
get.Append(
$" P_CURSORSELECT: {{ type: oracleDb.type(\"CURSOR\"), dir: oracleDb.type(\"BIND_OUT\") }}{N}");
get.Append($" }}, \"P_CURSORSELECT\", function (err, result) {{ {N}");
get.Append($" callback(err, result);{N}");
get.Append($" }});{N}");
get.Append($" }},{N}");
return(get);
}
private StringBuilder GetById()
{
var get = new StringBuilder();
get.Append($" getById: function (id, callback) {{{N}");
get.Append(
$" oracleDb.beginProcedureById({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela() + "_ID"}\",{N}");
get.Append($" {{{N}");
get.Append(
$" P_CURSORSELECT: {{ type: oracleDb.type(\"CURSOR\"), dir: oracleDb.type(\"BIND_OUT\") }},{N}");
get.Append($" P_{ListaAtributosTabela.First().COLUMN_NAME}: id, {N}");
get.Append($" }}, function (err, result) {{ {N}");
get.Append($" callback(err, result);{N}");
get.Append($" }});{N}");
get.Append($" }},{N}");
return(get);
}
private StringBuilder Delete()
{
var get = new StringBuilder();
get.Append($" delete: function (id, callback) {{ {N}");
get.Append(
$" oracleDb.executeProcedure({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "D_" + NomeTabela.TratarNomeTabela()}\",{N}");
get.Append($" {{{N}");
get.Append(
$" P_RESULT: {{ dir: oracleDb.type(\"BIND_OUT\"), type: oracleDb.type(\"STRING\") }}, {N}");
get.Append($" P_{ListaAtributosTabela.First().COLUMN_NAME}: id,{N}");
get.Append($" }}, \"P_RESULT\",{N}");
get.Append($" function (err, result) {{ {N}");
get.Append($" callback(err, result);{N}");
get.Append($" }});{N}");
get.Append($" }},{N}");
return(get);
}
