private StringBuilder GetAll()
{
var nameProc = $"{ParamtersInput.Prefixos.Procedure}S_{NomeTabela.TratarNomeTabela().ToUpper()}";
var get = new StringBuilder();
get.Append($" public List<{NomeTabela}> GetAll() throws Exception{N}");
get.Append($" {{{N}");
get.Append($" try{{{N}");
get.Append($" List<{NomeTabela}> lista = new java.util.ArrayList<{NomeTabela}>();{N}{N}");
get.Append($" BeginNewStatement(Proc.{nameProc}, \"{ParamtersInput.DataBase}\");{N}");
get.Append($" ResultSet rs = super.ExecuteReader();{N}{N}");
get.Append($" while(rs.next()){{{N}");
get.Append($" {NomeTabela} resposta = new {NomeTabela}();{N}");
foreach (var att in ListaAtributosTabela)
{
get.Append(
$" resposta.set{att.FIELD_NAME}(rs.get{JavaTypesFirebird.GetTypeAtribute(att)}(\"{att.FIELD_NAME}\"));{N}");
}
get.Append($" lista.add(resposta);{N}");
get.Append($" }};{N}");
get.Append($" return lista;{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}");
return(get);
}
private StringBuilder Update()
{
var nameProc = $"{ParamtersInput.Prefixos.Procedure}U_{NomeTabela.TratarNomeTabela().ToUpper()}";
var get = new StringBuilder();
get.Append($" public void Update({NomeTabela} entidade) 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}");
foreach (var att in ListaAtributosTabela)
{
get.Append(
$" AddParamter(new Paramter(\"P_{att.FIELD_NAME}\", java.sql.Types.{JavaTypesFirebird.GetTypeAtribute(att)}, entidade.get{att.FIELD_NAME}()));{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}");
return(get);
}
private StringBuilder GetById()
{
var nameProc = $"{ParamtersInput.Prefixos.Procedure}S_{NomeTabela.TratarNomeTabela().ToUpper()}_ID";
var get = new StringBuilder();
get.Append($" public {NomeTabela} GetById(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_{ListaAtributosTabela.First().FIELD_NAME}\", java.sql.Types.NUMERIC, id));{N}{N}");
get.Append($" ResultSet rs = super.ExecuteReader();{N}{N}");
get.Append($" if(rs.next()){{{N}");
get.Append($" {NomeTabela} resposta = new {NomeTabela}();{N}");
foreach (var att in ListaAtributosTabela)
{
get.Append(
$" resposta.set{att.FIELD_NAME}(rs.get{JavaTypesFirebird.GetTypeAtribute(att)}(\"{att.FIELD_NAME}\"));{N}");
}
get.Append($" return resposta;{N}");
get.Append($" }};{N}");
get.Append($" return null;{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}");
return(get);
}
private StringBuilder BodyDelete()
{
var body = new StringBuilder();
body.Append(Environment.NewLine);
var nomeProc = ParamtersInput.Prefixos.Procedure + "D_" + NomeTabela.TratarNomeTabela();
body.Append(AdicionaCabecalho(nomeProc, false, false, true));
body.Append(DeleteBodyInside());
body.Append($"END {nomeProc};" + Environment.NewLine);
body.Append(Environment.NewLine);
return(body);
}
private StringBuilder BodySelect(bool Isall = false)
{
var body = new StringBuilder();
body.Append(Environment.NewLine);
var nomeProc = ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela() +
(Isall ? "" : "_ID");
body.Append(AdicionaCabecalho(nomeProc, false, true, true, Isall));
body.Append(SelectBodyInside(Isall));
body.Append($"END {nomeProc};" + Environment.NewLine);
body.Append(Environment.NewLine);
return(body);
}
private StringBuilder ProceduresNames()
{
var baseProc = NomeTabela.TratarNomeTabela().ToUpper();
var proc = new StringBuilder();
proc.Append($" private enum Proc{N}");
proc.Append($" {{{N}");
proc.Append($" {baseProc.TratarNomeProcedure(OperationProcedure.Search)},{N}");
proc.Append($" {baseProc.TratarNomeProcedure(OperationProcedure.List)},{N}");
proc.Append($" {baseProc.TratarNomeProcedure(OperationProcedure.Insert)},{N}");
proc.Append($" {baseProc.TratarNomeProcedure(OperationProcedure.Update)},{N}");
proc.Append($" {baseProc.TratarNomeProcedure(OperationProcedure.Delete)}{N}");
proc.Append($" }}{N}");
return(proc);
}
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 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 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 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 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);
}
