public string GerarBody()
{
var baseProc = NomeTabela.TratarNomeTabela().ToUpper();
var header = new StringBuilder();
header.Append(new PostgreGet().Init($"{ParamtersInput.Prefixos.Procedure}S_{baseProc}", NomeTabela,
ListaAtributosTabela));
header.Append(new PostgreBuscar().Init($"{ParamtersInput.Prefixos.Procedure}S_{baseProc}_ID", NomeTabela,
ListaAtributosTabela));
header.Append(new PostgreInsert().Init($"{ParamtersInput.Prefixos.Procedure}I_{baseProc}", NomeTabela,
ListaAtributosTabela));
header.Append(new PostgreUpdate().Init($"{ParamtersInput.Prefixos.Procedure}U_{baseProc}", NomeTabela,
ListaAtributosTabela));
header.Append(new PostgreDelete().Init($"{ParamtersInput.Prefixos.Procedure}D_{baseProc}", NomeTabela,
ListaAtributosTabela));
return(header.ToString());
}
public string GerarBody()
{
var baseProc = NomeTabela.TratarNomeTabela().ToUpper();
var header = new StringBuilder();
header.Append(new MySqlGet().Init($"{NomeTabela.TratarNomeProcedure(OperationProcedure.List)}", NomeTabela,
ListaAtributosTabela));
header.Append(new MySqlBuscar().Init($"{NomeTabela.TratarNomeProcedure(OperationProcedure.Search)}",
NomeTabela, ListaAtributosTabela));
header.Append(new MySqlInsert().Init($"{NomeTabela.TratarNomeProcedure(OperationProcedure.Insert)}",
NomeTabela, ListaAtributosTabela));
header.Append(new MySqlUpdate().Init($"{NomeTabela.TratarNomeProcedure(OperationProcedure.Update)}",
NomeTabela, ListaAtributosTabela));
header.Append(new MySqlDelete().Init($"{NomeTabela.TratarNomeProcedure(OperationProcedure.Delete)}",
NomeTabela, ListaAtributosTabela));
return(header.ToString());
}
public string GerarBody()
{
var atributos = new SQLTables().ListarAtributos(NomeTabela);
var classe = new StringBuilder();
classe.Append($"package model;{N}{N}");
classe.Append(Imports());
classe.Append("@XmlRootElement" + N);
classe.Append($"public class {NomeTabela.ToFirstCharToUpper()} {{{N}");
classe.Append(AtributosHeader(atributos));
classe.Append(AtributosBody(atributos));
classe.Append("}" + Environment.NewLine);
return(classe.ToString());
}
private StringBuilder MontaTodosParametrosInsert()
{
var parametro = new StringBuilder();
parametro.Append($" INSERT INTO {NomeTabela}" + Environment.NewLine);
parametro.Append(" (");
for (var i = 0; i < ListaAtributosTabela.Count; i++)
{
if (i == ListaAtributosTabela.Count - 1)
{
parametro.Append($" {ListaAtributosTabela[i].COLUMN_NAME}");
}
else if (i == 0)
{
parametro.Append($"{ListaAtributosTabela[i].COLUMN_NAME}," + Environment.NewLine);
}
else
{
parametro.Append($" {ListaAtributosTabela[i].COLUMN_NAME}," + Environment.NewLine);
}
}
parametro.Append(")" + Environment.NewLine);
parametro.Append(" VALUES" + Environment.NewLine);
parametro.Append(" (");
for (var i = 0; i < ListaAtributosTabela.Count; i++)
{
if (i == ListaAtributosTabela.Count - 1)
{
parametro.Append($" P_{ListaAtributosTabela[i].COLUMN_NAME}");
}
else if (i == 0)
{
parametro.Append($"{NomeTabela.TratarNomeSequence()}," + Environment.NewLine);
}
else
{
parametro.Append($" P_{ListaAtributosTabela[i].COLUMN_NAME}," + Environment.NewLine);
}
}
parametro.Append(");");
return(parametro);
}
public StringBuilder GerarInterfaceSharProc()
{
var nomeProcBase = NomeTabela.TratarNomeTabela();
var classe = new StringBuilder();
classe.Append("using System;" + N + N);
classe.Append("namespace MeuProjeto" + N);
classe.Append("{" + N);
classe.Append($" public interface {nomeProcBase.ToLowerInvariant()}RequestRepository : IADORepository" +
N);
classe.Append(" {" + N + N);
classe.Append(GetInterfacesMethod());
classe.Append(" }" + N);
classe.Append("}" + N);
return(classe);
}
public string GerarClasse()
{
var template = Tratamentos.PathTemplate();
var connection = new MySqlConnectionStringModel(ParamtersInput.ConnectionString);
var p = String.Format(template,
connection.host, connection.user,
connection.database, connection.password,
connection.port,
parametrosQuery(false), parametrosQuery(true),
NomeTabela.TratarNomeProcedure(OperationProcedure.Search),
NomeTabela.TratarNomeProcedure(OperationProcedure.List),
NomeTabela.TratarNomeProcedure(OperationProcedure.Insert),
NomeTabela.TratarNomeProcedure(OperationProcedure.Update),
NomeTabela.TratarNomeProcedure(OperationProcedure.Delete));
return(p);
}
public string GerarBody()
{
var classe = new StringBuilder();
classe.Append("namespace Model" + N);
classe.Append("{" + N);
classe.Append($" public class {NomeTabela.ToFirstCharToUpper()}" + N);
classe.Append(" {" + N + N);
foreach (var item in ListaAtributosTabela)
{
classe.Append($" public string {item.COLUMN_NAME} {{ get; set; }}" + N);
classe.Append(N);
}
classe.Append(" }" + N);
classe.Append("}" + N);
return(GerarUsing() + classe.ToString());
}
public StringBuilder GerarClasse()
{
var classe = new StringBuilder();
classe.Append(Imports());
classe.Append($"namespace meuprojeto{N}{{{N}");
classe.Append($" public class {NomeTabela.ToFirstCharToUpper()}Dao : FirebirdRepository {{ {N}{N}");
classe.Append(GetById());
classe.Append(N);
classe.Append(GetAll());
classe.Append(N);
classe.Append(Add());
classe.Append(N);
classe.Append(Update());
classe.Append(N);
classe.Append(Delete());
classe.Append($" }}{N}");
classe.Append($"}}");
return(classe);
}
public StringBuilder GerarBodyCSharpProc()
{
var nomeProcBase = NomeTabela.TratarNomeTabelaMySql();
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(GetById(nomeProcBase));
classe.Append(Add(nomeProcBase));
classe.Append(Update(nomeProcBase));
classe.Append(" }" + N);
classe.Append("}" + N);
return(classe);
}
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 Delete()
{
var nameProc = $"{ParamtersInput.Prefixos.Procedure}U_{NomeTabela.TratarNomeTabela().ToUpper()}";
var get = new StringBuilder();
get.Append($" public void Delete(int ID) throws Exception{N}");
get.Append($" {{{N}");
get.Append($" try{{{N}");
get.Append($" BeginNewStatement(Proc.{nameProc}, \"{ParamtersInput.DataBase}\");{N}");
get.Append($" AddParamter(new Paramter(\"P_RESULT\", java.sql.Types.VARCHAR, null,\"OUT\"));{N}{N}");
get.Append($" RequestProc();{N}");
get.Append($" }}{N}");
get.Append($" catch (Exception ex){{{N}");
get.Append($" throw ex;{N}");
get.Append($" }}{N}");
get.Append($" finally {{{N}");
get.Append($" desconecta();{N}");
get.Append($" }}{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 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: () => {{{N}");
get.Append($" return Firebird.executeString(`SELECT * FROM {NomeTabela.ToLower()}`);{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);
}
