private StringBuilder GetAll()
{
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($" PreparedStatement conn = BeginNewStatement(\"SELECT * FROM {NomeTabela}\");{N}");
get.Append($" ResultSet rs = conn.executeQuery();{N}");
get.Append($" while(rs.next()){{{N}");
get.Append($" {NomeTabela} resposta = new {NomeTabela}();{N}");
foreach (var att in ListaAtributosTabela)
{
get.Append(
$" resposta.set{att.COLUMN_NAME.ToFirstCharToUpper()}(rs.get{JavaTypesOracle.GetTypeAtribute(att).ToFirstCharToUpper()}(\"{att.COLUMN_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 Add()
{
var get = new StringBuilder();
get.Append($" public void Add({NomeTabela} entidade) throws Exception{N}");
get.Append($" {{{N}");
get.Append($" try{{{N}");
get.Append(
$" PreparedStatement conn = BeginNewStatement(\"INSERT INTO {NomeTabela} ({string.Join(", ", ListaAtributosTabela.Where(e => e.COLUMN_NAME != ListaAtributosTabela.First().COLUMN_NAME).Select(e => e.COLUMN_NAME))}) values ({string.Join(", ", ListaAtributosTabela.Where(e => e.COLUMN_NAME != ListaAtributosTabela.First().COLUMN_NAME).Select(q => "?"))})\");{N}");
for (var index = 1; index < ListaAtributosTabela.Count; index++)
{
var att = ListaAtributosTabela[index];
get.Append(
$" conn.set{JavaTypesOracle.GetTypeAtribute(att).ToFirstCharToUpper()}({index}, entidade.get{att.COLUMN_NAME.ToFirstCharToUpper()}());{N}");
}
get.Append($" conn.execute();{N}");
get.Append($" commit();{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 get = new StringBuilder();
get.Append($" public {NomeTabela} GetById(int ID) throws Exception{N}");
get.Append($" {{{N}");
get.Append($" try{{{N}");
get.Append(
$" PreparedStatement conn = BeginNewStatement(\"SELECT * FROM {NomeTabela} WHERE {ListaAtributosTabela.First().COLUMN_NAME} =\"+ ID);{N}");
get.Append($" ResultSet rs = conn.executeQuery();{N}");
get.Append($" if(rs.next()){{{N}");
get.Append($" {NomeTabela} resposta = new {NomeTabela}();{N}");
foreach (var att in ListaAtributosTabela)
{
get.Append(
$" resposta.set{att.COLUMN_NAME.ToFirstCharToUpper()}(rs.get{JavaTypesOracle.GetTypeAtribute(att).ToFirstCharToUpper()}(\"{att.COLUMN_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 GetAll()
{
var get = new StringBuilder();
get.Append($" public List<{NomeTabela}> GetAll(int id) 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(Package, Proc.S, \"SOURCE\");{N}");
get.Append($" AddParamter(new Parameter(\"ID\", OracleTypes.NUMBER, ID));{N}{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.COLUMN_NAME}(rs.get{JavaTypesOracle.GetTypeAtribute(att)}(\"{att.COLUMN_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 AtributosBody(List <OracleEntidadeTabela> entidadeTabela)
{
var atributoBody = new StringBuilder();
foreach (var att in entidadeTabela)
{
atributoBody.Append($" /** {N}");
atributoBody.Append($" * {N}");
atributoBody.Append($" * @Descrição {att.COMMENTS} {N}");
atributoBody.Append($" */{N}");
atributoBody.Append(
$" public {JavaTypesOracle.GetTypeAtribute(att)} get{att.COLUMN_NAME.ToFirstCharToUpper()}() {{{N}");
atributoBody.Append($" return {att.COLUMN_NAME};{N}");
atributoBody.Append($" }}{N}");
atributoBody.Append($"{N}");
atributoBody.Append($" /** {N}");
atributoBody.Append($" * {N}");
atributoBody.Append($" * @Descrição {att.COMMENTS} {N}");
atributoBody.Append($" */{N}");
atributoBody.Append(
$" public void set{att.COLUMN_NAME.ToFirstCharToUpper()}({JavaTypesOracle.GetTypeAtribute(att)} {att.COLUMN_NAME}) {{{N}");
atributoBody.Append($" this.{att.COLUMN_NAME} = {att.COLUMN_NAME};{N}");
atributoBody.Append($" }}{N}");
atributoBody.Append($"{N}");
}
atributoBody.Append($"{N}");
return(atributoBody);
}
private StringBuilder AtributosHeader(List <OracleEntidadeTabela> entidadeTabela)
{
var atributosHeader = new StringBuilder();
foreach (var att in entidadeTabela)
{
atributosHeader.Append($" private {JavaTypesOracle.GetTypeAtribute(att)} {att.COLUMN_NAME};{N}");
}
atributosHeader.Append($"{N}");
return(atributosHeader);
}
private StringBuilder Add()
{
var get = new StringBuilder();
get.Append($" public RequestMessageLite<String> Add({NomeTabela} entidade) throws Exception{N}");
get.Append($" {{{N}");
get.Append($" try{{{N}");
get.Append($" BeginNewStatement(Package, Proc.I, \"SOURCE\");{N}");
get.Append($" AddParamter(new Parameter(\"P_RESULT\", OracleTypes.VARCHAR, null,\"OUT\"));{N}{N}");
foreach (var att in ListaAtributosTabela)
{
get.Append(
$" AddParamter(new Parameter(\"P_{att.COLUMN_NAME}\", OracleTypes.{JavaTypesOracle.GetTypeAtribute(att)}, entidade.get{att.COLUMN_NAME}()));{N}");
}
get.Append($" return 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);
}
