private StringBuilder Add()
{
var get = new StringBuilder();
get.Append($" public void Insert({NomeTabela.ToFirstCharToUpper()}Model entidade){N}");
get.Append($" {{{N}");
get.Append(
$" var sql = $\"INSERT INTO {NomeTabela} ({string.Join(",", ListaAtributosTabela.Select(q => q.FIELD_NAME))}) VALUES\"{N}");
get.Append(AddParams());
get.Append($" ExecuteNonResult(sql); {N}");
get.Append($" }}{N}");
return(get);
}
private StringBuilder Update()
{
var get = new StringBuilder();
get.Append($" public void Update({NomeTabela.ToFirstCharToUpper()}Model entidade){N}");
get.Append($" {{{N}");
get.Append($" var sql = $\"UPDATE {NomeTabela} SET \" {N}");
get.Append(UpdateParams());
get.Append(
$" +$\"WHERE {ListaAtributosTabela.First().FIELD_NAME} = {{ entidade.{ListaAtributosTabela.First().FIELD_NAME}}}\"; {N}");
get.Append($" ExecuteNonResult(sql); {N}");
get.Append($" }}{N}");
return(get);
}
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());
}
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 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());
}
